A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1187500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1312500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1359 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1859 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` = 1673317 OR `props-main`.`id` = 1685333 OR `props-main`.`id` = 1685334 OR `props-main`.`id` = 1688733 OR `props-main`.`id` = 1695275 OR `props-main`.`id` = 1684452 OR `props-main`.`id` = 1689492 OR `props-main`.`id` = 1689540 OR `props-main`.`id` = 1694572 OR `props-main`.`id` = 1685282 OR `props-main`.`id` = 1693760 OR `props-main`.`id` = 1691509 OR `props-main`.`id` = 1696377 OR `props-main`.`id` = 1696477 OR `props-main`.`id` = 1697022 OR `props-main`.`id` = 1685952 OR `props-main`.`id` = 1696311 OR `props-main`.`id` = 1623356 OR `props-main`.`id` = 1656779 OR `props-main`.`id` = 1697792 OR `props-main`.`id` = 1668641 OR `props-main`.`id` = 1691058 OR `props-main`.`id` = 1696388 OR `props-main`.`id` = 1658158 OR `props-main`.`id` = 1695747 OR `props-main`.`id` = 1676256 OR `props-main`.`id` = 1696312 OR `props-main`.`id` = 1668328 OR `props-main`.`id` = 1694682 OR `props-main`.`id` = 1649797 OR `props-main`.`id` = 1695010 OR `props-main`.`id` = 1695430 OR `props-main`.`id` = 1693409 OR `props-main`.`id` = 1667476 OR `props-main`.`id` = 1690590 OR `props-main`.`id` = 1677935 OR `props-main`.`id` = 1696414 OR `props-main`.`id` = 1686681 OR `props-main`.`id` = 1688182 OR `props-main`.`id` = 1695021 OR `props-main`.`id` = 1690705 OR `props-main`.`id` = 1680646 OR `props-main`.`id` = 1668175 OR `props-main`.`id` = 1623404 OR `props-main`.`id` = 1697318 OR `props-main`.`id` = 1634854 OR `props-main`.`id` = 1694997 OR `props-main`.`id` = 1697216 OR `props-main`.`id` = 1694169 OR `props-main`.`id` = 1683352 OR `props-main`.`id` = 1685789 OR `props-main`.`id` = 1689688 OR `props-main`.`id` = 1689004 OR `props-main`.`id` = 1686820 OR `props-main`.`id` = 1690389 OR `props-main`.`id` = 1690508 OR `props-main`.`id` = 1686324 OR `props-main`.`id` = 1682120 OR `props-main`.`id` = 1672836 OR `props-main`.`id` = 1658740 OR `props-main`.`id` = 1679463 OR `props-main`.`id` = 1687991 OR `props-main`.`id` = 1693431 OR `props-main`.`id` = 1688232 OR `props-main`.`id` = 1677845 OR `props-main`.`id` = 1641603 OR `props-main`.`id` = 1692519 OR `props-main`.`id` = 1696437 OR `props-main`.`id` = 1679733 OR `props-main`.`id` = 1697844 OR `props-main`.`id` = 1695483 OR `props-main`.`id` = 1688483 OR `props-main`.`id` = 1651646 OR `props-main`.`id` = 1695009 OR `props-main`.`id` = 1695635 OR `props-main`.`id` = 1684621 OR `props-main`.`id` = 1661116 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` = 1690437 OR `props-main`.`id` = 1623230 OR `props-main`.`id` = 1684233 OR `props-main`.`id` = 1695930 OR `props-main`.`id` = 1695931 OR `props-main`.`id` = 1623531 OR `props-main`.`id` = 1673218 OR `props-main`.`id` = 1683157 OR `props-main`.`id` = 1695007 OR `props-main`.`id` = 1668834 OR `props-main`.`id` = 1696967 OR `props-main`.`id` = 1663980 OR `props-main`.`id` = 1671277 OR `props-main`.`id` = 1659265 OR `props-main`.`id` = 1686667 OR `props-main`.`id` = 1679310 OR `props-main`.`id` = 1693384 OR `props-main`.`id` = 1679262 OR `props-main`.`id` = 1679263 OR `props-main`.`id` = 1651401 OR `props-main`.`id` = 1651403 OR `props-main`.`id` = 1691905 OR `props-main`.`id` = 1680174 OR `props-main`.`id` = 1689248 OR `props-main`.`id` = 1690991 OR `props-main`.`id` = 1697760 OR `props-main`.`id` = 1679240 OR `props-main`.`id` = 1694046 OR `props-main`.`id` = 1695016 OR `props-main`.`id` = 1694043 OR `props-main`.`id` = 1695018 OR `props-main`.`id` = 1623273 OR `props-main`.`id` = 1691542 OR `props-main`.`id` = 1675353 OR `props-main`.`id` = 1689756 OR `props-main`.`id` = 1695013 OR `props-main`.`id` = 1687911)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC25099512' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-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: