A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 437000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 483000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1750 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2250 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` = 1748875 OR `props-main`.`id` = 1748007 OR `props-main`.`id` = 1723694 OR `props-main`.`id` = 1723733 OR `props-main`.`id` = 1723742 OR `props-main`.`id` = 1760863 OR `props-main`.`id` = 1758993 OR `props-main`.`id` = 1765898 OR `props-main`.`id` = 1724840 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` = 1754478 OR `props-main`.`id` = 1754982 OR `props-main`.`id` = 1748877 OR `props-main`.`id` = 1712817 OR `props-main`.`id` = 1760958 OR `props-main`.`id` = 1763138 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` = 1759340 OR `props-main`.`id` = 1738701 OR `props-main`.`id` = 1739049 OR `props-main`.`id` = 1764280 OR `props-main`.`id` = 1750955 OR `props-main`.`id` = 1739177 OR `props-main`.`id` = 1753162 OR `props-main`.`id` = 1729113 OR `props-main`.`id` = 1741567 OR `props-main`.`id` = 1741557 OR `props-main`.`id` = 1762466 OR `props-main`.`id` = 1762479 OR `props-main`.`id` = 1731115 OR `props-main`.`id` = 1752334 OR `props-main`.`id` = 1752887 OR `props-main`.`id` = 1716323 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` = 1762326 OR `props-main`.`id` = 1761024 OR `props-main`.`id` = 1761822 OR `props-main`.`id` = 1721515 OR `props-main`.`id` = 1757572 OR `props-main`.`id` = 1746210 OR `props-main`.`id` = 1742125 OR `props-main`.`id` = 1761739 OR `props-main`.`id` = 1761738 OR `props-main`.`id` = 1761740 OR `props-main`.`id` = 1758347 OR `props-main`.`id` = 1758773 OR `props-main`.`id` = 1760501 OR `props-main`.`id` = 1756192 OR `props-main`.`id` = 1750915 OR `props-main`.`id` = 1752088 OR `props-main`.`id` = 1758413 OR `props-main`.`id` = 1736349 OR `props-main`.`id` = 1762503 OR `props-main`.`id` = 1748547 OR `props-main`.`id` = 1753362 OR `props-main`.`id` = 1744424 OR `props-main`.`id` = 1744396 OR `props-main`.`id` = 1744402 OR `props-main`.`id` = 1745341 OR `props-main`.`id` = 1737824 OR `props-main`.`id` = 1762533 OR `props-main`.`id` = 1762549 OR `props-main`.`id` = 1761465 OR `props-main`.`id` = 1762209 OR `props-main`.`id` = 1731799 OR `props-main`.`id` = 1745699 OR `props-main`.`id` = 1764296 OR `props-main`.`id` = 1737059 OR `props-main`.`id` = 1739571 OR `props-main`.`id` = 1739595 OR `props-main`.`id` = 1741083 OR `props-main`.`id` = 1764281 OR `props-main`.`id` = 1680247 OR `props-main`.`id` = 1759433 OR `props-main`.`id` = 1754206 OR `props-main`.`id` = 1754468 OR `props-main`.`id` = 1754342 OR `props-main`.`id` = 1754405 OR `props-main`.`id` = 1766416 OR `props-main`.`id` = 1766438 OR `props-main`.`id` = 1766432 OR `props-main`.`id` = 1766677 OR `props-main`.`id` = 1765402 OR `props-main`.`id` = 1765581 OR `props-main`.`id` = 1751368 OR `props-main`.`id` = 1738280 OR `props-main`.`id` = 1738619 OR `props-main`.`id` = 1738689 OR `props-main`.`id` = 1740019 OR `props-main`.`id` = 1758343 OR `props-main`.`id` = 1758344 OR `props-main`.`id` = 1762001 OR `props-main`.`id` = 1765475 OR `props-main`.`id` = 1765481 OR `props-main`.`id` = 1750282 OR `props-main`.`id` = 1758364 OR `props-main`.`id` = 1765998 OR `props-main`.`id` = 1752581 OR `props-main`.`id` = 1757023 OR `props-main`.`id` = 1718175 OR `props-main`.`id` = 1712967)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare243623' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-25' 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();