A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 370499.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 409498.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 920 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1420 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` = 1676713 OR `props-main`.`id` = 1700515 OR `props-main`.`id` = 1676721 OR `props-main`.`id` = 1700875 OR `props-main`.`id` = 1699213 OR `props-main`.`id` = 1699110 OR `props-main`.`id` = 1662552 OR `props-main`.`id` = 1697843 OR `props-main`.`id` = 1700043 OR `props-main`.`id` = 1697945 OR `props-main`.`id` = 1700586 OR `props-main`.`id` = 1697743 OR `props-main`.`id` = 1697767 OR `props-main`.`id` = 1676545 OR `props-main`.`id` = 1700529 OR `props-main`.`id` = 1700575 OR `props-main`.`id` = 1701809 OR `props-main`.`id` = 1701829 OR `props-main`.`id` = 1700366 OR `props-main`.`id` = 1697611 OR `props-main`.`id` = 1701052 OR `props-main`.`id` = 1658833 OR `props-main`.`id` = 1658832 OR `props-main`.`id` = 1658843 OR `props-main`.`id` = 1691701 OR `props-main`.`id` = 1702001 OR `props-main`.`id` = 1700467 OR `props-main`.`id` = 1701022 OR `props-main`.`id` = 1701009 OR `props-main`.`id` = 1695476 OR `props-main`.`id` = 1695469 OR `props-main`.`id` = 1700996 OR `props-main`.`id` = 1697491 OR `props-main`.`id` = 1694968 OR `props-main`.`id` = 1701013 OR `props-main`.`id` = 1696178 OR `props-main`.`id` = 1701350 OR `props-main`.`id` = 1700372 OR `props-main`.`id` = 1700728 OR `props-main`.`id` = 1701050 OR `props-main`.`id` = 1700804 OR `props-main`.`id` = 1688019 OR `props-main`.`id` = 1700942 OR `props-main`.`id` = 1690481 OR `props-main`.`id` = 1701905 OR `props-main`.`id` = 1700276 OR `props-main`.`id` = 1700526 OR `props-main`.`id` = 1693449 OR `props-main`.`id` = 1701044 OR `props-main`.`id` = 1694853 OR `props-main`.`id` = 1700257 OR `props-main`.`id` = 1700984 OR `props-main`.`id` = 1689636 OR `props-main`.`id` = 1700462 OR `props-main`.`id` = 1701769 OR `props-main`.`id` = 1701029 OR `props-main`.`id` = 1700255 OR `props-main`.`id` = 1701059 OR `props-main`.`id` = 1702041 OR `props-main`.`id` = 1677473 OR `props-main`.`id` = 1700670 OR `props-main`.`id` = 1701038 OR `props-main`.`id` = 1700826 OR `props-main`.`id` = 1697807 OR `props-main`.`id` = 1679631 OR `props-main`.`id` = 1694952 OR `props-main`.`id` = 1694953 OR `props-main`.`id` = 1699827 OR `props-main`.`id` = 1701062 OR `props-main`.`id` = 1690685 OR `props-main`.`id` = 1702128 OR `props-main`.`id` = 1697666 OR `props-main`.`id` = 1689736 OR `props-main`.`id` = 1700469 OR `props-main`.`id` = 1700468 OR `props-main`.`id` = 1701016 OR `props-main`.`id` = 1700400 OR `props-main`.`id` = 1694467 OR `props-main`.`id` = 1698010 OR `props-main`.`id` = 1697551 OR `props-main`.`id` = 1692244 OR `props-main`.`id` = 1700658 OR `props-main`.`id` = 1691976 OR `props-main`.`id` = 1701575 OR `props-main`.`id` = 1676645 OR `props-main`.`id` = 901883 OR `props-main`.`id` = 1697610 OR `props-main`.`id` = 1697637 OR `props-main`.`id` = 1700957 OR `props-main`.`id` = 1701778 OR `props-main`.`id` = 1637747 OR `props-main`.`id` = 1689294 OR `props-main`.`id` = 1691726 OR `props-main`.`id` = 1698697 OR `props-main`.`id` = 1667959 OR `props-main`.`id` = 1701487 OR `props-main`.`id` = 1697099 OR `props-main`.`id` = 1691307 OR `props-main`.`id` = 1691294 OR `props-main`.`id` = 1678680 OR `props-main`.`id` = 1682050 OR `props-main`.`id` = 1698983 OR `props-main`.`id` = 1700557 OR `props-main`.`id` = 1649903 OR `props-main`.`id` = 1701116 OR `props-main`.`id` = 1697608 OR `props-main`.`id` = 1690894 OR `props-main`.`id` = 1698127 OR `props-main`.`id` = 1701344 OR `props-main`.`id` = 1680299 OR `props-main`.`id` = 1699199 OR `props-main`.`id` = 1695921 OR `props-main`.`id` = 280750 OR `props-main`.`id` = 1697927 OR `props-main`.`id` = 1701660 OR `props-main`.`id` = 1693820 OR `props-main`.`id` = 1690291 OR `props-main`.`id` = 1687330 OR `props-main`.`id` = 1698116)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25235568' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-09' 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();