A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 2370250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2619750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3821 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4321 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` = 1677631 OR `props-main`.`id` = 1657141 OR `props-main`.`id` = 1687433 OR `props-main`.`id` = 1638830 OR `props-main`.`id` = 1678611 OR `props-main`.`id` = 1667546 OR `props-main`.`id` = 1685443 OR `props-main`.`id` = 1680741 OR `props-main`.`id` = 1689135 OR `props-main`.`id` = 1678678 OR `props-main`.`id` = 1688924 OR `props-main`.`id` = 1623330 OR `props-main`.`id` = 1688923 OR `props-main`.`id` = 1683857 OR `props-main`.`id` = 1656566 OR `props-main`.`id` = 1676382 OR `props-main`.`id` = 1688620 OR `props-main`.`id` = 1685717 OR `props-main`.`id` = 1623446 OR `props-main`.`id` = 1654369 OR `props-main`.`id` = 1684624 OR `props-main`.`id` = 1623382 OR `props-main`.`id` = 1623424 OR `props-main`.`id` = 1674377 OR `props-main`.`id` = 1687513 OR `props-main`.`id` = 1660411 OR `props-main`.`id` = 1683862 OR `props-main`.`id` = 1679376 OR `props-main`.`id` = 1679377 OR `props-main`.`id` = 1645717 OR `props-main`.`id` = 1684974 OR `props-main`.`id` = 1680341 OR `props-main`.`id` = 1680714 OR `props-main`.`id` = 1689711 OR `props-main`.`id` = 1615049 OR `props-main`.`id` = 1623314 OR `props-main`.`id` = 1614985 OR `props-main`.`id` = 1659370 OR `props-main`.`id` = 1673471 OR `props-main`.`id` = 1606100 OR `props-main`.`id` = 1606104 OR `props-main`.`id` = 1623462 OR `props-main`.`id` = 1623464 OR `props-main`.`id` = 1657721 OR `props-main`.`id` = 1675354 OR `props-main`.`id` = 1656237 OR `props-main`.`id` = 1623520 OR `props-main`.`id` = 1662547 OR `props-main`.`id` = 1623374 OR `props-main`.`id` = 1623341 OR `props-main`.`id` = 1623339 OR `props-main`.`id` = 1673922 OR `props-main`.`id` = 1623179 OR `props-main`.`id` = 1651004 OR `props-main`.`id` = 1685474 OR `props-main`.`id` = 1684530 OR `props-main`.`id` = 1679173 OR `props-main`.`id` = 1637999 OR `props-main`.`id` = 1689246 OR `props-main`.`id` = 1617443 OR `props-main`.`id` = 1623334 OR `props-main`.`id` = 1681415 OR `props-main`.`id` = 1623498 OR `props-main`.`id` = 1681186 OR `props-main`.`id` = 1649796 OR `props-main`.`id` = 1651962 OR `props-main`.`id` = 1676651 OR `props-main`.`id` = 1623321 OR `props-main`.`id` = 1686025 OR `props-main`.`id` = 1690042 OR `props-main`.`id` = 1658008 OR `props-main`.`id` = 1660475 OR `props-main`.`id` = 1660474 OR `props-main`.`id` = 1681528 OR `props-main`.`id` = 1662548 OR `props-main`.`id` = 1671625 OR `props-main`.`id` = 1623328 OR `props-main`.`id` = 1631992 OR `props-main`.`id` = 1652644 OR `props-main`.`id` = 1659648 OR `props-main`.`id` = 1658009 OR `props-main`.`id` = 1650449 OR `props-main`.`id` = 1654344)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC24146550' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-16' 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.
