A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 417990.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 461989.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1894 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2394 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` = 1686833 OR `props-main`.`id` = 1686834 OR `props-main`.`id` = 1674716 OR `props-main`.`id` = 1655732 OR `props-main`.`id` = 1655741 OR `props-main`.`id` = 1685911 OR `props-main`.`id` = 1668678 OR `props-main`.`id` = 1681610 OR `props-main`.`id` = 1655334 OR `props-main`.`id` = 1671944 OR `props-main`.`id` = 1683996 OR `props-main`.`id` = 1666082 OR `props-main`.`id` = 1685906 OR `props-main`.`id` = 1677614 OR `props-main`.`id` = 1687707 OR `props-main`.`id` = 1666114 OR `props-main`.`id` = 1687596 OR `props-main`.`id` = 1689856 OR `props-main`.`id` = 1689840 OR `props-main`.`id` = 1689022 OR `props-main`.`id` = 1681951 OR `props-main`.`id` = 1687593 OR `props-main`.`id` = 1687674 OR `props-main`.`id` = 1677984 OR `props-main`.`id` = 1677976 OR `props-main`.`id` = 1687095 OR `props-main`.`id` = 1687703 OR `props-main`.`id` = 1685276 OR `props-main`.`id` = 1689456 OR `props-main`.`id` = 1689452 OR `props-main`.`id` = 1678692 OR `props-main`.`id` = 1687690 OR `props-main`.`id` = 1687689 OR `props-main`.`id` = 1668732 OR `props-main`.`id` = 1668734 OR `props-main`.`id` = 1665952 OR `props-main`.`id` = 1683765 OR `props-main`.`id` = 1683758 OR `props-main`.`id` = 1687580 OR `props-main`.`id` = 1683170 OR `props-main`.`id` = 1627345 OR `props-main`.`id` = 1686072 OR `props-main`.`id` = 1674929 OR `props-main`.`id` = 1673519 OR `props-main`.`id` = 1674105 OR `props-main`.`id` = 1687539 OR `props-main`.`id` = 1665722 OR `props-main`.`id` = 1686235 OR `props-main`.`id` = 1645467 OR `props-main`.`id` = 1645426 OR `props-main`.`id` = 1687545 OR `props-main`.`id` = 1665764 OR `props-main`.`id` = 1676314 OR `props-main`.`id` = 1689800 OR `props-main`.`id` = 1676282 OR `props-main`.`id` = 1665914 OR `props-main`.`id` = 1691336 OR `props-main`.`id` = 1684120 OR `props-main`.`id` = 1687694 OR `props-main`.`id` = 1691059 OR `props-main`.`id` = 1639077 OR `props-main`.`id` = 91486 OR `props-main`.`id` = 1691258 OR `props-main`.`id` = 1675445 OR `props-main`.`id` = 1686832 OR `props-main`.`id` = 1682083 OR `props-main`.`id` = 1671972 OR `props-main`.`id` = 1666255 OR `props-main`.`id` = 1681315 OR `props-main`.`id` = 1687686 OR `props-main`.`id` = 1683078 OR `props-main`.`id` = 1677182 OR `props-main`.`id` = 1677212 OR `props-main`.`id` = 1673119 OR `props-main`.`id` = 1667788 OR `props-main`.`id` = 1680100 OR `props-main`.`id` = 1687683 OR `props-main`.`id` = 1663346 OR `props-main`.`id` = 1663343 OR `props-main`.`id` = 1662244 OR `props-main`.`id` = 1666398 OR `props-main`.`id` = 1666375 OR `props-main`.`id` = 1689623 OR `props-main`.`id` = 1689619 OR `props-main`.`id` = 1681704 OR `props-main`.`id` = 1678562 OR `props-main`.`id` = 1661856 OR `props-main`.`id` = 1651393 OR `props-main`.`id` = 1651359 OR `props-main`.`id` = 1685231 OR `props-main`.`id` = 1687215 OR `props-main`.`id` = 1665711 OR `props-main`.`id` = 1687249 OR `props-main`.`id` = 1677241 OR `props-main`.`id` = 1688936 OR `props-main`.`id` = 1684122 OR `props-main`.`id` = 1676310 OR `props-main`.`id` = 1684942 OR `props-main`.`id` = 1687174 OR `props-main`.`id` = 1681930 OR `props-main`.`id` = 1681934 OR `props-main`.`id` = 1651395 OR `props-main`.`id` = 1685316 OR `props-main`.`id` = 1687693 OR `props-main`.`id` = 1683729 OR `props-main`.`id` = 1687651 OR `props-main`.`id` = 1671327 OR `props-main`.`id` = 1689125 OR `props-main`.`id` = 1656543 OR `props-main`.`id` = 1641618 OR `props-main`.`id` = 1689798 OR `props-main`.`id` = 1688978 OR `props-main`.`id` = 1690771 OR `props-main`.`id` = 1690786 OR `props-main`.`id` = 1666316 OR `props-main`.`id` = 1665717 OR `props-main`.`id` = 1684139 OR `props-main`.`id` = 1679171 OR `props-main`.`id` = 1679133 OR `props-main`.`id` = 1684130 OR `props-main`.`id` = 1684155 OR `props-main`.`id` = 1687535 OR `props-main`.`id` = 1678506 OR `props-main`.`id` = 1665731 OR `props-main`.`id` = 1648120 OR `props-main`.`id` = 1687573 OR `props-main`.`id` = 1677672 OR `props-main`.`id` = 1659659 OR `props-main`.`id` = 1659570 OR `props-main`.`id` = 1678495 OR `props-main`.`id` = 1665915 OR `props-main`.`id` = 1666171 OR `props-main`.`id` = 1676323 OR `props-main`.`id` = 1676330)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR24206566' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-26' 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();