A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 418000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 462000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1283 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1783 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` = 1686571 OR `props-main`.`id` = 1686555 OR `props-main`.`id` = 1682739 OR `props-main`.`id` = 1687937 OR `props-main`.`id` = 1684618 OR `props-main`.`id` = 1684426 OR `props-main`.`id` = 1688019 OR `props-main`.`id` = 1686455 OR `props-main`.`id` = 1690481 OR `props-main`.`id` = 1691459 OR `props-main`.`id` = 1691379 OR `props-main`.`id` = 1687169 OR `props-main`.`id` = 1678832 OR `props-main`.`id` = 1679095 OR `props-main`.`id` = 1682310 OR `props-main`.`id` = 1682871 OR `props-main`.`id` = 1685858 OR `props-main`.`id` = 1686526 OR `props-main`.`id` = 1686474 OR `props-main`.`id` = 1682701 OR `props-main`.`id` = 1687849 OR `props-main`.`id` = 1689461 OR `props-main`.`id` = 1670931 OR `props-main`.`id` = 1666710 OR `props-main`.`id` = 1677473 OR `props-main`.`id` = 1691218 OR `props-main`.`id` = 1689097 OR `props-main`.`id` = 1687165 OR `props-main`.`id` = 1679631 OR `props-main`.`id` = 1687977 OR `props-main`.`id` = 1687978 OR `props-main`.`id` = 1682401 OR `props-main`.`id` = 1681254 OR `props-main`.`id` = 1690685 OR `props-main`.`id` = 1659431 OR `props-main`.`id` = 1689736 OR `props-main`.`id` = 1686057 OR `props-main`.`id` = 1689744 OR `props-main`.`id` = 1690798 OR `props-main`.`id` = 1689988 OR `props-main`.`id` = 1681435 OR `props-main`.`id` = 1681445 OR `props-main`.`id` = 1690630 OR `props-main`.`id` = 1689850 OR `props-main`.`id` = 1676645 OR `props-main`.`id` = 901883 OR `props-main`.`id` = 1688295 OR `props-main`.`id` = 1686490 OR `props-main`.`id` = 1690306 OR `props-main`.`id` = 1637747 OR `props-main`.`id` = 1683897 OR `props-main`.`id` = 1689528 OR `props-main`.`id` = 1689294 OR `props-main`.`id` = 1687968 OR `props-main`.`id` = 1691726 OR `props-main`.`id` = 1667947 OR `props-main`.`id` = 1667959 OR `props-main`.`id` = 1687391 OR `props-main`.`id` = 1691307 OR `props-main`.`id` = 1691294 OR `props-main`.`id` = 1678680 OR `props-main`.`id` = 1685247 OR `props-main`.`id` = 1671228 OR `props-main`.`id` = 1686291 OR `props-main`.`id` = 1682050 OR `props-main`.`id` = 1691044 OR `props-main`.`id` = 1691213 OR `props-main`.`id` = 1683457 OR `props-main`.`id` = 1690735 OR `props-main`.`id` = 1691469 OR `props-main`.`id` = 1689845 OR `props-main`.`id` = 1649903 OR `props-main`.`id` = 1686033 OR `props-main`.`id` = 1685439 OR `props-main`.`id` = 1659297 OR `props-main`.`id` = 1691627 OR `props-main`.`id` = 1690400 OR `props-main`.`id` = 1687951 OR `props-main`.`id` = 1688003 OR `props-main`.`id` = 1690894 OR `props-main`.`id` = 1675248 OR `props-main`.`id` = 1689455 OR `props-main`.`id` = 1684669 OR `props-main`.`id` = 1691821 OR `props-main`.`id` = 1684469 OR `props-main`.`id` = 1680299 OR `props-main`.`id` = 1680263 OR `props-main`.`id` = 280750 OR `props-main`.`id` = 1683742 OR `props-main`.`id` = 1680822 OR `props-main`.`id` = 1690291 OR `props-main`.`id` = 1687330 OR `props-main`.`id` = 1686707 OR `props-main`.`id` = 1685488 OR `props-main`.`id` = 1688695 OR `props-main`.`id` = 1679249 OR `props-main`.`id` = 1688074 OR `props-main`.`id` = 1688060 OR `props-main`.`id` = 1689353 OR `props-main`.`id` = 1691501 OR `props-main`.`id` = 1674176 OR `props-main`.`id` = 1685084 OR `props-main`.`id` = 1690555 OR `props-main`.`id` = 1683338 OR `props-main`.`id` = 1679231 OR `props-main`.`id` = 1690629 OR `props-main`.`id` = 1689374 OR `props-main`.`id` = 1681350 OR `props-main`.`id` = 1685682 OR `props-main`.`id` = 1690779 OR `props-main`.`id` = 1690323 OR `props-main`.`id` = 1688575 OR `props-main`.`id` = 1669930 OR `props-main`.`id` = 1671067 OR `props-main`.`id` = 1678108 OR `props-main`.`id` = 1688379)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC22226731' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-29' 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();