A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332499.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367498.95 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) >= 1918 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2418 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` = 1688897 OR `props-main`.`id` = 1712695 OR `props-main`.`id` = 1707988 OR `props-main`.`id` = 1690718 OR `props-main`.`id` = 1695242 OR `props-main`.`id` = 1703815 OR `props-main`.`id` = 1700899 OR `props-main`.`id` = 1679865 OR `props-main`.`id` = 1668687 OR `props-main`.`id` = 1715719 OR `props-main`.`id` = 1691441 OR `props-main`.`id` = 1719108 OR `props-main`.`id` = 1703812 OR `props-main`.`id` = 1719075 OR `props-main`.`id` = 1685220 OR `props-main`.`id` = 1685223 OR `props-main`.`id` = 1685227 OR `props-main`.`id` = 1685225 OR `props-main`.`id` = 1715606 OR `props-main`.`id` = 1704087 OR `props-main`.`id` = 1685229 OR `props-main`.`id` = 1685224 OR `props-main`.`id` = 1685222 OR `props-main`.`id` = 1685221 OR `props-main`.`id` = 1685226 OR `props-main`.`id` = 1685228 OR `props-main`.`id` = 1719222 OR `props-main`.`id` = 1709831 OR `props-main`.`id` = 1715787 OR `props-main`.`id` = 1714400)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225123536' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-02' 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:
$359,500
3
2
1,932
0.12
20528 Sarazen Ln
Patterson, CA 95363
$345,000
3
3
2,036
0.07
9390 Vintner
Patterson, CA 95363
Courtesy of George Mac Master, Mountain Valley Properties IDX provided by Reliance Marketing
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.
