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

137 Brown Road
Tuftonboro, NH 03816
Randall Parker with Maxfield Real Estate/Wolfeboro, original listing - (603) 569-3128

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $12,250,000
Beds: 5
Baths: Full: 4, ½: 1, ¾: 1
Status: Active
SqFt: 6178 Square Feet
Agency: Maxfield Real Estate/Wolfeboro
Agency Phone: (603) 569-3128

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 114 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Welcome to this breathtaking country home estate, majestically perched on 114 acres of pristine land, w/ unparalleled mountain views. This grand residence offers the perfect blend of tranquility and sophistication, nestled amidst the lush greenery & serene landscapes. This elegant estate boasts 5 luxurious bedrooms & 6 full baths, each meticulously designed to provide the ultimate comfort and style. The spacious interiors are adorned with exquisite finishes, reflecting an impeccable attention to detail that resonates throughout the estate. The large 3-story barn holds vehicles & farm equipment below, horse stalls & a tack room on the 1st floor and a loft converted into a bunk room with a kitchenette and living room. A private dock adds to the allure, offering endless opportunities for canoeing, fishing, or simply soaking in the scenic views. A quaint water's edge cottage further enhances the charm of this waterfront haven, providing an idyllic spot for quiet contemplation or intimate gatherings. The estate's expansive grounds also offer ample space for outdoor activities, from leisurely strolls along the manicured lawns to picnics under the shade of mature trees. Whether you're indulging in the tranquility of the pond, exploring the vast acreage, or retiring to the comfort of the stately home,this country estate promises a lifestyle of unparalleled elegance & serenity. It's more than just a home; it's a sanctuary where every day feels like a vacation.Seller is licensed agent
MlsNumber: --
ListingId: 4973384


Listing Provided By: Maxfield Real Estate/Wolfeboro, original listing
Phone: (603) 569-3128
Office Phone: (603) 569-3128
Agent Name: Randall Parker
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