Title Page Background
DEBUG FN args: Array ( [0] => 207 [1] => [2] => [3] => agent ) BEFORE: Site: 207 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 207 Igate: njhud LocID: 207 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 207 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 207 [1] => [2] => [3] => lender ) BEFORE: Site: 207 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 207 Igate: njhud LocID: 207 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 207 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 207 [1] => [2] => [3] => other ) BEFORE: Site: 207 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 207 Igate: njhud LocID: 207 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 207 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

43972 Wells Road
Coarsegold, CA 93614

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $895,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2866 Square Feet
Agency: Keller Williams Fresno

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other
Heating: Fireplace
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Kitchen, Living Room

Window Features

Exterior Features: Wood
Parking Features: Garage, Garage - Detached
Roof: Metal, Composition

Neighborhood/Schools

Elementary School/District: Coarsegold/Yosemite
Middle/Junior High School/District: /Yosemite
High School/District: Yosemite/Raymond Knowles
Subvidision Name:

Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Welcome to your foothill sanctuary in scenic Coarsegold, CA. This stunning 3bd/3ba home boasts 2,866sf of living space on 2.55ac of picturesque land. The main level primary suite features a private balcony, custom fireplace, and a spa-like ensuite bath with a 72'', 7-jet tub, glass shower, private commode and oversized walk-in closet. Upstairs, 2 additional bedrooms and a bathroom are connected by a hallway balcony overlooking the living area below. The kitchen showcases granite counters, custom wood cabinetry, a Dacor 5-burner gas range in a large center island with counter seating, a built-in desk, and a walk-in pantry. Skylights and a wall of windows flood the living space with natural light, centered around the custom Hansel Kern stone fireplace. Outside, enjoy the covered back patio porch for peaceful moments surrounded by nature, along with the inviting wrap-around front porch offering amazing views of the landscape. The 42x60 shop with pedestrian entrance and a 14' roll-up door sits at the base of the property and is large enough to house an RV and more. Additional features include owned Solar, a 3-car garage with a 2nd floor loft and bath. Andersen dual-pane, triple-glazed windows, two wells, and a pump house with a 2500gal in-ground storage tank. With its prime location in the foothills, 5 miles from Coarsegold, 13 miles from Oakhurst, and 33 miles from Fresno, this property offers the perfect blend of luxury and convenience.
MlsNumber: --


Listing Provided By: Keller Williams Fresno, original listing
Phone: 320-0625
Office Phone: (559) 432-5533
Agent Name: Bryan Martin
Disclaimer: Copyright © 2024 Fresno Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App