A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 419998.95 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) >= 1128 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1628 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` = 1691572 OR `props-main`.`id` = 1681454 OR `props-main`.`id` = 1622894 OR `props-main`.`id` = 1691764 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1686457 OR `props-main`.`id` = 1686562 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1675208 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1688612 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 281861 OR `props-main`.`id` = 764482 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 301259 OR `props-main`.`id` = 1682226 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1687293 OR `props-main`.`id` = 1687304 OR `props-main`.`id` = 1689533 OR `props-main`.`id` = 1691911 OR `props-main`.`id` = 1683888 OR `props-main`.`id` = 1686909 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1681613 OR `props-main`.`id` = 1686565 OR `props-main`.`id` = 1681501 OR `props-main`.`id` = 1627752 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1688038 OR `props-main`.`id` = 1622792 OR `props-main`.`id` = 1684138 OR `props-main`.`id` = 1683145 OR `props-main`.`id` = 1682973 OR `props-main`.`id` = 1685928 OR `props-main`.`id` = 1673216 OR `props-main`.`id` = 1686760 OR `props-main`.`id` = 1686268 OR `props-main`.`id` = 1686740 OR `props-main`.`id` = 1691488 OR `props-main`.`id` = 1691221 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1688629 OR `props-main`.`id` = 1688587 OR `props-main`.`id` = 1688598 OR `props-main`.`id` = 1689674 OR `props-main`.`id` = 1689667 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1688930 OR `props-main`.`id` = 1690040 OR `props-main`.`id` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 1622885 OR `props-main`.`id` = 1663976 OR `props-main`.`id` = 1682782 OR `props-main`.`id` = 1671761 OR `props-main`.`id` = 1690886 OR `props-main`.`id` = 1691960 OR `props-main`.`id` = 1691872 OR `props-main`.`id` = 1691969 OR `props-main`.`id` = 1668924 OR `props-main`.`id` = 1686574 OR `props-main`.`id` = 1683927 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1677622 OR `props-main`.`id` = 1686912 OR `props-main`.`id` = 1677617 OR `props-main`.`id` = 1677620 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1690818 OR `props-main`.`id` = 1690813 OR `props-main`.`id` = 1690831 OR `props-main`.`id` = 1687151 OR `props-main`.`id` = 1686888 OR `props-main`.`id` = 1686925 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 175921 OR `props-main`.`id` = 1688440 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1690054 OR `props-main`.`id` = 1692112 OR `props-main`.`id` = 1688816 OR `props-main`.`id` = 1686506 OR `props-main`.`id` = 1689672 OR `props-main`.`id` = 1688905 OR `props-main`.`id` = 1688907 OR `props-main`.`id` = 1675292 OR `props-main`.`id` = 1675274 OR `props-main`.`id` = 1675278 OR `props-main`.`id` = 1656550 OR `props-main`.`id` = 1656714 OR `props-main`.`id` = 1656726 OR `props-main`.`id` = 258606 OR `props-main`.`id` = 1678627 OR `props-main`.`id` = 1678617 OR `props-main`.`id` = 1687328 OR `props-main`.`id` = 1687326 OR `props-main`.`id` = 1684436 OR `props-main`.`id` = 1684479 OR `props-main`.`id` = 155874 OR `props-main`.`id` = 342762 OR `props-main`.`id` = 1690176 OR `props-main`.`id` = 1690198 OR `props-main`.`id` = 1678843 OR `props-main`.`id` = 1656585 OR `props-main`.`id` = 1690562 OR `props-main`.`id` = 1692150 OR `props-main`.`id` = 1692125 OR `props-main`.`id` = 1685496 OR `props-main`.`id` = 1691063 OR `props-main`.`id` = 1690158 OR `props-main`.`id` = 1678367 OR `props-main`.`id` = 1678343 OR `props-main`.`id` = 1678350 OR `props-main`.`id` = 1622832 OR `props-main`.`id` = 1622833 OR `props-main`.`id` = 1686452 OR `props-main`.`id` = 1686453 OR `props-main`.`id` = 1667509 OR `props-main`.`id` = 1686533)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC23124019' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-31' 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();