Bedroom(s), Family Room, Full Bath(s), Garage, Kitchen
Architectural Style
Craftsman
Construction Materials
Stucco, Frame
Foundation
Slab
Roof
Composition
Heating
Central
Cooling
Central
Laundry Features
Dryer Included, Electric, Washer Included
Full Bathrooms
3
Bath Features
Double Sinks, Tub w/Shower Over
Flooring
Carpet
Appliances
Built-In Gas Range, Dishwasher, Disposal, Tankless Water Heater
Kitchen Features
Granite Counter
Dining Room Features
Breakfast Nook
Living Room Features
Other
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Sewer Connected, Electric, Natural Gas Connected
Electric
220 Volts in Laundry
Irrigation
See Remarks
Water Source
Public
Sewer
Public Sewer
Parking Features
Garage Facing Rear
Garage Spaces
2.00
Lot Features
Curb(s)/Gutter(s), Street Lights, See Remarks
APN
170 021 003 000
Horse Property
No
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
Yes
Association Mandatory
Yes
Association Fee
155
Association Fee Frequency
Monthly
Association Fee Includes
MaintenanceGrounds
Association Features
Playground, Game Court Exterior
Senior Community
No
School District (County)
Merced
Elementary School District
Merced City
Middle or Junior School District
Merced City
Senior High School District
Merced Union High
Census Tract
25.00
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 451250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 498750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1643 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2143 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` = 204765 OR `props-main`.`id` = 1713342 OR `props-main`.`id` = 1737113 OR `props-main`.`id` = 1737134 OR `props-main`.`id` = 1737196 OR `props-main`.`id` = 1721101 OR `props-main`.`id` = 1721326 OR `props-main`.`id` = 1713511 OR `props-main`.`id` = 1725489 OR `props-main`.`id` = 1736125 OR `props-main`.`id` = 1736163 OR `props-main`.`id` = 1726991 OR `props-main`.`id` = 1726957 OR `props-main`.`id` = 1733043 OR `props-main`.`id` = 1700902 OR `props-main`.`id` = 1731825 OR `props-main`.`id` = 1700897 OR `props-main`.`id` = 1731827 OR `props-main`.`id` = 1731826 OR `props-main`.`id` = 1728646 OR `props-main`.`id` = 1728953 OR `props-main`.`id` = 1728957 OR `props-main`.`id` = 1731938 OR `props-main`.`id` = 1728906 OR `props-main`.`id` = 1730643 OR `props-main`.`id` = 1738562 OR `props-main`.`id` = 1741369 OR `props-main`.`id` = 1736993 OR `props-main`.`id` = 1723222 OR `props-main`.`id` = 1731812 OR `props-main`.`id` = 1728909 OR `props-main`.`id` = 1704849 OR `props-main`.`id` = 1725492 OR `props-main`.`id` = 1725228 OR `props-main`.`id` = 1724958 OR `props-main`.`id` = 1724939 OR `props-main`.`id` = 1725629 OR `props-main`.`id` = 1733272 OR `props-main`.`id` = 1741482 OR `props-main`.`id` = 1728505 OR `props-main`.`id` = 1734891 OR `props-main`.`id` = 1734087 OR `props-main`.`id` = 1705596 OR `props-main`.`id` = 1718560 OR `props-main`.`id` = 1718552 OR `props-main`.`id` = 1739664 OR `props-main`.`id` = 1727790 OR `props-main`.`id` = 1734116 OR `props-main`.`id` = 1706773 OR `props-main`.`id` = 1727560 OR `props-main`.`id` = 1724895 OR `props-main`.`id` = 1727559 OR `props-main`.`id` = 1723836 OR `props-main`.`id` = 1734115 OR `props-main`.`id` = 1724960 OR `props-main`.`id` = 1724962 OR `props-main`.`id` = 1727223 OR `props-main`.`id` = 1723957 OR `props-main`.`id` = 1728178 OR `props-main`.`id` = 1723956 OR `props-main`.`id` = 1723977 OR `props-main`.`id` = 1727980 OR `props-main`.`id` = 1727994 OR `props-main`.`id` = 1723958 OR `props-main`.`id` = 1728191 OR `props-main`.`id` = 1725284 OR `props-main`.`id` = 1724004 OR `props-main`.`id` = 1728013 OR `props-main`.`id` = 1701451 OR `props-main`.`id` = 1741656 OR `props-main`.`id` = 1741666 OR `props-main`.`id` = 1741676 OR `props-main`.`id` = 1736853 OR `props-main`.`id` = 1739613 OR `props-main`.`id` = 1687778 OR `props-main`.`id` = 1722652 OR `props-main`.`id` = 1722651 OR `props-main`.`id` = 1709676 OR `props-main`.`id` = 1735461 OR `props-main`.`id` = 1738269 OR `props-main`.`id` = 1721195)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226079862' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-24' 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();
2
Similar Properties
$485,000
5
4
1,890
0.05
236 Montage Dr
Merced, CA 95348
$485,000
5
4
1,890
0.05
242 Montage Dr
Merced, CA 95348
Courtesy of Kelly Jean Hasko, Realty Executives of Northern California IDX provided by Reliance Marketing
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.
