A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 587100 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 648900 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2168 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2668 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` = 1703701 OR `props-main`.`id` = 1716591 OR `props-main`.`id` = 1717514 OR `props-main`.`id` = 1713975 OR `props-main`.`id` = 1717450 OR `props-main`.`id` = 1721206 OR `props-main`.`id` = 235292 OR `props-main`.`id` = 971585 OR `props-main`.`id` = 1714850 OR `props-main`.`id` = 1715737 OR `props-main`.`id` = 1718474 OR `props-main`.`id` = 1714995 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1709968 OR `props-main`.`id` = 1672985 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 1701105 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1726716 OR `props-main`.`id` = 1721163 OR `props-main`.`id` = 1722142 OR `props-main`.`id` = 1707971 OR `props-main`.`id` = 1723034 OR `props-main`.`id` = 1720272 OR `props-main`.`id` = 188254 OR `props-main`.`id` = 1722916 OR `props-main`.`id` = 1714998 OR `props-main`.`id` = 1686412 OR `props-main`.`id` = 1720963 OR `props-main`.`id` = 1725042 OR `props-main`.`id` = 1721786 OR `props-main`.`id` = 1705055 OR `props-main`.`id` = 1726655 OR `props-main`.`id` = 1721641 OR `props-main`.`id` = 1702438 OR `props-main`.`id` = 1715514 OR `props-main`.`id` = 1704516 OR `props-main`.`id` = 1725528 OR `props-main`.`id` = 1709425 OR `props-main`.`id` = 1716523 OR `props-main`.`id` = 1708199 OR `props-main`.`id` = 1712727 OR `props-main`.`id` = 1723086 OR `props-main`.`id` = 1711434 OR `props-main`.`id` = 1711436 OR `props-main`.`id` = 1723437 OR `props-main`.`id` = 1706984 OR `props-main`.`id` = 1721442 OR `props-main`.`id` = 896872 OR `props-main`.`id` = 1721191 OR `props-main`.`id` = 1718566 OR `props-main`.`id` = 1723732 OR `props-main`.`id` = 1691341 OR `props-main`.`id` = 1725111 OR `props-main`.`id` = 1707179 OR `props-main`.`id` = 1707877 OR `props-main`.`id` = 1674613 OR `props-main`.`id` = 1721854 OR `props-main`.`id` = 1717770 OR `props-main`.`id` = 1713832 OR `props-main`.`id` = 1719804 OR `props-main`.`id` = 1705398 OR `props-main`.`id` = 1719325 OR `props-main`.`id` = 1723859 OR `props-main`.`id` = 1723849 OR `props-main`.`id` = 1723714 OR `props-main`.`id` = 1723748 OR `props-main`.`id` = 1721273 OR `props-main`.`id` = 1720837 OR `props-main`.`id` = 1716789 OR `props-main`.`id` = 1725101 OR `props-main`.`id` = 1726685 OR `props-main`.`id` = 1724603 OR `props-main`.`id` = 1725587 OR `props-main`.`id` = 269824 OR `props-main`.`id` = 742025 OR `props-main`.`id` = 1724722 OR `props-main`.`id` = 1716971 OR `props-main`.`id` = 1721439 OR `props-main`.`id` = 1726170 OR `props-main`.`id` = 1707183 OR `props-main`.`id` = 1703048 OR `props-main`.`id` = 1716588 OR `props-main`.`id` = 1723516 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1702701 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1722091 OR `props-main`.`id` = 1723156 OR `props-main`.`id` = 1716850 OR `props-main`.`id` = 1713574 OR `props-main`.`id` = 1724859 OR `props-main`.`id` = 1726169 OR `props-main`.`id` = 1718547 OR `props-main`.`id` = 1722856 OR `props-main`.`id` = 1715859 OR `props-main`.`id` = 1723667 OR `props-main`.`id` = 1725864 OR `props-main`.`id` = 1718280 OR `props-main`.`id` = 1720324 OR `props-main`.`id` = 1725314 OR `props-main`.`id` = 1700078 OR `props-main`.`id` = 1719743 OR `props-main`.`id` = 1705649 OR `props-main`.`id` = 1722445 OR `props-main`.`id` = 1725495 OR `props-main`.`id` = 1718738 OR `props-main`.`id` = 1726324 OR `props-main`.`id` = 1721190 OR `props-main`.`id` = 1704380 OR `props-main`.`id` = 1721177 OR `props-main`.`id` = 1721285 OR `props-main`.`id` = 1715704 OR `props-main`.`id` = 1712605 OR `props-main`.`id` = 1721164 OR `props-main`.`id` = 1713613 OR `props-main`.`id` = 1715710 OR `props-main`.`id` = 1717339 OR `props-main`.`id` = 1726089 OR `props-main`.`id` = 1718503 OR `props-main`.`id` = 1718490 OR `props-main`.`id` = 1699973 OR `props-main`.`id` = 1719764 OR `props-main`.`id` = 1722043 OR `props-main`.`id` = 1723199 OR `props-main`.`id` = 1722192 OR `props-main`.`id` = 1705042 OR `props-main`.`id` = 1718447 OR `props-main`.`id` = 1726115 OR `props-main`.`id` = 1725123 OR `props-main`.`id` = 1722326 OR `props-main`.`id` = 1718204 OR `props-main`.`id` = 1724511 OR `props-main`.`id` = 1717443)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645990' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-14' 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();