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;

23811 Marshall
Twain Harte, CA 95383

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $625,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 3000
Agency: DON SHARP BROKER

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1967
Notes: Custom Chalet with breathtaking views. Step off your gorgeous custom deck into an amazing meadow with a quaint pond and a stocked fishing ditch. This beautiful home is situated in the friendly community of Twain Harte which offers entertainment, restaurants, shopping and the Epperson Park for the kids. From the moment you arrive you will not be disappointed with this 4-bedroom 3-bath 3000 square foot home on a quiet cul-de-sac lot with great parking and an oversized garage w/attic storage. Spacious living room with picture windows framing the forest views, custom wood entertainment wall and access to the spacious decks. Oversized kitchen with beautiful countertops, tons of storage, soft close cabinetry, gas stove, breakfast bar and pellet stove. Dining room and kitchen nook are open to the kitchen and living room. Private primary suite w/walk in closet and spa bathroom plus private access to the lower deck and redwood enclosed hot tub. Three oversized guest bedrooms with views from every window. This is a turnkey home and everything has been thoughtfully taken care of including a new roof, mini split heating/cooling and new decking. Bring everyone as this home is set up to entertain. Twain Harte is a four-season vacation community making it a wonderful place to enjoy year-round. Amenities of Twain Harte and surrounding areas include: award winning restaurants, quaint shops, Stanislaus River, public nine-hole golf course, mini golf course, Bocce ball courts, Twain Harte Swimming Pool, public tennis courts, summer concerts in the park, year-round activities/festivals like the art and wine festival and the Christmas Parade, bocce ball courts, ice skating rink, lake and river fishing, endless hiking trails, Black Oak Casino and Arcade, Black Oak Amphitheater, Dodge Ridge Ski Resort and Pinecrest Lake Marina just to name a few. This home would make a profitable vacation rental, a perfect personal vacation home or a full-time residence. Furnishings are available
MlsNumber: 20240724


Listing Provided By: DON SHARP BROKER, original listing
Name: DON SHARP BROKER
Phone: (209) 532-7368
Office Name: Sharp Realty
Office Phone: (209) 532-7368
Agent Name: Carolyn Sharp
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.


Local Real Estate Expert

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;
Amy Walker
ASCIIRE/MAX Gold
Call Today!: (209) 588-6789

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App