A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 926155 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1023645 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) >= 2820 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3320 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` = 1732372 OR `props-main`.`id` = 1732362 OR `props-main`.`id` = 1722250 OR `props-main`.`id` = 1731616 OR `props-main`.`id` = 1713843 OR `props-main`.`id` = 1713678 OR `props-main`.`id` = 1731501 OR `props-main`.`id` = 1719552 OR `props-main`.`id` = 1719544 OR `props-main`.`id` = 1709281 OR `props-main`.`id` = 1709283 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` = 1725507 OR `props-main`.`id` = 1721209 OR `props-main`.`id` = 1721232 OR `props-main`.`id` = 1611781 OR `props-main`.`id` = 1611780 OR `props-main`.`id` = 1716115 OR `props-main`.`id` = 1716195 OR `props-main`.`id` = 1731521 OR `props-main`.`id` = 1731369 OR `props-main`.`id` = 1686974 OR `props-main`.`id` = 1686922 OR `props-main`.`id` = 1727996 OR `props-main`.`id` = 1731952 OR `props-main`.`id` = 1731636 OR `props-main`.`id` = 1723576 OR `props-main`.`id` = 1699201 OR `props-main`.`id` = 1699153 OR `props-main`.`id` = 1705902 OR `props-main`.`id` = 1705887 OR `props-main`.`id` = 1731459 OR `props-main`.`id` = 1726581 OR `props-main`.`id` = 1722180 OR `props-main`.`id` = 1726566 OR `props-main`.`id` = 1731611 OR `props-main`.`id` = 1723664 OR `props-main`.`id` = 1731635 OR `props-main`.`id` = 1723658 OR `props-main`.`id` = 1722176 OR `props-main`.`id` = 1715530 OR `props-main`.`id` = 1731510)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646906' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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();
0
CAME_FROM_PROP_SITE:
We're sorry, this listing is no longer available. Please click here to search from over 10,600 active listings.
Last modified 1 month ago Fresno MLS last checked for updates 31 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.
