A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 408490.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 451489.5 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) >= 1259 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1759 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` = 1750372 OR `props-main`.`id` = 1750373 OR `props-main`.`id` = 1723821 OR `props-main`.`id` = 1724910 OR `props-main`.`id` = 1667395 OR `props-main`.`id` = 1667390 OR `props-main`.`id` = 1723303 OR `props-main`.`id` = 1750374 OR `props-main`.`id` = 1667389 OR `props-main`.`id` = 1667396 OR `props-main`.`id` = 1750371 OR `props-main`.`id` = 1617327 OR `props-main`.`id` = 1622883 OR `props-main`.`id` = 1731157 OR `props-main`.`id` = 1750377 OR `props-main`.`id` = 1667912 OR `props-main`.`id` = 1667929 OR `props-main`.`id` = 1750380 OR `props-main`.`id` = 1750379 OR `props-main`.`id` = 1667931 OR `props-main`.`id` = 1667930 OR `props-main`.`id` = 1750378 OR `props-main`.`id` = 1750355 OR `props-main`.`id` = 1704658 OR `props-main`.`id` = 1744488 OR `props-main`.`id` = 1745418 OR `props-main`.`id` = 1709550 OR `props-main`.`id` = 1738363 OR `props-main`.`id` = 1747597 OR `props-main`.`id` = 1738341 OR `props-main`.`id` = 1747695 OR `props-main`.`id` = 1744294 OR `props-main`.`id` = 1746463 OR `props-main`.`id` = 1746464 OR `props-main`.`id` = 1747521 OR `props-main`.`id` = 1746444 OR `props-main`.`id` = 1718339 OR `props-main`.`id` = 1746436 OR `props-main`.`id` = 1746445 OR `props-main`.`id` = 1734544 OR `props-main`.`id` = 1710117 OR `props-main`.`id` = 1734533 OR `props-main`.`id` = 1746437 OR `props-main`.`id` = 1747733 OR `props-main`.`id` = 1750518 OR `props-main`.`id` = 1753455 OR `props-main`.`id` = 1727938 OR `props-main`.`id` = 1752512 OR `props-main`.`id` = 1746124 OR `props-main`.`id` = 1746130 OR `props-main`.`id` = 1705935 OR `props-main`.`id` = 1716724 OR `props-main`.`id` = 1749924 OR `props-main`.`id` = 196010 OR `props-main`.`id` = 1742786 OR `props-main`.`id` = 1753397 OR `props-main`.`id` = 1707096 OR `props-main`.`id` = 1698962 OR `props-main`.`id` = 1744437 OR `props-main`.`id` = 1751645 OR `props-main`.`id` = 1748948 OR `props-main`.`id` = 1701206 OR `props-main`.`id` = 1680643 OR `props-main`.`id` = 1732942 OR `props-main`.`id` = 1714053 OR `props-main`.`id` = 1719554 OR `props-main`.`id` = 1727779 OR `props-main`.`id` = 1719524 OR `props-main`.`id` = 1741033 OR `props-main`.`id` = 1741110 OR `props-main`.`id` = 1741124 OR `props-main`.`id` = 1725968 OR `props-main`.`id` = 1734301 OR `props-main`.`id` = 1723225 OR `props-main`.`id` = 1723794 OR `props-main`.`id` = 1725724 OR `props-main`.`id` = 1740678 OR `props-main`.`id` = 1711417 OR `props-main`.`id` = 1725535 OR `props-main`.`id` = 1725536 OR `props-main`.`id` = 1041230 OR `props-main`.`id` = 1753086 OR `props-main`.`id` = 1753015 OR `props-main`.`id` = 1749534 OR `props-main`.`id` = 1642756 OR `props-main`.`id` = 1741942 OR `props-main`.`id` = 1642913 OR `props-main`.`id` = 1687775 OR `props-main`.`id` = 1749587 OR `props-main`.`id` = 1708251 OR `props-main`.`id` = 1750122 OR `props-main`.`id` = 1753905 OR `props-main`.`id` = 1753912 OR `props-main`.`id` = 1717574 OR `props-main`.`id` = 1633654 OR `props-main`.`id` = 1694963 OR `props-main`.`id` = 1693646 OR `props-main`.`id` = 1753379 OR `props-main`.`id` = 1726945 OR `props-main`.`id` = 1743939 OR `props-main`.`id` = 1740744 OR `props-main`.`id` = 1746042 OR `props-main`.`id` = 1739454 OR `props-main`.`id` = 291212 OR `props-main`.`id` = 1722828 OR `props-main`.`id` = 1752658 OR `props-main`.`id` = 1736077 OR `props-main`.`id` = 788148 OR `props-main`.`id` = 1693974 OR `props-main`.`id` = 1694679)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26147293' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-27' 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
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$439,990
4
2
1,509
0.11
145 Sugar Creek Ln #157 S2
Merced, CA 95341
$433,990
4
2
1,509
0.12
114 Sugar Creek Ln #143 S2
Merced, CA 95341
$429,650
4
2
1,509
0.11
127 Sugar Creek Ln #159 S2
Merced, CA 95341
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.
