A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1804050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1993950 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) >= 2160 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2660 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` = 1686229 OR `props-main`.`id` = 1623325 OR `props-main`.`id` = 1645649 OR `props-main`.`id` = 1689676 OR `props-main`.`id` = 1687521 OR `props-main`.`id` = 1644744 OR `props-main`.`id` = 1630075 OR `props-main`.`id` = 1657720 OR `props-main`.`id` = 1671310 OR `props-main`.`id` = 1679096 OR `props-main`.`id` = 1623335 OR `props-main`.`id` = 1689077 OR `props-main`.`id` = 1648754 OR `props-main`.`id` = 1658089 OR `props-main`.`id` = 1670977 OR `props-main`.`id` = 1623290 OR `props-main`.`id` = 1623324 OR `props-main`.`id` = 1648755 OR `props-main`.`id` = 1623523 OR `props-main`.`id` = 1687266 OR `props-main`.`id` = 1688233 OR `props-main`.`id` = 1679066 OR `props-main`.`id` = 1682149 OR `props-main`.`id` = 1676186 OR `props-main`.`id` = 1672849 OR `props-main`.`id` = 1623422 OR `props-main`.`id` = 1631554 OR `props-main`.`id` = 1654613 OR `props-main`.`id` = 1676380 OR `props-main`.`id` = 1649668 OR `props-main`.`id` = 1676381 OR `props-main`.`id` = 1677645 OR `props-main`.`id` = 1678513 OR `props-main`.`id` = 1631254 OR `props-main`.`id` = 1674869 OR `props-main`.`id` = 1683986 OR `props-main`.`id` = 1684637 OR `props-main`.`id` = 1614789 OR `props-main`.`id` = 1663815 OR `props-main`.`id` = 1689409 OR `props-main`.`id` = 1687113 OR `props-main`.`id` = 1672059 OR `props-main`.`id` = 1672838 OR `props-main`.`id` = 1663283 OR `props-main`.`id` = 1664425 OR `props-main`.`id` = 1665660 OR `props-main`.`id` = 1647118 OR `props-main`.`id` = 1674224 OR `props-main`.`id` = 1663651 OR `props-main`.`id` = 1683156 OR `props-main`.`id` = 1642785 OR `props-main`.`id` = 1642773 OR `props-main`.`id` = 1667554 OR `props-main`.`id` = 1662005 OR `props-main`.`id` = 1646610 OR `props-main`.`id` = 1686614 OR `props-main`.`id` = 1672996 OR `props-main`.`id` = 1688112 OR `props-main`.`id` = 1671690)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC24153701' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-20' 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.
