A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 375250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 414750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1549 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2049 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` = 1676891 OR `props-main`.`id` = 1702542 OR `props-main`.`id` = 1704093 OR `props-main`.`id` = 1680814 OR `props-main`.`id` = 1704194 OR `props-main`.`id` = 1697925 OR `props-main`.`id` = 1690540 OR `props-main`.`id` = 1692404 OR `props-main`.`id` = 1689450 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` = 1704121 OR `props-main`.`id` = 1703111 OR `props-main`.`id` = 1678114 OR `props-main`.`id` = 1700887 OR `props-main`.`id` = 1694030 OR `props-main`.`id` = 1692325 OR `props-main`.`id` = 1696609 OR `props-main`.`id` = 1696606 OR `props-main`.`id` = 1698002 OR `props-main`.`id` = 1698699 OR `props-main`.`id` = 1691561 OR `props-main`.`id` = 1695855 OR `props-main`.`id` = 1698811 OR `props-main`.`id` = 1694858 OR `props-main`.`id` = 1671754 OR `props-main`.`id` = 1654023 OR `props-main`.`id` = 1703079 OR `props-main`.`id` = 1704082 OR `props-main`.`id` = 1683107 OR `props-main`.`id` = 1651438 OR `props-main`.`id` = 1702208 OR `props-main`.`id` = 1638016 OR `props-main`.`id` = 1700020 OR `props-main`.`id` = 1677294 OR `props-main`.`id` = 1702242 OR `props-main`.`id` = 1692526 OR `props-main`.`id` = 1701570 OR `props-main`.`id` = 1702943 OR `props-main`.`id` = 1701231 OR `props-main`.`id` = 1699980 OR `props-main`.`id` = 1681360 OR `props-main`.`id` = 1694788 OR `props-main`.`id` = 1697415 OR `props-main`.`id` = 1690978 OR `props-main`.`id` = 1703701 OR `props-main`.`id` = 1691716 OR `props-main`.`id` = 1691176 OR `props-main`.`id` = 1692236 OR `props-main`.`id` = 1702672 OR `props-main`.`id` = 1701759 OR `props-main`.`id` = 235292 OR `props-main`.`id` = 1703840 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` = 1702265 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1697121 OR `props-main`.`id` = 1672985 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 1701105 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1697200 OR `props-main`.`id` = 1694006 OR `props-main`.`id` = 1694007 OR `props-main`.`id` = 1697379 OR `props-main`.`id` = 1670908 OR `props-main`.`id` = 1696769 OR `props-main`.`id` = 1681580 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 1702595 OR `props-main`.`id` = 1697808 OR `props-main`.`id` = 188254 OR `props-main`.`id` = 1702556 OR `props-main`.`id` = 1704069 OR `props-main`.`id` = 1702889 OR `props-main`.`id` = 1686412 OR `props-main`.`id` = 1699036 OR `props-main`.`id` = 1703010 OR `props-main`.`id` = 1687404 OR `props-main`.`id` = 1702375 OR `props-main`.`id` = 1699034 OR `props-main`.`id` = 1701499 OR `props-main`.`id` = 1697236 OR `props-main`.`id` = 1701303 OR `props-main`.`id` = 1692013 OR `props-main`.`id` = 1697265 OR `props-main`.`id` = 1690514 OR `props-main`.`id` = 1690528 OR `props-main`.`id` = 1702464 OR `props-main`.`id` = 1691341 OR `props-main`.`id` = 1702842 OR `props-main`.`id` = 1702857 OR `props-main`.`id` = 1674613 OR `props-main`.`id` = 1691565 OR `props-main`.`id` = 1696725 OR `props-main`.`id` = 1698489 OR `props-main`.`id` = 1701373 OR `props-main`.`id` = 1686094 OR `props-main`.`id` = 1700108 OR `props-main`.`id` = 1697196 OR `props-main`.`id` = 269824 OR `props-main`.`id` = 742025 OR `props-main`.`id` = 1702844 OR `props-main`.`id` = 1703048 OR `props-main`.`id` = 1703130 OR `props-main`.`id` = 1703141 OR `props-main`.`id` = 1703118 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1701984 OR `props-main`.`id` = 1702905 OR `props-main`.`id` = 1703308 OR `props-main`.`id` = 1694367)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno587052' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-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();