A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1187405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1312395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2548 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3048 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` = 1683594 OR `props-main`.`id` = 1685282 OR `props-main`.`id` = 1693760 OR `props-main`.`id` = 1697002 OR `props-main`.`id` = 1700931 OR `props-main`.`id` = 1668328 OR `props-main`.`id` = 1680645 OR `props-main`.`id` = 1695430 OR `props-main`.`id` = 1674938 OR `props-main`.`id` = 1696617 OR `props-main`.`id` = 1698094 OR `props-main`.`id` = 1686681 OR `props-main`.`id` = 1690705 OR `props-main`.`id` = 1698710 OR `props-main`.`id` = 1702032 OR `props-main`.`id` = 1697384 OR `props-main`.`id` = 1689688 OR `props-main`.`id` = 1689004 OR `props-main`.`id` = 1686820 OR `props-main`.`id` = 1690389 OR `props-main`.`id` = 1690508 OR `props-main`.`id` = 1702071 OR `props-main`.`id` = 1686324 OR `props-main`.`id` = 1679463 OR `props-main`.`id` = 1687991 OR `props-main`.`id` = 1677845)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC25178309' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-12' 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,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.
