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 '1000000' AND '99999999'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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.
Description:Waterfront home in Eastman with Lake Views! Vaulted ceilings and skylights create a light and bright atmosphere throughout this contemporary 3-bedroom, 2.5-bath home. The living room features a beautiful fireplace and french doors opening to a large deck spanning the back of the home with lake views. A spacious family room with cathedral ceiling provides another gathering space for movie and game nights, and it opens to a three-season porch overlooking the water. The open kitchen with stainless steel appliances and an island with breakfast bar seating leads to a formal dining room. The first floor primary bedroom suite with bathroom boasts a large walk-in closet and its own deck access with water views. The walkout lower level is partially finished and includes 2 bedrooms and a full bath. Convenient 1st floor half-bath and first floor laundry. Large mudroom with direct entry to the attached 2-car garage. All vehicle electric charger in place. Just steps to North Cove Beach! Other amenities include well-maintained hardwood floors. mini splits, and a stand-by generator. The Eastman Community offers year-round recreation. Lake activities, golf, cross-country skiing, tennis, pickleball, an indoor pool, exercise facility and more. Located in the heart of the Dartmouth - Lake Sunapee Region.
Description:A private 16+ acre setting with views of Mt. Ascutney, a pond, barn, and open land to explore make this Plainfield property a special Upper Valley retreat. This home was completedly renovated in 2019. Large windows throughout the home bring in natural light and take full advantage of the surrounding landscape. The main level features a primary suite with walk-in closet and a spacious bath with soaking Jacuzzi tub and separate shower. The kitchen is well equipped for both everyday living and entertaining, with quartz countertops, a Thor Professional gas range, and generous cabinet and storage space. The open kitchen, dining, and living area creates a comfortable central gathering space for family and friends. The finished lower level adds great additional living space with a custom bar, pool table area, office, and exercise room—ideal for entertaining, working from home, or relaxing at the end of the day. Outside, two decks offer inviting spaces for outdoor dining and gathering. Spend summer evenings enjoying the peaceful setting, relax in the hot tub under the stars, or gather around a fire by the pond. In winter, the pond becomes a perfect spot for skating. The property also includes a barn, chicken coop, greenhouse, 2 sheds, treehouse and open acreage to explore. A two-car garage plus additional garage space provides plenty of room for vehicles, equipment, workshop and hobbies. Located just 7 miles from I-89, the property offers an easy commute to all Upper Valley employment while maintaining the privacy and space of a rural setting.
Description:Set on 6 private acres on the highly desirable Stevens Road, this exceptional Hanover home offers breathtaking westerly views into Vermont and toward Killington Mountain, creating unforgettable sunset backdrops from the expansive deck. The location is ideal—close to Dartmouth Hitchcock Medical Center and just minutes from the Etna Country Store, combining convenience with peaceful surroundings. The thoughtfully designed main level features a kitchen and dining area, spacious family room, living room, small office, and a cozy den that could easily serve as a first-floor primary bedroom with its own private bathroom, offering flexible living options. The second floor includes three bedrooms, a finished bonus room over the garage, and a dedicated storage room. Additional highlights include a two-car garage, ample storage throughout, town sewer, and beautifully landscaped grounds that maximize privacy while showcasing the stunning views. A rare opportunity to own a scenic and versatile property in one of Hanover’s most sought-after locations.