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 (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Set in a highly sought-after location with easy access to town and nearby trails, this beautifully maintained cape blends comfort, functionality, and convenience. An attached 2-car garage and direct entry add to the home’s everyday ease. Inside, the thoughtfully designed layout begins with a spacious mudroom featuring a walk-in closet and half bath—perfect for staying organized year-round. The open-concept kitchen, dining, and living area creates a natural gathering space, ideal for both daily living and entertaining, with a slider leading out to a private back patio. A dedicated home office offers the flexibility today’s buyers are looking for. Upstairs, you’ll find two generously sized bedrooms and a full bath, along with an oversized primary suite. This inviting retreat features a walk-in closet and an en-suite bath complete with a soaking tub. Convenient second-floor laundry enhances the home’s practical design. The finished lower level provides additional living space with a large family room and full window—perfect for guests, a media room, or a cozy place to unwind. A utility room offers excellent storage or the potential for a small workshop. All of this is just minutes from Dartmouth College and within 10 minutes of Dartmouth-Hitchcock Medical Center. With a level, low-maintenance yard and well manicured perennial gardens, and a location that balances accessibility with outdoor recreation, this home delivers the best of Upper Valley living.
Description:Wonderful contemporary home with 73+/-ac and majestic views from every window. Privately sited and with three very pretty ponds, there are several useful outbuildings to house animals or outdoor equipment as well as great indoor storage for sports equipment, skis, etc. With 3 bedrooms, 2 baths and a wonderful open floor plan, the property is close to the Green Woodlands ski/mountain biking/hiking trails, the Appalachian Trail, Dartmouth Skiway, boating on Reservoir Pond, and the charming village of Lyme. Just 30 minutes from Hanover, NH, Dartmouth College and Dartmouth Hitchcock Medical Center. A one-of-a-kind spot!
Description:A luxurious waterfront property in Eastman located at the end of a cul-de-sac offering the utmost privacy and seclusion. This home boasts an exceptional location with stunning views of Eastman Lake from its elevated position. The design of the house takes full advantage of the scenic surroundings, featuring walls of glass with all new sliders that open up to a spacious deck, creating a seamless indoor-outdoor living experience. The interior is thoughtfully designed with an inviting floor plan. It includes a bedroom suite with a generously sized bathroom, a great room, and family room, all adorned with cozy fireplaces. The three bedrooms in the home offer breathtaking views and can be enjoyed in all seasons. Living in the Eastman Community provides an opportunity to embrace an outdoor lifestyle, taking advantage of the surroundings and the proximity to walking trails and the lake. Enjoy tennis, pickleball, golf, XC ski trails, an indoor pool, fitness center and more. Whether it's watching the sunset from the comfort of your home or indulging in various outdoor activities, this residence offers a remarkable waterfront living experience.
Description:100 NORTH THETFORD ROAD- Updated, impeccably maintained Cape sited on a stunning nearly 4-acre parcel with breathtaking long-range views. The open concept interiors feature vaulted ceilings and effortless flow, designed to welcome abundant natural light and showcase the landscaped grounds, vistas, and abutting conserved land. A well-appointed kitchen with beautiful woodwork and adjacent dining area together with a sizable deck and covered patio make it perfect for entertaining family and friends alike. The living room is both grand and cozy, with built in bookshelves flanking the east side and a propane stove for cooler months. Also on the main level are a large en suite primary bedroom with office area, a second bedroom with a full bathroom, and laundry room. Upstairs is a private loft space and third bedroom accessed from a magical custom wood landing. The walkout lower level offers an additional finished living area–perfect as an office or recreation room–as well as ample storage space. Attached to the house via the lovely breezeway/patio is a newer 3-bay garage barn with a private heated woodshop, and storage above that has potential for conversion to additional finished space. Two Solaflect solar trackers help with annual electricity production. With its comfortable and versatile interiors, stunning grounds and views, and perfect location to access points both north and south, this move-in-ready home has something for everyone.
Description:Stunning views from almost every window of this 3 bedroom, 3.5 bathroom colonial. This house has it ALL! Renovated kitchen with bar seating and sunny breakfast nook, living room with big stone fireplace, primary suite with sitting room and western skies from your soaking tub, two other second floor bedrooms that share a full bathroom. Additionally, 2 first floor offices, formal dining room for entertaining, large family room and workout space in the walk out lower level, three car attached garage, and tons of storage! While outdoors, you will enjoy decks, a covered front porch, a lovely patio and pool. Set on 13.54 magical acres on one of Lebanon's most scenic roads, this is a perfect location - minutes to Dartmouth Health, downtown Lebanon and easy access to I89.