SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
and BuildingCert !='' and BuildingCert !=''
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:How about an electric bill of only ~ $700 a year (includes heat and ac)! This energy efficient, mostly solar powered VerMod home surely won't disappoint! Newly built just a couple years ago on a wide open 5 acre parcel. The huge front deck faces southwest, perfect for viewing those bright pink sunset skies or duck into the screened porch and enjoy a nice meal in the shade. Inside you'll find the master suite on one end of the home with a walk through closet into the 3/4 bath. Centrally located you have open kitchen, dining and living with a tiled mudroom to drop all your gear. And on the opposite end of the home there is a full bath, 2 additional bedrooms and an office. Highlights include: central ac, beautiful Canadien beech hardwood floors throughout the living spaces, maple kitchen cabinets with polished stone counters and vinyl interlocking tile in the baths. A bright, simple, clean lined home with energy efficient heating and cooling systems! Located in a beautiful tranquil setting in Etna (part of Hanover) within 15 minutes to both DHMC and Dartmouth College and on a great street for walking and Moose Mtn. and AT hiking just down the road!
Description:Welcome to the Gathering House. This Energy Star certified Yankee Barn Home is a custom built masterpiece & has been showcased on numerous TV shows and magazines. Thoughtfully designed to provide a combination of functional spaces for entertaining & quiet personal retreats this home offers quality, efficiency & privacy all in the heart of Eastman. Savor all four seasons from the Great Room with a majestic double sided fireplace that towers to the top of the cathedral ceiling & a wall of windows that overlooks the custom fieldstone patio. The kitchen has custom Crown Point Cabinetry, top of the line appliances & granite countertops. Offering one floor living, the primary bedroom has its own wing, with ensuite bathroom & private access to the beautifully landscaped patio. Two additional bedrooms upstairs, lofts, media room, office, workspaces & more. Community amenities include championship golf course, tennis courts, miles of ski/snowshoeing trails, indoor pool & six different beaches. Set on 4.5 acres within this prominent four season community the Gathering House is perfect for seasonal or year round living. Short walk to South Cove Activity Center, direct access to trail system & 300+ acre lake with impeccable views. Numerous upgrades include solar, heat pumps, 2 level-two EV chargers, pellet boiler & more. Join us at the Open House, Sunday 05-05-24 from 10am-12pm. Just minutes to I-89 & the Upper Valley/Dartmouth area, 20 minutes to Mt. Sunapee & 40 minutes to Concord.