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(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Just 15 minutes from DHMC, Dartmouth College, AND 12A, this thoughtfully updated ranch offers the peace and quiet of a rural setting within a wonderful neighborhood. A large kitchen (with Crown Point cabinetry, marble countertops, and newer appliances), spacious living areas, three bedrooms, and updated 3/4 primary and full hall baths complete the main floor. Downstairs you'll find another bedroom, family room, and office (all with new carpet), a full bath, laundry/workshop, and storage galore. New paint, garage door system, wood shed, Trex deck, fenced yard, mature flower gardens, and raised vegetable gardens enhance the exterior. Energy efficiency is a priority: windows installed since 2017 are Anderson 400 Low-E, a fully-owned 10-megawatt solar panel system, an electric heat pump hot water heater for domestic hot water, and a Level-2 CCS EV charger. Too many updates to name here - a full list available upon request.
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: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:Beautifully designed and meticulously crafted contemporary cape in a private country setting. Bright sunshine fills this home adding to the atmosphere of complete comfort. Large family room is open to the excellent kitchen, there is a formal dining room with more built-ins and a gorgeous vaulted ceiling living room with fireplace. Cozy sunroom completes the first floor. Upstairs there's a gracious primary suite with balcony, 2 more bedroom, a quiet study and a convenient laundry room. The grounds are fantastic with mature gardens which can be enjoyed from the spacious covered front porch, deck off the kitchen or the stone patio. A wonderful Post and Beam barn is perfect for a workshop, antique car storage or studio space. A very special offering! Showings begin Wednesday, March 12th.
Description:A beautiful and unique piece of property just a 10 minute drive to downtown Lebanon! Located on 26 acres at the top of Eastman Hill, this property provides plenty of space, privacy and spectacular views from everywhere in the house! Recent renovations, updates and fresh paint make it move-in ready!
Description:Discreetly tucked away to ensure privacy and leisure, this Mascoma Lake estate has it all. A rare opportunity on Mascoma Lake, this property has a grandfathered boathouse to store all your toys. Leading you out of the boathouse is your own personal dock. When you aren’t on your boat exploring the lake, sit on the oversized deck and soak in the views. An ideal location for hosting all of your get-togethers. The 180 degree views from every room allows pure natural light to permeate through this home. With the ability to connect to the town sewer system, this 3 bedroom home has the opportunity to be a 5+ bedroom home. Should you seek an in-law suite/studio, there is a bonus suite on the upper level that is plumbed for a kitchen. The basement contains finished space with a partial kitchen, allowing convenience for your hosting needs. This is luxury living.
Description:42 HIGHBRIDGE- Sited in one of the most desirable locales in Lyme, this stunning reproduction colonial is nestled on 21.30 private acres with gorgeous northerly views. The interiors are bright and well-appointed with a sizable chef's kitchen that steps down into a formal dining room surrounded by windows and a walk-out to the landscaped grounds and gardens. Adjoining the kitchen and dining room is an expansive living room with wood-burning fireplace which opens through French doors to a lovely covered porch/patio and in-ground swimming pool. Rounding out the first floor is a light-filled office to the front of the house and a functional laundry/mudroom entry from the breezeway to the attached two-car garage. An en suite primary bedroom with wood-burning stove on the second floor is complemented by two additional bedrooms with a shared bath, while a versatile open space on the uppermost level is perfectly suited for a rec room or additional living space. Above the garage is a generously-sized accessory studio with a kitchenette, bath, and its own private entry. The renovated sugar shack is incredible (+ approx. 285 sf). The grounds are a lovely mixture of landscaped gardens, lawns and curated mixed forest, all of which overlooks the gorgeous long-range vistas. Located minutes from downtown Lyme and a short drive from Hanover, Dartmouth College, and area schools, this property offers the convenience of proximity coupled with the luxury of privacy. Some photos virtually staged.
Description:DEER RUN- This rarest of estates is comprised of 177+ pristine south-facing acres with beautiful long-range views only minutes from downtown Hanover and Dartmouth College. The elegant federal reproduction house is spacious and well-appointed with premium finish work and attention to detail at every turn. A large open concept kitchen with eat-in dining and family space on the east side of the main level flows effortlessly onto a flagstone patio for entertaining and enjoying the landscaped views. On the west side of the main level is a formal dining room, grand living room, and cozy library. The second floor features a substantial and luxurious primary suite with bathroom, private dressing area/office, and a sizable walk-in closet. There are four additional bedrooms on this level, two of which are en suite while the other east-facing rooms share a bathroom. Rounding out the interiors is a versatile lower walkout level, perfect for a den, media room, or recreation space. The exteriors of the property are equally as stunning, with a geometric cobblestone driveway approaching the house and detached 3-bay garage, mature landscaped flower beds, stone walls, fenced vegetable garden, and separate barn for equipment, toys, and storage. Above the garage is a guest space with its own bedroom and bath. Enjoy miles of trails throughout the land component, perfect for walks, snow-shoeing/skiing, and an assortment of recreational activities.