A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 498750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 551250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2550 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3050 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` = 1687412 OR `props-main`.`id` = 1622892 OR `props-main`.`id` = 1645586 OR `props-main`.`id` = 1677642 OR `props-main`.`id` = 1685840 OR `props-main`.`id` = 1633654 OR `props-main`.`id` = 1633707 OR `props-main`.`id` = 1682495 OR `props-main`.`id` = 1674964 OR `props-main`.`id` = 1674950 OR `props-main`.`id` = 1686002 OR `props-main`.`id` = 1675303 OR `props-main`.`id` = 1688231 OR `props-main`.`id` = 1665550 OR `props-main`.`id` = 291212 OR `props-main`.`id` = 1687144 OR `props-main`.`id` = 1688063 OR `props-main`.`id` = 1671079 OR `props-main`.`id` = 788148 OR `props-main`.`id` = 1674412 OR `props-main`.`id` = 1678839 OR `props-main`.`id` = 1662202 OR `props-main`.`id` = 77474 OR `props-main`.`id` = 1681389 OR `props-main`.`id` = 1681378 OR `props-main`.`id` = 1659395 OR `props-main`.`id` = 1680302 OR `props-main`.`id` = 224715 OR `props-main`.`id` = 224717 OR `props-main`.`id` = 1687504 OR `props-main`.`id` = 1671187 OR `props-main`.`id` = 1688736 OR `props-main`.`id` = 1687983 OR `props-main`.`id` = 1684373 OR `props-main`.`id` = 1684370 OR `props-main`.`id` = 1689814 OR `props-main`.`id` = 1677195 OR `props-main`.`id` = 1652853 OR `props-main`.`id` = 93375 OR `props-main`.`id` = 1686717 OR `props-main`.`id` = 1683266 OR `props-main`.`id` = 1688172 OR `props-main`.`id` = 1688109 OR `props-main`.`id` = 1656258 OR `props-main`.`id` = 1690025 OR `props-main`.`id` = 1690031 OR `props-main`.`id` = 1690039 OR `props-main`.`id` = 1681127 OR `props-main`.`id` = 1637274 OR `props-main`.`id` = 1688618 OR `props-main`.`id` = 1689807 OR `props-main`.`id` = 1680032 OR `props-main`.`id` = 223289 OR `props-main`.`id` = 223288 OR `props-main`.`id` = 1659390 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1658305 OR `props-main`.`id` = 1684805 OR `props-main`.`id` = 1682982 OR `props-main`.`id` = 1688699 OR `props-main`.`id` = 1688686 OR `props-main`.`id` = 1677592 OR `props-main`.`id` = 202390 OR `props-main`.`id` = 1654695 OR `props-main`.`id` = 1666642 OR `props-main`.`id` = 1682741 OR `props-main`.`id` = 1681614 OR `props-main`.`id` = 1686623 OR `props-main`.`id` = 206435 OR `props-main`.`id` = 1686454 OR `props-main`.`id` = 1622703 OR `props-main`.`id` = 1682434 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1688832 OR `props-main`.`id` = 1680828 OR `props-main`.`id` = 1681077 OR `props-main`.`id` = 1667993 OR `props-main`.`id` = 1633539 OR `props-main`.`id` = 360956 OR `props-main`.`id` = 1685969 OR `props-main`.`id` = 1685977 OR `props-main`.`id` = 1622834 OR `props-main`.`id` = 1656522 OR `props-main`.`id` = 1678294 OR `props-main`.`id` = 1678342 OR `props-main`.`id` = 1678366 OR `props-main`.`id` = 1684707 OR `props-main`.`id` = 1683876 OR `props-main`.`id` = 1644740 OR `props-main`.`id` = 1688847 OR `props-main`.`id` = 1682921)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25109368' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-19' 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: