A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 2280000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2520000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3295 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3795 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` = 1702436 OR `props-main`.`id` = 1718448 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` = 1702434 OR `props-main`.`id` = 1717778 OR `props-main`.`id` = 1716603 OR `props-main`.`id` = 1704048 OR `props-main`.`id` = 1716335 OR `props-main`.`id` = 1719125 OR `props-main`.`id` = 1716925 OR `props-main`.`id` = 1685543 OR `props-main`.`id` = 1698109 OR `props-main`.`id` = 1698112 OR `props-main`.`id` = 1715837 OR `props-main`.`id` = 1698111 OR `props-main`.`id` = 1707897 OR `props-main`.`id` = 1717813 OR `props-main`.`id` = 1711137 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` = 1707871 OR `props-main`.`id` = 1685873 OR `props-main`.`id` = 1702382 OR `props-main`.`id` = 1717361 OR `props-main`.`id` = 1701141 OR `props-main`.`id` = 1708226 OR `props-main`.`id` = 1695460 OR `props-main`.`id` = 1695599 OR `props-main`.`id` = 1704566 OR `props-main`.`id` = 1708381 OR `props-main`.`id` = 1712548 OR `props-main`.`id` = 1713770 OR `props-main`.`id` = 1712469 OR `props-main`.`id` = 1702313 OR `props-main`.`id` = 1707994 OR `props-main`.`id` = 1719422 OR `props-main`.`id` = 1718464 OR `props-main`.`id` = 1713070 OR `props-main`.`id` = 1718479 OR `props-main`.`id` = 1717812 OR `props-main`.`id` = 1713768 OR `props-main`.`id` = 1713150 OR `props-main`.`id` = 1693448 OR `props-main`.`id` = 1713211 OR `props-main`.`id` = 1719689 OR `props-main`.`id` = 1623058 OR `props-main`.`id` = 1719619 OR `props-main`.`id` = 1717264 OR `props-main`.`id` = 1718630 OR `props-main`.`id` = 1718361)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsNS24117496' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-03' 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,000 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.
