A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 524400 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 579600 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) >= 1663 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2163 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` = 1717988 OR `props-main`.`id` = 1701153 OR `props-main`.`id` = 1714287 OR `props-main`.`id` = 1689927 OR `props-main`.`id` = 1714209 OR `props-main`.`id` = 1714784 OR `props-main`.`id` = 1709777 OR `props-main`.`id` = 1716615 OR `props-main`.`id` = 1716701 OR `props-main`.`id` = 1649515 OR `props-main`.`id` = 1714373 OR `props-main`.`id` = 1716547 OR `props-main`.`id` = 1717018 OR `props-main`.`id` = 1704267 OR `props-main`.`id` = 1705012 OR `props-main`.`id` = 1704952 OR `props-main`.`id` = 1718391 OR `props-main`.`id` = 1715615 OR `props-main`.`id` = 1718440 OR `props-main`.`id` = 1692243 OR `props-main`.`id` = 1701386 OR `props-main`.`id` = 1701580 OR `props-main`.`id` = 1714544 OR `props-main`.`id` = 1705029 OR `props-main`.`id` = 1707874 OR `props-main`.`id` = 1707875 OR `props-main`.`id` = 1705572 OR `props-main`.`id` = 1713015 OR `props-main`.`id` = 1705565 OR `props-main`.`id` = 1716419 OR `props-main`.`id` = 1716593)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls26670201' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-26' 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
$535,000
4
2
2,115
0.12
918 Cumbria Ln
Patterson, CA 95363
$534,990
3
3
2,019
0.11
804 Wissett Pl
Patterson, CA 95363
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.
