A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 484490.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 535489.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1297 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1797 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` = 1716132 OR `props-main`.`id` = 1720556 OR `props-main`.`id` = 1701860 OR `props-main`.`id` = 1723550 OR `props-main`.`id` = 1724394 OR `props-main`.`id` = 1719397 OR `props-main`.`id` = 1714587 OR `props-main`.`id` = 1712798 OR `props-main`.`id` = 1723791 OR `props-main`.`id` = 1726065 OR `props-main`.`id` = 1723085 OR `props-main`.`id` = 1723109 OR `props-main`.`id` = 1723111 OR `props-main`.`id` = 1714501 OR `props-main`.`id` = 1723277 OR `props-main`.`id` = 1725270 OR `props-main`.`id` = 1725714 OR `props-main`.`id` = 1724937 OR `props-main`.`id` = 1725923 OR `props-main`.`id` = 1715932 OR `props-main`.`id` = 1724504 OR `props-main`.`id` = 1725707 OR `props-main`.`id` = 1721787 OR `props-main`.`id` = 1723650 OR `props-main`.`id` = 1725753 OR `props-main`.`id` = 1724708 OR `props-main`.`id` = 1712998 OR `props-main`.`id` = 1725868 OR `props-main`.`id` = 1725973 OR `props-main`.`id` = 1706854 OR `props-main`.`id` = 1720648 OR `props-main`.`id` = 1717131 OR `props-main`.`id` = 1716343 OR `props-main`.`id` = 1715968 OR `props-main`.`id` = 1709827 OR `props-main`.`id` = 1722284 OR `props-main`.`id` = 1667438 OR `props-main`.`id` = 1725550 OR `props-main`.`id` = 1721810 OR `props-main`.`id` = 1723886 OR `props-main`.`id` = 1709706 OR `props-main`.`id` = 1713707 OR `props-main`.`id` = 1725532 OR `props-main`.`id` = 1706808 OR `props-main`.`id` = 1721119 OR `props-main`.`id` = 1722677 OR `props-main`.`id` = 1722106 OR `props-main`.`id` = 1603454 OR `props-main`.`id` = 1724044 OR `props-main`.`id` = 1724338 OR `props-main`.`id` = 1726003 OR `props-main`.`id` = 1725188 OR `props-main`.`id` = 1695237 OR `props-main`.`id` = 1726229 OR `props-main`.`id` = 1722526 OR `props-main`.`id` = 1622931 OR `props-main`.`id` = 1726160 OR `props-main`.`id` = 1721859 OR `props-main`.`id` = 1720343 OR `props-main`.`id` = 1716687 OR `props-main`.`id` = 1725613 OR `props-main`.`id` = 1721579 OR `props-main`.`id` = 1703898 OR `props-main`.`id` = 1714488 OR `props-main`.`id` = 1713767 OR `props-main`.`id` = 1706036 OR `props-main`.`id` = 1713166 OR `props-main`.`id` = 1717099 OR `props-main`.`id` = 1719133 OR `props-main`.`id` = 1702640 OR `props-main`.`id` = 1716857 OR `props-main`.`id` = 1716205 OR `props-main`.`id` = 1722028 OR `props-main`.`id` = 1718288 OR `props-main`.`id` = 1718287 OR `props-main`.`id` = 1715644 OR `props-main`.`id` = 1713642 OR `props-main`.`id` = 1717768 OR `props-main`.`id` = 1700111 OR `props-main`.`id` = 1719796 OR `props-main`.`id` = 1710143 OR `props-main`.`id` = 1724556 OR `props-main`.`id` = 1725438 OR `props-main`.`id` = 1723540 OR `props-main`.`id` = 1721468 OR `props-main`.`id` = 1711578 OR `props-main`.`id` = 1722241 OR `props-main`.`id` = 1721528 OR `props-main`.`id` = 1714310 OR `props-main`.`id` = 1725767 OR `props-main`.`id` = 1724100 OR `props-main`.`id` = 1705953 OR `props-main`.`id` = 1713619 OR `props-main`.`id` = 1720672 OR `props-main`.`id` = 1718324 OR `props-main`.`id` = 1721821 OR `props-main`.`id` = 1694561 OR `props-main`.`id` = 1724486 OR `props-main`.`id` = 1720745 OR `props-main`.`id` = 1724815 OR `props-main`.`id` = 1726007 OR `props-main`.`id` = 1704719 OR `props-main`.`id` = 1720260 OR `props-main`.`id` = 1717510 OR `props-main`.`id` = 1685406 OR `props-main`.`id` = 1722330 OR `props-main`.`id` = 1724555 OR `props-main`.`id` = 1717322 OR `props-main`.`id` = 1701269 OR `props-main`.`id` = 1713497 OR `props-main`.`id` = 1723141 OR `props-main`.`id` = 1723155)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist222135837' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-09' 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();