A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 246050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 271950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 498 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 998 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` = 1678448 OR `props-main`.`id` = 1686204 OR `props-main`.`id` = 1682483 OR `props-main`.`id` = 1689327 OR `props-main`.`id` = 1689287 OR `props-main`.`id` = 1671255 OR `props-main`.`id` = 1673581 OR `props-main`.`id` = 1676361 OR `props-main`.`id` = 1667919 OR `props-main`.`id` = 1685650 OR `props-main`.`id` = 1684594 OR `props-main`.`id` = 1686342 OR `props-main`.`id` = 1670779 OR `props-main`.`id` = 174244 OR `props-main`.`id` = 1683526 OR `props-main`.`id` = 1677299 OR `props-main`.`id` = 1666148 OR `props-main`.`id` = 1666526 OR `props-main`.`id` = 1666238 OR `props-main`.`id` = 1678673 OR `props-main`.`id` = 1625090 OR `props-main`.`id` = 1674203 OR `props-main`.`id` = 1683102 OR `props-main`.`id` = 1683365 OR `props-main`.`id` = 1685412 OR `props-main`.`id` = 1687400 OR `props-main`.`id` = 1668893 OR `props-main`.`id` = 1688637 OR `props-main`.`id` = 1657521 OR `props-main`.`id` = 1653001 OR `props-main`.`id` = 1678851 OR `props-main`.`id` = 1681422 OR `props-main`.`id` = 1679846 OR `props-main`.`id` = 1683366 OR `props-main`.`id` = 1665851 OR `props-main`.`id` = 1666102 OR `props-main`.`id` = 1684372 OR `props-main`.`id` = 1629316 OR `props-main`.`id` = 1688426 OR `props-main`.`id` = 1689433 OR `props-main`.`id` = 1689201 OR `props-main`.`id` = 1689404 OR `props-main`.`id` = 1654657 OR `props-main`.`id` = 1650116 OR `props-main`.`id` = 1688370 OR `props-main`.`id` = 1673371 OR `props-main`.`id` = 1687999 OR `props-main`.`id` = 1688015 OR `props-main`.`id` = 1688948 OR `props-main`.`id` = 1684167 OR `props-main`.`id` = 1638703 OR `props-main`.`id` = 1689023 OR `props-main`.`id` = 1686751 OR `props-main`.`id` = 1679370 OR `props-main`.`id` = 1689231 OR `props-main`.`id` = 1673417 OR `props-main`.`id` = 1686816 OR `props-main`.`id` = 1688993 OR `props-main`.`id` = 1688994 OR `props-main`.`id` = 1678322 OR `props-main`.`id` = 1684874 OR `props-main`.`id` = 1634333 OR `props-main`.`id` = 1656003 OR `props-main`.`id` = 1678309 OR `props-main`.`id` = 1673837 OR `props-main`.`id` = 1689230 OR `props-main`.`id` = 1686980 OR `props-main`.`id` = 1688863 OR `props-main`.`id` = 1687397 OR `props-main`.`id` = 1687252 OR `props-main`.`id` = 1689029 OR `props-main`.`id` = 1625610 OR `props-main`.`id` = 1618309 OR `props-main`.`id` = 1676775 OR `props-main`.`id` = 1651836 OR `props-main`.`id` = 1686343 OR `props-main`.`id` = 1641622 OR `props-main`.`id` = 1659149 OR `props-main`.`id` = 1684698 OR `props-main`.`id` = 1684722 OR `props-main`.`id` = 1684734 OR `props-main`.`id` = 1638920 OR `props-main`.`id` = 1638705 OR `props-main`.`id` = 1681922 OR `props-main`.`id` = 1689137 OR `props-main`.`id` = 1688509 OR `props-main`.`id` = 1680666 OR `props-main`.`id` = 1670004 OR `props-main`.`id` = 1686592 OR `props-main`.`id` = 1686964 OR `props-main`.`id` = 194016 OR `props-main`.`id` = 1658032 OR `props-main`.`id` = 1667752 OR `props-main`.`id` = 1685214 OR `props-main`.`id` = 1687282 OR `props-main`.`id` = 1689634 OR `props-main`.`id` = 1654794 OR `props-main`.`id` = 1689281 OR `props-main`.`id` = 1665713 OR `props-main`.`id` = 1646185 OR `props-main`.`id` = 1681359 OR `props-main`.`id` = 1673437 OR `props-main`.`id` = 1680587 OR `props-main`.`id` = 1685860 OR `props-main`.`id` = 1671540 OR `props-main`.`id` = 1684861 OR `props-main`.`id` = 1650954 OR `props-main`.`id` = 232302 OR `props-main`.`id` = 232595 OR `props-main`.`id` = 1654900 OR `props-main`.`id` = 228066 OR `props-main`.`id` = 1673000 OR `props-main`.`id` = 1651433 OR `props-main`.`id` = 1676841 OR `props-main`.`id` = 1687179 OR `props-main`.`id` = 1688615 OR `props-main`.`id` = 1688538 OR `props-main`.`id` = 1685273 OR `props-main`.`id` = 1673963 OR `props-main`.`id` = 1684160 OR `props-main`.`id` = 1684204 OR `props-main`.`id` = 1673961 OR `props-main`.`id` = 1673962 OR `props-main`.`id` = 1688159 OR `props-main`.`id` = 1680014 OR `props-main`.`id` = 1656415)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno614430' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-11' 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();