A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 360050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 397950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1150 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1650 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` = 1674206 OR `props-main`.`id` = 1687543 OR `props-main`.`id` = 1665743 OR `props-main`.`id` = 1666389 OR `props-main`.`id` = 1663325 OR `props-main`.`id` = 1689502 OR `props-main`.`id` = 1672992 OR `props-main`.`id` = 1655692 OR `props-main`.`id` = 1655717 OR `props-main`.`id` = 1679751 OR `props-main`.`id` = 1683463 OR `props-main`.`id` = 1683460 OR `props-main`.`id` = 1689940 OR `props-main`.`id` = 1687552 OR `props-main`.`id` = 1689922 OR `props-main`.`id` = 1686999 OR `props-main`.`id` = 1673053 OR `props-main`.`id` = 1672968 OR `props-main`.`id` = 1606109 OR `props-main`.`id` = 1690434 OR `props-main`.`id` = 1690419 OR `props-main`.`id` = 1689508 OR `props-main`.`id` = 1677652 OR `props-main`.`id` = 1679042 OR `props-main`.`id` = 1679059 OR `props-main`.`id` = 1680131 OR `props-main`.`id` = 1637977 OR `props-main`.`id` = 1656703 OR `props-main`.`id` = 1659374 OR `props-main`.`id` = 1660360 OR `props-main`.`id` = 1656496 OR `props-main`.`id` = 1659388 OR `props-main`.`id` = 1689557 OR `props-main`.`id` = 1673013 OR `props-main`.`id` = 1622921 OR `props-main`.`id` = 1686622 OR `props-main`.`id` = 1686605 OR `props-main`.`id` = 1637985 OR `props-main`.`id` = 1657135 OR `props-main`.`id` = 1655920 OR `props-main`.`id` = 1683612 OR `props-main`.`id` = 1673027 OR `props-main`.`id` = 1673033 OR `props-main`.`id` = 1688034 OR `props-main`.`id` = 1687910 OR `props-main`.`id` = 1690344 OR `props-main`.`id` = 1666538 OR `props-main`.`id` = 1675398 OR `props-main`.`id` = 1678236 OR `props-main`.`id` = 1691301 OR `props-main`.`id` = 1649510 OR `props-main`.`id` = 1662342 OR `props-main`.`id` = 1665844 OR `props-main`.`id` = 1668740 OR `props-main`.`id` = 1668916 OR `props-main`.`id` = 1667484 OR `props-main`.`id` = 1687564 OR `props-main`.`id` = 1667579 OR `props-main`.`id` = 1686784 OR `props-main`.`id` = 1686792 OR `props-main`.`id` = 1685356 OR `props-main`.`id` = 1687547 OR `props-main`.`id` = 1687534 OR `props-main`.`id` = 1666298 OR `props-main`.`id` = 1685749 OR `props-main`.`id` = 1685734 OR `props-main`.`id` = 1687579 OR `props-main`.`id` = 1665912)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno626591' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-24' 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: