A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 427500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 472500 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) >= 1308 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1808 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` = 1718168 OR `props-main`.`id` = 1718181 OR `props-main`.`id` = 1714839 OR `props-main`.`id` = 1659390 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1719273 OR `props-main`.`id` = 1685606 OR `props-main`.`id` = 1698211 OR `props-main`.`id` = 202390 OR `props-main`.`id` = 1717006 OR `props-main`.`id` = 1716047 OR `props-main`.`id` = 1716133 OR `props-main`.`id` = 1711272 OR `props-main`.`id` = 1702577 OR `props-main`.`id` = 1702568 OR `props-main`.`id` = 1704802 OR `props-main`.`id` = 1707000 OR `props-main`.`id` = 1714876 OR `props-main`.`id` = 1714091 OR `props-main`.`id` = 1622703 OR `props-main`.`id` = 1708190 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1708196 OR `props-main`.`id` = 1702162 OR `props-main`.`id` = 1714570 OR `props-main`.`id` = 360956 OR `props-main`.`id` = 1715915 OR `props-main`.`id` = 1715927 OR `props-main`.`id` = 1715798 OR `props-main`.`id` = 1713342 OR `props-main`.`id` = 1712953 OR `props-main`.`id` = 1689954 OR `props-main`.`id` = 1711218 OR `props-main`.`id` = 1709672 OR `props-main`.`id` = 1706672 OR `props-main`.`id` = 1712818 OR `props-main`.`id` = 1706679 OR `props-main`.`id` = 1716572 OR `props-main`.`id` = 1713540 OR `props-main`.`id` = 1713511 OR `props-main`.`id` = 1713661 OR `props-main`.`id` = 1713146 OR `props-main`.`id` = 1700902 OR `props-main`.`id` = 1700897 OR `props-main`.`id` = 1705344 OR `props-main`.`id` = 1705282 OR `props-main`.`id` = 1709925 OR `props-main`.`id` = 1716479 OR `props-main`.`id` = 1689536 OR `props-main`.`id` = 1715696 OR `props-main`.`id` = 1718105 OR `props-main`.`id` = 1711312 OR `props-main`.`id` = 1716949 OR `props-main`.`id` = 1703392 OR `props-main`.`id` = 1704849 OR `props-main`.`id` = 1717897 OR `props-main`.`id` = 1717924 OR `props-main`.`id` = 1712713 OR `props-main`.`id` = 1712543 OR `props-main`.`id` = 1706816 OR `props-main`.`id` = 1716168 OR `props-main`.`id` = 1716223 OR `props-main`.`id` = 1712710 OR `props-main`.`id` = 1705259 OR `props-main`.`id` = 1705596 OR `props-main`.`id` = 1705601 OR `props-main`.`id` = 1704350 OR `props-main`.`id` = 1709853 OR `props-main`.`id` = 1712821 OR `props-main`.`id` = 1718560 OR `props-main`.`id` = 1718552 OR `props-main`.`id` = 1717529 OR `props-main`.`id` = 1711333 OR `props-main`.`id` = 1708144 OR `props-main`.`id` = 1715751 OR `props-main`.`id` = 1715752 OR `props-main`.`id` = 1666278 OR `props-main`.`id` = 1701226 OR `props-main`.`id` = 1701225 OR `props-main`.`id` = 1706107 OR `props-main`.`id` = 1706773 OR `props-main`.`id` = 1706126 OR `props-main`.`id` = 1701227 OR `props-main`.`id` = 1701229 OR `props-main`.`id` = 1708147 OR `props-main`.`id` = 1715795 OR `props-main`.`id` = 1709924 OR `props-main`.`id` = 1710118 OR `props-main`.`id` = 1629281 OR `props-main`.`id` = 1600784 OR `props-main`.`id` = 1701369 OR `props-main`.`id` = 1717746 OR `props-main`.`id` = 1701451 OR `props-main`.`id` = 1717610 OR `props-main`.`id` = 1687778 OR `props-main`.`id` = 1709676)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26006051' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-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();
5
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$439,999
4
3
1,787
0.17
6 Westmont Ct
Merced, CA 95348
$435,990
4
2
1,509
0.12
628 Skyler Ln #63 B2
Merced, CA 95348
$435,000
4
3
1,787
0.17
310 Buena Vista Ct
Merced, CA 95348
$429,950
4
2
1,564
0.11
4246 Freemark Ave
Merced, CA 95348-9643
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.
