A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 322999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 356998.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1014 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1514 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` = 1688975 OR `props-main`.`id` = 1688571 OR `props-main`.`id` = 1662588 OR `props-main`.`id` = 1690063 OR `props-main`.`id` = 1679532 OR `props-main`.`id` = 1688452 OR `props-main`.`id` = 1687109 OR `props-main`.`id` = 1688068 OR `props-main`.`id` = 279647 OR `props-main`.`id` = 1678705 OR `props-main`.`id` = 1683856 OR `props-main`.`id` = 1687806 OR `props-main`.`id` = 1680078 OR `props-main`.`id` = 1676336 OR `props-main`.`id` = 1689242 OR `props-main`.`id` = 1689344 OR `props-main`.`id` = 1688700 OR `props-main`.`id` = 1674436 OR `props-main`.`id` = 1659015 OR `props-main`.`id` = 1688814 OR `props-main`.`id` = 1683312 OR `props-main`.`id` = 1682890 OR `props-main`.`id` = 1678324 OR `props-main`.`id` = 1684897 OR `props-main`.`id` = 1686542 OR `props-main`.`id` = 1681956 OR `props-main`.`id` = 1622694 OR `props-main`.`id` = 1658779 OR `props-main`.`id` = 1637576 OR `props-main`.`id` = 1687934 OR `props-main`.`id` = 1665493 OR `props-main`.`id` = 1689129 OR `props-main`.`id` = 1689332 OR `props-main`.`id` = 1686503 OR `props-main`.`id` = 1656086 OR `props-main`.`id` = 1648800 OR `props-main`.`id` = 1622873 OR `props-main`.`id` = 1674548 OR `props-main`.`id` = 1678884 OR `props-main`.`id` = 1689316 OR `props-main`.`id` = 1678651 OR `props-main`.`id` = 1689907 OR `props-main`.`id` = 1655855 OR `props-main`.`id` = 1683018 OR `props-main`.`id` = 1689591 OR `props-main`.`id` = 1123502 OR `props-main`.`id` = 1625895 OR `props-main`.`id` = 1686466 OR `props-main`.`id` = 1687942 OR `props-main`.`id` = 1666350 OR `props-main`.`id` = 1627326 OR `props-main`.`id` = 1684543 OR `props-main`.`id` = 1690072 OR `props-main`.`id` = 1690062 OR `props-main`.`id` = 1690209 OR `props-main`.`id` = 1689573 OR `props-main`.`id` = 1689568 OR `props-main`.`id` = 1687268 OR `props-main`.`id` = 1622733 OR `props-main`.`id` = 1622891 OR `props-main`.`id` = 1674192 OR `props-main`.`id` = 1686301 OR `props-main`.`id` = 1688106 OR `props-main`.`id` = 1687846 OR `props-main`.`id` = 1686551 OR `props-main`.`id` = 1686754 OR `props-main`.`id` = 1676643 OR `props-main`.`id` = 1655369 OR `props-main`.`id` = 1690152 OR `props-main`.`id` = 1683057 OR `props-main`.`id` = 1689315 OR `props-main`.`id` = 1685567 OR `props-main`.`id` = 1683727 OR `props-main`.`id` = 1683726 OR `props-main`.`id` = 1681806 OR `props-main`.`id` = 1688854 OR `props-main`.`id` = 1677287 OR `props-main`.`id` = 1689782 OR `props-main`.`id` = 1689790 OR `props-main`.`id` = 1688572 OR `props-main`.`id` = 1690433 OR `props-main`.`id` = 1690429 OR `props-main`.`id` = 1688778 OR `props-main`.`id` = 1673715 OR `props-main`.`id` = 1673741 OR `props-main`.`id` = 1657370 OR `props-main`.`id` = 1686552 OR `props-main`.`id` = 1622798 OR `props-main`.`id` = 262682 OR `props-main`.`id` = 1681301 OR `props-main`.`id` = 1689559 OR `props-main`.`id` = 1688050 OR `props-main`.`id` = 1688040 OR `props-main`.`id` = 1688815 OR `props-main`.`id` = 1688913 OR `props-main`.`id` = 1681087 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1680830 OR `props-main`.`id` = 1686960 OR `props-main`.`id` = 1686965 OR `props-main`.`id` = 289931 OR `props-main`.`id` = 1677524 OR `props-main`.`id` = 1677523 OR `props-main`.`id` = 1680045 OR `props-main`.`id` = 1680039 OR `props-main`.`id` = 1680043 OR `props-main`.`id` = 1653139 OR `props-main`.`id` = 1653151 OR `props-main`.`id` = 1679706 OR `props-main`.`id` = 1686825 OR `props-main`.`id` = 1690269 OR `props-main`.`id` = 1685786 OR `props-main`.`id` = 1683579 OR `props-main`.`id` = 1673816 OR `props-main`.`id` = 87746 OR `props-main`.`id` = 1663511 OR `props-main`.`id` = 1678157 OR `props-main`.`id` = 1681183 OR `props-main`.`id` = 270485 OR `props-main`.`id` = 1684012 OR `props-main`.`id` = 1683991 OR `props-main`.`id` = 1688119 OR `props-main`.`id` = 1686079 OR `props-main`.`id` = 1680532 OR `props-main`.`id` = 1689423 OR `props-main`.`id` = 1689436 OR `props-main`.`id` = 1689408 OR `props-main`.`id` = 1684758 OR `props-main`.`id` = 1673241 OR `props-main`.`id` = 1673275)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist224126355' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-18' 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();