A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 445550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 492450 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) >= 1254 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1754 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` = 1690603 OR `props-main`.`id` = 1666323 OR `props-main`.`id` = 1692247 OR `props-main`.`id` = 1718982 OR `props-main`.`id` = 1706044 OR `props-main`.`id` = 1712847 OR `props-main`.`id` = 1716477 OR `props-main`.`id` = 1709801 OR `props-main`.`id` = 1717880 OR `props-main`.`id` = 1697312 OR `props-main`.`id` = 689708 OR `props-main`.`id` = 1666223 OR `props-main`.`id` = 1694264 OR `props-main`.`id` = 1718737 OR `props-main`.`id` = 1654721 OR `props-main`.`id` = 1717340 OR `props-main`.`id` = 232301 OR `props-main`.`id` = 1716621 OR `props-main`.`id` = 1712880 OR `props-main`.`id` = 1653283 OR `props-main`.`id` = 1718460 OR `props-main`.`id` = 1713649 OR `props-main`.`id` = 1713807 OR `props-main`.`id` = 1715926 OR `props-main`.`id` = 1718819 OR `props-main`.`id` = 1717773 OR `props-main`.`id` = 1715621 OR `props-main`.`id` = 1717267 OR `props-main`.`id` = 1719744 OR `props-main`.`id` = 1703829 OR `props-main`.`id` = 1706692 OR `props-main`.`id` = 1694090 OR `props-main`.`id` = 1717226 OR `props-main`.`id` = 1719392 OR `props-main`.`id` = 1719262 OR `props-main`.`id` = 1702315 OR `props-main`.`id` = 1702305 OR `props-main`.`id` = 1715639 OR `props-main`.`id` = 1715689 OR `props-main`.`id` = 1719645 OR `props-main`.`id` = 1701736 OR `props-main`.`id` = 1716212 OR `props-main`.`id` = 1716232 OR `props-main`.`id` = 1701750 OR `props-main`.`id` = 1719384 OR `props-main`.`id` = 70513 OR `props-main`.`id` = 1717027 OR `props-main`.`id` = 1707114 OR `props-main`.`id` = 1700214 OR `props-main`.`id` = 1698700 OR `props-main`.`id` = 1700216 OR `props-main`.`id` = 1712804 OR `props-main`.`id` = 1719158 OR `props-main`.`id` = 1716978 OR `props-main`.`id` = 1717537 OR `props-main`.`id` = 1718751 OR `props-main`.`id` = 1702761 OR `props-main`.`id` = 1717230 OR `props-main`.`id` = 1636687 OR `props-main`.`id` = 1666079 OR `props-main`.`id` = 1718741 OR `props-main`.`id` = 1676760 OR `props-main`.`id` = 1705215 OR `props-main`.`id` = 1718740 OR `props-main`.`id` = 1713585 OR `props-main`.`id` = 1719141 OR `props-main`.`id` = 1709233 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1694602 OR `props-main`.`id` = 1718018 OR `props-main`.`id` = 1666292 OR `props-main`.`id` = 1717215 OR `props-main`.`id` = 1714023 OR `props-main`.`id` = 1708280 OR `props-main`.`id` = 1691902 OR `props-main`.`id` = 1697720 OR `props-main`.`id` = 1701422 OR `props-main`.`id` = 1702248 OR `props-main`.`id` = 1677619 OR `props-main`.`id` = 1704253 OR `props-main`.`id` = 1705309 OR `props-main`.`id` = 1679273 OR `props-main`.`id` = 1715629 OR `props-main`.`id` = 1719562 OR `props-main`.`id` = 1715630 OR `props-main`.`id` = 1713841 OR `props-main`.`id` = 1718201 OR `props-main`.`id` = 1717156 OR `props-main`.`id` = 1697275 OR `props-main`.`id` = 1718498 OR `props-main`.`id` = 1700151 OR `props-main`.`id` = 1717874 OR `props-main`.`id` = 1717877 OR `props-main`.`id` = 1717889 OR `props-main`.`id` = 1717894 OR `props-main`.`id` = 1718090 OR `props-main`.`id` = 1697445 OR `props-main`.`id` = 1707230 OR `props-main`.`id` = 1700213 OR `props-main`.`id` = 1700211 OR `props-main`.`id` = 1718456 OR `props-main`.`id` = 1718959 OR `props-main`.`id` = 1695955 OR `props-main`.`id` = 1705332 OR `props-main`.`id` = 1719391 OR `props-main`.`id` = 1717797 OR `props-main`.`id` = 1717177 OR `props-main`.`id` = 1717166 OR `props-main`.`id` = 1717174 OR `props-main`.`id` = 1717180 OR `props-main`.`id` = 1717194 OR `props-main`.`id` = 1703915 OR `props-main`.`id` = 1717520 OR `props-main`.`id` = 1719413 OR `props-main`.`id` = 1695993 OR `props-main`.`id` = 1695988 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1716993 OR `props-main`.`id` = 1705574 OR `props-main`.`id` = 1710213 OR `props-main`.`id` = 1717599 OR `props-main`.`id` = 1711200 OR `props-main`.`id` = 1700055 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1712341)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR24214099' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-03' 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();