Title Page Background
HFQUERY 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 ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

59788 Road 601
Ahwahnee, CA 93601
Rene Christenson with Century 21 Ditton Realty, original listing - (559) 683-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $519,888
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1826 Square Feet
Agency: Century 21 Ditton Realty
Agency Phone: (559) 683-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1993
Notes: Absolutely gorgeous mountain views from this charming 3 BD, 2 BA 2-story home! Peaceful front porch w/ceiling fan to enjoy those views & lovely landscaping. Rustic glamour can be found once you enter this spacious 1826+/- sq. ft. home. Tongue 'n groove beamed ceiling w/fans, dramatic picture windows, wood stove w/rock & slate hearth & that's just the living room. Beautiful wood flooring in the main living area. An open dining area & kitchen make family time baking or cooking so memorable! The center island w/a breakfast bar & built-in cook top, granite counter tops, dbl. ovens, lots of cabinets w/under cabinet lighting, dishwasher & stainless steel refrigerator make this kitchen a dream! The guest BDs are both downstairs w/the guest BA & laundry room. The master retreat is waiting for you upstairs! w/high beamed ceiling w/ceiling fan, huge walk-in closet, lg. master BA w/2 vanities, shower, jetted tub, privacy toilet & stunning views from the upper windows too! The back deck view will take your breath away w/the distant mountain views & it's a wonderful spot to entertain! A nice landscaped sitting area is great for a fire pit & sitting out under the stars. A 2 car garage w/an attached carport & storage port lg. enough for a boat, tools & more w/an additional separate RV port! This wonderful home has a new roof, granite counter tops, front windows & the carport is new too! Stunning views, upgrades, a beautiful floor plan & privacy are waiting for you on 1.06+/- peaceful acres!
MlsNumber: --
ListingId: 614429


Listing Provided By: Century 21 Ditton Realty, original listing
Phone: 760-4221
Office Phone: (559) 683-7653
Agent Name: Rene Christenson
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