A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 607050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 670950 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) >= 1042 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1542 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` = 1688776 OR `props-main`.`id` = 1679568 OR `props-main`.`id` = 1623316 OR `props-main`.`id` = 1645585 OR `props-main`.`id` = 1623322 OR `props-main`.`id` = 1683593 OR `props-main`.`id` = 1685230 OR `props-main`.`id` = 1687947 OR `props-main`.`id` = 1674399 OR `props-main`.`id` = 1623423 OR `props-main`.`id` = 1679005 OR `props-main`.`id` = 1688154 OR `props-main`.`id` = 1689134 OR `props-main`.`id` = 1686113 OR `props-main`.`id` = 1688321 OR `props-main`.`id` = 1690120 OR `props-main`.`id` = 1689318 OR `props-main`.`id` = 1656674 OR `props-main`.`id` = 1630139 OR `props-main`.`id` = 1630473 OR `props-main`.`id` = 1685569 OR `props-main`.`id` = 1686199 OR `props-main`.`id` = 1623519 OR `props-main`.`id` = 1689539 OR `props-main`.`id` = 1674172 OR `props-main`.`id` = 1687515 OR `props-main`.`id` = 1671623 OR `props-main`.`id` = 1657811 OR `props-main`.`id` = 1674195 OR `props-main`.`id` = 1647434 OR `props-main`.`id` = 1680756 OR `props-main`.`id` = 1647433 OR `props-main`.`id` = 1689991 OR `props-main`.`id` = 1671633 OR `props-main`.`id` = 1689228 OR `props-main`.`id` = 1672831 OR `props-main`.`id` = 1688153 OR `props-main`.`id` = 1680831 OR `props-main`.`id` = 1685477 OR `props-main`.`id` = 1686613 OR `props-main`.`id` = 1689249 OR `props-main`.`id` = 1652999 OR `props-main`.`id` = 1689943 OR `props-main`.`id` = 1673686 OR `props-main`.`id` = 1637276 OR `props-main`.`id` = 1684925 OR `props-main`.`id` = 1685281 OR `props-main`.`id` = 1679278 OR `props-main`.`id` = 1649121 OR `props-main`.`id` = 1652503 OR `props-main`.`id` = 1683271 OR `props-main`.`id` = 1663489 OR `props-main`.`id` = 1689459 OR `props-main`.`id` = 1636610 OR `props-main`.`id` = 1623381 OR `props-main`.`id` = 1655059 OR `props-main`.`id` = 1678609 OR `props-main`.`id` = 1674440 OR `props-main`.`id` = 1631363)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsNS24119749' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-16' 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,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.
