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 = 242 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 = 242 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 = 242 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;

20796 Lama Teumete Rd
Mi Wuk Village, CA 95346
Kristin Frankhauser with RE/MAX GOLD, original listing - (209) 536-8400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,950
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1482 Square Feet
Agency: RE/MAX GOLD
Agency Phone: (209) 536-8400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1961
Notes: Hardie siding, Trex decking and a new metal roof! Turnkey houses like this one with high-quality improvements are a rarity in Mi Wuk. Welcome to your move-in ready mountain getaway "Sierra Dream"; Created as a lifestyle house for entertaining and outdoor living, this upgraded mountain cottage is perfect for Weekend Warriors or those seeking an escape. Maintenance-free landscaping, no highway noise and minimal neighbors enhance the serenity. With plenty of extra parking for visitors, you'll love the stone wall that lines the driveway as an impressive accent to your new retreat. Once on the spacious deck, take in the views at tree level. With an outdoor kitchen, this house is perfect for indoor/outdoor living most of the year. Enter through the French doors to an open floor plan and enjoy the large windows for natural light and tree views. The original knotty pine interior and beamed ceilings offer a true cabin vibe. After a day in the snow, imagine the warmth and coziness of the wood-burning stove with family and friends. Upstairs, vaulted ceilings give an expansive feel. You'll also love the mudroom complete with washer/dryer and the separate bonus walkout basement downstairs - currently used as an office. It's all about location! Dodge Ridge Ski Resort, Pinecrest Lake, hiking, biking, OHV trails, snow parks, and more are only minutes away. Head to Sonora for shopping, dining and a fabulous seasonal farmers market, but don't forget Kennedy Meadows and the breathtaking Sonora Pass are just a short drive up 108, while wine country is less than an hour away. Mi Wuk offers many restaurants and coffee options within one mile, plus a general store, post office, and library. For those interested, this house is located on the school bus and snow plow routes and offers a 1.5 car garage with a workbench + 3 parking spaces. We know you'll absolutely fall in love with this very special and unique mountain retreat. Welcome to your dream, "Sierra Dream".
MlsNumber: --
ListingId: 20241305


Listing Provided By: RE/MAX GOLD, original listing
Phone: (209) 768-7734
Office Phone: (209) 536-8400
Agent Name: Kristin Frankhauser
Disclaimer: Copyright © 2024 Tuolumne County 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