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 >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 30
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Gorgeous house to be built in rural Hanover on a 5.3+/- acre parcel with year round westerly mountain views. With high ceilings and huge imported European triple pane windows and sliding glass doors, the light in this house will be amazing. High end Wolf and SubZero appliances, gourmet kitchen with waterfall soapstone counter and large pantry. First floor master suite with very large marble bathroom and walk in closet. On the lower level, 3 additional bedrooms and bathrooms, each with its own slider to the outdoors. The quality of construction will be absolutely top-notch: this builder is exceptional! Previously built Hanover home will be possible to view.