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

655 Frizzell Road
Lemington, VT 05903
Jennifer Rancourt with RE/MAX Northern Edge Realty/Colebrook, original listing - (603) 752-0003

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $695,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2724 Square Feet
Agency: RE/MAX Northern Edge Realty/Colebrook
Agency Phone: (603) 752-0003

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 187 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1971
Notes: Welcome home to this 187.5-acre homestead with beautiful mountain views! Sitting privately and overlooking the property is this 3 bedroom, 2 bath log cabin.Inside you will enjoy the exposed beans, warm wooden accents and all the charm with windows all around bringing the outside in. Enjoy a nice kitchen with updated appliances, dining area, office with laundry, full bath, seating room with brick hearth and two spacious bedrooms upstairs.You will enjoy a nice primary en-suite with great closet space, views of the mountains and a full bath.The other end of the home offers a great room with cathedral ceilings built in cabinetry, stone hearth with wood burning fireplace and spacious dining area.The home has received many updates including mini splits, drilled well, forced hot air heating system, hot water heater, and so much more.The full walkout basement has tons of storage including a one bay garage.There is also a detached 1120 square foot garage with 3 bays, large storage room in the back with drive out access and an overhang storage area above.You will enjoy the spring fed trout pond that is just a short distance from the front covered porch.The property has trails all throughout the acreage and the maple sugar bush consisting of 9387 sugar maples and 1375 red maples.The property abuts on two sides 9,900 acres owned by Weyerhaeuser making this your perfect private location.The town does maintain Frizzell Road, and this property has access to the VAST trail system.
MlsNumber: --
ListingId: 5023002


Listing Provided By: RE/MAX Northern Edge Realty/Colebrook, original listing
Phone: (603) 752-0003
Office Phone: (603) 752-0003
Agent Name: Jennifer Rancourt
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