A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 397090.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 438889.5 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) >= 980 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1480 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` = 1704802 OR `props-main`.`id` = 1707000 OR `props-main`.`id` = 1708190 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1708196 OR `props-main`.`id` = 1702162 OR `props-main`.`id` = 1709467 OR `props-main`.`id` = 1709442 OR `props-main`.`id` = 1705673 OR `props-main`.`id` = 1689954 OR `props-main`.`id` = 1711218 OR `props-main`.`id` = 1709672 OR `props-main`.`id` = 1706672 OR `props-main`.`id` = 1706679 OR `props-main`.`id` = 1703717 OR `props-main`.`id` = 1703858 OR `props-main`.`id` = 1694399 OR `props-main`.`id` = 1706057 OR `props-main`.`id` = 1704869 OR `props-main`.`id` = 1704889 OR `props-main`.`id` = 1704915 OR `props-main`.`id` = 1705344 OR `props-main`.`id` = 1701912 OR `props-main`.`id` = 1701908 OR `props-main`.`id` = 1705282 OR `props-main`.`id` = 1709925 OR `props-main`.`id` = 1694386 OR `props-main`.`id` = 1689536 OR `props-main`.`id` = 1702926 OR `props-main`.`id` = 1685384 OR `props-main`.`id` = 1683766 OR `props-main`.`id` = 1683771 OR `props-main`.`id` = 1704369 OR `props-main`.`id` = 1711312 OR `props-main`.`id` = 1703392 OR `props-main`.`id` = 1704849 OR `props-main`.`id` = 1694943 OR `props-main`.`id` = 1704838 OR `props-main`.`id` = 1704360 OR `props-main`.`id` = 1704364 OR `props-main`.`id` = 1702711 OR `props-main`.`id` = 1702684 OR `props-main`.`id` = 1702695 OR `props-main`.`id` = 1706816 OR `props-main`.`id` = 1703184 OR `props-main`.`id` = 1702578 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` = 1711333 OR `props-main`.`id` = 1704899 OR `props-main`.`id` = 1704926 OR `props-main`.`id` = 1708144 OR `props-main`.`id` = 1708145 OR `props-main`.`id` = 1708146 OR `props-main`.`id` = 1666278 OR `props-main`.`id` = 1698754 OR `props-main`.`id` = 1701226 OR `props-main`.`id` = 1701225 OR `props-main`.`id` = 1706107 OR `props-main`.`id` = 1706773 OR `props-main`.`id` = 1706127 OR `props-main`.`id` = 1706126 OR `props-main`.`id` = 1706108 OR `props-main`.`id` = 1711149 OR `props-main`.`id` = 1701227 OR `props-main`.`id` = 1701229 OR `props-main`.`id` = 1705081 OR `props-main`.`id` = 1708147 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` = 1709529 OR `props-main`.`id` = 1710262 OR `props-main`.`id` = 1684427 OR `props-main`.`id` = 1701451 OR `props-main`.`id` = 1687778 OR `props-main`.`id` = 1709676 OR `props-main`.`id` = 1641188 OR `props-main`.`id` = 1710389)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26032626' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-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();
4
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$420,434
3
2
1,435
0.12
726 Skyler Ct
Merced, CA 95348
$412,000
3
2
1,195
0.14
327 Hart Dr
Merced, CA 95348
$410,000
3
2
1,435
0.10
624 Marybelle Dr
Merced, CA 95348
$406,990
3
2
1,230
0.12
611 Skyler Ln #92 B2
Merced, CA 95348
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.
