SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms='1') and (bedrooms='1')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Post Pond Possibilities!! One of a few number of lots that have pond access. Don't miss the opportunity to be a Post Pond resident. 11 Acres and a Camp/Cottage with rustic character overlooks the pond in a wooded setting. Most of the land already in current use and building envelope is ready for your personal touches. Septic installed new in 2007 with power and a drilled well onsite. Outbuildings for boat storage and more. Come and imagine life on the pond minutes from Hanover, Dartmouth College, and DHMC. All the amenities of the Upper Valley minutes away from your quiet access to nature and wooded serenity.
Description:The sun streams in to this delightfully bright home set on a gorgeous 3.45 ac site in Lebanon. Spacious great room with beautiful outlook. 2648 sq ft home is currently set up as 1 bedroom, 2.5 bath, with large first floor master suite. Upstairs has a large family/game room and a full bath. Seller will give credit of builder's estimate to add two more bedrooms to the second floor. (House has a 4 bedroom septic system). Full basement provides great space for workshop or more finished space. 2 car garage. Open house Sunday, May 31 from 1--3pm.