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 = 2814 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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 = 2814 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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 = 2814 AND i.igate IN ('usahud','nwhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nwhud', 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;

227 Bowenville Road
Troy, VT 05868
Nicholas Maclure with Century 21 Farm & Forest, original listing - (802) 334-1200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,900
Beds: 3
Baths: Full: 2, ½: 1, ¼: 1, ¾: 1
Status: Active
SqFt: 4020 Square Feet
Agency: Century 21 Farm & Forest
Agency Phone: (802) 334-1200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 21 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: As you ride up the long, paved, maple tree-lined driveway you’ll fall in love with the location, and once inside this home you may never want to leave. The 2,480-sq-ft home is clean and bright, with an additional 850 finished sq ft in the lower level. The L-shaped kitchen features maple cabinets, granite counters, tile backsplash, stainless appliances, and a large island with gas cooktop and seating for 4. From here this an easy flow to the dining area and living room. A covered porch along the front of the house offers local mountain views. The primary bedroom has an en suite bath with double sink, tiled shower, and walk-in closet. A second bedroom and full bath, as well as a laundry room are found on this side of the second floor. Sitting over the 3-car garage is a den/game room that is accessed from the mudroom. The lower level is ideally set up as a guest suite complete with seating area and ¾ bath. Double French doors in the dining area open to the stamped-concrete patio and outdoor kitchen/dining area, where you’ll doubtless spend hours with family and friends. Just beyond is a cozy fire pit area, and beyond that is the immaculate 3-stall horse barn with tack room. The 21-acre property includes pasture area, raised garden beds, and established perennial beds adding bursts of bright color contrasting with the deep green lawn. This home is 15 minutes from shopping and dining in the Newport/Derby area, as well as Lake Memphremagog, and an 11-mile drive to Jay Peak Resort.
MlsNumber: --
ListingId: 5003475


Listing Provided By: Century 21 Farm & Forest, original listing
Phone: (802) 334-1200
Office Phone: (802) 334-1200
Agent Name: Nicholas Maclure
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