A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 327750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 362250 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) >= 867 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1367 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` = 1712816 OR `props-main`.`id` = 1712810 OR `props-main`.`id` = 1748864 OR `props-main`.`id` = 1724094 OR `props-main`.`id` = 1724097 OR `props-main`.`id` = 1765892 OR `props-main`.`id` = 1749662 OR `props-main`.`id` = 1749636 OR `props-main`.`id` = 1777757 OR `props-main`.`id` = 1777766 OR `props-main`.`id` = 1778637 OR `props-main`.`id` = 1748875 OR `props-main`.`id` = 1767640 OR `props-main`.`id` = 1754768 OR `props-main`.`id` = 1778823 OR `props-main`.`id` = 1778844 OR `props-main`.`id` = 1778866 OR `props-main`.`id` = 1748007 OR `props-main`.`id` = 1779044 OR `props-main`.`id` = 1746804 OR `props-main`.`id` = 1746848 OR `props-main`.`id` = 1758455 OR `props-main`.`id` = 1772019 OR `props-main`.`id` = 1772615 OR `props-main`.`id` = 1771341 OR `props-main`.`id` = 1757153 OR `props-main`.`id` = 1777453 OR `props-main`.`id` = 1778535 OR `props-main`.`id` = 1767222 OR `props-main`.`id` = 1767249 OR `props-main`.`id` = 1769394 OR `props-main`.`id` = 1768990 OR `props-main`.`id` = 1723694 OR `props-main`.`id` = 1723733 OR `props-main`.`id` = 1723742 OR `props-main`.`id` = 1754963 OR `props-main`.`id` = 1774988 OR `props-main`.`id` = 1774467 OR `props-main`.`id` = 1758993 OR `props-main`.`id` = 1767326 OR `props-main`.`id` = 1765898 OR `props-main`.`id` = 1724840 OR `props-main`.`id` = 1775462 OR `props-main`.`id` = 1745984 OR `props-main`.`id` = 1707238 OR `props-main`.`id` = 1764712 OR `props-main`.`id` = 1710124 OR `props-main`.`id` = 1711130 OR `props-main`.`id` = 1711142 OR `props-main`.`id` = 1774021 OR `props-main`.`id` = 1770184 OR `props-main`.`id` = 1768939 OR `props-main`.`id` = 1744713 OR `props-main`.`id` = 1775795 OR `props-main`.`id` = 1778238 OR `props-main`.`id` = 1773752 OR `props-main`.`id` = 1754478 OR `props-main`.`id` = 1749174 OR `props-main`.`id` = 1774578 OR `props-main`.`id` = 1754982 OR `props-main`.`id` = 1712817 OR `props-main`.`id` = 1760958 OR `props-main`.`id` = 1728296 OR `props-main`.`id` = 1741243 OR `props-main`.`id` = 1747274 OR `props-main`.`id` = 1752880 OR `props-main`.`id` = 1754259 OR `props-main`.`id` = 1747289 OR `props-main`.`id` = 1728299 OR `props-main`.`id` = 1738701 OR `props-main`.`id` = 1739049 OR `props-main`.`id` = 1764280 OR `props-main`.`id` = 1766942 OR `props-main`.`id` = 1739177 OR `props-main`.`id` = 1753162 OR `props-main`.`id` = 1741567 OR `props-main`.`id` = 1741557 OR `props-main`.`id` = 1762466 OR `props-main`.`id` = 1762479 OR `props-main`.`id` = 1779203 OR `props-main`.`id` = 1776247 OR `props-main`.`id` = 1776248 OR `props-main`.`id` = 1752887 OR `props-main`.`id` = 1778437 OR `props-main`.`id` = 1724791 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1765255 OR `props-main`.`id` = 1763669 OR `props-main`.`id` = 1751842 OR `props-main`.`id` = 1767298 OR `props-main`.`id` = 1762326 OR `props-main`.`id` = 1761024 OR `props-main`.`id` = 1761822 OR `props-main`.`id` = 1721515 OR `props-main`.`id` = 1778445 OR `props-main`.`id` = 1746210 OR `props-main`.`id` = 1742125 OR `props-main`.`id` = 1779172 OR `props-main`.`id` = 1779193 OR `props-main`.`id` = 1756192 OR `props-main`.`id` = 1779911 OR `props-main`.`id` = 1779793 OR `props-main`.`id` = 1776665 OR `props-main`.`id` = 1750915 OR `props-main`.`id` = 1752088 OR `props-main`.`id` = 1778411 OR `props-main`.`id` = 1736349 OR `props-main`.`id` = 1762503 OR `props-main`.`id` = 1753362 OR `props-main`.`id` = 1776481 OR `props-main`.`id` = 1776945 OR `props-main`.`id` = 1773072 OR `props-main`.`id` = 1773074 OR `props-main`.`id` = 1776706 OR `props-main`.`id` = 1761465 OR `props-main`.`id` = 1731799 OR `props-main`.`id` = 1737059 OR `props-main`.`id` = 1764281 OR `props-main`.`id` = 1680247 OR `props-main`.`id` = 1771367 OR `props-main`.`id` = 1768565 OR `props-main`.`id` = 1766677 OR `props-main`.`id` = 1765402 OR `props-main`.`id` = 1765581 OR `props-main`.`id` = 1758343 OR `props-main`.`id` = 1758344 OR `props-main`.`id` = 1765475 OR `props-main`.`id` = 1772002 OR `props-main`.`id` = 1750282 OR `props-main`.`id` = 1765998 OR `props-main`.`id` = 1757023)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings234902' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-22' 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();