A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 831250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 918750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2807 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3307 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` = 1613712 OR `props-main`.`id` = 1633459 OR `props-main`.`id` = 1643779 OR `props-main`.`id` = 1613708 OR `props-main`.`id` = 1629374 OR `props-main`.`id` = 1638439 OR `props-main`.`id` = 1641665 OR `props-main`.`id` = 1638440 OR `props-main`.`id` = 1638442 OR `props-main`.`id` = 1632484 OR `props-main`.`id` = 1647044 OR `props-main`.`id` = 1649990 OR `props-main`.`id` = 37604 OR `props-main`.`id` = 1643889 OR `props-main`.`id` = 1628282 OR `props-main`.`id` = 1651769 OR `props-main`.`id` = 1631889 OR `props-main`.`id` = 1643713 OR `props-main`.`id` = 1649985 OR `props-main`.`id` = 1645702 OR `props-main`.`id` = 1632344 OR `props-main`.`id` = 1632328 OR `props-main`.`id` = 1645413 OR `props-main`.`id` = 1626173 OR `props-main`.`id` = 1642900 OR `props-main`.`id` = 1634517 OR `props-main`.`id` = 1649885 OR `props-main`.`id` = 1648655 OR `props-main`.`id` = 1648645 OR `props-main`.`id` = 1650244 OR `props-main`.`id` = 1642532 OR `props-main`.`id` = 1607302 OR `props-main`.`id` = 1642780 OR `props-main`.`id` = 1613651 OR `props-main`.`id` = 1647458 OR `props-main`.`id` = 1650589 OR `props-main`.`id` = 1644670 OR `props-main`.`id` = 1650352 OR `props-main`.`id` = 1652840 OR `props-main`.`id` = 1652814 OR `props-main`.`id` = 1651480 OR `props-main`.`id` = 1651698 OR `props-main`.`id` = 1651068 OR `props-main`.`id` = 1652945 OR `props-main`.`id` = 1651775 OR `props-main`.`id` = 1617128 OR `props-main`.`id` = 1617202 OR `props-main`.`id` = 1638017 OR `props-main`.`id` = 1650160 OR `props-main`.`id` = 1647256 OR `props-main`.`id` = 1647175 OR `props-main`.`id` = 364614 OR `props-main`.`id` = 1649909 OR `props-main`.`id` = 1649908 OR `props-main`.`id` = 1650143 OR `props-main`.`id` = 1625547 OR `props-main`.`id` = 1650739 OR `props-main`.`id` = 1651870 OR `props-main`.`id` = 1636711 OR `props-main`.`id` = 1641318 OR `props-main`.`id` = 1650313 OR `props-main`.`id` = 1651845 OR `props-main`.`id` = 1265238 OR `props-main`.`id` = 1633422 OR `props-main`.`id` = 1643844 OR `props-main`.`id` = 1650944 OR `props-main`.`id` = 1637922 OR `props-main`.`id` = 1650372 OR `props-main`.`id` = 1644653 OR `props-main`.`id` = 1651284 OR `props-main`.`id` = 1642641 OR `props-main`.`id` = 228969 OR `props-main`.`id` = 1607174 OR `props-main`.`id` = 1627519 OR `props-main`.`id` = 1646128 OR `props-main`.`id` = 1652472 OR `props-main`.`id` = 1643707 OR `props-main`.`id` = 1638688 OR `props-main`.`id` = 325803 OR `props-main`.`id` = 1649232 OR `props-main`.`id` = 1635613 OR `props-main`.`id` = 1611457 OR `props-main`.`id` = 1611456 OR `props-main`.`id` = 1649224 OR `props-main`.`id` = 187711 OR `props-main`.`id` = 1637704 OR `props-main`.`id` = 1642989 OR `props-main`.`id` = 1637468 OR `props-main`.`id` = 1639123 OR `props-main`.`id` = 1650690 OR `props-main`.`id` = 195780 OR `props-main`.`id` = 1649925 OR `props-main`.`id` = 1650193 OR `props-main`.`id` = 1652807 OR `props-main`.`id` = 698805 OR `props-main`.`id` = 1628966 OR `props-main`.`id` = 1595562 OR `props-main`.`id` = 1636497 OR `props-main`.`id` = 1636493 OR `props-main`.`id` = 231417 OR `props-main`.`id` = 258175 OR `props-main`.`id` = 1649153 OR `props-main`.`id` = 1648806 OR `props-main`.`id` = 1652881 OR `props-main`.`id` = 244747 OR `props-main`.`id` = 37607 OR `props-main`.`id` = 1627159 OR `props-main`.`id` = 1637840 OR `props-main`.`id` = 1645723 OR `props-main`.`id` = 1645719 OR `props-main`.`id` = 1639113 OR `props-main`.`id` = 1651131 OR `props-main`.`id` = 1651321 OR `props-main`.`id` = 1645724 OR `props-main`.`id` = 1651811 OR `props-main`.`id` = 311276 OR `props-main`.`id` = 1647243 OR `props-main`.`id` = 256897 OR `props-main`.`id` = 211531 OR `props-main`.`id` = 1650844 OR `props-main`.`id` = 1638107 OR `props-main`.`id` = 1645987 OR `props-main`.`id` = 1652709 OR `props-main`.`id` = 1649609)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno618709' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-04-17' 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();

CAME_FROM_PROP_SITE: Y