Courtesy of Judy Koontz, Century 21 Select Real Estate - [email protected]
Own a piece of magic in the foothills! Situated on approximately 8 acres, this one-of-a-kind custom tri-level home offers 3 bedrooms and 2 bathrooms in a beautiful, peaceful setting.Step inside to a dramatic, light-filled entry featuring marble flooring and a unique indoor pond surrounded by natural rock. Double doors open to the spacious living room with a vaulted wood-beamed ceiling, impressive floor-to-ceiling rock wall with a wood-burning fireplace insert, and abundant windows that fill the room with natural light.The kitchen features granite countertops, generous counter space, a solid-surface cooktop, double oven and newer dishwasher, with large windows overlooking the beautiful outdoor setting. The tri-level floor plan includes an isolated downstairs bedroom with a private entrance and its own adjoining living areaideal for a teenager, guests, extended family or a comfortable home office suite.Outside is where this property truly shines. A paved driveway extends from the street to the residence, offering convenient year-round access and a welcoming approach to the home. Enjoy the pool with waterfall, relax or entertain on the expansive outdoor deck while taking in beautiful sunset views, and watch deer wander through the property. With approximately 8 acres and two producing wells, there is plenty of room to experience the privacy and natural beauty of the foothill setting.Recent improvements include a brand-new HVAC system and new electrical panel. The home also features a 50-year composition roof, approximately 15 years old.A rare opportunity to own a private foothill retreat offering acreage, character and exceptional outdoor living.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1971
Region
Foothill
# of Stories
Multi/Split
Price Per Square Foot
$321
Price Per Acre
$91,429
Days On London
0
Cumulative Days On London
0
County
Fresno
Reports Available
Septic, Well, NHD
Leased Equipment
Propane
Special Features
Isolated Bedroom, Isolated Bathroom
REO / Bank Owned
No
Cross Street Address
Tollhouse/Highway 168
Directions
Take Hwy 168 North, turn right unto Tollhouse Road. Gate to property is on the right.
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Both
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Eating Area, Breakfast Bar, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 608000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 672000 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) >= 1745 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2245 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` = 1773336 OR `props-main`.`id` = 1777312 OR `props-main`.`id` = 1777958 OR `props-main`.`id` = 1774442 OR `props-main`.`id` = 1704706 OR `props-main`.`id` = 1704721)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno655404' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-17' 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
Last modified 1 hour 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.
