A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1211250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1338750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3289 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3789 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` = 1717443 OR `props-main`.`id` = 1717444 OR `props-main`.`id` = 1719469 OR `props-main`.`id` = 1707101 OR `props-main`.`id` = 1698148 OR `props-main`.`id` = 1709697 OR `props-main`.`id` = 1712521 OR `props-main`.`id` = 1719597 OR `props-main`.`id` = 1705807 OR `props-main`.`id` = 1718240 OR `props-main`.`id` = 1718236 OR `props-main`.`id` = 226899 OR `props-main`.`id` = 1692341 OR `props-main`.`id` = 1717999 OR `props-main`.`id` = 1706045 OR `props-main`.`id` = 1712607 OR `props-main`.`id` = 1704905 OR `props-main`.`id` = 1716527 OR `props-main`.`id` = 1716040 OR `props-main`.`id` = 1716597 OR `props-main`.`id` = 1708512 OR `props-main`.`id` = 1709953 OR `props-main`.`id` = 1715721 OR `props-main`.`id` = 1715638 OR `props-main`.`id` = 1717513 OR `props-main`.`id` = 717214 OR `props-main`.`id` = 1718463 OR `props-main`.`id` = 1719631 OR `props-main`.`id` = 1715479 OR `props-main`.`id` = 37606 OR `props-main`.`id` = 1719714 OR `props-main`.`id` = 1716830 OR `props-main`.`id` = 1716328 OR `props-main`.`id` = 1716322 OR `props-main`.`id` = 1708118 OR `props-main`.`id` = 1708401 OR `props-main`.`id` = 1716982 OR `props-main`.`id` = 1706043 OR `props-main`.`id` = 1712610 OR `props-main`.`id` = 1718084 OR `props-main`.`id` = 1692498 OR `props-main`.`id` = 1716970 OR `props-main`.`id` = 1714921 OR `props-main`.`id` = 1718494 OR `props-main`.`id` = 1712630 OR `props-main`.`id` = 1713550 OR `props-main`.`id` = 1713509 OR `props-main`.`id` = 981418 OR `props-main`.`id` = 1718454 OR `props-main`.`id` = 1693719 OR `props-main`.`id` = 1692603 OR `props-main`.`id` = 1696816 OR `props-main`.`id` = 1698120 OR `props-main`.`id` = 1713077 OR `props-main`.`id` = 1719259 OR `props-main`.`id` = 1701497 OR `props-main`.`id` = 1716624 OR `props-main`.`id` = 102873 OR `props-main`.`id` = 1717093 OR `props-main`.`id` = 1717435 OR `props-main`.`id` = 1717769 OR `props-main`.`id` = 1709783 OR `props-main`.`id` = 1701563 OR `props-main`.`id` = 1713027 OR `props-main`.`id` = 1712891 OR `props-main`.`id` = 1712744 OR `props-main`.`id` = 1712849 OR `props-main`.`id` = 1712853 OR `props-main`.`id` = 1712852 OR `props-main`.`id` = 1718542 OR `props-main`.`id` = 1703326 OR `props-main`.`id` = 1713572 OR `props-main`.`id` = 1713404 OR `props-main`.`id` = 1718942 OR `props-main`.`id` = 1710113 OR `props-main`.`id` = 1707908 OR `props-main`.`id` = 1719229 OR `props-main`.`id` = 1713557 OR `props-main`.`id` = 1709194 OR `props-main`.`id` = 1705384 OR `props-main`.`id` = 1713628 OR `props-main`.`id` = 1706746 OR `props-main`.`id` = 1706741 OR `props-main`.`id` = 1696782 OR `props-main`.`id` = 1696783 OR `props-main`.`id` = 1697315 OR `props-main`.`id` = 1703586 OR `props-main`.`id` = 1714984 OR `props-main`.`id` = 1706740 OR `props-main`.`id` = 1710041 OR `props-main`.`id` = 1718282 OR `props-main`.`id` = 1697250 OR `props-main`.`id` = 1710039 OR `props-main`.`id` = 1719703 OR `props-main`.`id` = 1701800 OR `props-main`.`id` = 1718648 OR `props-main`.`id` = 1694725 OR `props-main`.`id` = 1717962 OR `props-main`.`id` = 227897 OR `props-main`.`id` = 1719716 OR `props-main`.`id` = 1719704 OR `props-main`.`id` = 1715594 OR `props-main`.`id` = 1713321 OR `props-main`.`id` = 1714010 OR `props-main`.`id` = 1717522 OR `props-main`.`id` = 1717059 OR `props-main`.`id` = 1717530 OR `props-main`.`id` = 1715777 OR `props-main`.`id` = 1717913 OR `props-main`.`id` = 1665744 OR `props-main`.`id` = 1665747 OR `props-main`.`id` = 1689571 OR `props-main`.`id` = 1709983 OR `props-main`.`id` = 1709978)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636456' 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();