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 list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This one-of-a-kind luxury Eastman home will not last long. Beautifully maintained, thoughtfully designed, this exceptional 4-bedroom, 3.5-bath home offers the perfect blend of comfort, privacy, and year-round recreation. Step inside to a fieldstone fireplace, creating a warm and inviting focal point for gathering with family and friends. The spacious kitchen features granite countertops, abundant cabinetry, and a large center island. A bright three-season room provides an ideal place to enjoy the surrounding natural beauty throughout the year. The thoughtfully designed floor plan includes a finished walkout lower level with a spacious family room, wet bar, dedicated home theater, and an infrared sauna, creating a perfect retreat after a long day at work. Additional highlights include central air conditioning, Energy Star construction, oversized attached 2-car garage. One of this home's most remarkable features, its walkable location. Leave the car and enjoy everything Eastman offers on foot. Across the street is Eastman's main beach, where you can spend summer days swimming, kayaking, paddleboarding, or simply relaxing by the water. Enjoy outdoor concerts and community events throughout the season, treat yourself to an ice cream at Peppermint Patty's, or stroll to the recreation fields for basketball, softball, and soccer. The Eastman Recreation Center, featuring an indoor pool, fitness center, game room, and year-round activities, is also just a short walk away. Bordering Eastman's cross-country ski trail system, you will enjoy direct access to miles of trails for walking, hiking, running, snowshoeing, and cross-country skiing from your backyard. Relax on the spacious deck and listen to the peaceful brook sounds meandering alongside the trail. This isn't simply a home; it's an opportunity to embrace the Eastman lifestyle. Few properties offer this unique combination of natural beauty, recreation, walkability, and community.
Description:Views...Contemporary 2-story home in Grantham, NH, set on 5.6 acres with scenic mountain views and thoughtfully designed indoor and outdoor living spaces. A covered front porch and attached two-car garage provide a welcoming entry. The open-concept main level features a floor-to-ceiling stone fireplace, a spacious kitchen with stainless steel appliances and a breakfast bar, and an adjoining dining area with sliding doors leading to an expansive wraparound deck that spans the width of the home. The deck overlooks the beautiful surrounding landscape and has a 2 propane outlet to connect a gas grill. The screened porch offers additional space for outdoor enjoyment. The first-floor primary bedroom suite provides convenient main-level living and boasts an ultra modern bathroom remodeled in 2021 with heated flooring. Upstairs, a loft with built-in shelving offers flexible space for a sitting area, workspace, or library. You'll also find 2 private bedroom suites on the upper level, each with beautiful views. A separate studio or home office provides additional versatility for a variety of uses. The walkout lower level expands the living space with a family room, full bath, and bonus room, offering flexibility for recreation, hobbies, or other needs. This property combines modern design, functional living areas, and a private setting just minutes from the amenities of Grantham and nearby access to I-89.
Description:A property for all seasons with waterfront, views, color, comfort and privacy. From the moment you walk into this totally renovated, architecturally designed waterfront home, you will be taken! The floor plan takes advantage of light, efficiency, space and views; includes kitchen, with island crafted of hardwood maple salvaged from a bowling alley in Maine and beautifully refurbished, high-end appliances, dining area, living room and the bedroom where you awaken looking at the River. In addition, there is a laundry area and three-quarter bathroom and a sleeping loft as well as a small area of basement. Not only River frontage but a cove, too, a dock and docking ramps and a Level 2 EV Charger. The owners have been the ultimate stewards of this property; they have had engineers assess the banks and have added structural components not only to better stabilize the banks but to also assure the integrity of the structure of the house. A gem and only minutes to “in town” Hanover!! *‘Renovations were completed in 2022, with design by Daniel Johnson of Watershed Studio Architecture."
Description:Gorgeous New Hampshire Lakefront! Wake up to breathtaking unobstructed views of Mascoma Lake in this beautifully situated Shaker Village home. Located across from the peaceful Shaker Museum walking grounds, this end-lot offers privacy while still being part of the sought-after Chosen Vale community. Outdoor enthusiasts will love the easy access to boating, swimming, ice fishing, skating, sledding, snowshoeing, hiking trails in the Lower Shaker Wildlife Management Area, and nearby skiing at Whaleback Mountain. This home boasts direct access to a dock slip and is just a short walk to two shared beaches. Additional features include heat pumps, Powerwall backup battery system, electric vehicle charger, and recently installed on-demand boiler. Conveniently located just 15–20 minutes from Dartmouth Hitchcock Medical Center, Dartmouth College, and White River Junction, this property offers the perfect balance of lakeside tranquility and accessibility. Open house Fri 7/10 3-5pm and Sat 7/11 10am-12pm
Description:Tucked into a picturesque tree-lined neighborhood with buried power lines, a central grassy common area, and a charming community mailbox gathering spot, this beautifully maintained home offers the perfect blend of comfort and convenience just five minutes from downtown Hanover. A welcoming covered front porch leads into a gracious foyer, while a second entrance from the attached two-car garage provides easy access directly into the kitchen. The main level is thoughtfully designed for both everyday living and entertaining, featuring a bright kitchen with a casual dining area, a separate formal dining room that could also serve as a home office or den, and a spacious living room anchored by a cozy gas fireplace. The living room opens directly onto the large back deck with built-in bench seating, where you can enjoy peaceful views of the level grassy backyard and the wooded backdrop beyond. A convenient half bath completes the main level. Upstairs, the home offers four bedrooms, including a serene primary suite with its own 3/4 bath and walk-in closet. Three additional bedrooms share a well-appointed full bath, providing comfortable accommodations for family and guests alike. The walk-out lower level is partially finished, offering flexible space for a recreation room, media area, gym, or hobby space, while also housing the laundry area and additional storage. Ideally situated just minutes from Dartmouth College, DHMC, and all the shops, restaurants, and cultural amenities of downtown Hanover, this home combines a serene neighborhood setting with exceptional proximity to everything the Upper Valley has to offer. Only 5 minutes to downtown Hanover, this is a rare opportunity to enjoy peaceful residential living without sacrificing convenience.