A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 607050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 670950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3216 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3716 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` = 1677113 OR `props-main`.`id` = 1651078 OR `props-main`.`id` = 1690398 OR `props-main`.`id` = 1682967 OR `props-main`.`id` = 1682968 OR `props-main`.`id` = 1682969 OR `props-main`.`id` = 1673075 OR `props-main`.`id` = 1685727 OR `props-main`.`id` = 1649644 OR `props-main`.`id` = 1687219 OR `props-main`.`id` = 1668556 OR `props-main`.`id` = 1687218 OR `props-main`.`id` = 1683968 OR `props-main`.`id` = 1681063 OR `props-main`.`id` = 1682432 OR `props-main`.`id` = 1690160 OR `props-main`.`id` = 1688039 OR `props-main`.`id` = 1686702 OR `props-main`.`id` = 1679154 OR `props-main`.`id` = 1689675 OR `props-main`.`id` = 1690081 OR `props-main`.`id` = 1682397 OR `props-main`.`id` = 1682824 OR `props-main`.`id` = 1679667 OR `props-main`.`id` = 1689015 OR `props-main`.`id` = 1689927 OR `props-main`.`id` = 1689960 OR `props-main`.`id` = 1676707 OR `props-main`.`id` = 1666127 OR `props-main`.`id` = 1682550 OR `props-main`.`id` = 1687368 OR `props-main`.`id` = 1679573 OR `props-main`.`id` = 1682299 OR `props-main`.`id` = 1689368 OR `props-main`.`id` = 1682790 OR `props-main`.`id` = 1689289 OR `props-main`.`id` = 1680782 OR `props-main`.`id` = 1688355 OR `props-main`.`id` = 1686502 OR `props-main`.`id` = 1686471 OR `props-main`.`id` = 1686577 OR `props-main`.`id` = 1685635 OR `props-main`.`id` = 1683869 OR `props-main`.`id` = 1663818 OR `props-main`.`id` = 1685321 OR `props-main`.`id` = 1674628 OR `props-main`.`id` = 1651003 OR `props-main`.`id` = 1682479 OR `props-main`.`id` = 1684032 OR `props-main`.`id` = 1689633 OR `props-main`.`id` = 1678880 OR `props-main`.`id` = 1690089 OR `props-main`.`id` = 1689398 OR `props-main`.`id` = 1685965 OR `props-main`.`id` = 1652791 OR `props-main`.`id` = 1667491 OR `props-main`.`id` = 1688326 OR `props-main`.`id` = 1682394 OR `props-main`.`id` = 1682091 OR `props-main`.`id` = 1684229 OR `props-main`.`id` = 1689040 OR `props-main`.`id` = 1689363 OR `props-main`.`id` = 1682395 OR `props-main`.`id` = 1690086 OR `props-main`.`id` = 1656938 OR `props-main`.`id` = 1668247 OR `props-main`.`id` = 1673535 OR `props-main`.`id` = 1673534 OR `props-main`.`id` = 1673533 OR `props-main`.`id` = 1673532 OR `props-main`.`id` = 1690488)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224087021' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-18' 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();
1
We're sorry, this listing is no longer available. Here are some similar properties you may be interested in:
$629,000
5
4
3,312
0.14
238 Romanov Ct
Patterson, CA 95363
Courtesy of Cyndy Gomes, Realty World -RW 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.