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;

23340 Lakewood
Twain Harte, CA 95383
Yana Vass with Vass Haus Real Estate, original listing - (530) 233-8084

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3695 Square Feet
Agency: Vass Haus Real Estate
Agency Phone: (530) 233-8084

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1987
Notes: Welcome to this tastefully updated sanctuary nestled on 3 acres in the serene neighborhood of Lynnwood Estates located at the end of a tranquil cul-de-sac in Twain Harte, with optional lake membership to Lakewood Lake. Step inside to be greeted by high ceilings with beautiful dark contrasting beams over the living room, where the wood burning fireplace creates cozy mountain ambiance. The spacious kitchen is perfect for hosting gatherings with a large center island and ample storage and counter space. Kitchen shares an open floorpan with the oversized dining room- which opens up to the living room, and one of the two bonus rooms/offices/school rooms. South facing windows allow natural light to stream in, illuminating the beauty of the space. All three bedrooms are located on entry level. Enjoy the luxury of the upgraded Primary Suite- featuring a soaking tub for ultimate relaxation, separate shower, dual vanities and a fabulous walk-in closet in addition to the wall closet in bedroom. Downstairs is set up as a theatre with wet bar, full bathroom, wood burning fireplace and lots of space to spread out. Downstairs office and bonus family room/theatre add an extra touch of of spacious convenience, while the ample storage and three-car garage enhance the appeal of this well appointed home. The large back deck which has several access points with three sliders throughout the home, with views into the trees, featuring a high end hot tub which enhances a peaceful retreat. A couple bonuses to highlight- Automatic Generac generator, HVAC, parking for boat and RV... With its fantastic amenities and prime location, this home is not just a residence but a lifestyle. Don't miss out on the opportunity to make this dream property yours! Located about 30 minutes from Dodge Ridge and Pinecrest, 20 minutes from Sonora, 15 minutes to Black Oak Casino. If you're considering an STR this home would be excellent!!
MlsNumber: --
ListingId: 20240343


Listing Provided By: Vass Haus Real Estate, original listing
Phone: (530) 233-8504
Office Phone: (530) 233-8084
Agent Name: Yana Vass
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