A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 679250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 750750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2350 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2850 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` = 1713843 OR `props-main`.`id` = 1713678 OR `props-main`.`id` = 1719552 OR `props-main`.`id` = 1719544 OR `props-main`.`id` = 1713615 OR `props-main`.`id` = 1709281 OR `props-main`.`id` = 1709283 OR `props-main`.`id` = 1718821 OR `props-main`.`id` = 1718792 OR `props-main`.`id` = 1718188 OR `props-main`.`id` = 1718208 OR `props-main`.`id` = 1718322 OR `props-main`.`id` = 1718357 OR `props-main`.`id` = 1716664 OR `props-main`.`id` = 1716342 OR `props-main`.`id` = 1689913 OR `props-main`.`id` = 1719081 OR `props-main`.`id` = 1719036 OR `props-main`.`id` = 1611781 OR `props-main`.`id` = 1611780 OR `props-main`.`id` = 1716115 OR `props-main`.`id` = 1716195 OR `props-main`.`id` = 1686974 OR `props-main`.`id` = 1686922 OR `props-main`.`id` = 1699201 OR `props-main`.`id` = 1699153 OR `props-main`.`id` = 1712491 OR `props-main`.`id` = 1705902 OR `props-main`.`id` = 1705887 OR `props-main`.`id` = 1694918 OR `props-main`.`id` = 1711262 OR `props-main`.`id` = 1711319)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno516911' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-04' 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();
0
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 9,400 active listings.
Courtesy of Leanne Shaw, Coldwell Banker Premier R. E. Last modified 6 years, 10 months ago Fresno MLS last checked for updates 2 minutes ago
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
