A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 417050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 460950 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) >= 957 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1457 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` = 1728820 OR `props-main`.`id` = 1791564 OR `props-main`.`id` = 1789854 OR `props-main`.`id` = 1788787 OR `props-main`.`id` = 1791130 OR `props-main`.`id` = 1785018 OR `props-main`.`id` = 1783871 OR `props-main`.`id` = 1778478 OR `props-main`.`id` = 1781420 OR `props-main`.`id` = 1781942 OR `props-main`.`id` = 1781943 OR `props-main`.`id` = 1781944 OR `props-main`.`id` = 1788980 OR `props-main`.`id` = 1788732 OR `props-main`.`id` = 1786282 OR `props-main`.`id` = 1774326 OR `props-main`.`id` = 1785273 OR `props-main`.`id` = 1790986 OR `props-main`.`id` = 1766365 OR `props-main`.`id` = 1754913 OR `props-main`.`id` = 1771908 OR `props-main`.`id` = 1766271 OR `props-main`.`id` = 1789788 OR `props-main`.`id` = 1780923 OR `props-main`.`id` = 1776138 OR `props-main`.`id` = 1785125 OR `props-main`.`id` = 1785057 OR `props-main`.`id` = 1783675 OR `props-main`.`id` = 1768362 OR `props-main`.`id` = 1786620 OR `props-main`.`id` = 1776286 OR `props-main`.`id` = 1788724 OR `props-main`.`id` = 1749526 OR `props-main`.`id` = 1788856 OR `props-main`.`id` = 1788089 OR `props-main`.`id` = 1765608 OR `props-main`.`id` = 1787458 OR `props-main`.`id` = 1781218 OR `props-main`.`id` = 1776681 OR `props-main`.`id` = 1780429 OR `props-main`.`id` = 1752883 OR `props-main`.`id` = 1763008 OR `props-main`.`id` = 1781897 OR `props-main`.`id` = 1776625 OR `props-main`.`id` = 1726184 OR `props-main`.`id` = 1787223 OR `props-main`.`id` = 1779401 OR `props-main`.`id` = 1714968 OR `props-main`.`id` = 1774721 OR `props-main`.`id` = 1773813 OR `props-main`.`id` = 1791562 OR `props-main`.`id` = 1715603 OR `props-main`.`id` = 1772980 OR `props-main`.`id` = 1787336 OR `props-main`.`id` = 1790461 OR `props-main`.`id` = 1766431 OR `props-main`.`id` = 1776675 OR `props-main`.`id` = 1774119 OR `props-main`.`id` = 1791408 OR `props-main`.`id` = 1790988 OR `props-main`.`id` = 1726521 OR `props-main`.`id` = 1770980 OR `props-main`.`id` = 1782466 OR `props-main`.`id` = 1791461 OR `props-main`.`id` = 1759723 OR `props-main`.`id` = 1764734 OR `props-main`.`id` = 1776154 OR `props-main`.`id` = 1790168 OR `props-main`.`id` = 1785511 OR `props-main`.`id` = 1773168 OR `props-main`.`id` = 1755086 OR `props-main`.`id` = 1752066 OR `props-main`.`id` = 1780175 OR `props-main`.`id` = 1718072 OR `props-main`.`id` = 1773735 OR `props-main`.`id` = 1755883 OR `props-main`.`id` = 1768951 OR `props-main`.`id` = 1725170 OR `props-main`.`id` = 1749242 OR `props-main`.`id` = 1768366 OR `props-main`.`id` = 1754310 OR `props-main`.`id` = 1789149 OR `props-main`.`id` = 1781941 OR `props-main`.`id` = 1773841 OR `props-main`.`id` = 1768405 OR `props-main`.`id` = 1781068 OR `props-main`.`id` = 1776843 OR `props-main`.`id` = 1775345 OR `props-main`.`id` = 1773776 OR `props-main`.`id` = 1788685 OR `props-main`.`id` = 1726359 OR `props-main`.`id` = 1780451 OR `props-main`.`id` = 1784779 OR `props-main`.`id` = 1758568 OR `props-main`.`id` = 1787764 OR `props-main`.`id` = 1773070 OR `props-main`.`id` = 1770157 OR `props-main`.`id` = 1774455 OR `props-main`.`id` = 1779347 OR `props-main`.`id` = 1736994 OR `props-main`.`id` = 1720798 OR `props-main`.`id` = 1755261 OR `props-main`.`id` = 1786610 OR `props-main`.`id` = 1727765 OR `props-main`.`id` = 1791107 OR `props-main`.`id` = 1772160 OR `props-main`.`id` = 1762627 OR `props-main`.`id` = 1776399 OR `props-main`.`id` = 1784186 OR `props-main`.`id` = 1782563 OR `props-main`.`id` = 1774207 OR `props-main`.`id` = 1775316 OR `props-main`.`id` = 1789129 OR `props-main`.`id` = 1762315 OR `props-main`.`id` = 1788379 OR `props-main`.`id` = 1761744)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226111954' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-15' 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();