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` = 1743807 OR `props-main`.`id` = 1745673 OR `props-main`.`id` = 1747150 OR `props-main`.`id` = 1738743 OR `props-main`.`id` = 1760791 OR `props-main`.`id` = 1728062 OR `props-main`.`id` = 1760270 OR `props-main`.`id` = 1721983 OR `props-main`.`id` = 1728855 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` = 1729214 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` = 1748610 OR `props-main`.`id` = 1755207 OR `props-main`.`id` = 1755812 OR `props-main`.`id` = 1766354 OR `props-main`.`id` = 1757061 OR `props-main`.`id` = 1727656 OR `props-main`.`id` = 1736933 OR `props-main`.`id` = 1736886 OR `props-main`.`id` = 1771244 OR `props-main`.`id` = 1747275 OR `props-main`.`id` = 1758815 OR `props-main`.`id` = 1734590 OR `props-main`.`id` = 1758253 OR `props-main`.`id` = 1768310 OR `props-main`.`id` = 1728037 OR `props-main`.`id` = 1771245 OR `props-main`.`id` = 1754356 OR `props-main`.`id` = 1734910 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-09-04' 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();
0
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 11,100 active listings.
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.
