A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 949905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1049895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2012 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2512 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` = 1692233 OR `props-main`.`id` = 1711358 OR `props-main`.`id` = 1717437 OR `props-main`.`id` = 1719722 OR `props-main`.`id` = 1716860 OR `props-main`.`id` = 1715036 OR `props-main`.`id` = 1623331 OR `props-main`.`id` = 1696571 OR `props-main`.`id` = 1716893 OR `props-main`.`id` = 1623354 OR `props-main`.`id` = 1623384 OR `props-main`.`id` = 1678374 OR `props-main`.`id` = 1705624 OR `props-main`.`id` = 1713803 OR `props-main`.`id` = 1705101 OR `props-main`.`id` = 1719212 OR `props-main`.`id` = 1683859 OR `props-main`.`id` = 1685443 OR `props-main`.`id` = 1683858 OR `props-main`.`id` = 1680741 OR `props-main`.`id` = 1716802 OR `props-main`.`id` = 1689135 OR `props-main`.`id` = 1650063 OR `props-main`.`id` = 1678678 OR `props-main`.`id` = 1707099 OR `props-main`.`id` = 1695227 OR `props-main`.`id` = 1717408 OR `props-main`.`id` = 1623330 OR `props-main`.`id` = 1623333 OR `props-main`.`id` = 1716981 OR `props-main`.`id` = 1713385 OR `props-main`.`id` = 1683857 OR `props-main`.`id` = 1716934 OR `props-main`.`id` = 1715652 OR `props-main`.`id` = 1709797 OR `props-main`.`id` = 1676382 OR `props-main`.`id` = 1697849 OR `props-main`.`id` = 1716315 OR `props-main`.`id` = 1654369 OR `props-main`.`id` = 1684624 OR `props-main`.`id` = 1623382 OR `props-main`.`id` = 1707241 OR `props-main`.`id` = 1715618 OR `props-main`.`id` = 1705320 OR `props-main`.`id` = 1701337 OR `props-main`.`id` = 1716316 OR `props-main`.`id` = 1691920 OR `props-main`.`id` = 1712964 OR `props-main`.`id` = 1709224 OR `props-main`.`id` = 1683862 OR `props-main`.`id` = 1717012 OR `props-main`.`id` = 1716927 OR `props-main`.`id` = 1716365 OR `props-main`.`id` = 1707013 OR `props-main`.`id` = 1717678 OR `props-main`.`id` = 1702959 OR `props-main`.`id` = 1623314 OR `props-main`.`id` = 1713640 OR `props-main`.`id` = 1716521 OR `props-main`.`id` = 1691955 OR `props-main`.`id` = 1614985 OR `props-main`.`id` = 1713383 OR `props-main`.`id` = 1673471 OR `props-main`.`id` = 1697861 OR `props-main`.`id` = 1697862 OR `props-main`.`id` = 1716270 OR `props-main`.`id` = 1657721 OR `props-main`.`id` = 1623520 OR `props-main`.`id` = 1697865 OR `props-main`.`id` = 1713284 OR `props-main`.`id` = 1702417 OR `props-main`.`id` = 1623374 OR `props-main`.`id` = 1712962 OR `props-main`.`id` = 1717649 OR `props-main`.`id` = 1623339 OR `props-main`.`id` = 1673922 OR `props-main`.`id` = 1623179 OR `props-main`.`id` = 1685474 OR `props-main`.`id` = 1698744 OR `props-main`.`id` = 1637999 OR `props-main`.`id` = 1699188 OR `props-main`.`id` = 1700092 OR `props-main`.`id` = 1700062 OR `props-main`.`id` = 1718555 OR `props-main`.`id` = 1623334 OR `props-main`.`id` = 1716928 OR `props-main`.`id` = 1715620 OR `props-main`.`id` = 1623498 OR `props-main`.`id` = 1706923 OR `props-main`.`id` = 1696938 OR `props-main`.`id` = 1717536 OR `props-main`.`id` = 1623321 OR `props-main`.`id` = 1719050 OR `props-main`.`id` = 1690475 OR `props-main`.`id` = 1701753 OR `props-main`.`id` = 1716926 OR `props-main`.`id` = 1690042 OR `props-main`.`id` = 1660475 OR `props-main`.`id` = 1660474 OR `props-main`.`id` = 1717299 OR `props-main`.`id` = 1662548 OR `props-main`.`id` = 1671625 OR `props-main`.`id` = 1713775 OR `props-main`.`id` = 1623328 OR `props-main`.`id` = 1712991 OR `props-main`.`id` = 1719218 OR `props-main`.`id` = 1716230 OR `props-main`.`id` = 1705895 OR `props-main`.`id` = 1713011 OR `props-main`.`id` = 1659648 OR `props-main`.`id` = 1658009 OR `props-main`.`id` = 1713151 OR `props-main`.`id` = 1719620)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsSC24118819' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-03' 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: