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` = 1688537 OR `props-main`.`id` = 1666457 OR `props-main`.`id` = 1666460 OR `props-main`.`id` = 1680814 OR `props-main`.`id` = 1690540 OR `props-main`.`id` = 1689265 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` = 1689282 OR `props-main`.`id` = 1684908 OR `props-main`.`id` = 1674697 OR `props-main`.`id` = 1688459 OR `props-main`.`id` = 1688385 OR `props-main`.`id` = 1673696 OR `props-main`.`id` = 1678114 OR `props-main`.`id` = 1690577 OR `props-main`.`id` = 1688337 OR `props-main`.`id` = 1685024 OR `props-main`.`id` = 1642537 OR `props-main`.`id` = 1686163 OR `props-main`.`id` = 1684953 OR `props-main`.`id` = 1661800 OR `props-main`.`id` = 1690252 OR `props-main`.`id` = 1690467 OR `props-main`.`id` = 1691340 OR `props-main`.`id` = 1685023 OR `props-main`.`id` = 1671754 OR `props-main`.`id` = 1654023 OR `props-main`.`id` = 1658333 OR `props-main`.`id` = 1688987 OR `props-main`.`id` = 1683107 OR `props-main`.`id` = 1651438 OR `props-main`.`id` = 1690141 OR `props-main`.`id` = 1690146 OR `props-main`.`id` = 1691400 OR `props-main`.`id` = 1689474 OR `props-main`.`id` = 1679511 OR `props-main`.`id` = 1690782 OR `props-main`.`id` = 1680357 OR `props-main`.`id` = 1638016 OR `props-main`.`id` = 1677294 OR `props-main`.`id` = 1678849 OR `props-main`.`id` = 1688927 OR `props-main`.`id` = 1681360 OR `props-main`.`id` = 1683295 OR `props-main`.`id` = 1691062 OR `props-main`.`id` = 1690978 OR `props-main`.`id` = 1673634 OR `props-main`.`id` = 1680793 OR `props-main`.`id` = 1682155 OR `props-main`.`id` = 1677252 OR `props-main`.`id` = 1691176 OR `props-main`.`id` = 1679272 OR `props-main`.`id` = 235292 OR `props-main`.`id` = 1687358 OR `props-main`.`id` = 1652560 OR `props-main`.`id` = 1689968 OR `props-main`.`id` = 971585 OR `props-main`.`id` = 1691411 OR `props-main`.`id` = 1686274 OR `props-main`.`id` = 1684648 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1646806 OR `props-main`.`id` = 1680009 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1672985 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 1683175 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1688423 OR `props-main`.`id` = 1686039 OR `props-main`.`id` = 1690319 OR `props-main`.`id` = 1680568 OR `props-main`.`id` = 1670908 OR `props-main`.`id` = 1681580 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 1688422 OR `props-main`.`id` = 1691390 OR `props-main`.`id` = 188254 OR `props-main`.`id` = 1682061 OR `props-main`.`id` = 1686412 OR `props-main`.`id` = 1684199 OR `props-main`.`id` = 1686215 OR `props-main`.`id` = 1660602 OR `props-main`.`id` = 1691254 OR `props-main`.`id` = 1690774 OR `props-main`.`id` = 1687404 OR `props-main`.`id` = 1685037 OR `props-main`.`id` = 1691264 OR `props-main`.`id` = 1691428 OR `props-main`.`id` = 1690297 OR `props-main`.`id` = 1646842 OR `props-main`.`id` = 1676630 OR `props-main`.`id` = 1646833 OR `props-main`.`id` = 1668366 OR `props-main`.`id` = 1682157 OR `props-main`.`id` = 1690514 OR `props-main`.`id` = 1690528 OR `props-main`.`id` = 1680698 OR `props-main`.`id` = 1691341 OR `props-main`.`id` = 1688506 OR `props-main`.`id` = 1688530 OR `props-main`.`id` = 1685733 OR `props-main`.`id` = 1690017 OR `props-main`.`id` = 1674613 OR `props-main`.`id` = 1688424 OR `props-main`.`id` = 1681105 OR `props-main`.`id` = 1686094 OR `props-main`.`id` = 1686256 OR `props-main`.`id` = 1686238 OR `props-main`.`id` = 269824 OR `props-main`.`id` = 742025 OR `props-main`.`id` = 1683435 OR `props-main`.`id` = 1681683 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1684711 OR `props-main`.`id` = 1687048 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1675084 OR `props-main`.`id` = 1678766 OR `props-main`.`id` = 1676181 OR `props-main`.`id` = 1680452 OR `props-main`.`id` = 1686220 OR `props-main`.`id` = 1677154)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno587052' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-26' 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();