A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367500 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) >= 937 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1437 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` = 1716395 OR `props-main`.`id` = 1719635 OR `props-main`.`id` = 1713607 OR `props-main`.`id` = 1713266 OR `props-main`.`id` = 1713485 OR `props-main`.`id` = 1716239 OR `props-main`.`id` = 1716237 OR `props-main`.`id` = 1716238 OR `props-main`.`id` = 1688452 OR `props-main`.`id` = 1715694 OR `props-main`.`id` = 1715753 OR `props-main`.`id` = 1715746 OR `props-main`.`id` = 1715759 OR `props-main`.`id` = 279647 OR `props-main`.`id` = 1698238 OR `props-main`.`id` = 1713330 OR `props-main`.`id` = 1705416 OR `props-main`.`id` = 1717865 OR `props-main`.`id` = 1705077 OR `props-main`.`id` = 1709192 OR `props-main`.`id` = 1709198 OR `props-main`.`id` = 1709154 OR `props-main`.`id` = 1714956 OR `props-main`.`id` = 1713126 OR `props-main`.`id` = 1716989 OR `props-main`.`id` = 1714440 OR `props-main`.`id` = 1708287 OR `props-main`.`id` = 1709466 OR `props-main`.`id` = 1709216 OR `props-main`.`id` = 1720262 OR `props-main`.`id` = 1702687 OR `props-main`.`id` = 1704692 OR `props-main`.`id` = 1718622 OR `props-main`.`id` = 1702067 OR `props-main`.`id` = 1702099 OR `props-main`.`id` = 1714607 OR `props-main`.`id` = 1702508 OR `props-main`.`id` = 1714774 OR `props-main`.`id` = 1714465 OR `props-main`.`id` = 1694967 OR `props-main`.`id` = 1696185 OR `props-main`.`id` = 1701468 OR `props-main`.`id` = 1665493 OR `props-main`.`id` = 1689129 OR `props-main`.`id` = 1714387 OR `props-main`.`id` = 1719549 OR `props-main`.`id` = 1719735 OR `props-main`.`id` = 1719553 OR `props-main`.`id` = 1719749 OR `props-main`.`id` = 1693807 OR `props-main`.`id` = 1693713 OR `props-main`.`id` = 1693694 OR `props-main`.`id` = 1714454 OR `props-main`.`id` = 1694962 OR `props-main`.`id` = 1674548 OR `props-main`.`id` = 1706026 OR `props-main`.`id` = 1692454 OR `props-main`.`id` = 1692435 OR `props-main`.`id` = 1706931 OR `props-main`.`id` = 1717007 OR `props-main`.`id` = 1703178 OR `props-main`.`id` = 1703174 OR `props-main`.`id` = 1703265 OR `props-main`.`id` = 1714340 OR `props-main`.`id` = 1123502 OR `props-main`.`id` = 1718808 OR `props-main`.`id` = 1708189 OR `props-main`.`id` = 1714743 OR `props-main`.`id` = 1714759 OR `props-main`.`id` = 1627326 OR `props-main`.`id` = 1696651 OR `props-main`.`id` = 1714499 OR `props-main`.`id` = 1717217 OR `props-main`.`id` = 1717979 OR `props-main`.`id` = 1716553 OR `props-main`.`id` = 1720206 OR `props-main`.`id` = 1690062 OR `props-main`.`id` = 1716559 OR `props-main`.`id` = 1716763 OR `props-main`.`id` = 1707010 OR `props-main`.`id` = 1719093 OR `props-main`.`id` = 1717008 OR `props-main`.`id` = 1708460 OR `props-main`.`id` = 1710126 OR `props-main`.`id` = 1718502 OR `props-main`.`id` = 1714294 OR `props-main`.`id` = 1704870 OR `props-main`.`id` = 1704891 OR `props-main`.`id` = 1704917 OR `props-main`.`id` = 1676643 OR `props-main`.`id` = 1655369 OR `props-main`.`id` = 1695165 OR `props-main`.`id` = 1714622 OR `props-main`.`id` = 1703320 OR `props-main`.`id` = 1704769 OR `props-main`.`id` = 1689782 OR `props-main`.`id` = 1690433 OR `props-main`.`id` = 1690429 OR `props-main`.`id` = 1698961 OR `props-main`.`id` = 1718535 OR `props-main`.`id` = 262682 OR `props-main`.`id` = 1688050 OR `props-main`.`id` = 1688040 OR `props-main`.`id` = 1711274 OR `props-main`.`id` = 1703457 OR `props-main`.`id` = 1704693 OR `props-main`.`id` = 1717582 OR `props-main`.`id` = 1064603 OR `props-main`.`id` = 1706987 OR `props-main`.`id` = 1704003)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC23115162' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-04' 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();