A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 451250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 498750 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) >= 1235 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1735 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` = 1718677 OR `props-main`.`id` = 1717400 OR `props-main`.`id` = 1716552 OR `props-main`.`id` = 1719672 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 1694830 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1718516 OR `props-main`.`id` = 1719862 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1704102 OR `props-main`.`id` = 1718789 OR `props-main`.`id` = 1718483 OR `props-main`.`id` = 1692098 OR `props-main`.`id` = 1692107 OR `props-main`.`id` = 1717261 OR `props-main`.`id` = 1706150 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 1717466 OR `props-main`.`id` = 1681580 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 1693905 OR `props-main`.`id` = 1715779 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1718249 OR `props-main`.`id` = 1718246 OR `props-main`.`id` = 1703999 OR `props-main`.`id` = 1714983 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1708131 OR `props-main`.`id` = 1718676 OR `props-main`.`id` = 1709425 OR `props-main`.`id` = 1694317 OR `props-main`.`id` = 1714009 OR `props-main`.`id` = 1718000 OR `props-main`.`id` = 1719566 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1704367 OR `props-main`.`id` = 1715597 OR `props-main`.`id` = 1713568 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1717159 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1711281 OR `props-main`.`id` = 1718254 OR `props-main`.`id` = 1712495 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1716845 OR `props-main`.`id` = 1716326 OR `props-main`.`id` = 1716751 OR `props-main`.`id` = 1713154 OR `props-main`.`id` = 1693924 OR `props-main`.`id` = 1715990 OR `props-main`.`id` = 1709455 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1706637 OR `props-main`.`id` = 1716294 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1709935 OR `props-main`.`id` = 1717456 OR `props-main`.`id` = 1717420 OR `props-main`.`id` = 1717431 OR `props-main`.`id` = 1717440 OR `props-main`.`id` = 1701870 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1719684 OR `props-main`.`id` = 1717439 OR `props-main`.`id` = 1713049 OR `props-main`.`id` = 1704410 OR `props-main`.`id` = 1715897 OR `props-main`.`id` = 1711143 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1716028 OR `props-main`.`id` = 1712606 OR `props-main`.`id` = 1716498 OR `props-main`.`id` = 1719778 OR `props-main`.`id` = 1719773 OR `props-main`.`id` = 1719777 OR `props-main`.`id` = 1703808 OR `props-main`.`id` = 1719779 OR `props-main`.`id` = 1719786 OR `props-main`.`id` = 1719769 OR `props-main`.`id` = 1708299 OR `props-main`.`id` = 1719770 OR `props-main`.`id` = 1719785 OR `props-main`.`id` = 1708298 OR `props-main`.`id` = 1708311 OR `props-main`.`id` = 1719767 OR `props-main`.`id` = 1719784 OR `props-main`.`id` = 1719787 OR `props-main`.`id` = 1719768 OR `props-main`.`id` = 1719793 OR `props-main`.`id` = 1708309 OR `props-main`.`id` = 1708297 OR `props-main`.`id` = 1719791 OR `props-main`.`id` = 1719792 OR `props-main`.`id` = 1708296 OR `props-main`.`id` = 1719790 OR `props-main`.`id` = 1719783 OR `props-main`.`id` = 1719780 OR `props-main`.`id` = 1708306 OR `props-main`.`id` = 1708307 OR `props-main`.`id` = 1719782 OR `props-main`.`id` = 1719788 OR `props-main`.`id` = 1719789 OR `props-main`.`id` = 1719771 OR `props-main`.`id` = 1718323 OR `props-main`.`id` = 1703614 OR `props-main`.`id` = 1719772 OR `props-main`.`id` = 1720316 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1708154 OR `props-main`.`id` = 1705157 OR `props-main`.`id` = 1705163 OR `props-main`.`id` = 1705164 OR `props-main`.`id` = 1705159 OR `props-main`.`id` = 1705160)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno621731' 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();