A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 674405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 745395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3193 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3693 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` = 1640607 OR `props-main`.`id` = 1647223 OR `props-main`.`id` = 1637625 OR `props-main`.`id` = 1649310 OR `props-main`.`id` = 1646961 OR `props-main`.`id` = 1646963 OR `props-main`.`id` = 1649737 OR `props-main`.`id` = 1649070 OR `props-main`.`id` = 1647298 OR `props-main`.`id` = 1650460 OR `props-main`.`id` = 1651389 OR `props-main`.`id` = 1651475 OR `props-main`.`id` = 1651509 OR `props-main`.`id` = 1647192 OR `props-main`.`id` = 1652568 OR `props-main`.`id` = 1646560 OR `props-main`.`id` = 1645562 OR `props-main`.`id` = 1647428 OR `props-main`.`id` = 1638467 OR `props-main`.`id` = 1637830 OR `props-main`.`id` = 1647026 OR `props-main`.`id` = 1634600 OR `props-main`.`id` = 1647152 OR `props-main`.`id` = 1630506 OR `props-main`.`id` = 1649691 OR `props-main`.`id` = 1634598 OR `props-main`.`id` = 1634599 OR `props-main`.`id` = 1649313 OR `props-main`.`id` = 1649716 OR `props-main`.`id` = 1620913 OR `props-main`.`id` = 1649610 OR `props-main`.`id` = 1649694 OR `props-main`.`id` = 1651008 OR `props-main`.`id` = 235509 OR `props-main`.`id` = 1648970 OR `props-main`.`id` = 1652830 OR `props-main`.`id` = 1646542 OR `props-main`.`id` = 1651327 OR `props-main`.`id` = 1652721 OR `props-main`.`id` = 70513 OR `props-main`.`id` = 1640827 OR `props-main`.`id` = 1642903 OR `props-main`.`id` = 1649191 OR `props-main`.`id` = 1649192 OR `props-main`.`id` = 1650535 OR `props-main`.`id` = 1651599 OR `props-main`.`id` = 1622228 OR `props-main`.`id` = 1651824 OR `props-main`.`id` = 1633760 OR `props-main`.`id` = 1637408 OR `props-main`.`id` = 1635761 OR `props-main`.`id` = 1635624 OR `props-main`.`id` = 1650273 OR `props-main`.`id` = 1636821 OR `props-main`.`id` = 1632386 OR `props-main`.`id` = 1652477 OR `props-main`.`id` = 1641385 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1634459 OR `props-main`.`id` = 1644833 OR `props-main`.`id` = 1642779 OR `props-main`.`id` = 1642795 OR `props-main`.`id` = 1642782 OR `props-main`.`id` = 1644617 OR `props-main`.`id` = 1638085 OR `props-main`.`id` = 1638082 OR `props-main`.`id` = 1638084 OR `props-main`.`id` = 1652941 OR `props-main`.`id` = 1652971 OR `props-main`.`id` = 1652986 OR `props-main`.`id` = 1646759 OR `props-main`.`id` = 1649763 OR `props-main`.`id` = 1631201 OR `props-main`.`id` = 1650049 OR `props-main`.`id` = 1647176 OR `props-main`.`id` = 1651417 OR `props-main`.`id` = 1632394 OR `props-main`.`id` = 1632372 OR `props-main`.`id` = 1647087 OR `props-main`.`id` = 1650907 OR `props-main`.`id` = 1649288 OR `props-main`.`id` = 1651435 OR `props-main`.`id` = 1641602 OR `props-main`.`id` = 1642640 OR `props-main`.`id` = 1649546 OR `props-main`.`id` = 1650654 OR `props-main`.`id` = 1653104 OR `props-main`.`id` = 1651128 OR `props-main`.`id` = 1650937 OR `props-main`.`id` = 1650876 OR `props-main`.`id` = 1646360 OR `props-main`.`id` = 1652507 OR `props-main`.`id` = 1639163 OR `props-main`.`id` = 1628901 OR `props-main`.`id` = 1642631 OR `props-main`.`id` = 1649774 OR `props-main`.`id` = 1653122 OR `props-main`.`id` = 1653129 OR `props-main`.`id` = 1648636 OR `props-main`.`id` = 1651820 OR `props-main`.`id` = 1651453 OR `props-main`.`id` = 1651464 OR `props-main`.`id` = 1651470 OR `props-main`.`id` = 1594663 OR `props-main`.`id` = 1652927 OR `props-main`.`id` = 1651807 OR `props-main`.`id` = 1645407 OR `props-main`.`id` = 1648659 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1650027 OR `props-main`.`id` = 1650068 OR `props-main`.`id` = 1642491 OR `props-main`.`id` = 1634338 OR `props-main`.`id` = 167463 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1649080 OR `props-main`.`id` = 1640942 OR `props-main`.`id` = 1648668 OR `props-main`.`id` = 1650316 OR `props-main`.`id` = 1636384 OR `props-main`.`id` = 1651641 OR `props-main`.`id` = 1649051 OR `props-main`.`id` = 1651716 OR `props-main`.`id` = 1635722 OR `props-main`.`id` = 1649036 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1651257 OR `props-main`.`id` = 1651018 OR `props-main`.`id` = 1646230)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno615712' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-04-18' 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();