A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 359100 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 396900 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) >= 1682 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2182 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` = 1722200 OR `props-main`.`id` = 1726123 OR `props-main`.`id` = 1712695 OR `props-main`.`id` = 1707988 OR `props-main`.`id` = 1722889 OR `props-main`.`id` = 1695242 OR `props-main`.`id` = 1703815 OR `props-main`.`id` = 1729138 OR `props-main`.`id` = 1679865 OR `props-main`.`id` = 1668687 OR `props-main`.`id` = 1728403 OR `props-main`.`id` = 1721582 OR `props-main`.`id` = 1726983 OR `props-main`.`id` = 1715719 OR `props-main`.`id` = 1719108 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` = 1726479 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` = 1728550)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225099721' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-03' 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:
$379,900
3
3
2,036
0.07
9397 Vintner Cir
Patterson, CA 95363
$379,000
3
3
1,802
0.07
9348 Vintner Circle
Patterson, CA 95363
$369,000
3
3
1,775
0.09
9305 Vintner Cir
Patterson, CA 95363
$359,500
3
2
1,932
0.12
20528 Sarazen Ln
Patterson, CA 95363
Courtesy of Taylor Thompson, KW Patterson 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.
