A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 323000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 357000 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) >= 987 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1487 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` = 1648185 OR `props-main`.`id` = 1616928 OR `props-main`.`id` = 1690720 OR `props-main`.`id` = 1549555 OR `props-main`.`id` = 1684180 OR `props-main`.`id` = 1681202 OR `props-main`.`id` = 1648449 OR `props-main`.`id` = 1687799 OR `props-main`.`id` = 1674485 OR `props-main`.`id` = 1691065 OR `props-main`.`id` = 1691073 OR `props-main`.`id` = 1691075 OR `props-main`.`id` = 1691082 OR `props-main`.`id` = 1694339 OR `props-main`.`id` = 1693958 OR `props-main`.`id` = 1651729 OR `props-main`.`id` = 1651784 OR `props-main`.`id` = 1696580 OR `props-main`.`id` = 1695114 OR `props-main`.`id` = 1687014 OR `props-main`.`id` = 1681923 OR `props-main`.`id` = 1689737 OR `props-main`.`id` = 1650662 OR `props-main`.`id` = 1650663 OR `props-main`.`id` = 1650657 OR `props-main`.`id` = 1650766 OR `props-main`.`id` = 1697856 OR `props-main`.`id` = 1697398 OR `props-main`.`id` = 1694031 OR `props-main`.`id` = 1695234 OR `props-main`.`id` = 1690044 OR `props-main`.`id` = 1694024 OR `props-main`.`id` = 1695025 OR `props-main`.`id` = 1693689 OR `props-main`.`id` = 1696748 OR `props-main`.`id` = 1657257 OR `props-main`.`id` = 1696247 OR `props-main`.`id` = 1694547 OR `props-main`.`id` = 1680183 OR `props-main`.`id` = 1677474 OR `props-main`.`id` = 1693637 OR `props-main`.`id` = 1696175 OR `props-main`.`id` = 1692529 OR `props-main`.`id` = 1684110 OR `props-main`.`id` = 1690732 OR `props-main`.`id` = 1694782 OR `props-main`.`id` = 1695064 OR `props-main`.`id` = 1694154 OR `props-main`.`id` = 1696483 OR `props-main`.`id` = 1679610 OR `props-main`.`id` = 1695448 OR `props-main`.`id` = 1696665 OR `props-main`.`id` = 1696658 OR `props-main`.`id` = 1688494 OR `props-main`.`id` = 1697432 OR `props-main`.`id` = 1695906 OR `props-main`.`id` = 1694315 OR `props-main`.`id` = 1696317 OR `props-main`.`id` = 1694554 OR `props-main`.`id` = 1696923 OR `props-main`.`id` = 1697853 OR `props-main`.`id` = 1648184 OR `props-main`.`id` = 1697824 OR `props-main`.`id` = 1676419 OR `props-main`.`id` = 1679752 OR `props-main`.`id` = 1696969 OR `props-main`.`id` = 1697316 OR `props-main`.`id` = 1686434 OR `props-main`.`id` = 1697162 OR `props-main`.`id` = 1697161 OR `props-main`.`id` = 1691899 OR `props-main`.`id` = 1691904 OR `props-main`.`id` = 1694231 OR `props-main`.`id` = 1694457 OR `props-main`.`id` = 1681566 OR `props-main`.`id` = 1696183 OR `props-main`.`id` = 1671574 OR `props-main`.`id` = 1667925 OR `props-main`.`id` = 1658113 OR `props-main`.`id` = 1658112 OR `props-main`.`id` = 1686704 OR `props-main`.`id` = 1658114 OR `props-main`.`id` = 1675166 OR `props-main`.`id` = 1687309 OR `props-main`.`id` = 1679033 OR `props-main`.`id` = 1679034 OR `props-main`.`id` = 1674891 OR `props-main`.`id` = 1688961 OR `props-main`.`id` = 1686038 OR `props-main`.`id` = 1686106 OR `props-main`.`id` = 1686066 OR `props-main`.`id` = 1685884 OR `props-main`.`id` = 1692210 OR `props-main`.`id` = 1678055 OR `props-main`.`id` = 1648478 OR `props-main`.`id` = 1695222 OR `props-main`.`id` = 1694314 OR `props-main`.`id` = 1685845 OR `props-main`.`id` = 1689829 OR `props-main`.`id` = 1687117 OR `props-main`.`id` = 1688841 OR `props-main`.`id` = 1689104 OR `props-main`.`id` = 1697017 OR `props-main`.`id` = 1690606 OR `props-main`.`id` = 1690281 OR `props-main`.`id` = 1694313 OR `props-main`.`id` = 1695794 OR `props-main`.`id` = 1697018 OR `props-main`.`id` = 1690626 OR `props-main`.`id` = 1690628 OR `props-main`.`id` = 1648266 OR `props-main`.`id` = 1697273 OR `props-main`.`id` = 1693878 OR `props-main`.`id` = 1697926 OR `props-main`.`id` = 1695624 OR `props-main`.`id` = 1692288 OR `props-main`.`id` = 1696854 OR `props-main`.`id` = 1698008 OR `props-main`.`id` = 1663396 OR `props-main`.`id` = 1650946 OR `props-main`.`id` = 1691067 OR `props-main`.`id` = 1694909 OR `props-main`.`id` = 1695033 OR `props-main`.`id` = 1694366 OR `props-main`.`id` = 1697231 OR `props-main`.`id` = 1674706)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare238376' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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();