A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 388550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 429450 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) >= 945 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1445 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` = 1723298 OR `props-main`.`id` = 1725340 OR `props-main`.`id` = 1723290 OR `props-main`.`id` = 1722662 OR `props-main`.`id` = 1720387 OR `props-main`.`id` = 1725729 OR `props-main`.`id` = 1721563 OR `props-main`.`id` = 1721565 OR `props-main`.`id` = 1721572 OR `props-main`.`id` = 223289 OR `props-main`.`id` = 223288 OR `props-main`.`id` = 1714839 OR `props-main`.`id` = 1659390 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1719687 OR `props-main`.`id` = 1719832 OR `props-main`.`id` = 1719830 OR `props-main`.`id` = 1721362 OR `props-main`.`id` = 1721406 OR `props-main`.`id` = 1720457 OR `props-main`.`id` = 1722616 OR `props-main`.`id` = 1722618 OR `props-main`.`id` = 1723955 OR `props-main`.`id` = 1723966 OR `props-main`.`id` = 1725305 OR `props-main`.`id` = 1725309 OR `props-main`.`id` = 1725313 OR `props-main`.`id` = 202390 OR `props-main`.`id` = 1717006 OR `props-main`.`id` = 1716047 OR `props-main`.`id` = 1716133 OR `props-main`.`id` = 1722966 OR `props-main`.`id` = 1723153 OR `props-main`.`id` = 1723158 OR `props-main`.`id` = 1711272 OR `props-main`.`id` = 1724169 OR `props-main`.`id` = 1724945 OR `props-main`.`id` = 1721036 OR `props-main`.`id` = 1721042 OR `props-main`.`id` = 1723538 OR `props-main`.`id` = 1723528 OR `props-main`.`id` = 1723533 OR `props-main`.`id` = 1704802 OR `props-main`.`id` = 1707000 OR `props-main`.`id` = 206435 OR `props-main`.`id` = 1714876 OR `props-main`.`id` = 1714091 OR `props-main`.`id` = 1723262 OR `props-main`.`id` = 1724196 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1714570 OR `props-main`.`id` = 1725954 OR `props-main`.`id` = 1721038 OR `props-main`.`id` = 360956 OR `props-main`.`id` = 1715798 OR `props-main`.`id` = 1713342 OR `props-main`.`id` = 1709672 OR `props-main`.`id` = 1706672 OR `props-main`.`id` = 1712818 OR `props-main`.`id` = 1706679 OR `props-main`.`id` = 1721101 OR `props-main`.`id` = 1721326 OR `props-main`.`id` = 1716572 OR `props-main`.`id` = 1713511 OR `props-main`.`id` = 1725489 OR `props-main`.`id` = 1700902 OR `props-main`.`id` = 1700897 OR `props-main`.`id` = 1723564 OR `props-main`.`id` = 1723523 OR `props-main`.`id` = 1722230 OR `props-main`.`id` = 1722504 OR `props-main`.`id` = 1723752 OR `props-main`.`id` = 1715696 OR `props-main`.`id` = 1720347 OR `props-main`.`id` = 1720348 OR `props-main`.`id` = 1716949 OR `props-main`.`id` = 1723222 OR `props-main`.`id` = 1704849 OR `props-main`.`id` = 1725492 OR `props-main`.`id` = 1725228 OR `props-main`.`id` = 1723482 OR `props-main`.`id` = 1724958 OR `props-main`.`id` = 1724939 OR `props-main`.`id` = 1725629 OR `props-main`.`id` = 1724680 OR `props-main`.`id` = 1724608 OR `props-main`.`id` = 1724619 OR `props-main`.`id` = 1712543 OR `props-main`.`id` = 1725121 OR `props-main`.`id` = 1705259 OR `props-main`.`id` = 1705596 OR `props-main`.`id` = 1705601 OR `props-main`.`id` = 1704350 OR `props-main`.`id` = 1709853 OR `props-main`.`id` = 1718560 OR `props-main`.`id` = 1718552 OR `props-main`.`id` = 1717529 OR `props-main`.`id` = 1711333 OR `props-main`.`id` = 1715751 OR `props-main`.`id` = 1715752 OR `props-main`.`id` = 1721288 OR `props-main`.`id` = 1706107 OR `props-main`.`id` = 1706773 OR `props-main`.`id` = 1724895 OR `props-main`.`id` = 1724894 OR `props-main`.`id` = 1723836 OR `props-main`.`id` = 1724960 OR `props-main`.`id` = 1724962 OR `props-main`.`id` = 1724961 OR `props-main`.`id` = 1723957 OR `props-main`.`id` = 1723956 OR `props-main`.`id` = 1723977 OR `props-main`.`id` = 1723958 OR `props-main`.`id` = 1725284 OR `props-main`.`id` = 1724004 OR `props-main`.`id` = 1701451 OR `props-main`.`id` = 1717610 OR `props-main`.`id` = 1687778 OR `props-main`.`id` = 1722652 OR `props-main`.`id` = 1722651)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26028459' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-08' 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();