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

975 Westside Lake Road
Maidstone, VT 05905
Lisa Hampton with Lisa Hampton Real Estate, original listing - (603) 788-5106

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,198,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2679 Square Feet
Agency: Lisa Hampton Real Estate
Agency Phone: (603) 788-5106

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Escape to paradise at this exquisite lakefront retreat on Maidstone Lake. This contemporary 3 bedroom, 2.5 bath masterpiece offers many custom features sure to please even the most discerning buyer. The home was built to capture the essence of lake living and the desire for privacy blending the home with the natural landscape of the lot. A dramatic veranda wraps around all four sides of the home providing additional living space to entertain guests or relax and while away the summer days. IPE decking boards were used on all exterior floors and stairs to ensure years of low maintenance. A lakeside dock provides room for your watercraft and a large sunning deck for access to all the lake activities. The main level of the home has a lovely kitchen with ample cupboards and granite counter tops, dining area and a gorgeous angled living room with a wall of windows overlooking the lake. Beautiful hardwood cherry floors flow throughout the main level of the home. The primary en-suite bedroom has french doors to the living room and windows to capture the view of the lake. Also on this level is a second bedroom & a guest powder room. Upstairs you will find a billiard room & an en-suite bedroom with large picture window. The basement has a den, laundry room, utility room and storage room. Maidstone is a 796 acre glacial formed lake that offers trout fishing and loon watching. Across the road is West Mountain Wildlife Refuge with 120,000 conserved acres to entice the explorer.
MlsNumber: --
ListingId: 5000812


Listing Provided By: Lisa Hampton Real Estate, original listing
Phone: (603) 788-5106
Office Phone: (603) 788-5106
Agent Name: Lisa Hampton
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