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

0 Applewood Avenue
Gilmanton, NH 03237
Erica Bruce with Better Homes and Gardens Real Estate The Masiello Group, original listing - (603) 625-2800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $49,900
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Better Homes and Gardens Real Estate The Masiello Group
Agency Phone: (603) 298-8254

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 31,363 acre(s)
Property Type: Land-Single Family Residence
Year Built: --
Notes: Beautiful .72-Acre Land with Water Access to Sawyer Lake Discover your dream property in the picturesque Sawyer Lake District! This stunning (5 lot merge) parcel, situated at the end of Applewood Ave, offers a unique opportunity for your hillside chalet or secluded getaway. Here are the highlights: Scenic Water Access: With exclusive water access to the pristine Sawyer Lake, you can enjoy boating, fishing, and tranquil lakeside moments just steps away from your future home. Natural Beauty: This property is a nature lovers paradise, with breathtaking rocky slopes and lush surroundings. The conservation land on two sides ensures your privacy and a serene environment. Hillside Chalet Potential: The sloped terrain provides the perfect setting for a hillside chalet, allowing you to design a home that capitalizes on the awe-inspiring lake and mountain surroundings. Endless Outdoor Activities: Whether youre into hiking, wildlife watching, or simply soaking in the natural beauty, this land offers unlimited opportunities for outdoor enthusiasts. Prime Location: Nestled in the sought-after Sawyer Lake District of Gilmanton NH. Youll relish the tranquility of the countryside while still being conveniently close to nearby towns and amenities. This is your chance to own a piece of paradise. Dont miss out on this unique property “ schedule a viewing today and start planning your lakeside retreat! Contact us for more information.
MlsNumber: --
ListingId: 4973997


Listing Provided By: Better Homes and Gardens Real Estate The Masiello Group, original listing
Phone: (603) 717-6237
Office Phone: (603) 625-2800
Agent Name: Erica Bruce
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