A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 593750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 656250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1977 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2477 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` = 1665689 OR `props-main`.`id` = 1731337 OR `props-main`.`id` = 1665648 OR `props-main`.`id` = 1731530 OR `props-main`.`id` = 1717119 OR `props-main`.`id` = 1717142 OR `props-main`.`id` = 1725898 OR `props-main`.`id` = 1725891 OR `props-main`.`id` = 1724827 OR `props-main`.`id` = 1723573 OR `props-main`.`id` = 1731638 OR `props-main`.`id` = 1732172 OR `props-main`.`id` = 1719238 OR `props-main`.`id` = 1687726 OR `props-main`.`id` = 1731321 OR `props-main`.`id` = 1731558 OR `props-main`.`id` = 1688970 OR `props-main`.`id` = 1731535 OR `props-main`.`id` = 1688944 OR `props-main`.`id` = 1718021 OR `props-main`.`id` = 1718043 OR `props-main`.`id` = 1704569 OR `props-main`.`id` = 1726371 OR `props-main`.`id` = 1719295 OR `props-main`.`id` = 1726384 OR `props-main`.`id` = 1702086 OR `props-main`.`id` = 1731934 OR `props-main`.`id` = 1732016 OR `props-main`.`id` = 1725397 OR `props-main`.`id` = 1699159 OR `props-main`.`id` = 1699982 OR `props-main`.`id` = 1731578 OR `props-main`.`id` = 1634812 OR `props-main`.`id` = 1692124 OR `props-main`.`id` = 1709461)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226600638' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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();