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) >= 1092 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1592 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` = 1723290 OR `props-main`.`id` = 1722662 OR `props-main`.`id` = 1720387 OR `props-main`.`id` = 1724244 OR `props-main`.`id` = 1721563 OR `props-main`.`id` = 1721565 OR `props-main`.`id` = 1721572 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` = 1721562 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` = 1685606 OR `props-main`.`id` = 1698211 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` = 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` = 1723057 OR `props-main`.`id` = 1724196 OR `props-main`.`id` = 204765 OR `props-main`.`id` = 1714570 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` = 1713540 OR `props-main`.`id` = 1713511 OR `props-main`.`id` = 1713661 OR `props-main`.`id` = 1724031 OR `props-main`.`id` = 1713146 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` = 1723482 OR `props-main`.`id` = 1712543 OR `props-main`.`id` = 1722559 OR `props-main`.`id` = 1722645 OR `props-main`.`id` = 1722523 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` = 1708144 OR `props-main`.`id` = 1715751 OR `props-main`.`id` = 1715752 OR `props-main`.`id` = 1722676 OR `props-main`.`id` = 1723844 OR `props-main`.`id` = 1723192 OR `props-main`.`id` = 1721288 OR `props-main`.`id` = 1706107 OR `props-main`.`id` = 1706773 OR `props-main`.`id` = 1701227 OR `props-main`.`id` = 1723836 OR `props-main`.`id` = 1723957 OR `props-main`.`id` = 1723956 OR `props-main`.`id` = 1723977 OR `props-main`.`id` = 1723958 OR `props-main`.`id` = 1701369 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`) != 'crmlsMC26071916' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-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();