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

14430 Avenida Central
La Grange, CA 95329-9799
Gisele Schreyer with KW Sierra Foothills, original listing - (209) 694-8077

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2530 Square Feet
Agency: KW Sierra Foothills
Agency Phone: (209) 694-8077

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: Lake Don Pedro's Amazing "Barn Style Custom Home" with magnificent views of the foothills of the Sierra Nevada Mountains & Yosemite Nat'l Park + 4,000 sf Commercial Workshop on 7.1 acres, all custom built! Looking forward to work from your own piece of paradise? Here it is... the quintessential place to live & work, even play! This home is built with 211 insolated, all wrapped with Hardie backer weather barriers, dual pane windows equipped w/ dark sunscreens for energy efficiency, new composition shingle roof, 2-zoned air & heating system, alarm system & 4 security cameras. You will enter this beauty on the 2nd floor (main floor), on an exquisite oak wood strained flooring in the living room, amongst a charming Heatilator wood burning fireplace. The dining area provides ample space for your China cabinet & dual-pane blind integral glass sliding doors that lead you to a lovely "L-shaped" deck for Barbecuing & relaxation enjoying the views. The kitchen has black appliances w/ a Jenn-air electric stove top, wall oven, built-in microwave, black granite countertops, kitchen island, a 3 bar stool breakfast bar, garden window, roll-out drawers in cabinets have accent & under-cabinet lighting for ambiance, instant hot water, a large pantry & ceramic tile. The large 2nd bedroom is also on the main level which includes built-in window seating/storage & decorative a ceiling. The guest bathroom is remodeled with ceramic tile, high quality American Standard shower/glass with custom seating, granite countertops & a slit shower drain. The laundry room is fully equipped w/ washer, dryer, built-in ironing board & a laundry shoot. The 3rd level is fabulous... These quarters offers a primary large bedroom showcasing a walk-in closet that has an armoire & built-in cabinetry. The primary bathroom has a spa tub, glass tile shower & dual granite countertops. The large family room is accented with 2 dormers that open, a lovely pellet stove, built-in entertainment center for a large TV & books, a wet bar equipped w/ granite counter tops, sink, small refrigerator, microwave, storage closet, Bose surround sound system, Pela dual-pane blind integral glass sliding doors that lead to a private balcony. Oh then there is the 1st level... that has a large 3rd bedroom that leads outside, bathroom w/ shower, a bonus room/office/den for the quarters w/ custom built large cabinets. The oversized 3 car garage also has wall to wall customary built shelving with plenty of room in front and on sides for vehicles. There is a steel carport that is perfect for that 4th vehicle adjacent to the garage. Now for those who are wanting a Commercial Grade Metal Workshop, it's in the rear! Drive or walk down to your 9-car & RV tandem garage w/ a private office w/ built-in cabinets & half bathroom. This is waiting for you: a engine hoist, a mezzanine above the office for extra storage, utility sink, ventilation room for painting, air compressor, 2 regular garage doors, RV garage tandem doors, a double electric door, extra storage room, swap cooler, heater, whole house fan w/ filters, multiple skylights that truly provide plenty of brightness in addition to the electrical lighting. So there it is... the quintessential place to live & work, even play! Located between 2 nearby lakes, Lake Don Pedro & Lake McClure where boating, fishing, camping awaits & equestrian trails for horseback riding... Yosemite National Park is one of America's favorite vacation spots to hike, sight-see, camp & enjoy. There's also Lake Don Pedro Homeowner's Association that includes a community pool, gym, small library, massage therapist, a lounge & large pavilion to rent. Low yearly fees for $119.00. Come and see if this little piece of paradise is for you and your family!
MlsNumber: --
ListingId: 20241698


Listing Provided By: KW Sierra Foothills, original listing
Phone: (209) 454-9808
Office Phone: (209) 694-8077
Agent Name: Gisele Schreyer
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 = 237 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;
Real Estate Expert Photo for Candice Terry
Candice Terry
ASCIIPMZ Real Estate
Call Today!: (209) 678-1724

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App