Listing Agent: Alifonso Mendoza, Keller Williams Property Team
The front yard is beautifully landscaped with automatic irrigation, artificial turf, and concrete for enhanced curb appeal and minimal upkeep. The low-maintenance backyard features extensive concrete and a covered patio, providing the perfect space for outdoor entertaining or relaxing year-round.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2024
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$400
Days On London
1
Cumulative Days On London
1
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
S M St to Marcus St to Callie ST to Mackenzie Ct
Room Type
Kitchen, Living Room
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
In Garage
Main Level Bedrooms
3
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
2
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Rectangular Lot
Lot Size Area
4998.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Common Interest
None
Parcel Number
222060048000
Additional Parcels Y/N
No
Community Features
Suburban
Senior Community Y/N
No
Association Y/N
No
High School District
Merced City
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
173
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 419895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 750 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1250 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` = 1739617 OR `props-main`.`id` = 1739624 OR `props-main`.`id` = 1739574 OR `props-main`.`id` = 1743979 OR `props-main`.`id` = 1728573 OR `props-main`.`id` = 1737393 OR `props-main`.`id` = 1736196 OR `props-main`.`id` = 1739298 OR `props-main`.`id` = 1730583 OR `props-main`.`id` = 1730586 OR `props-main`.`id` = 1730692 OR `props-main`.`id` = 1747801 OR `props-main`.`id` = 1739300 OR `props-main`.`id` = 1731971 OR `props-main`.`id` = 1731976 OR `props-main`.`id` = 1748619 OR `props-main`.`id` = 1733029 OR `props-main`.`id` = 1746894 OR `props-main`.`id` = 1715753 OR `props-main`.`id` = 1742832 OR `props-main`.`id` = 1715746 OR `props-main`.`id` = 1715759 OR `props-main`.`id` = 279647 OR `props-main`.`id` = 1725764 OR `props-main`.`id` = 1754374 OR `props-main`.`id` = 1754388 OR `props-main`.`id` = 1754377 OR `props-main`.`id` = 1753557 OR `props-main`.`id` = 1744704 OR `props-main`.`id` = 1709192 OR `props-main`.`id` = 1750434 OR `props-main`.`id` = 1752522 OR `props-main`.`id` = 1752944 OR `props-main`.`id` = 1708287 OR `props-main`.`id` = 1747521 OR `props-main`.`id` = 1737937 OR `props-main`.`id` = 1750479 OR `props-main`.`id` = 1702508 OR `props-main`.`id` = 1749244 OR `props-main`.`id` = 1747733 OR `props-main`.`id` = 1748622 OR `props-main`.`id` = 1726878 OR `props-main`.`id` = 1726868 OR `props-main`.`id` = 1740245 OR `props-main`.`id` = 1740244 OR `props-main`.`id` = 1728831 OR `props-main`.`id` = 1746162 OR `props-main`.`id` = 1746412 OR `props-main`.`id` = 1732942 OR `props-main`.`id` = 1737274 OR `props-main`.`id` = 1701468 OR `props-main`.`id` = 1748981 OR `props-main`.`id` = 1693807 OR `props-main`.`id` = 1737050 OR `props-main`.`id` = 1739064 OR `props-main`.`id` = 1693713 OR `props-main`.`id` = 1693694 OR `props-main`.`id` = 1750438 OR `props-main`.`id` = 1694962 OR `props-main`.`id` = 1737049 OR `props-main`.`id` = 1739066 OR `props-main`.`id` = 1706026 OR `props-main`.`id` = 1692454 OR `props-main`.`id` = 1692435 OR `props-main`.`id` = 1745734 OR `props-main`.`id` = 1738258 OR `props-main`.`id` = 1750407 OR `props-main`.`id` = 1123502 OR `props-main`.`id` = 1740874 OR `props-main`.`id` = 1723296 OR `props-main`.`id` = 1714759 OR `props-main`.`id` = 1750514 OR `props-main`.`id` = 1729890 OR `props-main`.`id` = 1723264 OR `props-main`.`id` = 1751552 OR `props-main`.`id` = 1751628 OR `props-main`.`id` = 1739248 OR `props-main`.`id` = 1739112 OR `props-main`.`id` = 1735184 OR `props-main`.`id` = 1724054 OR `props-main`.`id` = 1734972 OR `props-main`.`id` = 1718502 OR `props-main`.`id` = 1741765 OR `props-main`.`id` = 1736110 OR `props-main`.`id` = 1736203 OR `props-main`.`id` = 1723282 OR `props-main`.`id` = 1747171 OR `props-main`.`id` = 1731018 OR `props-main`.`id` = 1690433 OR `props-main`.`id` = 1690429)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26163641' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-28' 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();
3
Similar Properties
$399,900
3
2
1,214
0.12
714 Dean Ct
Merced, CA 95341
$395,000
3
2
1,214
0.13
785 Dean Ct
Merced, CA 95341
$390,000
3
2
1,136
0.22
355 E Main
Merced, CA 95340
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.
