Lee Ann Kreps559.664.7100leeannk@londonproperties.comEmail Agent
Property Description
Country Living at its Best. The absence of city noise and hustle provides a tranquil environment for relaxation and contemplation yet still less than 10 minutes from Fresno Just off Hwy 41 and across from the Beautiful Tesoro Viejo community. This 2200 sqft home sits on one acre parcel and it has it all! 2000 sq. ft. Shop, Pool, Automatic security Gate, Extensive Security System, All new Windows and Blinds, New Flooring. Newly remodeled Kitchen with Stainless Steel Appliances, 3 Bedrooms, 2 Bathrooms and a Large 4th Room for Home Gym or Office/Guest Room. 2 car attached garage. Host Special Events and Weddings on this Spacious Property with plenty of Guest and RV Parking.This One-Of-Kind Unique Property will not last long so Secure your Purchase TODAY!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1979
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$349
Price Per Acre
$723,585
Days On Market
8
Cumulative Days On Market
122
County
Madera
REO / Bank Owned
No
Cross Street Address
Highway 41/Ave 15
Directions
From Fresno, 41 N to 14 1/2, turn left and them immediately left on Huntington Rd. (Across de freeway from Tesoro Viejo)
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 728650 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 805350 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) >= 1950 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2450 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` = 1674994 OR `props-main`.`id` = 1675121 OR `props-main`.`id` = 1636330 OR `props-main`.`id` = 1681947 OR `props-main`.`id` = 1683083 OR `props-main`.`id` = 1677618 OR `props-main`.`id` = 1687063 OR `props-main`.`id` = 1678785 OR `props-main`.`id` = 1683821 OR `props-main`.`id` = 1686409 OR `props-main`.`id` = 1656927 OR `props-main`.`id` = 1679968 OR `props-main`.`id` = 1679969 OR `props-main`.`id` = 1674422 OR `props-main`.`id` = 1684859 OR `props-main`.`id` = 1683571 OR `props-main`.`id` = 1682002 OR `props-main`.`id` = 1682059 OR `props-main`.`id` = 1683325 OR `props-main`.`id` = 1646318 OR `props-main`.`id` = 1684863 OR `props-main`.`id` = 1671621 OR `props-main`.`id` = 1663724 OR `props-main`.`id` = 1683442 OR `props-main`.`id` = 1660730 OR `props-main`.`id` = 1685313 OR `props-main`.`id` = 1674966 OR `props-main`.`id` = 1678853 OR `props-main`.`id` = 1676596 OR `props-main`.`id` = 1676604 OR `props-main`.`id` = 1681578 OR `props-main`.`id` = 1683597 OR `props-main`.`id` = 1679056 OR `props-main`.`id` = 1681832 OR `props-main`.`id` = 1681834 OR `props-main`.`id` = 1657513 OR `props-main`.`id` = 1674185 OR `props-main`.`id` = 1651473 OR `props-main`.`id` = 1687049 OR `props-main`.`id` = 1662382)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637403' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-27' 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
Courtesy of Isa Tenchio, Rio Mesa Realty - isatenchio@aol.com Last modified 2 days ago Fresno MLS last checked for updates 1 hour 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.
