SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:A classic Cape Cod, post and beam New England home, in one of the premiere and most desirable Hanover neighborhoods. Sited on 5.05 private acres, this spacious and stylish home has a modern open concept floor plan, high ceilings with stunning woodwork, is flooded with natural light, and is just a short commute to Dartmouth College and Dartmouth Health. Significant additions have taken place, including the large piano room, and twin dormered bedrooms. The kitchen, with custom cabinetry and generous prep space, is perfect for intimate meals or lively gatherings that seamlessly flow into the adjoining dining and living rooms. The first floor also has an office, half bathroom and laundry room, as well as a functional breezeway/mudroom combination. Upstairs, the primary suite has an en-suite bathroom and walk-in closet. Three additional bedrooms are spacious and versatile, perfect for residents and guests and are supported by a 3/4 bathroom. The bonus room is a clever flexible space that could be an additional office, gym or studio. Outdoors, the stone patio overlooks a setting for relaxation and entertaining. Seller upgrades include: a ~10 year old roof, refinished floors and a repainted exterior, to name a few. With its prime location, refined interiors, and exceptional craftsmanship, this home invites you to experience the best of Hanover living. **Septic was designed as a 3 bedroom system. Open House on Saturday Jan 18th, from 9-11.
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:Sited on a southeast-facing ridge in the hills of Plainfield, this extraordinary estate seamlessly blends elegance, solitude, and natural beauty. The private 103 acres of pristine woodlands with multiple ponds, meandering hiking and riding trails, and views of local hills and distant mountains, offers the ultimate retreat while being just minutes from Dartmouth College, DHMC, I-89, and I-91. Its location provides both tranquility and convenient access to the best of the Upper Valley, Boston, and beyond. The residence is a unique fusion of Tuscan-inspired design, Italian elegance, and traditional New England craftsmanship. Recently renovated with meticulous attention to detail, the home features a sun-drenched, flexible floor plan with five spacious bedrooms, multiple additional spaces to use as you see fit, and a guest wing. The redesigned eat-in kitchen and breakfast nook showcase modern updates, while radiant heat, wood, and pellet stoves ensure cozy warmth. Notable features such as the observation tower provide unique spaces to relax, take in the spectacular views, and stargaze. The property is designed for both leisure and function and includes a 2-bay attached garage, 1-bay under, 3-bay detached barn, and more. There's ample space for your hobbies and all the gear. Whether exploring the trails, enjoying the ponds, or hosting in the expansive living spaces, this retreat delivers a lifestyle of unmatched serenity, privacy, luxury, and sophistication.
Description:Gorgeous Lakefront! From the moment you enter this newly renovated contemporary home, you will be greeted with views and sunshine. Luxurious renovations include a high end designer chef's kitchen with Induction Wolf Range, double ovens and built-in microwave, Sub Zero Refrigerator, Bosch Dishwasher, elegant wine cooler and gorgeous counters opening to the sun filled dining area.The easy open flow and abundant windows framing the exquisite views are sure to impress you, while the quality craftsmanship can be observed in every room from the two center stone fireplaces to the custom Dana Robes built cherry shelving. Not only do you have a light bright open floor plan with main level ensuite primary bedroom/ bath and a wrap around deck overlooking the water but you also enjoy 3 other bedroom and home office options complimented by 4 beautifully renovated custom bathrooms including the primary suite bath with sumptuous sauna. The Village abuts acres of conserved land for you to explore and the local rail trail is nearby for hiking and biking pleasure. This little piece of paradise also includes an attached two car garage, beautiful stonewalls and is located only minutes from Dartmouth Health, Dartmouth College and Mt. Cardigan. (virtual staging used)
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: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.
Description:A special opportunity to acquire a dramatic contemporary on 10+/- gorgeous acres, featuring Trout Brook, a swimming hole, and a magnificent waterfall. Located in the gorgeous hills of Lyme the house was created by architect Don Metz, an early pioneer of thoughtful sustainable design. Living room has dramatic windows, hardwood floors and cozy stove. The kitchen and dining room look out to a large year round sunroom from which you can see Trout Brook. First floor also has two offices, both with lovely views. Upstairs there are three bedrooms, one with a loft, and two full baths. A further finished space in the walkout lower level has a guest room or playroom and bath. And then there is the guest house, which has a complete apartment which you can use for guests or as a rental. This is a really great listing!
Description:Welcome to this charming brick Cape nestled near the top of Pinnacle Road, a lovingly transformed retreat rich in character. Antique home enthusiasts will appreciate its unique history, incorporating part of an old schoolhouse and showcasing delightful details throughout. The home features five bedrooms, including two on the main floor, and four baths (two ensuite), offering versatile living spaces. Highlights include antique wide pine floors, original fireplaces with stone hearths, exposed beams, high ceilings, and a spacious great room with a gas fireplace. The country kitchen with a cozy breakfast nook offers views of the Green Mountains, while the formal dining room is perfect for gatherings. There are both formal and informal living areas, and numerous elements that enhance the home’s appeal. Outside, the beauty of the property extends in every direction. Facing west, enjoy long-range views of the Vermont hills and stunning sunsets. A patio off the kitchen provides a lovely spot for outdoor dining while taking in the changing scenery. Set on 10 acres, the land includes open fields, a small wooded area with a trail loop, and a stream that adds tranquility to the setting. Additional features include a detached two-car garage with storage and workshop, a pole barn for equipment or animals (or events!), and a smaller three-bay run-in shed. Perennial gardens, maple trees, and hardscaping further enhance this breathtaking location atop Pinnacle Road.
Description:This very pretty house is located close to the end of a cul-de-sac in a walk to town location, and also close to an access for the Appalachian Trail. With a large 1.89+/-ac lot, the open floor plan makes the kitchen/dining room/living room/sunroom a truly welcoming space and wonderful for entertaining. Elegant new fireplace in living room. Newer primary suite is spacious and has privacy and quiet, plus a mini split. 3-4 additional bedrooms and 2.5 additional bathrooms complete the picture. Beautiful grounds require minimal maintenance. First floor laundry. Two potential offices. Sunset views. Two car heated attached garage. A great one!
Description:A special opportunity to acquire a generously proportioned, privately situated, carefully maintained home in Hanover, NH. In 1989, a business owner and Dartmouth alum collaborated with a noted architect to construct a thoughtful residence on over 3 acres — just short of the cul-de-sac in a quiet neighborhood, roughly halfway between the Lyme Green and Dartmouth Green. Offered for the first time. This 5-bedroom, 5-bath lends itself to a multiplicity of shared living arrangements. The stucco-clad section of the house centers on a courtyard defined by stone walls. The potential large quarters above the oversized three-car garage might be ideal as an independently accessible space for in-laws or teenagers. There is a further space on the lowest walkout level of the house that has historically been used as an attractive office space. Fireplaces, rarely used in the 35 years, anchor the two separate living rooms. The atriums on each flanking end of the house help to define the unusual aspects of this home. The more dramatic atrium, accessed via the front door, floods, the house with light. The entire interior and exterior were recently painted, and newly installed hardwood floors add a fresh glow to the house. Generous storage space and closets abound. This uncluttered house is entirely appropriate for rapid occupancy and yet lends itself to possible re-imagination by new owners. Enjoy privacy and main highway access to Hanover and Lyme, and I-91 from this singular home.