Listing Agent: Erin Mussano, ELM Realty and Property Mgmt. Inc.
Updated and move-in ready! 4-bedroom, 2-bath home with updated with flooring, paint, and updated countertops. Enjoy the swimming pool and the benefits of owned solar panels. Conveniently located near Juniper Elementary School, shopping, restaurants, and freeway access. Buyer to verify all information to their satisfaction.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1972
Year Built Source
Public Records
Special Listing Conditions
Conservatorship
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$316
Days On London
26
Cumulative Days On London
26
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross streets Shaffer Rd. and E Juniper Ave.
Room Type
Bonus Room, All Bedrooms Down
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
In Garage
Main Level Bedrooms
4
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
2
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Pool Features
Private
Pool Private Y/N
Yes
Water Source
Public
Sewer
Public Sewer
Parking Total
1.00
Attached Garage Y/N
Yes
Garage Spaces
1.00
Lot Features
0-1 Unit/Acre
Lot Size Area
6348.0000
Lot Size Units
Square Feet
View Y/N
No
View
None
Common Interest
None
Parcel Number
004060006000
Additional Parcels Y/N
No
Community Features
Gutters, Curbs
Senior Community Y/N
No
Association Y/N
No
High School District
Merced Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
CFD/Mello-Roos
Tax Lot
5
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 389405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 430395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1046 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1546 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` = 1078072 OR `props-main`.`id` = 1702939 OR `props-main`.`id` = 1702920 OR `props-main`.`id` = 1714627 OR `props-main`.`id` = 1730748 OR `props-main`.`id` = 1730840 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 1717756 OR `props-main`.`id` = 1717748 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1727719 OR `props-main`.`id` = 1728599 OR `props-main`.`id` = 1728309 OR `props-main`.`id` = 1738219 OR `props-main`.`id` = 1720310 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1745126 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1723863 OR `props-main`.`id` = 1745256 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 1723150 OR `props-main`.`id` = 1717926 OR `props-main`.`id` = 1740557 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1731188 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1723302 OR `props-main`.`id` = 1721065 OR `props-main`.`id` = 1723280 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1726641 OR `props-main`.`id` = 1723294 OR `props-main`.`id` = 1724484 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 1723293 OR `props-main`.`id` = 1743898 OR `props-main`.`id` = 1742833 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1744330 OR `props-main`.`id` = 1744263 OR `props-main`.`id` = 1736031 OR `props-main`.`id` = 1723297 OR `props-main`.`id` = 1740956 OR `props-main`.`id` = 1732522 OR `props-main`.`id` = 1726751 OR `props-main`.`id` = 1715714 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1734911 OR `props-main`.`id` = 1737000 OR `props-main`.`id` = 1727284 OR `props-main`.`id` = 1725386 OR `props-main`.`id` = 1723279 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1732272 OR `props-main`.`id` = 1732285 OR `props-main`.`id` = 1740984 OR `props-main`.`id` = 1725250 OR `props-main`.`id` = 1724879 OR `props-main`.`id` = 1727965 OR `props-main`.`id` = 1737493 OR `props-main`.`id` = 1744379 OR `props-main`.`id` = 1711217 OR `props-main`.`id` = 1734790 OR `props-main`.`id` = 1702479 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1726183 OR `props-main`.`id` = 1741657 OR `props-main`.`id` = 1732098 OR `props-main`.`id` = 1738351 OR `props-main`.`id` = 1738699 OR `props-main`.`id` = 1728911 OR `props-main`.`id` = 1732524 OR `props-main`.`id` = 1742756 OR `props-main`.`id` = 1742406 OR `props-main`.`id` = 1744002 OR `props-main`.`id` = 1741453 OR `props-main`.`id` = 1742755 OR `props-main`.`id` = 1742710 OR `props-main`.`id` = 1742766 OR `props-main`.`id` = 1732735 OR `props-main`.`id` = 1739111 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1740651 OR `props-main`.`id` = 1734262 OR `props-main`.`id` = 1739301 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1714397 OR `props-main`.`id` = 1731191 OR `props-main`.`id` = 1731165 OR `props-main`.`id` = 1731179 OR `props-main`.`id` = 1726708 OR `props-main`.`id` = 1737256 OR `props-main`.`id` = 1736193 OR `props-main`.`id` = 1737170 OR `props-main`.`id` = 1726817 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1717457 OR `props-main`.`id` = 1742751 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1707011 OR `props-main`.`id` = 1716394 OR `props-main`.`id` = 1694847 OR `props-main`.`id` = 1732939)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26126640' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-05' 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();
0
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.
