A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 774250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 855750 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) >= 2640 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3140 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` = 1729050 OR `props-main`.`id` = 1729971 OR `props-main`.`id` = 1722416 OR `props-main`.`id` = 1729053 OR `props-main`.`id` = 1721248 OR `props-main`.`id` = 1726222 OR `props-main`.`id` = 1719764 OR `props-main`.`id` = 1723199 OR `props-main`.`id` = 1663479 OR `props-main`.`id` = 1728305 OR `props-main`.`id` = 1705042 OR `props-main`.`id` = 1728133 OR `props-main`.`id` = 1727518 OR `props-main`.`id` = 1722326 OR `props-main`.`id` = 1717845 OR `props-main`.`id` = 1726975 OR `props-main`.`id` = 1719858 OR `props-main`.`id` = 1719844 OR `props-main`.`id` = 1727197 OR `props-main`.`id` = 1716623 OR `props-main`.`id` = 1724599 OR `props-main`.`id` = 1727537 OR `props-main`.`id` = 1729239 OR `props-main`.`id` = 1727205 OR `props-main`.`id` = 1725830 OR `props-main`.`id` = 1727377 OR `props-main`.`id` = 1665791 OR `props-main`.`id` = 1725311 OR `props-main`.`id` = 1726760 OR `props-main`.`id` = 1725241 OR `props-main`.`id` = 1725428 OR `props-main`.`id` = 1711157 OR `props-main`.`id` = 1710246 OR `props-main`.`id` = 226899 OR `props-main`.`id` = 1692341 OR `props-main`.`id` = 1696764 OR `props-main`.`id` = 1709977 OR `props-main`.`id` = 1718685 OR `props-main`.`id` = 1704905 OR `props-main`.`id` = 1716527 OR `props-main`.`id` = 1726712 OR `props-main`.`id` = 1716040 OR `props-main`.`id` = 1716597 OR `props-main`.`id` = 1728760 OR `props-main`.`id` = 1720782 OR `props-main`.`id` = 1721908 OR `props-main`.`id` = 1729355 OR `props-main`.`id` = 1721094 OR `props-main`.`id` = 1709160 OR `props-main`.`id` = 1717513 OR `props-main`.`id` = 1721461 OR `props-main`.`id` = 1696533 OR `props-main`.`id` = 1703290 OR `props-main`.`id` = 717214 OR `props-main`.`id` = 1729076 OR `props-main`.`id` = 1728087 OR `props-main`.`id` = 1719631 OR `props-main`.`id` = 1724826 OR `props-main`.`id` = 1723071 OR `props-main`.`id` = 37606 OR `props-main`.`id` = 1727495 OR `props-main`.`id` = 1716328 OR `props-main`.`id` = 1716322 OR `props-main`.`id` = 1708118 OR `props-main`.`id` = 1708401 OR `props-main`.`id` = 1722581 OR `props-main`.`id` = 1712610 OR `props-main`.`id` = 1718084 OR `props-main`.`id` = 1729463 OR `props-main`.`id` = 1727927 OR `props-main`.`id` = 1725243 OR `props-main`.`id` = 1725918 OR `props-main`.`id` = 1725154 OR `props-main`.`id` = 1726233 OR `props-main`.`id` = 1716970 OR `props-main`.`id` = 1712630 OR `props-main`.`id` = 1725468 OR `props-main`.`id` = 1724983 OR `props-main`.`id` = 1713550 OR `props-main`.`id` = 1713509 OR `props-main`.`id` = 981418 OR `props-main`.`id` = 1728665 OR `props-main`.`id` = 1726419 OR `props-main`.`id` = 1726361 OR `props-main`.`id` = 1725988 OR `props-main`.`id` = 1721518 OR `props-main`.`id` = 1721479 OR `props-main`.`id` = 1725855 OR `props-main`.`id` = 1728082 OR `props-main`.`id` = 1701497 OR `props-main`.`id` = 1716624 OR `props-main`.`id` = 102873 OR `props-main`.`id` = 1725917 OR `props-main`.`id` = 1727126 OR `props-main`.`id` = 1574826 OR `props-main`.`id` = 1721809 OR `props-main`.`id` = 1727515 OR `props-main`.`id` = 1727157 OR `props-main`.`id` = 1725084 OR `props-main`.`id` = 1728792 OR `props-main`.`id` = 1728914 OR `props-main`.`id` = 1729855 OR `props-main`.`id` = 1728518 OR `props-main`.`id` = 1718542 OR `props-main`.`id` = 1703326 OR `props-main`.`id` = 1725339 OR `props-main`.`id` = 1725511 OR `props-main`.`id` = 1725026 OR `props-main`.`id` = 1722336 OR `props-main`.`id` = 1724585 OR `props-main`.`id` = 1724607 OR `props-main`.`id` = 1726492 OR `props-main`.`id` = 1718942 OR `props-main`.`id` = 1710113 OR `props-main`.`id` = 1713557 OR `props-main`.`id` = 1709194 OR `props-main`.`id` = 1705384 OR `props-main`.`id` = 1723770 OR `props-main`.`id` = 1725542 OR `props-main`.`id` = 1723985 OR `props-main`.`id` = 1720848 OR `props-main`.`id` = 1697315 OR `props-main`.`id` = 1714984 OR `props-main`.`id` = 1706740 OR `props-main`.`id` = 1710041 OR `props-main`.`id` = 1718282 OR `props-main`.`id` = 1697250 OR `props-main`.`id` = 1719703 OR `props-main`.`id` = 1718648 OR `props-main`.`id` = 1694725 OR `props-main`.`id` = 1717962 OR `props-main`.`id` = 1724531 OR `props-main`.`id` = 227897)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644978' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-30' 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: