A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1268250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1401750 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) >= 1472 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1972 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` = 1664313 OR `props-main`.`id` = 1664201 OR `props-main`.`id` = 1694310 OR `props-main`.`id` = 1650450 OR `props-main`.`id` = 1680132 OR `props-main`.`id` = 1688733 OR `props-main`.`id` = 1701304 OR `props-main`.`id` = 1689492 OR `props-main`.`id` = 1689540 OR `props-main`.`id` = 1701090 OR `props-main`.`id` = 1691509 OR `props-main`.`id` = 1696477 OR `props-main`.`id` = 1697022 OR `props-main`.`id` = 1685952 OR `props-main`.`id` = 1701610 OR `props-main`.`id` = 1700898 OR `props-main`.`id` = 1696311 OR `props-main`.`id` = 1656779 OR `props-main`.`id` = 1691058 OR `props-main`.`id` = 1658158 OR `props-main`.`id` = 1695747 OR `props-main`.`id` = 1676256 OR `props-main`.`id` = 1690590 OR `props-main`.`id` = 1677935 OR `props-main`.`id` = 1696414 OR `props-main`.`id` = 1686681 OR `props-main`.`id` = 1688182 OR `props-main`.`id` = 1695021 OR `props-main`.`id` = 1680646 OR `props-main`.`id` = 1668175 OR `props-main`.`id` = 1697961 OR `props-main`.`id` = 1623404 OR `props-main`.`id` = 1697318 OR `props-main`.`id` = 1634854 OR `props-main`.`id` = 1694997 OR `props-main`.`id` = 1697216 OR `props-main`.`id` = 1694169 OR `props-main`.`id` = 1683352 OR `props-main`.`id` = 1685789 OR `props-main`.`id` = 1697934 OR `props-main`.`id` = 1682120 OR `props-main`.`id` = 1672836 OR `props-main`.`id` = 1698807 OR `props-main`.`id` = 1658740 OR `props-main`.`id` = 1698484 OR `props-main`.`id` = 1688232 OR `props-main`.`id` = 1641603 OR `props-main`.`id` = 1696437 OR `props-main`.`id` = 1701142 OR `props-main`.`id` = 1695635)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC25268041' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-08' 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 8,100 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.
