A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 503500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 556500 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) >= 2050 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2550 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` = 1720180 OR `props-main`.`id` = 1720179 OR `props-main`.`id` = 1687309 OR `props-main`.`id` = 1704261 OR `props-main`.`id` = 1718441 OR `props-main`.`id` = 1717793 OR `props-main`.`id` = 1713335 OR `props-main`.`id` = 1712418 OR `props-main`.`id` = 1716429 OR `props-main`.`id` = 1686038 OR `props-main`.`id` = 1711070 OR `props-main`.`id` = 1686066 OR `props-main`.`id` = 1703209 OR `props-main`.`id` = 1711244 OR `props-main`.`id` = 1704448 OR `props-main`.`id` = 1706016 OR `props-main`.`id` = 1704533 OR `props-main`.`id` = 1718713 OR `props-main`.`id` = 1719706 OR `props-main`.`id` = 1700105 OR `props-main`.`id` = 1694314 OR `props-main`.`id` = 1715538 OR `props-main`.`id` = 1719708 OR `props-main`.`id` = 1716319 OR `props-main`.`id` = 1713502 OR `props-main`.`id` = 1713501 OR `props-main`.`id` = 1719198 OR `props-main`.`id` = 1715964 OR `props-main`.`id` = 1706641 OR `props-main`.`id` = 1713659 OR `props-main`.`id` = 1718543 OR `props-main`.`id` = 1718545 OR `props-main`.`id` = 1703268 OR `props-main`.`id` = 1705331 OR `props-main`.`id` = 1717383 OR `props-main`.`id` = 1717022 OR `props-main`.`id` = 1708233 OR `props-main`.`id` = 1666495 OR `props-main`.`id` = 1715453 OR `props-main`.`id` = 1717375 OR `props-main`.`id` = 1702885 OR `props-main`.`id` = 1718533 OR `props-main`.`id` = 1696927 OR `props-main`.`id` = 1704216 OR `props-main`.`id` = 1719531 OR `props-main`.`id` = 1717895 OR `props-main`.`id` = 1717914 OR `props-main`.`id` = 1712887 OR `props-main`.`id` = 1698173 OR `props-main`.`id` = 1708188 OR `props-main`.`id` = 1718974 OR `props-main`.`id` = 1686098 OR `props-main`.`id` = 1712530 OR `props-main`.`id` = 1718195 OR `props-main`.`id` = 1718197 OR `props-main`.`id` = 1718157 OR `props-main`.`id` = 1716610 OR `props-main`.`id` = 1718139 OR `props-main`.`id` = 1719464 OR `props-main`.`id` = 1717693 OR `props-main`.`id` = 1712569 OR `props-main`.`id` = 1716221 OR `props-main`.`id` = 1716371 OR `props-main`.`id` = 1716378 OR `props-main`.`id` = 1715015 OR `props-main`.`id` = 1699067 OR `props-main`.`id` = 1699066 OR `props-main`.`id` = 1701591 OR `props-main`.`id` = 1712570 OR `props-main`.`id` = 1701592 OR `props-main`.`id` = 1703329 OR `props-main`.`id` = 1718159 OR `props-main`.`id` = 1713626 OR `props-main`.`id` = 1718152 OR `props-main`.`id` = 1711334 OR `props-main`.`id` = 1703762 OR `props-main`.`id` = 1713653 OR `props-main`.`id` = 1704399 OR `props-main`.`id` = 1719897 OR `props-main`.`id` = 1718844 OR `props-main`.`id` = 1704510 OR `props-main`.`id` = 1713824 OR `props-main`.`id` = 1719336 OR `props-main`.`id` = 929721 OR `props-main`.`id` = 1706095 OR `props-main`.`id` = 1718638 OR `props-main`.`id` = 1717667 OR `props-main`.`id` = 1717943 OR `props-main`.`id` = 1704073 OR `props-main`.`id` = 1704406 OR `props-main`.`id` = 1709491 OR `props-main`.`id` = 1719816 OR `props-main`.`id` = 1720128 OR `props-main`.`id` = 1671529 OR `props-main`.`id` = 1671562 OR `props-main`.`id` = 1719961 OR `props-main`.`id` = 1706757 OR `props-main`.`id` = 1697705 OR `props-main`.`id` = 1697719 OR `props-main`.`id` = 1697708 OR `props-main`.`id` = 1697728 OR `props-main`.`id` = 1716646 OR `props-main`.`id` = 1716582 OR `props-main`.`id` = 1715682 OR `props-main`.`id` = 1719836 OR `props-main`.`id` = 1719702 OR `props-main`.`id` = 1718904 OR `props-main`.`id` = 1717026 OR `props-main`.`id` = 1719691 OR `props-main`.`id` = 1716660 OR `props-main`.`id` = 1716657 OR `props-main`.`id` = 1716670 OR `props-main`.`id` = 1716671 OR `props-main`.`id` = 1716682 OR `props-main`.`id` = 1716681)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare230589' 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();