A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 321052.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 354847.5 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) >= 1103 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1603 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` = 1698450 OR `props-main`.`id` = 1684412 OR `props-main`.`id` = 1695754 OR `props-main`.`id` = 1698824 OR `props-main`.`id` = 1696540 OR `props-main`.`id` = 1691098 OR `props-main`.`id` = 1695657 OR `props-main`.`id` = 1695663 OR `props-main`.`id` = 1695582 OR `props-main`.`id` = 1701281 OR `props-main`.`id` = 1685922 OR `props-main`.`id` = 1679178 OR `props-main`.`id` = 1679179 OR `props-main`.`id` = 1695439 OR `props-main`.`id` = 1696732 OR `props-main`.`id` = 1696455 OR `props-main`.`id` = 1696213 OR `props-main`.`id` = 1696446 OR `props-main`.`id` = 1696456 OR `props-main`.`id` = 1696215 OR `props-main`.`id` = 1696447 OR `props-main`.`id` = 1696457 OR `props-main`.`id` = 1696448 OR `props-main`.`id` = 1696452 OR `props-main`.`id` = 1691849 OR `props-main`.`id` = 1691767 OR `props-main`.`id` = 1701423 OR `props-main`.`id` = 86628 OR `props-main`.`id` = 1701174 OR `props-main`.`id` = 1686743 OR `props-main`.`id` = 1700126 OR `props-main`.`id` = 1700906 OR `props-main`.`id` = 1690591 OR `props-main`.`id` = 1695772 OR `props-main`.`id` = 1700806 OR `props-main`.`id` = 1698713 OR `props-main`.`id` = 1676891 OR `props-main`.`id` = 1701418 OR `props-main`.`id` = 1701668 OR `props-main`.`id` = 37605 OR `props-main`.`id` = 1680814 OR `props-main`.`id` = 1698164 OR `props-main`.`id` = 1694857 OR `props-main`.`id` = 1697925 OR `props-main`.`id` = 1690540 OR `props-main`.`id` = 1701564 OR `props-main`.`id` = 1692404 OR `props-main`.`id` = 1689450 OR `props-main`.`id` = 1702006 OR `props-main`.`id` = 1678175 OR `props-main`.`id` = 1689226 OR `props-main`.`id` = 1689290 OR `props-main`.`id` = 1667572 OR `props-main`.`id` = 1694690 OR `props-main`.`id` = 1674697 OR `props-main`.`id` = 1701172 OR `props-main`.`id` = 1649781 OR `props-main`.`id` = 1678114 OR `props-main`.`id` = 1700887 OR `props-main`.`id` = 1694030 OR `props-main`.`id` = 1680361 OR `props-main`.`id` = 1692325 OR `props-main`.`id` = 1696609 OR `props-main`.`id` = 1696606 OR `props-main`.`id` = 248876 OR `props-main`.`id` = 261479 OR `props-main`.`id` = 1698002 OR `props-main`.`id` = 1685930 OR `props-main`.`id` = 1698699 OR `props-main`.`id` = 1691561 OR `props-main`.`id` = 1695855 OR `props-main`.`id` = 1698811 OR `props-main`.`id` = 1697319 OR `props-main`.`id` = 1693812 OR `props-main`.`id` = 1694858 OR `props-main`.`id` = 1671754 OR `props-main`.`id` = 1654023 OR `props-main`.`id` = 1688987 OR `props-main`.`id` = 1698844 OR `props-main`.`id` = 1651438 OR `props-main`.`id` = 1638016 OR `props-main`.`id` = 1700020 OR `props-main`.`id` = 1677294 OR `props-main`.`id` = 1692526 OR `props-main`.`id` = 1701570 OR `props-main`.`id` = 1696790 OR `props-main`.`id` = 1701231 OR `props-main`.`id` = 1699980 OR `props-main`.`id` = 1681360 OR `props-main`.`id` = 1691062 OR `props-main`.`id` = 1694788 OR `props-main`.`id` = 1697415 OR `props-main`.`id` = 1696497 OR `props-main`.`id` = 1690978 OR `props-main`.`id` = 1687083 OR `props-main`.`id` = 138928 OR `props-main`.`id` = 1691716 OR `props-main`.`id` = 1691176 OR `props-main`.`id` = 1692236 OR `props-main`.`id` = 1696519 OR `props-main`.`id` = 235292 OR `props-main`.`id` = 1695665 OR `props-main`.`id` = 1695890 OR `props-main`.`id` = 971585 OR `props-main`.`id` = 1695637 OR `props-main`.`id` = 1686274 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1672985 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 1701105 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1694006 OR `props-main`.`id` = 1694007 OR `props-main`.`id` = 1697379)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640719' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-09' 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();