Lee Ann Kreps559.664.7100leeannk@londonproperties.comEmail Agent
72875
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 389405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 430395 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) >= 1188 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1688 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` = 1716250 OR `props-main`.`id` = 1718400 OR `props-main`.`id` = 1717183 OR `props-main`.`id` = 1717852 OR `props-main`.`id` = 1717847 OR `props-main`.`id` = 1716783 OR `props-main`.`id` = 1716798 OR `props-main`.`id` = 1717094 OR `props-main`.`id` = 1716792 OR `props-main`.`id` = 1716269 OR `props-main`.`id` = 1687560 OR `props-main`.`id` = 1687561 OR `props-main`.`id` = 1687562 OR `props-main`.`id` = 1687563 OR `props-main`.`id` = 1719892 OR `props-main`.`id` = 1597954 OR `props-main`.`id` = 1665839 OR `props-main`.`id` = 1687559 OR `props-main`.`id` = 1597958 OR `props-main`.`id` = 1665840 OR `props-main`.`id` = 1719893 OR `props-main`.`id` = 1719894 OR `props-main`.`id` = 1719895 OR `props-main`.`id` = 1719896 OR `props-main`.`id` = 1597960 OR `props-main`.`id` = 1665841 OR `props-main`.`id` = 1597961 OR `props-main`.`id` = 1665842 OR `props-main`.`id` = 1597951 OR `props-main`.`id` = 1665843 OR `props-main`.`id` = 1716595 OR `props-main`.`id` = 1704827 OR `props-main`.`id` = 1713814 OR `props-main`.`id` = 1704840 OR `props-main`.`id` = 1708204 OR `props-main`.`id` = 1708223 OR `props-main`.`id` = 1666319 OR `props-main`.`id` = 1701326 OR `props-main`.`id` = 1687628 OR `props-main`.`id` = 1717402 OR `props-main`.`id` = 1698081 OR `props-main`.`id` = 1698085)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno616737' 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 Robert Ramirez, Fathom Realty Group, Inc. Last modified 1 year, 5 months ago Fresno MLS last checked for updates 5 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.
