A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 380000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 420000 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) >= 1455 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1955 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` = 1689782 OR `props-main`.`id` = 1690433 OR `props-main`.`id` = 1690429 OR `props-main`.`id` = 1718535 OR `props-main`.`id` = 262682 OR `props-main`.`id` = 1688050 OR `props-main`.`id` = 1688040 OR `props-main`.`id` = 1711274 OR `props-main`.`id` = 1703457 OR `props-main`.`id` = 1704693 OR `props-main`.`id` = 1717582 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1706987 OR `props-main`.`id` = 1704003 OR `props-main`.`id` = 1680830 OR `props-main`.`id` = 1706988 OR `props-main`.`id` = 1686965 OR `props-main`.`id` = 1714366 OR `props-main`.`id` = 289931 OR `props-main`.`id` = 1677524 OR `props-main`.`id` = 1677523 OR `props-main`.`id` = 1708410 OR `props-main`.`id` = 1708334 OR `props-main`.`id` = 1679706 OR `props-main`.`id` = 1686825 OR `props-main`.`id` = 1690564 OR `props-main`.`id` = 1695318 OR `props-main`.`id` = 1704152 OR `props-main`.`id` = 1714687 OR `props-main`.`id` = 1693624 OR `props-main`.`id` = 1693647 OR `props-main`.`id` = 1714599 OR `props-main`.`id` = 87746 OR `props-main`.`id` = 1702244 OR `props-main`.`id` = 1714493 OR `props-main`.`id` = 270485 OR `props-main`.`id` = 1698786 OR `props-main`.`id` = 1712920 OR `props-main`.`id` = 1712897 OR `props-main`.`id` = 1712913 OR `props-main`.`id` = 1696131 OR `props-main`.`id` = 1719092 OR `props-main`.`id` = 1696130 OR `props-main`.`id` = 1716049 OR `props-main`.`id` = 1716226 OR `props-main`.`id` = 1704847 OR `props-main`.`id` = 1704795 OR `props-main`.`id` = 1718576 OR `props-main`.`id` = 1708286 OR `props-main`.`id` = 1695615 OR `props-main`.`id` = 1720346 OR `props-main`.`id` = 1719076 OR `props-main`.`id` = 1642555 OR `props-main`.`id` = 1713364 OR `props-main`.`id` = 1715691 OR `props-main`.`id` = 1716876 OR `props-main`.`id` = 1716882 OR `props-main`.`id` = 1717810 OR `props-main`.`id` = 1717805 OR `props-main`.`id` = 1716863 OR `props-main`.`id` = 1718052 OR `props-main`.`id` = 1718050 OR `props-main`.`id` = 1718068 OR `props-main`.`id` = 1680215 OR `props-main`.`id` = 1704743 OR `props-main`.`id` = 1704754 OR `props-main`.`id` = 302141 OR `props-main`.`id` = 1720291 OR `props-main`.`id` = 1697562 OR `props-main`.`id` = 1711179 OR `props-main`.`id` = 1711176 OR `props-main`.`id` = 1696579 OR `props-main`.`id` = 1697488 OR `props-main`.`id` = 1705931 OR `props-main`.`id` = 1701910 OR `props-main`.`id` = 1697930 OR `props-main`.`id` = 1718168 OR `props-main`.`id` = 1718181 OR `props-main`.`id` = 1706801 OR `props-main`.`id` = 1714839 OR `props-main`.`id` = 1659390 OR `props-main`.`id` = 1659386 OR `props-main`.`id` = 1659394 OR `props-main`.`id` = 1719273 OR `props-main`.`id` = 1717010 OR `props-main`.`id` = 1717647 OR `props-main`.`id` = 1717679 OR `props-main`.`id` = 1685606 OR `props-main`.`id` = 1698211 OR `props-main`.`id` = 342849 OR `props-main`.`id` = 1716047 OR `props-main`.`id` = 1716133 OR `props-main`.`id` = 1702577 OR `props-main`.`id` = 1720273 OR `props-main`.`id` = 1704802 OR `props-main`.`id` = 1707000 OR `props-main`.`id` = 1714876 OR `props-main`.`id` = 1708190 OR `props-main`.`id` = 1708196 OR `props-main`.`id` = 1702162 OR `props-main`.`id` = 1714570 OR `props-main`.`id` = 1714061 OR `props-main`.`id` = 1698404 OR `props-main`.`id` = 1715798 OR `props-main`.`id` = 1712953 OR `props-main`.`id` = 1689954 OR `props-main`.`id` = 1711218 OR `props-main`.`id` = 1718873 OR `props-main`.`id` = 1709672 OR `props-main`.`id` = 1712818 OR `props-main`.`id` = 1716572 OR `props-main`.`id` = 1713146 OR `props-main`.`id` = 1705344 OR `props-main`.`id` = 1705282 OR `props-main`.`id` = 1709925 OR `props-main`.`id` = 1716479 OR `props-main`.`id` = 1689536 OR `props-main`.`id` = 1715696 OR `props-main`.`id` = 1718105 OR `props-main`.`id` = 1720347 OR `props-main`.`id` = 1720348 OR `props-main`.`id` = 1711312 OR `props-main`.`id` = 1703392 OR `props-main`.`id` = 1712713 OR `props-main`.`id` = 1705259 OR `props-main`.`id` = 1705596 OR `props-main`.`id` = 1705601)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC24008777' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-06' 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();