Calling all outdoor enthusiasts! If you've been dreaming of a location off the beaten path where you can relax on your creek-front property & welcome the sights & sounds of nature, look no further! Being one with nature doesn't mean you have to sacrifice your home comforts, this home has been updated to include a new metal roof, split-unit AC and heat, ducted evaporative cooling for energy efficiency, modern vinyl plank flooring w/carpeted stairs, Wi-Fi controlled switches, new windows, updated appliances, resurfaced cabinets, repainted inside & out, & remodeled bathrooms! Upstairs includes a large bonus room with balcony overlooking the foothills. Outside includes a large covered patio front & back, a storage shed and workshop w/concrete floor & hardy board siding. Take a hike down the graded path to the creek that runs 8-9 months of the year! Approximately 2 acres around the home has been fenced for pets. This unique property is not one to quickly tour; bring your hiking boots & explore the beautiful rolling hills with abundant shade trees and areas to roam. The area is close to forest service roads that connect to many local mountain areas, and close to Pine Flat Lake.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1979
Region
Foothill
# of Stories
Two
Price Per Square Foot
$221
Price Per Acre
$17,495
Days On Market
4
Cumulative Days On Market
4
County
Fresno
Leased Equipment
Propane
Special Features
Horses Allowed
REO / Bank Owned
No
Cross Street Address
Sycamore and Watts Valley
Directions
From Tollhouse Rd, take Burrough Valley Rd approx 4 mi, left on Sycamore.Follow down the hill, as as it curves stay left, Go past Holkoma a bit, you'll come to a dirt rd on Right w/stone pillars. Follow rd across creek then stay left to address on left
Special Disclosure
See Remrks/Attchmnts
Heating & Cooling
Ductless or Split, Evaporative Cool
Laundry
On Porch, Electric Hook Up
Roofing
Metal
Foundation
Both
Detached Structures
Shop, Shed
Kitchen
F/S Range/Oven, Gas Appliances, Electric Appliances, Dishwasher, Breakfast Bar
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1334 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1834 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` = 1686037 OR `props-main`.`id` = 1690763)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno638838' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-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
Courtesy of Jeri Kuddes, Realty Concepts - Prather - [email protected] Last modified 4 days ago Fresno MLS last checked for updates 16 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.
