A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 783750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 866250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '6' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 4466 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4966 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` = 1710047 OR `props-main`.`id` = 1710042 OR `props-main`.`id` = 1713324 OR `props-main`.`id` = 1707103 OR `props-main`.`id` = 1703089 OR `props-main`.`id` = 1698131 OR `props-main`.`id` = 1716163 OR `props-main`.`id` = 1715911 OR `props-main`.`id` = 1717352 OR `props-main`.`id` = 1717317 OR `props-main`.`id` = 1699212 OR `props-main`.`id` = 1699128 OR `props-main`.`id` = 1700176 OR `props-main`.`id` = 1700181 OR `props-main`.`id` = 1718484 OR `props-main`.`id` = 1712596 OR `props-main`.`id` = 1703754 OR `props-main`.`id` = 1695673 OR `props-main`.`id` = 1695864 OR `props-main`.`id` = 1687534 OR `props-main`.`id` = 1696418 OR `props-main`.`id` = 1696415 OR `props-main`.`id` = 1704916 OR `props-main`.`id` = 1704867 OR `props-main`.`id` = 1718198 OR `props-main`.`id` = 1657428 OR `props-main`.`id` = 1657431 OR `props-main`.`id` = 1705992 OR `props-main`.`id` = 1706003 OR `props-main`.`id` = 1718146 OR `props-main`.`id` = 1703575 OR `props-main`.`id` = 1687261 OR `props-main`.`id` = 1637104 OR `props-main`.`id` = 1690329 OR `props-main`.`id` = 1690188 OR `props-main`.`id` = 1705108 OR `props-main`.`id` = 1705099 OR `props-main`.`id` = 1716171 OR `props-main`.`id` = 1666303 OR `props-main`.`id` = 1704810 OR `props-main`.`id` = 1713130 OR `props-main`.`id` = 1687624 OR `props-main`.`id` = 1709501 OR `props-main`.`id` = 1709523 OR `props-main`.`id` = 1694724 OR `props-main`.`id` = 1715034 OR `props-main`.`id` = 230457)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR24115813' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-01' 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,200 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.
