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(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:**Open House Saturday 4/12 and Sunday 4/13 from 11:00 - 3:00!** Just 15 minutes from DHMC, Dartmouth College, AND 12A, this thoughtfully updated ranch offers the peace and quiet of a rural setting within a wonderful neighborhood. A large kitchen (with Crown Point cabinetry, marble countertops, and newer appliances), spacious living areas, three bedrooms, and updated 3/4 primary and full hall baths complete the main floor. Downstairs you'll find another bedroom, family room, and office (all with new carpet), a full bath, laundry/workshop, and storage galore. New paint, garage door system, wood shed, Trex deck, fenced yard, mature flower gardens, and raised vegetable gardens enhance the exterior. Energy efficiency is a priority: windows installed since 2017 are Anderson 400 Low-E, a fully-owned 10-megawatt solar panel system, an electric heat pump hot water heater for domestic hot water, and a Level-2 CCS EV charger. Too many updates to name here - a full list available upon request.
Description:Marvellous contemporary cape in move-in condition with fabulous gleaming hardwood floors throughout the main level. Open first floor has spacious kitchen, dining room, living room, mudroom, office and 1/2 bath/laundry. Second floor has 3 bedrooms, 2 full bathrooms. Separate suite, accessed from mudroom has large living room or home office, bedroom, and 3/4 bath. This residential neighborhood location makes for quick and easy commuting to the medical center, without driving through Hanover, or to the College. A great one! Showings start at Open House Saturday, Jan 4, 10am-12 and Sunday, Jan 5, 2-4pm
Description:7 WILLOW SPRING LANE- Spacious, well-maintained home on a large private lot in a quiet neighborhood within walking distance of downtown Hanover. The Girl Brook Trail and Dartmouth's Practice Golf Course are adjacent the property providing acres of space to recreate. The house interiors are spacious and bright, including a large living room with central fireplace and views over the back lawn on the main level. There is a large, well-appointed eat-in kitchen that adjoins a formal dining room, while the primary bedroom suite on this level features a generous en suite bathroom, changing area, and plenty of wardrobe space. There is also a second en suite bedroom on this floor providing plenty of options for one-floor living. The lower walkout level offers several versatile bright and spacious rooms including a family room, rec room, and two additional bedrooms that share a full bathroom. Additionally, there is a large central laundry room, workshop, and additional storage space. Outside the home are level lawns, mature landscaping, and a sizable deck to enjoy during warmer weather. With walking trails, cross country skiing, and more on the Girl Brook Trail network and shops, restaurants, and area schools just minutes away, this charming family home is a true Hanover gem. A few photos are virtually staged.
Description:Welcome to the best of golf course living! This upscale home on Eastman Golf Links is on the market for the very first time. A custom Yankee Barn home on the 2nd fairway with golf course views throughout many rooms. This spacious 4,397 SF home offers sleeping quarters on each of its 3 finished levels. Featuring a statement living room with cathedral ceilings, a 2-story window display, double-sided fireplace, and the quintessential wood beams highlighting its architecture. A beautiful kitchen with an island and stainless steel appliances sits opposite the dining area with sliders to a cozy sunroom. Retreat to the main level Primary bedroom suite with its own bath and deck access. You’ll also find an office with skylights, family room with deck access, and a half bath on the main level. The upper level has a loft area + 2 bedrooms and a full bath with separate tub and shower. The finished walkout lower level is an expansive space for gatherings and game nights. It includes a family room area with built-ins, a wet bar with seating, a built-in desk with storage, and a rec area. This grand home is complete with a 2-car attached garage, tiled mudroom, level lot and paved driveway. Eastman offers lake activities, golf, cross-country skiing, tennis, pickleball, walking trails, an indoor pool, fitness center and more. All this in the heart of the Dartmouth - Lake Sunapee Region with easy access to I-89.
Description:Mastlands, named for the towering Eastern white pines once used as ship masts, is a historic Cornish Art Colony estate nestled among trees, farmland, and exquisite gardens. Once the summer home of Dr. Arthur Nichols and his family, it carries a rich legacy, with his daughter, Rose Nichols - a prominent landscape architect - designing the walled garden off the piazza, inspired by her uncle Augustus Saint-Gaudens and architect Charles Platt. The estate's 24 acres feature revived gardens, seasonal blooms, restored fountains, and peaceful retreats like Pine Tree Alley and a firepit. The property offers great outdoor opportunities, with access to a nearby Class 4 road connecting to the scenic River Road, ideal for walks, and additional paths around the cornfields for leisurely strolls. The grand living spaces featuring high ceilings and intricate moldings, including a ballroom wing with elements salvaged from a European chateau, combine historic charm with modern comforts and is crafted for sharing with loved ones. A versatile one-bedroom apartment offers independent living or rental potential, making Mastlands a perfect home for those who cherish history and seek to continue its stewardship. Showings begin 9/3.