A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 835050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 922950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 868 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1368 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` = 1685952 OR `props-main`.`id` = 1623356 OR `props-main`.`id` = 1656779 OR `props-main`.`id` = 1687187 OR `props-main`.`id` = 1687185 OR `props-main`.`id` = 1677583 OR `props-main`.`id` = 1676256 OR `props-main`.`id` = 1639001 OR `props-main`.`id` = 1667911 OR `props-main`.`id` = 1668328 OR `props-main`.`id` = 1683011 OR `props-main`.`id` = 1685169 OR `props-main`.`id` = 1688769 OR `props-main`.`id` = 1689406 OR `props-main`.`id` = 1667476 OR `props-main`.`id` = 1668250 OR `props-main`.`id` = 1685308 OR `props-main`.`id` = 1677935 OR `props-main`.`id` = 1686681 OR `props-main`.`id` = 1688182 OR `props-main`.`id` = 1680646 OR `props-main`.`id` = 1684468 OR `props-main`.`id` = 1668175 OR `props-main`.`id` = 1682121 OR `props-main`.`id` = 1640923 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` = 1683352 OR `props-main`.`id` = 1685789 OR `props-main`.`id` = 1689688 OR `props-main`.`id` = 1686115 OR `props-main`.`id` = 1686116 OR `props-main`.`id` = 1689004 OR `props-main`.`id` = 1686820 OR `props-main`.`id` = 1686324 OR `props-main`.`id` = 1687030 OR `props-main`.`id` = 1660912 OR `props-main`.`id` = 1673645 OR `props-main`.`id` = 1682120 OR `props-main`.`id` = 1672836 OR `props-main`.`id` = 1662389 OR `props-main`.`id` = 1658740 OR `props-main`.`id` = 1674123 OR `props-main`.`id` = 1685096 OR `props-main`.`id` = 1679463 OR `props-main`.`id` = 1687991 OR `props-main`.`id` = 1683269 OR `props-main`.`id` = 1688232 OR `props-main`.`id` = 1677845 OR `props-main`.`id` = 1688363 OR `props-main`.`id` = 1659156 OR `props-main`.`id` = 1641603 OR `props-main`.`id` = 1631809 OR `props-main`.`id` = 1678906 OR `props-main`.`id` = 1679733 OR `props-main`.`id` = 1685386 OR `props-main`.`id` = 1684457 OR `props-main`.`id` = 1688483 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` = 1661116 OR `props-main`.`id` = 1668176 OR `props-main`.`id` = 1670934 OR `props-main`.`id` = 1674173 OR `props-main`.`id` = 1680220 OR `props-main`.`id` = 1687145 OR `props-main`.`id` = 1687292 OR `props-main`.`id` = 1689563 OR `props-main`.`id` = 1623230 OR `props-main`.`id` = 1684233 OR `props-main`.`id` = 1659221 OR `props-main`.`id` = 1623531 OR `props-main`.`id` = 1673218 OR `props-main`.`id` = 1683157 OR `props-main`.`id` = 1685097 OR `props-main`.`id` = 1668834 OR `props-main`.`id` = 1671533 OR `props-main`.`id` = 1663980 OR `props-main`.`id` = 1668430 OR `props-main`.`id` = 1671277 OR `props-main`.`id` = 1658136 OR `props-main`.`id` = 1659265 OR `props-main`.`id` = 1660961 OR `props-main`.`id` = 1686667 OR `props-main`.`id` = 1679310 OR `props-main`.`id` = 1685940 OR `props-main`.`id` = 1687518 OR `props-main`.`id` = 1679262 OR `props-main`.`id` = 1679263 OR `props-main`.`id` = 1651401 OR `props-main`.`id` = 1651403 OR `props-main`.`id` = 1683484 OR `props-main`.`id` = 1683497 OR `props-main`.`id` = 1680174 OR `props-main`.`id` = 1688935 OR `props-main`.`id` = 1689248 OR `props-main`.`id` = 1683453 OR `props-main`.`id` = 1680342 OR `props-main`.`id` = 1659607 OR `props-main`.`id` = 1679240 OR `props-main`.`id` = 1623273 OR `props-main`.`id` = 1641276 OR `props-main`.`id` = 1669664 OR `props-main`.`id` = 1678654 OR `props-main`.`id` = 1680034 OR `props-main`.`id` = 1688183 OR `props-main`.`id` = 1675353 OR `props-main`.`id` = 1689756 OR `props-main`.`id` = 1688818 OR `props-main`.`id` = 1688080 OR `props-main`.`id` = 1668642 OR `props-main`.`id` = 1689378 OR `props-main`.`id` = 1676280 OR `props-main`.`id` = 1679948 OR `props-main`.`id` = 1686345 OR `props-main`.`id` = 1672865 OR `props-main`.`id` = 1678816 OR `props-main`.`id` = 1687271 OR `props-main`.`id` = 1687911)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC24134262' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-13' 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();

CAME_FROM_PROP_SITE: