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

662 Hurricane Road
Keene, NH 03431
Norma Couture with Better Homes and Gardens Real Estate The Masiello Group, original listing - (603) 352-5433

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 3
Baths: Full: 5, ½: 1
Status: Active
SqFt: 4400 Square Feet
Agency: Better Homes and Gardens Real Estate The Masiello Group
Agency Phone: (603) 352-5433

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 100,000 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: This exquisite contemporary home spans over 4400 sq ft and is nestled within 60 acres of forest, streams, and hiking trails. The owners who designed and built this home have imbued the property with quality and care, creating a comfortable and relaxed atmosphere. Key features include a kitchen with field stone fireplace -what a space to cook and entertain- gorgeous windows overlooking the deck and yard, quartz counters, cherry cabinets, center island and built-in bench. A spacious and charming living room enjoys lots of natural light. The cozy den and beautiful first floor primary suite, plus the whimsical pine paneled dining room and fabulous mudroom make this an easy house to live in and love. Gorgeous hardwood floors go on forever! There are front and back stairways to the second level where open sitting areas were designed outside each room. A large office anchors one end, and each of the bedrooms has its own bath. A recent addition provides a fabulous in-law suite with a full kitchen w/dining banquette, living room with loft above, sleeping area and full bath; easily accessed by the main floor or a separate entrance from the garage. The walkout lower level offers expansive space for exercise, games, and entertainment, including a bunk room and full bath. With endless opportunities for exploration on your own land and a short distance to schools and shopping, this home combines privacy, convenience with understated luxury.
MlsNumber: --
ListingId: 5011387


Listing Provided By: Better Homes and Gardens Real Estate The Masiello Group, original listing
Phone: (603) 209-4918
Office Phone: (603) 352-5433
Agent Name: Norma Couture
Disclaimer: Copyright © 2024 Better Homes and Gardens Real Estate. 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