Courtesy of Randhir Hayer, Realty Executives of Northern California - [email protected]
Welcome to this spacious two-story home offering 5 bedrooms and 2.5 bathrooms with a layout designed for comfortable everyday living! Inside, you'll find an floor plan featuring dual pane windows, LED lighting and a spacious kitchen with quartz countertops, a center island with breakfast bar, pantry, and a gas stove approximately 5 years old. The upstairs layout includes generously sized bedrooms with carpeted floors and closets. The large primary suite offers a large closet and a tiled walk-in shower with quartz countertops. A convenient upstairs laundry room with cabinet storage adds everyday functionality. Outside, the property features a large front lawn, trimmed landscaping, a converted patio area and a 2-car tandem garage. Additional highlights include smart home features and 12 solar panels for improved energy efficiency. Situated on a quiet cul-de-sac in North Merced, this home is surrounded by established neighborhoods and offers convenient access to parks, shopping centers, restaurants, schools, and major commuter routes, making it an ideal location for both convenience and everyday living.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2021
Region
Rural
# of Stories
Two
Price Per Square Foot
$232
Price Per Acre
$3,523,357
Days On London
88
Cumulative Days On London
88
County
Merced
REO / Bank Owned
No
Cross Street Address
Terra Corvo Ave
Directions
From Elmer Murchie Park take Foothill Dr toward Cardella Rd (turn R), Turn R on Terra Corvo Ave, Turn R on Coppola CT, Property on left.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, On Upper Level
Roofing
Composition
Foundation
Both
Kitchen
Breakfast Bar, Pantry
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower
Flooring
Carpet, Tile
Exterior
Other
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
Yes
Solar Type
Owned
Parking Features
Tandem Garage
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
224 092 026 000
School District
Merced Union
School Type 1
High School
School Name 1
Merced High
School Type 2
Junior High School
School Name 2
Cruickshank
School Type 3
Grade School
School Name 3
Bellview
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 422750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 467250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1669 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2169 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1748975 OR `props-main`.`id` = 1749084 OR `props-main`.`id` = 1723298 OR `props-main`.`id` = 1752985 OR `props-main`.`id` = 1725758 OR `props-main`.`id` = 1752118 OR `props-main`.`id` = 1733377 OR `props-main`.`id` = 1726941 OR `props-main`.`id` = 1726930 OR `props-main`.`id` = 1727524 OR `props-main`.`id` = 1728540 OR `props-main`.`id` = 1729039 OR `props-main`.`id` = 1742788 OR `props-main`.`id` = 1742768 OR `props-main`.`id` = 1743824 OR `props-main`.`id` = 1754970 OR `props-main`.`id` = 1754976 OR `props-main`.`id` = 1714839 OR `props-main`.`id` = 1737246 OR `props-main`.`id` = 1748617 OR `props-main`.`id` = 1749105 OR `props-main`.`id` = 1749490 OR `props-main`.`id` = 1720457 OR `props-main`.`id` = 1747022 OR `props-main`.`id` = 1747861 OR `props-main`.`id` = 1755175 OR `props-main`.`id` = 202390 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1728766 OR `props-main`.`id` = 1744739 OR `props-main`.`id` = 1747644 OR `props-main`.`id` = 1753940 OR `props-main`.`id` = 1747352 OR `props-main`.`id` = 1731900 OR `props-main`.`id` = 1754838 OR `props-main`.`id` = 1746129 OR `props-main`.`id` = 1755806 OR `props-main`.`id` = 1744943 OR `props-main`.`id` = 1752567 OR `props-main`.`id` = 1754971 OR `props-main`.`id` = 1740985 OR `props-main`.`id` = 1714876 OR `props-main`.`id` = 1754619 OR `props-main`.`id` = 1754615 OR `props-main`.`id` = 1714091 OR `props-main`.`id` = 1755945 OR `props-main`.`id` = 1723262 OR `props-main`.`id` = 1754901 OR `props-main`.`id` = 1741279 OR `props-main`.`id` = 1751600 OR `props-main`.`id` = 1724196 OR `props-main`.`id` = 1743851 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1727728 OR `props-main`.`id` = 1727723 OR `props-main`.`id` = 1727764 OR `props-main`.`id` = 1750472 OR `props-main`.`id` = 1755176 OR `props-main`.`id` = 1721038 OR `props-main`.`id` = 1753889 OR `props-main`.`id` = 360956 OR `props-main`.`id` = 1751394 OR `props-main`.`id` = 1713342 OR `props-main`.`id` = 1751428 OR `props-main`.`id` = 1737113 OR `props-main`.`id` = 1712818 OR `props-main`.`id` = 1737134 OR `props-main`.`id` = 1737196 OR `props-main`.`id` = 1721101 OR `props-main`.`id` = 1721326 OR `props-main`.`id` = 1752967 OR `props-main`.`id` = 1752982 OR `props-main`.`id` = 1754673 OR `props-main`.`id` = 1755262 OR `props-main`.`id` = 1713511 OR `props-main`.`id` = 1725489 OR `props-main`.`id` = 1746429 OR `props-main`.`id` = 1746399 OR `props-main`.`id` = 1739369 OR `props-main`.`id` = 1736125 OR `props-main`.`id` = 1736163 OR `props-main`.`id` = 1726991 OR `props-main`.`id` = 1726957 OR `props-main`.`id` = 1731126 OR `props-main`.`id` = 1731108 OR `props-main`.`id` = 1731114 OR `props-main`.`id` = 1751615 OR `props-main`.`id` = 1747638 OR `props-main`.`id` = 1755626 OR `props-main`.`id` = 1722230 OR `props-main`.`id` = 1728646 OR `props-main`.`id` = 1728953 OR `props-main`.`id` = 1728957 OR `props-main`.`id` = 1749568 OR `props-main`.`id` = 1754331 OR `props-main`.`id` = 1749567 OR `props-main`.`id` = 1753409 OR `props-main`.`id` = 1753560 OR `props-main`.`id` = 1754359 OR `props-main`.`id` = 1753577 OR `props-main`.`id` = 1749711 OR `props-main`.`id` = 1749721 OR `props-main`.`id` = 1743212 OR `props-main`.`id` = 1743901 OR `props-main`.`id` = 1755672 OR `props-main`.`id` = 1754696 OR `props-main`.`id` = 1731812 OR `props-main`.`id` = 1728909 OR `props-main`.`id` = 1752152 OR `props-main`.`id` = 1725629 OR `props-main`.`id` = 1744526 OR `props-main`.`id` = 1754627 OR `props-main`.`id` = 1741482 OR `props-main`.`id` = 1728505 OR `props-main`.`id` = 1746893 OR `props-main`.`id` = 1734891 OR `props-main`.`id` = 1755211 OR `props-main`.`id` = 1755258 OR `props-main`.`id` = 1734087 OR `props-main`.`id` = 1749566 OR `props-main`.`id` = 1749584 OR `props-main`.`id` = 1754977 OR `props-main`.`id` = 1753399 OR `props-main`.`id` = 1718560 OR `props-main`.`id` = 1718552 OR `props-main`.`id` = 1739664 OR `props-main`.`id` = 1727790 OR `props-main`.`id` = 1746062 OR `props-main`.`id` = 1754495 OR `props-main`.`id` = 1754597 OR `props-main`.`id` = 1754485 OR `props-main`.`id` = 1734116 OR `props-main`.`id` = 1706773 OR `props-main`.`id` = 1727560 OR `props-main`.`id` = 1754635 OR `props-main`.`id` = 1724895 OR `props-main`.`id` = 1724960 OR `props-main`.`id` = 1724962 OR `props-main`.`id` = 1755821 OR `props-main`.`id` = 1755820 OR `props-main`.`id` = 1755753 OR `props-main`.`id` = 1755752 OR `props-main`.`id` = 1755754 OR `props-main`.`id` = 1755751 OR `props-main`.`id` = 1728178 OR `props-main`.`id` = 1727980 OR `props-main`.`id` = 1727994 OR `props-main`.`id` = 1728191 OR `props-main`.`id` = 1728013 OR `props-main`.`id` = 1741656 OR `props-main`.`id` = 1741666 OR `props-main`.`id` = 1741676 OR `props-main`.`id` = 1756122 OR `props-main`.`id` = 1755275 OR `props-main`.`id` = 1687778 OR `props-main`.`id` = 1753927 OR `props-main`.`id` = 1753941 OR `props-main`.`id` = 1722651)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648126' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-03' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
1
Similar Properties
$450,000
5
3
1,919
0.13
733 Newton Ct
Merced, CA 95348
Last modified 2 months ago
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
