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 '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 30
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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:Prime location! Discover this charming classic New Englander, perfectly positioned in the heart of town. Enjoy the convenience of being just a short walk—approximately 6 minutes to Dartmouth College and the lively downtown scene, with its array of shops, restaurants, and cultural attractions. Currently set up as an income-producing duplex, this property provides fantastic versatility— with possibilities of transforming it into a spacious single-family residence, where you can bring your creativity to life. Or, keep the duplex setup for owner-occupied living with built-in rental potential to offset costs while enjoying the best of both worlds. Don't miss this opportunity—schedule a tour today and start envisioning the possibilities!
Description:3 WOODMORE DRIVE- Stylish, recently renovated home in a highly desirable neighborhood near Hanover, Dartmouth campus, local schools, and miles of walking, hiking, and cross-country trails. The interiors are spacious and bright, anchored by a large open-concept living room with a contemporary gas fireplace. The immaculate kitchen features a central island ideal for meal preparation, gathering, and casual dining, with an adjacent dining area complementing the space. On the east side of the main level just off the dining area is a large family room with a vaulted ceiling and skylight providing additional living space. The primary bedroom is situated on the west side of the main floor and includes an en suite bath, while two additional bedrooms on this level share a newer full bath. The lower level offers a spacious and versatile rec room or office area as well as a fourth bedroom with an en suite bath. Rounding out the floor is the laundry room that connects to a generous storage area, part of which is currently used as a home gym. The exterior spaces are equally appealing, a large south-facing deck with hillside views, a pergola, oversized hot tub, and ample garden space for entertaining or play. An attached carport accommodates two vehicles and includes a dedicated storage room, perfect for bikes, skis, and garden equipment. Ideally sited in a charming neighborhood with the convenience of all things Hanover at your fingertips, this beautifully updated and maintained home is turnkey and move-in ready. Exterior grass photos virtually enhanced. Showings begin Saturday, 4/4/26.
Description:Custom-built Timberpeg post-and-beam home set on 5.02 acres with expansive long-range mountain views visible from all three levels of living space. This 3-bedroom, 3.5-bath home features a living room with a 2-story stone fireplace, cathedral ceilings, and a wall of windows designed to capture the surrounding landscape. The eat-in kitchen includes Corian countertops, a kitchen island, stainless steel appliances and a walk-in pantry. Separate formal dining room is a plus. Beautiful 1st-floor primary bedroom with cathedral ceiling, an en-suite bath with separate whirlpool tub and shower, deck access, and skylights. An office/study, laundry room, and half bath complete the first floor. The upper level includes a media room in the finished attic space, a family room, two bedrooms with walk-in closets, and two full bathrooms. A small library alcove overlooks the living room below, adding additional flexible space. The lower level walkout offers an exercise or game room, storage room, and a utility room with additional storage capacity. Numerous windows throughout the home provide natural light and take advantage of the mountain views. An attached three-car garage with direct entry includes a dedicated workspace area.
Description:The one you’ve been waiting for! This beautiful 3-bedroom, 3-bath home is perfectly situated in sought-after Hanover, NH a town known for its vibrant downtown, scenic trails, and warm community feel. Move-in-ready and full of light, this home blends charm, comfort, and convenience in every detail. The well maintained landscaping surrounds the home with mature trees and colorful gardens, creating a peaceful setting. Enjoy the large front deck, ideal for morning coffee, summer dinners, or simply soaking up the sunshine. Inside, the bright, open layout welcomes you in. Spacious rooms feature wonderful natural light, and the finished basement offers flexible space for a family room, home office, or guest suite. Every corner feels cared for and ready for you to make your own. With its inviting style, easy walk to downtown Hanover, and thoughtful updates throughout, this is a home that truly captures the best of Upper Valley living.