A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 588050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 649950 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) >= 1713 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2213 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` = 1739085 OR `props-main`.`id` = 1745673 OR `props-main`.`id` = 1747150 OR `props-main`.`id` = 1738743 OR `props-main`.`id` = 1728062 OR `props-main`.`id` = 1792408 OR `props-main`.`id` = 1792437 OR `props-main`.`id` = 1760270 OR `props-main`.`id` = 1721983 OR `props-main`.`id` = 1779001 OR `props-main`.`id` = 1779594 OR `props-main`.`id` = 1728855 OR `props-main`.`id` = 1781543 OR `props-main`.`id` = 1763178 OR `props-main`.`id` = 1738332 OR `props-main`.`id` = 1766255 OR `props-main`.`id` = 1765361 OR `props-main`.`id` = 1765362 OR `props-main`.`id` = 1736935 OR `props-main`.`id` = 1730605 OR `props-main`.`id` = 1758814 OR `props-main`.`id` = 1736932 OR `props-main`.`id` = 1763247 OR `props-main`.`id` = 1729169 OR `props-main`.`id` = 1737390 OR `props-main`.`id` = 1745730 OR `props-main`.`id` = 1755812 OR `props-main`.`id` = 1780597 OR `props-main`.`id` = 1757061 OR `props-main`.`id` = 1782524 OR `props-main`.`id` = 1736933 OR `props-main`.`id` = 1736886 OR `props-main`.`id` = 1771244 OR `props-main`.`id` = 1747275 OR `props-main`.`id` = 1787416 OR `props-main`.`id` = 1773146 OR `props-main`.`id` = 1758815 OR `props-main`.`id` = 1734590 OR `props-main`.`id` = 1790970 OR `props-main`.`id` = 1758253 OR `props-main`.`id` = 1768310 OR `props-main`.`id` = 1772017 OR `props-main`.`id` = 1728037 OR `props-main`.`id` = 1791663 OR `props-main`.`id` = 1780949 OR `props-main`.`id` = 1754356 OR `props-main`.`id` = 1734910 OR `props-main`.`id` = 1793294 OR `props-main`.`id` = 1729040 OR `props-main`.`id` = 1770969 OR `props-main`.`id` = 1749751)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML82032647' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-19' 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
3
2
1,840
0.19
18981 Old Bridge Road
Jamestown, CA 95327
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.
