Title Page Background
DEBUG FN args: Array ( [0] => 3462 [1] => [2] => [3] => agent ) BEFORE: Site: 3462 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3462 Igate: njhud LocID: 3462 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3462 AND i.igate IN ('mihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3462 [1] => [2] => [3] => lender ) BEFORE: Site: 3462 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3462 Igate: njhud LocID: 3462 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3462 AND i.igate IN ('mihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3462 [1] => [2] => [3] => other ) BEFORE: Site: 3462 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3462 Igate: njhud LocID: 3462 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3462 AND i.igate IN ('mihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

5518 Vt Route 12
Barnard, VT 05031

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,850,000
Beds: 6
Baths:
Status: Active
SqFt: 7619 Square Feet
Agency: William Raveis Woodstock

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Range, Refrigerator, Dryer, Freezer, Range - Gas
Architectural Style: Other
Flooring: Carpet, Tile, Wood
Heating: Hot Water, Baseboard
Interior Features: Kitchen Island, Natural Woodwork, Smoke Detector, Dining Area, In-law Suite, Co Detector, Fireplace - Wood, Natural Light, Laundry - 2nd Floor, Storage - Indoor, In-Law/Accessory Dwelling, Fireplaces - 3+, Air Conditioner, Window Ac
Rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Dining Room, Kitchen, Laundry, Family Room, Living Room

Window Features

Exterior Features: Porch, Patio, Balcony, Barn, Storage, Shed, Outbuilding, Guest House, Window Screens, Garden Space, Porch - Covered, Building, Fence - Partial, Natural Shade
Fencing: Fenced, Partial
Parking Features: Off Street
Other Features: Barn(s), Outbuilding, Storage, Packing Shed, Shed(s), Guest House
Patio and Porch Features: Patio, Porch

Neighborhood/Schools

Elementary School/District: Barnard Academy/Windsor Central
Middle/Junior High School/District: /Windsor Central
High School/District: Woodstock Senior UHSD #4/Windsor Central
Subvidision Name:

Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1796
Notes: An historic brick residence prominently located in an affluent and growing community! Conveniently situated within walking distance to the Elementary School, to year round recreation on beloved Silver Lake and to the classic Barnard General Store. All the amenities of Woodstock Village are just minutes away! World class medical care at Dartmouth Hitchcock Hospital and year round cultural events at Dartmouth College are well under an hour away! The spacious 1st floor consists of a state-of-the-art commercial kitchen, to please any gourmet chef, elegant formal dining rooms and for casual entertaining a tavern complete with bar. Upstairs you'll find a designer kitchen with ample cooking, eating & lounging spaces, 5 bedrooms & cozy reading nooks. A beautifully framed detached barn presents, on a lower level, a newly renovated yoga studio and guest suite with radiant floor heat! A large great room is above, for entertaining or studio space. These compelling structures are nestled on a well maintained 10 acres which include expansive lawns, gardens, and lush meadow paths leading to a secluded pond with a gazebo. Nearby the pond additional property value is provided by existence of a site for an additional 2 bedroom residence, with certified septic. A significant residence complimented by an extraordinary detached auxiliary building, with well conceived grounds! An opportunity to create a home base that could be long enjoyed by every generation of the family! Genuine Vermont appeal!
MlsNumber: --


Listing Provided By: William Raveis Woodstock, original listing
Phone: (800) 547-8693
Office Phone: (800) 547-8693
Agent Name: John Wetmore
Disclaimer: Copyright © 2024 PrimeMLS. 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