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','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 = 3120 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 = 3120 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;

28 Forest Lane
Pittsburg, NH 03592

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $375,000
Beds: 3
Baths: 1
Status: Active
SqFt: 1872
Agency: keller williams coastal realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 1992
Notes: FANTASTIC 3 BEDROOM PITTSBURG, NH HOME WITH SNOWMOBILE AND ATV TRAIL ACCESS - This charming home provides a perfect blend of accessibility and tranquility, as it offers easy access off of route 3 while still providing the feeling of being secluded in nature. Upon entering the main floor, you'll be greeted by an oversized open concept kitchen, dining, and living room area, creating a spacious and inviting atmosphere. The mudroom/entryway is thoughtfully designed with ample storage, making it convenient for organizing your belongings. Additionally, the first floor boasts a bedroom, a laundry/utility room, and a full bath for added convenience. Moving upstairs, you'll find bedrooms 2 and 3, both generously sized and capable of accommodating a group of guests comfortably. There's also a large landing/multi-purpose room at the top of the stairs, perfect for use as an extra sleeping area, office, or home school space. Designed with single-level living in mind, this property ensures your comfort well into your golden years. Furthermore, there's plenty of space to accommodate all your friends and family when they come to visit, making it an ideal year-round home or a delightful Northern NH camp. The location is a dream for outdoor enthusiasts, as it's in close proximity to the beautiful Pittsburg lakes, rivers, hiking trails, and prime hunting areas. Additionally, the 24x24 foundation has already been poured, providing the perfect opportunity for you to build your new garage,
MlsNumber: 4962129


Listing Provided By: keller williams coastal realty, original listing
Name: keller williams coastal realty
Phone: (603) 610-8500
Office Name: KW Coastal and Lakes & Mtns Realty/A Notch Ab
Office Phone: (603) 538-9922
Agent Name: Joey Sweatt
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