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;

175 Ambrose Way
Wolfeboro, NH 03894
Sara Reineman with BHHS Verani Wolfeboro, original listing - (603) 569-6060

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,950,000
Beds: 4
Baths: Full: 2, ½: 1, ¾: 1
Status: Active
SqFt: 4040 Square Feet
Agency: BHHS Verani Wolfeboro
Agency Phone: (603) 569-6060

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Newly-built, luxurious home in Wolfeboro, NH with breathtaking views of the Belknap Mountain range! This 4-bedroom, 3.5-bath home is exquisite, spares no expense and offers a world of graceful, elegant living. Perched on nearly 2 acres, this meticulous estate home is mesmerizing. Turn the doorknob and you enter a world of beauty. Wide plank European white oak floors run throughout the 1st floor. The great room has stunning fir beams that frame the cathedral ceilings. Nearly every window in the home offers majestic mountain & peaceful lake views. A granite fireplace lends a timeless appeal. The expansive 40-foot deck leaves one breathless as you marvel at the magnificent vistas. The oversized primary bedroom suite is a sanctuary, with a fireplace, exercise area, built-in desk and 2 large walk-in closets. The luxurious en-suite bathroom has quartzite and tile. The kitchen is a chef's dream, equipped with a Wolfe range, a Bertazonni fridge and Costa Esmeralda granite countertops. The pantry provides counter space & functionality. An inviting guest suite & laundry complete the 1st floor. The 2nd floor is ideal for guests or as an in-law suite with living area, kitchenette, two guest rooms and a beautiful bathroom. The walk-out basement is large with views and could be finished for additional living space. Landscaping & paving the driveway are scheduled for Aug/Sept. This pristine paradise is less than 5 minutes to downtown Wolfeboro, the “Oldest Summer Resort in America."
MlsNumber: --
ListingId: 5006220


Listing Provided By: BHHS Verani Wolfeboro, original listing
Phone: (603) 569-6060
Office Phone: (603) 569-6060
Agent Name: Sara Reineman
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