A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 812250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 897750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1130 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1630 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` = 1718793 OR `props-main`.`id` = 1706976 OR `props-main`.`id` = 1717722 OR `props-main`.`id` = 1718722 OR `props-main`.`id` = 1714021 OR `props-main`.`id` = 1716718 OR `props-main`.`id` = 1716361 OR `props-main`.`id` = 1715549 OR `props-main`.`id` = 1715548 OR `props-main`.`id` = 1715550 OR `props-main`.`id` = 1715551 OR `props-main`.`id` = 1683594 OR `props-main`.`id` = 1685282 OR `props-main`.`id` = 1713957 OR `props-main`.`id` = 1703910 OR `props-main`.`id` = 1717146 OR `props-main`.`id` = 1700898 OR `props-main`.`id` = 1716100 OR `props-main`.`id` = 1703395 OR `props-main`.`id` = 1718935 OR `props-main`.`id` = 1701610 OR `props-main`.`id` = 1714877 OR `props-main`.`id` = 1702239 OR `props-main`.`id` = 1712586 OR `props-main`.`id` = 1668328 OR `props-main`.`id` = 1716068 OR `props-main`.`id` = 1680645 OR `props-main`.`id` = 1713533 OR `props-main`.`id` = 1706989 OR `props-main`.`id` = 1705858 OR `props-main`.`id` = 1718405 OR `props-main`.`id` = 1703477 OR `props-main`.`id` = 1706901 OR `props-main`.`id` = 1704370 OR `props-main`.`id` = 1719130 OR `props-main`.`id` = 1716894 OR `props-main`.`id` = 1707098 OR `props-main`.`id` = 1715796 OR `props-main`.`id` = 1708488 OR `props-main`.`id` = 1702032 OR `props-main`.`id` = 1715820 OR `props-main`.`id` = 1713802 OR `props-main`.`id` = 1623404 OR `props-main`.`id` = 1715819 OR `props-main`.`id` = 1713731 OR `props-main`.`id` = 1714879 OR `props-main`.`id` = 1713172 OR `props-main`.`id` = 1683352 OR `props-main`.`id` = 1717364 OR `props-main`.`id` = 1689688 OR `props-main`.`id` = 1689004 OR `props-main`.`id` = 1690389 OR `props-main`.`id` = 1690508 OR `props-main`.`id` = 1702071 OR `props-main`.`id` = 1704091 OR `props-main`.`id` = 1717363 OR `props-main`.`id` = 1717764 OR `props-main`.`id` = 1718145 OR `props-main`.`id` = 1716666 OR `props-main`.`id` = 1707136 OR `props-main`.`id` = 1704248 OR `props-main`.`id` = 1709796 OR `props-main`.`id` = 1702661 OR `props-main`.`id` = 1702662 OR `props-main`.`id` = 1687991 OR `props-main`.`id` = 1710121 OR `props-main`.`id` = 1705965 OR `props-main`.`id` = 1713285 OR `props-main`.`id` = 1708336 OR `props-main`.`id` = 1716070 OR `props-main`.`id` = 1704366 OR `props-main`.`id` = 1717257 OR `props-main`.`id` = 1670934 OR `props-main`.`id` = 1674173 OR `props-main`.`id` = 1687145 OR `props-main`.`id` = 1689563 OR `props-main`.`id` = 1690437 OR `props-main`.`id` = 1704939 OR `props-main`.`id` = 1719000 OR `props-main`.`id` = 1719080 OR `props-main`.`id` = 1623531 OR `props-main`.`id` = 1702146 OR `props-main`.`id` = 1708333 OR `props-main`.`id` = 1717314 OR `props-main`.`id` = 1718875 OR `props-main`.`id` = 1712837 OR `props-main`.`id` = 1663980 OR `props-main`.`id` = 1679310 OR `props-main`.`id` = 1693384)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC24143179' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-01' 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,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.
