A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 403750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 446250 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) >= 992 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1492 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` = 1747606 OR `props-main`.`id` = 1774664 OR `props-main`.`id` = 1764629 OR `props-main`.`id` = 1774521 OR `props-main`.`id` = 1767036 OR `props-main`.`id` = 1773868 OR `props-main`.`id` = 1776768 OR `props-main`.`id` = 1771767 OR `props-main`.`id` = 1765510 OR `props-main`.`id` = 1716375 OR `props-main`.`id` = 1733150 OR `props-main`.`id` = 1773382 OR `props-main`.`id` = 1737197 OR `props-main`.`id` = 1723143 OR `props-main`.`id` = 1700083 OR `props-main`.`id` = 1779369 OR `props-main`.`id` = 1775809 OR `props-main`.`id` = 1704117 OR `props-main`.`id` = 1771591 OR `props-main`.`id` = 1761876 OR `props-main`.`id` = 1780140 OR `props-main`.`id` = 1758492 OR `props-main`.`id` = 1771775 OR `props-main`.`id` = 1771840 OR `props-main`.`id` = 1771587 OR `props-main`.`id` = 1774144 OR `props-main`.`id` = 1771745 OR `props-main`.`id` = 1747306 OR `props-main`.`id` = 1681376 OR `props-main`.`id` = 1767684 OR `props-main`.`id` = 1779612 OR `props-main`.`id` = 1773301 OR `props-main`.`id` = 1768271 OR `props-main`.`id` = 1746711 OR `props-main`.`id` = 1763023 OR `props-main`.`id` = 1773925 OR `props-main`.`id` = 1771761 OR `props-main`.`id` = 1774774 OR `props-main`.`id` = 1776676 OR `props-main`.`id` = 1747682 OR `props-main`.`id` = 1771661 OR `props-main`.`id` = 1771618 OR `props-main`.`id` = 1771662 OR `props-main`.`id` = 1771772 OR `props-main`.`id` = 1757801 OR `props-main`.`id` = 1771567 OR `props-main`.`id` = 1771781 OR `props-main`.`id` = 1774049 OR `props-main`.`id` = 1767712 OR `props-main`.`id` = 1779665 OR `props-main`.`id` = 1775858 OR `props-main`.`id` = 1763967 OR `props-main`.`id` = 1771909 OR `props-main`.`id` = 1778744 OR `props-main`.`id` = 1753018 OR `props-main`.`id` = 1749815 OR `props-main`.`id` = 1771606 OR `props-main`.`id` = 1771820 OR `props-main`.`id` = 1751310 OR `props-main`.`id` = 1766325 OR `props-main`.`id` = 1734251 OR `props-main`.`id` = 1764105 OR `props-main`.`id` = 1773082 OR `props-main`.`id` = 1780366 OR `props-main`.`id` = 1776805 OR `props-main`.`id` = 1757595 OR `props-main`.`id` = 1761572 OR `props-main`.`id` = 1765364 OR `props-main`.`id` = 1769118 OR `props-main`.`id` = 1769646 OR `props-main`.`id` = 1745352 OR `props-main`.`id` = 1774065 OR `props-main`.`id` = 1774680 OR `props-main`.`id` = 1774629 OR `props-main`.`id` = 1759551 OR `props-main`.`id` = 1768944 OR `props-main`.`id` = 1762491 OR `props-main`.`id` = 1771838 OR `props-main`.`id` = 1755687 OR `props-main`.`id` = 1755686 OR `props-main`.`id` = 1754680 OR `props-main`.`id` = 1778638 OR `props-main`.`id` = 1766491 OR `props-main`.`id` = 1767727 OR `props-main`.`id` = 1680147 OR `props-main`.`id` = 1713035 OR `props-main`.`id` = 1778643 OR `props-main`.`id` = 1776746 OR `props-main`.`id` = 1759282 OR `props-main`.`id` = 1761311 OR `props-main`.`id` = 1771609 OR `props-main`.`id` = 1750637 OR `props-main`.`id` = 1779074 OR `props-main`.`id` = 1726500 OR `props-main`.`id` = 1723305 OR `props-main`.`id` = 1757712 OR `props-main`.`id` = 1739199 OR `props-main`.`id` = 1774238 OR `props-main`.`id` = 1771588 OR `props-main`.`id` = 1770659 OR `props-main`.`id` = 1748420 OR `props-main`.`id` = 1778080 OR `props-main`.`id` = 1777812 OR `props-main`.`id` = 1763588 OR `props-main`.`id` = 1737967 OR `props-main`.`id` = 1737966 OR `props-main`.`id` = 1757777 OR `props-main`.`id` = 1773603 OR `props-main`.`id` = 1773604 OR `props-main`.`id` = 1768091 OR `props-main`.`id` = 1726019 OR `props-main`.`id` = 1754583 OR `props-main`.`id` = 1768901 OR `props-main`.`id` = 1775669 OR `props-main`.`id` = 1776041 OR `props-main`.`id` = 1751158)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist222123169' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-23' 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();