A:SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 403750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 446250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1690 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2190 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` = 1587893 OR `props-main`.`id` = 1587970 OR `props-main`.`id` = 1584467 OR `props-main`.`id` = 1576985 OR `props-main`.`id` = 1576949 OR `props-main`.`id` = 1576906 OR `props-main`.`id` = 1576954 OR `props-main`.`id` = 1590286 OR `props-main`.`id` = 1590519 OR `props-main`.`id` = 1587747 OR `props-main`.`id` = 1580909 OR `props-main`.`id` = 1586507 OR `props-main`.`id` = 1586721 OR `props-main`.`id` = 1586705 OR `props-main`.`id` = 1590469 OR `props-main`.`id` = 1587808 OR `props-main`.`id` = 1581689 OR `props-main`.`id` = 1583759 OR `props-main`.`id` = 1587547 OR `props-main`.`id` = 1585687 OR `props-main`.`id` = 1584858 OR `props-main`.`id` = 1583577 OR `props-main`.`id` = 1588227 OR `props-main`.`id` = 1589031 OR `props-main`.`id` = 1589830 OR `props-main`.`id` = 1584162 OR `props-main`.`id` = 1583266 OR `props-main`.`id` = 1583234 OR `props-main`.`id` = 1583236 OR `props-main`.`id` = 1583228 OR `props-main`.`id` = 1587704 OR `props-main`.`id` = 1584281 OR `props-main`.`id` = 1579658 OR `props-main`.`id` = 1589081 OR `props-main`.`id` = 1577902 OR `props-main`.`id` = 1588700 OR `props-main`.`id` = 1581998 OR `props-main`.`id` = 1585235 OR `props-main`.`id` = 1578518 OR `props-main`.`id` = 1576027 OR `props-main`.`id` = 1588424 OR `props-main`.`id` = 1585767 OR `props-main`.`id` = 1583599 OR `props-main`.`id` = 1587302 OR `props-main`.`id` = 1588532 OR `props-main`.`id` = 1588939 OR `props-main`.`id` = 1589193 OR `props-main`.`id` = 1590073 OR `props-main`.`id` = 1585728 OR `props-main`.`id` = 1583387 OR `props-main`.`id` = 1589460 OR `props-main`.`id` = 1578897 OR `props-main`.`id` = 1589661 OR `props-main`.`id` = 1583738 OR `props-main`.`id` = 1589778 OR `props-main`.`id` = 1589761 OR `props-main`.`id` = 1579159 OR `props-main`.`id` = 1579332 OR `props-main`.`id` = 1567302 OR `props-main`.`id` = 1582487 OR `props-main`.`id` = 1583299 OR `props-main`.`id` = 1583278 OR `props-main`.`id` = 1580079 OR `props-main`.`id` = 1580139 OR `props-main`.`id` = 1572646 OR `props-main`.`id` = 1573620 OR `props-main`.`id` = 1588133 OR `props-main`.`id` = 1578959 OR `props-main`.`id` = 1590093 OR `props-main`.`id` = 1550394 OR `props-main`.`id` = 1588717 OR `props-main`.`id` = 1590109 OR `props-main`.`id` = 1569528 OR `props-main`.`id` = 1581196 OR `props-main`.`id` = 1571435 OR `props-main`.`id` = 1580670 OR `props-main`.`id` = 1590423 OR `props-main`.`id` = 1590426 OR `props-main`.`id` = 1590388 OR `props-main`.`id` = 161024 OR `props-main`.`id` = 1570159 OR `props-main`.`id` = 1572663 OR `props-main`.`id` = 1582131 OR `props-main`.`id` = 1586625 OR `props-main`.`id` = 1586414 OR `props-main`.`id` = 1574127 OR `props-main`.`id` = 1587766 OR `props-main`.`id` = 1587652 OR `props-main`.`id` = 1582513 OR `props-main`.`id` = 1590161 OR `props-main`.`id` = 1589482 OR `props-main`.`id` = 1586127 OR `props-main`.`id` = 1574733 OR `props-main`.`id` = 1567351 OR `props-main`.`id` = 1561229 OR `props-main`.`id` = 102280 OR `props-main`.`id` = 1588103 OR `props-main`.`id` = 1587949 OR `props-main`.`id` = 1583383 OR `props-main`.`id` = 1589086 OR `props-main`.`id` = 1581241 OR `props-main`.`id` = 1578004 OR `props-main`.`id` = 1582493 OR `props-main`.`id` = 1588326 OR `props-main`.`id` = 1586865 OR `props-main`.`id` = 1590522 OR `props-main`.`id` = 1577803 OR `props-main`.`id` = 1579839 OR `props-main`.`id` = 1584299 OR `props-main`.`id` = 1584042 OR `props-main`.`id` = 1589807 OR `props-main`.`id` = 1586977 OR `props-main`.`id` = 1579746 OR `props-main`.`id` = 1587167 OR `props-main`.`id` = 1583442 OR `props-main`.`id` = 1585966 OR `props-main`.`id` = 1589484 OR `props-main`.`id` = 1576349 OR `props-main`.`id` = 305398 OR `props-main`.`id` = 233922)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno611316' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2024-05-09' 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: