A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 523950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2174 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2674 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` = 1758798 OR `props-main`.`id` = 1758771 OR `props-main`.`id` = 1758774 OR `props-main`.`id` = 1726956 OR `props-main`.`id` = 1726992 OR `props-main`.`id` = 1714977 OR `props-main`.`id` = 1714941 OR `props-main`.`id` = 1714947 OR `props-main`.`id` = 1732049 OR `props-main`.`id` = 1732059 OR `props-main`.`id` = 1734255 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1757466 OR `props-main`.`id` = 1757638 OR `props-main`.`id` = 1705655 OR `props-main`.`id` = 1705641 OR `props-main`.`id` = 1750503 OR `props-main`.`id` = 1726383 OR `props-main`.`id` = 1727711 OR `props-main`.`id` = 1739016 OR `props-main`.`id` = 1726898 OR `props-main`.`id` = 1742752 OR `props-main`.`id` = 1733239 OR `props-main`.`id` = 1727460 OR `props-main`.`id` = 1764278 OR `props-main`.`id` = 1746003 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1662063 OR `props-main`.`id` = 1757356 OR `props-main`.`id` = 1738257 OR `props-main`.`id` = 1761773 OR `props-main`.`id` = 1761598 OR `props-main`.`id` = 1721284 OR `props-main`.`id` = 1721067 OR `props-main`.`id` = 1721227 OR `props-main`.`id` = 1721804 OR `props-main`.`id` = 1723288 OR `props-main`.`id` = 1701327 OR `props-main`.`id` = 1757375 OR `props-main`.`id` = 1735557 OR `props-main`.`id` = 1744848 OR `props-main`.`id` = 1745707 OR `props-main`.`id` = 1654611 OR `props-main`.`id` = 1666277 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1757336 OR `props-main`.`id` = 1750370 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1725465 OR `props-main`.`id` = 1762847 OR `props-main`.`id` = 1761007 OR `props-main`.`id` = 1760989 OR `props-main`.`id` = 1760994 OR `props-main`.`id` = 1753563 OR `props-main`.`id` = 1753527 OR `props-main`.`id` = 1753578 OR `props-main`.`id` = 1726796 OR `props-main`.`id` = 1726800 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1749419 OR `props-main`.`id` = 1752488 OR `props-main`.`id` = 1721549 OR `props-main`.`id` = 1754701 OR `props-main`.`id` = 1754711 OR `props-main`.`id` = 1746499 OR `props-main`.`id` = 1715744 OR `props-main`.`id` = 1727222 OR `props-main`.`id` = 1727207 OR `props-main`.`id` = 1740701 OR `props-main`.`id` = 1752267 OR `props-main`.`id` = 893173 OR `props-main`.`id` = 1732730 OR `props-main`.`id` = 1732657 OR `props-main`.`id` = 1732699 OR `props-main`.`id` = 1727062 OR `props-main`.`id` = 1727191 OR `props-main`.`id` = 1727545 OR `props-main`.`id` = 1761390 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1744915 OR `props-main`.`id` = 1726733 OR `props-main`.`id` = 1726793 OR `props-main`.`id` = 1741745 OR `props-main`.`id` = 1741698 OR `props-main`.`id` = 1726734 OR `props-main`.`id` = 1726794 OR `props-main`.`id` = 1727729)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652500' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-26' 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,900 active listings.
Last modified 1 month ago Fresno MLS last checked for updates 40 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.
