A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 855000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 945000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1310 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1810 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` = 1683594 OR `props-main`.`id` = 1704306 OR `props-main`.`id` = 1685282 OR `props-main`.`id` = 1703910 OR `props-main`.`id` = 1697002 OR `props-main`.`id` = 1703395 OR `props-main`.`id` = 1701610 OR `props-main`.`id` = 1702239 OR `props-main`.`id` = 1668328 OR `props-main`.`id` = 1680645 OR `props-main`.`id` = 1695430 OR `props-main`.`id` = 1705858 OR `props-main`.`id` = 1703276 OR `props-main`.`id` = 1696617 OR `props-main`.`id` = 1698094 OR `props-main`.`id` = 1703477 OR `props-main`.`id` = 1706901 OR `props-main`.`id` = 1704370 OR `props-main`.`id` = 1704400 OR `props-main`.`id` = 1704412 OR `props-main`.`id` = 1707098 OR `props-main`.`id` = 1708488 OR `props-main`.`id` = 1702032 OR `props-main`.`id` = 1689688 OR `props-main`.`id` = 1689004 OR `props-main`.`id` = 1690389 OR `props-main`.`id` = 1690508 OR `props-main`.`id` = 1702071 OR `props-main`.`id` = 1704091 OR `props-main`.`id` = 1710129 OR `props-main`.`id` = 1707136 OR `props-main`.`id` = 1702661 OR `props-main`.`id` = 1702662 OR `props-main`.`id` = 1687991 OR `props-main`.`id` = 1710121 OR `props-main`.`id` = 1705965)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSW25215255' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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 8,700 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.
