A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 503405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 556395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1752 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2252 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` = 1701904 OR `props-main`.`id` = 1701772 OR `props-main`.`id` = 1695075 OR `props-main`.`id` = 1703390 OR `props-main`.`id` = 1700145 OR `props-main`.`id` = 1700810 OR `props-main`.`id` = 1701607 OR `props-main`.`id` = 1699993 OR `props-main`.`id` = 1698083 OR `props-main`.`id` = 1704222 OR `props-main`.`id` = 1703284 OR `props-main`.`id` = 1704775 OR `props-main`.`id` = 1675227 OR `props-main`.`id` = 1691108 OR `props-main`.`id` = 1691856 OR `props-main`.`id` = 1698230 OR `props-main`.`id` = 1705040 OR `props-main`.`id` = 1705030 OR `props-main`.`id` = 1702127 OR `props-main`.`id` = 1692183 OR `props-main`.`id` = 1702652 OR `props-main`.`id` = 1693585 OR `props-main`.`id` = 1701342 OR `props-main`.`id` = 1692290 OR `props-main`.`id` = 1701043 OR `props-main`.`id` = 1695485 OR `props-main`.`id` = 1697658 OR `props-main`.`id` = 1695491 OR `props-main`.`id` = 1696197 OR `props-main`.`id` = 1689430 OR `props-main`.`id` = 1697557 OR `props-main`.`id` = 1697929 OR `props-main`.`id` = 1704886 OR `props-main`.`id` = 1658344 OR `props-main`.`id` = 1660514 OR `props-main`.`id` = 1658341 OR `props-main`.`id` = 1660513 OR `props-main`.`id` = 1689375 OR `props-main`.`id` = 1704668 OR `props-main`.`id` = 1700270 OR `props-main`.`id` = 1700698 OR `props-main`.`id` = 1702831 OR `props-main`.`id` = 1684503)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR22220039' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-30' 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
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$535,000
4
3
2,002
0.14
209 Fairwood Dr
Oakdale, CA 95361
$529,000
4
3
2,002
0.14
2337 Rainwood Ln
Oakdale, CA 95361
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.
