A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1709050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1888950 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) >= 2095 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2595 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` = 1678732 OR `props-main`.`id` = 1680132 OR `props-main`.`id` = 1688733 OR `props-main`.`id` = 1689492 OR `props-main`.`id` = 1689540 OR `props-main`.`id` = 1674987 OR `props-main`.`id` = 1623356 OR `props-main`.`id` = 1656779 OR `props-main`.`id` = 1668641 OR `props-main`.`id` = 1687187 OR `props-main`.`id` = 1687185 OR `props-main`.`id` = 1677583 OR `props-main`.`id` = 1658158 OR `props-main`.`id` = 1676256 OR `props-main`.`id` = 1676152 OR `props-main`.`id` = 1685169 OR `props-main`.`id` = 1688769 OR `props-main`.`id` = 1677935 OR `props-main`.`id` = 1688182 OR `props-main`.`id` = 1680646 OR `props-main`.`id` = 1668175 OR `props-main`.`id` = 1689859 OR `props-main`.`id` = 1623404 OR `props-main`.`id` = 1655570 OR `props-main`.`id` = 1634854 OR `props-main`.`id` = 1634855 OR `props-main`.`id` = 1683935 OR `props-main`.`id` = 1687003 OR `props-main`.`id` = 1690204 OR `props-main`.`id` = 1689990 OR `props-main`.`id` = 1683352 OR `props-main`.`id` = 1685789 OR `props-main`.`id` = 1686115 OR `props-main`.`id` = 1686116 OR `props-main`.`id` = 1682120 OR `props-main`.`id` = 1672836 OR `props-main`.`id` = 1658740 OR `props-main`.`id` = 1683269 OR `props-main`.`id` = 1688232 OR `props-main`.`id` = 1688363 OR `props-main`.`id` = 1641603 OR `props-main`.`id` = 1679733 OR `props-main`.`id` = 1685386 OR `props-main`.`id` = 1684457 OR `props-main`.`id` = 1685189 OR `props-main`.`id` = 1651646 OR `props-main`.`id` = 1685696 OR `props-main`.`id` = 1688777 OR `props-main`.`id` = 1675250 OR `props-main`.`id` = 1684621 OR `props-main`.`id` = 1623230 OR `props-main`.`id` = 1659221 OR `props-main`.`id` = 1683157 OR `props-main`.`id` = 1685097 OR `props-main`.`id` = 1668834 OR `props-main`.`id` = 1671533 OR `props-main`.`id` = 1658136 OR `props-main`.`id` = 1685940 OR `props-main`.`id` = 1679262 OR `props-main`.`id` = 1679263 OR `props-main`.`id` = 1675353)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC24141039' 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.
