A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 493050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 544950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2707 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3207 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` = 1726956 OR `props-main`.`id` = 1726992 OR `props-main`.`id` = 1714977 OR `props-main`.`id` = 1714941 OR `props-main`.`id` = 1714947 OR `props-main`.`id` = 1731508 OR `props-main`.`id` = 1724804 OR `props-main`.`id` = 1731353 OR `props-main`.`id` = 1723270 OR `props-main`.`id` = 1680816 OR `props-main`.`id` = 1716962 OR `props-main`.`id` = 1731371 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1706809 OR `props-main`.`id` = 1722078 OR `props-main`.`id` = 1731590 OR `props-main`.`id` = 1721098 OR `props-main`.`id` = 1705655 OR `props-main`.`id` = 1705641 OR `props-main`.`id` = 1714700 OR `props-main`.`id` = 1731456 OR `props-main`.`id` = 1731764 OR `props-main`.`id` = 1726383 OR `props-main`.`id` = 1730655 OR `props-main`.`id` = 1730660 OR `props-main`.`id` = 1727711 OR `props-main`.`id` = 1727716 OR `props-main`.`id` = 1723233 OR `props-main`.`id` = 1682125 OR `props-main`.`id` = 1726932 OR `props-main`.`id` = 1714339 OR `props-main`.`id` = 1731358 OR `props-main`.`id` = 1726898 OR `props-main`.`id` = 1726333 OR `props-main`.`id` = 1715459 OR `props-main`.`id` = 1727460 OR `props-main`.`id` = 1725862 OR `props-main`.`id` = 1725553 OR `props-main`.`id` = 1728428 OR `props-main`.`id` = 1728415 OR `props-main`.`id` = 1731330 OR `props-main`.`id` = 1725132 OR `props-main`.`id` = 1726323 OR `props-main`.`id` = 1725135 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1662063 OR `props-main`.`id` = 1714248 OR `props-main`.`id` = 1723267 OR `props-main`.`id` = 1731759 OR `props-main`.`id` = 1729336 OR `props-main`.`id` = 1729363 OR `props-main`.`id` = 1729339 OR `props-main`.`id` = 1724281 OR `props-main`.`id` = 1704531 OR `props-main`.`id` = 1722740 OR `props-main`.`id` = 1721284 OR `props-main`.`id` = 1721067 OR `props-main`.`id` = 1721227 OR `props-main`.`id` = 1731589 OR `props-main`.`id` = 1687929 OR `props-main`.`id` = 1731365 OR `props-main`.`id` = 1721804 OR `props-main`.`id` = 1723288 OR `props-main`.`id` = 1701327 OR `props-main`.`id` = 1714574 OR `props-main`.`id` = 1726045 OR `props-main`.`id` = 1726047 OR `props-main`.`id` = 1654611 OR `props-main`.`id` = 1666277 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1731322 OR `props-main`.`id` = 1714260 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1706732 OR `props-main`.`id` = 1731675 OR `props-main`.`id` = 1725465 OR `props-main`.`id` = 1706817 OR `props-main`.`id` = 1706981 OR `props-main`.`id` = 1731461 OR `props-main`.`id` = 1731513 OR `props-main`.`id` = 1715647 OR `props-main`.`id` = 1715622 OR `props-main`.`id` = 1715633 OR `props-main`.`id` = 1731526 OR `props-main`.`id` = 1717826 OR `props-main`.`id` = 1717855 OR `props-main`.`id` = 1726796 OR `props-main`.`id` = 1726800 OR `props-main`.`id` = 1731335 OR `props-main`.`id` = 1721095 OR `props-main`.`id` = 1731574 OR `props-main`.`id` = 1726302 OR `props-main`.`id` = 1682135 OR `props-main`.`id` = 1724265 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1721091 OR `props-main`.`id` = 1721549 OR `props-main`.`id` = 1715744 OR `props-main`.`id` = 1731515 OR `props-main`.`id` = 1727222 OR `props-main`.`id` = 1727207 OR `props-main`.`id` = 1731713 OR `props-main`.`id` = 1730085 OR `props-main`.`id` = 1731777 OR `props-main`.`id` = 893173 OR `props-main`.`id` = 1727062 OR `props-main`.`id` = 1727191 OR `props-main`.`id` = 1727545 OR `props-main`.`id` = 1723311 OR `props-main`.`id` = 1718358 OR `props-main`.`id` = 1718314 OR `props-main`.`id` = 1718318 OR `props-main`.`id` = 1731548 OR `props-main`.`id` = 1718231 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1730883 OR `props-main`.`id` = 1730993 OR `props-main`.`id` = 1731185 OR `props-main`.`id` = 1726733 OR `props-main`.`id` = 1731701 OR `props-main`.`id` = 1726793 OR `props-main`.`id` = 1716921 OR `props-main`.`id` = 1726734 OR `props-main`.`id` = 1726794 OR `props-main`.`id` = 1731702 OR `props-main`.`id` = 1727729 OR `props-main`.`id` = 1723371)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226600620' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-02' 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();