A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1710000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1890000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2201 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2701 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` = 1691575 OR `props-main`.`id` = 1702436 OR `props-main`.`id` = 1696939 OR `props-main`.`id` = 1691420 OR `props-main`.`id` = 1702900 OR `props-main`.`id` = 1716800 OR `props-main`.`id` = 1680387 OR `props-main`.`id` = 1659690 OR `props-main`.`id` = 1704564 OR `props-main`.`id` = 1623061 OR `props-main`.`id` = 1689223 OR `props-main`.`id` = 1695036 OR `props-main`.`id` = 1706938 OR `props-main`.`id` = 1623056 OR `props-main`.`id` = 1680063 OR `props-main`.`id` = 1712459 OR `props-main`.`id` = 1716042 OR `props-main`.`id` = 1713729 OR `props-main`.`id` = 1702434 OR `props-main`.`id` = 1716603 OR `props-main`.`id` = 1704048 OR `props-main`.`id` = 1716335 OR `props-main`.`id` = 1716925 OR `props-main`.`id` = 1711136 OR `props-main`.`id` = 1711134 OR `props-main`.`id` = 1714825 OR `props-main`.`id` = 1685543 OR `props-main`.`id` = 1698109 OR `props-main`.`id` = 1698110 OR `props-main`.`id` = 1698112 OR `props-main`.`id` = 1692090 OR `props-main`.`id` = 1715837 OR `props-main`.`id` = 1698111 OR `props-main`.`id` = 1692091 OR `props-main`.`id` = 1692092 OR `props-main`.`id` = 1693742 OR `props-main`.`id` = 1694005 OR `props-main`.`id` = 1707897 OR `props-main`.`id` = 1684438 OR `props-main`.`id` = 1706845 OR `props-main`.`id` = 1711137 OR `props-main`.`id` = 1716311 OR `props-main`.`id` = 1713444 OR `props-main`.`id` = 1711078 OR `props-main`.`id` = 1701091 OR `props-main`.`id` = 1709746 OR `props-main`.`id` = 1709285 OR `props-main`.`id` = 1698903 OR `props-main`.`id` = 1705198 OR `props-main`.`id` = 1716717 OR `props-main`.`id` = 1707871 OR `props-main`.`id` = 1685873 OR `props-main`.`id` = 1702382 OR `props-main`.`id` = 1701141 OR `props-main`.`id` = 1708226 OR `props-main`.`id` = 1695459 OR `props-main`.`id` = 1695460 OR `props-main`.`id` = 1695599 OR `props-main`.`id` = 1695602 OR `props-main`.`id` = 1704566 OR `props-main`.`id` = 1706939 OR `props-main`.`id` = 1708381 OR `props-main`.`id` = 1712548 OR `props-main`.`id` = 1713770 OR `props-main`.`id` = 1702313 OR `props-main`.`id` = 1707994 OR `props-main`.`id` = 1713070 OR `props-main`.`id` = 1713768 OR `props-main`.`id` = 1713150)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsNS26037838' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-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();
0
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 9,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.
