A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 616075 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 680925 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) >= 1448 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1948 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` = 1696939 OR `props-main`.`id` = 1727224 OR `props-main`.`id` = 1725970 OR `props-main`.`id` = 1727105 OR `props-main`.`id` = 1691420 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` = 1702900 OR `props-main`.`id` = 1623056 OR `props-main`.`id` = 1722562 OR `props-main`.`id` = 1722306 OR `props-main`.`id` = 1735119 OR `props-main`.`id` = 1727063 OR `props-main`.`id` = 1721383 OR `props-main`.`id` = 1722271 OR `props-main`.`id` = 1728697 OR `props-main`.`id` = 1720514 OR `props-main`.`id` = 1730523 OR `props-main`.`id` = 1716603 OR `props-main`.`id` = 1733225 OR `props-main`.`id` = 1722741 OR `props-main`.`id` = 1716925 OR `props-main`.`id` = 1685543 OR `props-main`.`id` = 1734848 OR `props-main`.`id` = 1698109 OR `props-main`.`id` = 1698110 OR `props-main`.`id` = 1698112 OR `props-main`.`id` = 1734791 OR `props-main`.`id` = 1698111 OR `props-main`.`id` = 1692092 OR `props-main`.`id` = 1727702 OR `props-main`.`id` = 1693742 OR `props-main`.`id` = 1707897 OR `props-main`.`id` = 1684438 OR `props-main`.`id` = 1725658 OR `props-main`.`id` = 1724850 OR `props-main`.`id` = 1725935 OR `props-main`.`id` = 1727093 OR `props-main`.`id` = 1721040 OR `props-main`.`id` = 1724006 OR `props-main`.`id` = 1711078 OR `props-main`.`id` = 1723586 OR `props-main`.`id` = 1732909 OR `props-main`.`id` = 1723342 OR `props-main`.`id` = 1705198 OR `props-main`.`id` = 1734673 OR `props-main`.`id` = 1723359 OR `props-main`.`id` = 1727261 OR `props-main`.`id` = 1702382 OR `props-main`.`id` = 1727703 OR `props-main`.`id` = 1701141 OR `props-main`.`id` = 1708226 OR `props-main`.`id` = 1712548 OR `props-main`.`id` = 1720430 OR `props-main`.`id` = 1720431 OR `props-main`.`id` = 1722707 OR `props-main`.`id` = 1722743 OR `props-main`.`id` = 1724583 OR `props-main`.`id` = 1733428 OR `props-main`.`id` = 1712469 OR `props-main`.`id` = 1727285 OR `props-main`.`id` = 1721634 OR `props-main`.`id` = 1725349 OR `props-main`.`id` = 1728319 OR `props-main`.`id` = 1727385 OR `props-main`.`id` = 1732640 OR `props-main`.`id` = 1732641 OR `props-main`.`id` = 1728507 OR `props-main`.`id` = 1733226 OR `props-main`.`id` = 1726335 OR `props-main`.`id` = 1726337 OR `props-main`.`id` = 1713070 OR `props-main`.`id` = 1713150 OR `props-main`.`id` = 1726958 OR `props-main`.`id` = 1693448 OR `props-main`.`id` = 1727452 OR `props-main`.`id` = 1723344 OR `props-main`.`id` = 1724851 OR `props-main`.`id` = 1623058 OR `props-main`.`id` = 1719619 OR `props-main`.`id` = 1723368 OR `props-main`.`id` = 1724694 OR `props-main`.`id` = 1728473 OR `props-main`.`id` = 1727582 OR `props-main`.`id` = 1727782 OR `props-main`.`id` = 1724540 OR `props-main`.`id` = 1703016 OR `props-main`.`id` = 1722125)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsNS26107951' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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 10,600 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.
