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

375 East Colebrook Road
Colebrook, NH 03576
Francine Rancourt with RE/MAX Northern Edge Realty/Colebrook, original listing - (603) 752-0003

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: You are driving on East Colebrook Road about a 1 1/2 mile when you look to your left & see this long-paved drive leading to a most striking cedar shake home! Perched in the middle of open fields w/ its boundaries bordered by mature trees & stone walls, overlooking tremendous views of Dixville Notch including the Balsams Club House surrounded by the famous Donald Ross golf course! This home is filled with sunlight in every room. The open floor offers the living room as the focal point with a wall of high windows letting in the gorgeous views. A tall soap stone woodstove that sure will hold the heat on chilly nights. The lg center kitchen island is perfect for entertaining. Many custom cabinets, granite countertops & ss appliances. There are many rooms but all with such purpose; the den/TV room a bit away from the rest, 3 bedrooms with an ensuite & walk-in closet in the primary, 4 bathrooms total, a huge well-designed panty, separate laundry room, spacious front and back entries with ample closets. The 2nd fl has the 3rd bdrm & a full bath. Here would be so easy to finish one of the attic areas for a guest suite with private kitchenette & sitting area. Relax on the most attractive deck & comfy furniture overlooking the views. Of course, the 3-car garage is special. Huge storage space in the basement. All this comes with the furnishings & equipment; UTV, tractor w/backhoe & chipper implements, & lawnmower. Maybe you have owned several homes, but this will become your favorite!
MlsNumber: --
ListingId: 5015332


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