A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 356250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 393750 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) >= 1623 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2123 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` = 1679442 OR `props-main`.`id` = 1678456 OR `props-main`.`id` = 1628670 OR `props-main`.`id` = 1683595 OR `props-main`.`id` = 1683546 OR `props-main`.`id` = 1662107 OR `props-main`.`id` = 1663595 OR `props-main`.`id` = 1678030 OR `props-main`.`id` = 1680607 OR `props-main`.`id` = 1680508 OR `props-main`.`id` = 1683812 OR `props-main`.`id` = 1684450 OR `props-main`.`id` = 1657894 OR `props-main`.`id` = 1657801 OR `props-main`.`id` = 1655245 OR `props-main`.`id` = 1656027 OR `props-main`.`id` = 1665961 OR `props-main`.`id` = 1627422 OR `props-main`.`id` = 1656083 OR `props-main`.`id` = 1667708 OR `props-main`.`id` = 1690118 OR `props-main`.`id` = 1675312 OR `props-main`.`id` = 1675296 OR `props-main`.`id` = 1687671 OR `props-main`.`id` = 1625993 OR `props-main`.`id` = 1624150 OR `props-main`.`id` = 1675191 OR `props-main`.`id` = 1682209 OR `props-main`.`id` = 1681494 OR `props-main`.`id` = 1681769 OR `props-main`.`id` = 1681879 OR `props-main`.`id` = 1677217 OR `props-main`.`id` = 1680271 OR `props-main`.`id` = 1689881 OR `props-main`.`id` = 1639078 OR `props-main`.`id` = 1639084)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR25017123' 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.
