A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1330000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1470000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2015 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2515 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` = 1748717 OR `props-main`.`id` = 1756000 OR `props-main`.`id` = 1694310 OR `props-main`.`id` = 1748347 OR `props-main`.`id` = 1754147 OR `props-main`.`id` = 1748346 OR `props-main`.`id` = 1754146 OR `props-main`.`id` = 1742121 OR `props-main`.`id` = 1751557 OR `props-main`.`id` = 1725086 OR `props-main`.`id` = 1705859 OR `props-main`.`id` = 1728653 OR `props-main`.`id` = 1754523 OR `props-main`.`id` = 1723358 OR `props-main`.`id` = 1746797 OR `props-main`.`id` = 1741280 OR `props-main`.`id` = 1751700 OR `props-main`.`id` = 1747961 OR `props-main`.`id` = 1740247 OR `props-main`.`id` = 1736465 OR `props-main`.`id` = 1758267 OR `props-main`.`id` = 1751577 OR `props-main`.`id` = 1755215 OR `props-main`.`id` = 1755568 OR `props-main`.`id` = 1747807 OR `props-main`.`id` = 1727453 OR `props-main`.`id` = 1744918 OR `props-main`.`id` = 1722950 OR `props-main`.`id` = 1744826 OR `props-main`.`id` = 1717146 OR `props-main`.`id` = 1732323 OR `props-main`.`id` = 1709437 OR `props-main`.`id` = 1723370 OR `props-main`.`id` = 1752938 OR `props-main`.`id` = 1754759 OR `props-main`.`id` = 1746759 OR `props-main`.`id` = 1745709 OR `props-main`.`id` = 1745710 OR `props-main`.`id` = 1739703 OR `props-main`.`id` = 1728912 OR `props-main`.`id` = 1752937 OR `props-main`.`id` = 1755890 OR `props-main`.`id` = 1754244 OR `props-main`.`id` = 1726864 OR `props-main`.`id` = 1734751 OR `props-main`.`id` = 1753289 OR `props-main`.`id` = 1747203 OR `props-main`.`id` = 1738785 OR `props-main`.`id` = 1734914 OR `props-main`.`id` = 1668328 OR `props-main`.`id` = 1739796 OR `props-main`.`id` = 1746467 OR `props-main`.`id` = 1731068 OR `props-main`.`id` = 1718405 OR `props-main`.`id` = 1758760 OR `props-main`.`id` = 1703477 OR `props-main`.`id` = 1755756 OR `props-main`.`id` = 1722576 OR `props-main`.`id` = 1749438 OR `props-main`.`id` = 1719130 OR `props-main`.`id` = 1741205 OR `props-main`.`id` = 1697961 OR `props-main`.`id` = 1719221 OR `props-main`.`id` = 1731959 OR `props-main`.`id` = 1749592 OR `props-main`.`id` = 1740681 OR `props-main`.`id` = 1740682 OR `props-main`.`id` = 1722846 OR `props-main`.`id` = 1724922 OR `props-main`.`id` = 1715796 OR `props-main`.`id` = 1745318 OR `props-main`.`id` = 1740686 OR `props-main`.`id` = 1742683 OR `props-main`.`id` = 1723411 OR `props-main`.`id` = 1715819 OR `props-main`.`id` = 1752423 OR `props-main`.`id` = 1735953 OR `props-main`.`id` = 1757570 OR `props-main`.`id` = 1737051 OR `props-main`.`id` = 1756959 OR `props-main`.`id` = 1738546 OR `props-main`.`id` = 1749789 OR `props-main`.`id` = 1754574 OR `props-main`.`id` = 1755278 OR `props-main`.`id` = 1728506 OR `props-main`.`id` = 1734674 OR `props-main`.`id` = 1755671 OR `props-main`.`id` = 1722615 OR `props-main`.`id` = 1758796 OR `props-main`.`id` = 1689004 OR `props-main`.`id` = 1702071 OR `props-main`.`id` = 1718145 OR `props-main`.`id` = 1733424 OR `props-main`.`id` = 1745736 OR `props-main`.`id` = 1745737 OR `props-main`.`id` = 1745745 OR `props-main`.`id` = 1747456 OR `props-main`.`id` = 1751633 OR `props-main`.`id` = 1727084 OR `props-main`.`id` = 1753508 OR `props-main`.`id` = 1728366 OR `props-main`.`id` = 1744634 OR `props-main`.`id` = 1723409 OR `props-main`.`id` = 1727169 OR `props-main`.`id` = 1728947 OR `props-main`.`id` = 1750115 OR `props-main`.`id` = 1658740 OR `props-main`.`id` = 1742123 OR `props-main`.`id` = 1744695 OR `props-main`.`id` = 1702661 OR `props-main`.`id` = 1702662 OR `props-main`.`id` = 1744822 OR `props-main`.`id` = 1710121 OR `props-main`.`id` = 1641603 OR `props-main`.`id` = 1751611 OR `props-main`.`id` = 1751612 OR `props-main`.`id` = 1746713 OR `props-main`.`id` = 1754902 OR `props-main`.`id` = 1712694 OR `props-main`.`id` = 1727094 OR `props-main`.`id` = 1758822 OR `props-main`.`id` = 1727511 OR `props-main`.`id` = 1738353 OR `props-main`.`id` = 1727303 OR `props-main`.`id` = 1674173 OR `props-main`.`id` = 1704939 OR `props-main`.`id` = 1725902 OR `props-main`.`id` = 1704390 OR `props-main`.`id` = 1758870 OR `props-main`.`id` = 1758795 OR `props-main`.`id` = 1723408 OR `props-main`.`id` = 1758317 OR `props-main`.`id` = 1758316 OR `props-main`.`id` = 1733506 OR `props-main`.`id` = 1719000 OR `props-main`.`id` = 1719080 OR `props-main`.`id` = 1723412 OR `props-main`.`id` = 1713358 OR `props-main`.`id` = 1728223 OR `props-main`.`id` = 1702146 OR `props-main`.`id` = 1724427 OR `props-main`.`id` = 1724969 OR `props-main`.`id` = 1740844 OR `props-main`.`id` = 1723383 OR `props-main`.`id` = 1752457 OR `props-main`.`id` = 1723381 OR `props-main`.`id` = 1745268 OR `props-main`.`id` = 1736665 OR `props-main`.`id` = 1736415 OR `props-main`.`id` = 1723386)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC26171288' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-06' 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 10,800 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.
