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 (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to your new home in Hanover! This stunning new construction boasts a spacious open floor plan, perfect for entertaining guests or enjoying quiet nights at home. With first floor laundry hookups and maintenance-free living, this home has all the modern conveniences you could ask for. Located just minutes away from Dartmouth College, Dartmouth Hospital, and multiple ski resorts, this property offers convenience and accessibility like no other. Whether you work on campus or want to explore all that Hanover has to offer, this location is unbeatable. Don't miss out on the opportunity to make this house your own - it's ready for a November move-in! Schedule a showing today and start envisioning yourself in your dream home in Hanover. Property will be complete and ready for move-in 11/30. Seller is a licensed New Hampshire real estate broker
Description:Discover your dream home in this serene 3 bedroom, 3 bathroom property set on 5 picturesque acres. A tree-lined lot provides privacy, giving you tranquility while the nearby neighbors offer a sense of community. Step inside to find beautiful hardwood floors that extend through much of the home. The spacious kitchen features stone counters, cherry cabinets, and stainless steel appliances. It connects seamlessly to the dining area, both of which are warmed by a cozy pellet stove, ideal for those chilly evenings and for reducing heating expenses! The main floor boasts a generous primary bedroom with ample closet space and a pretty 3/4 bath featuring dual sinks. Two additional bedrooms and versatile bonus rooms provide flexible living options, whether you need a home office, playroom, or guest space. Enjoy the convenient mudroom with lots of storage options, before heading out to the detached 2-car garage. Two additional sheds offer plenty of space for all your outdoor gear. Located in the sought-after Dresden School District, this home is a rare find--don't miss the opportunity to enjoy peaceful country living with modern comforts.
Description:Enjoy ultimate privacy and tranquility in this three bedroom, two and a half bath residence set on 3.8 acres in one of Lebanon's most desirable neighborhoods. Living room with gas fireplace for those cozy wintry evenings. Formal dining room plus kitchen with cherry cabinets and breakfast area with bay window to enjoy your natural surrounds. Primary en suite bedroom convenience on main level. Generously sized two bedrooms plus office on the second level. Plenty of storage and room for hobbies in the oversized garage and full basement. Large deck for your outside activities. Gardeners will certainly appreciate the greenhouse and organically cultivated raised beds plus relish in the generous harvests from the raspberry and blueberry patch. Easy drive to shopping, DHMC and area activities. Come take a look.
Description:Fantastic Mascoma Lake property with 93' of water frontage and breathtaking views of the surrounding mountains. The open layout connects a spacious kitchen, dining area, and family room with an adjacent screened-in seasonal porch to take in your dock, boat, and the expanse of the lake beyond. The interiors have recently been substantially renovated and upgraded, with a floor plan flow that accentuates the water view. There are three bedrooms upstairs, one of which is a primary suite overlooking the lake, while an office on the first floor could easily be converted into an additional bedroom. Stay warm in the winter with the pellet stove and radiant heat throughout. With so much fun on the lake leaving will be challenging, but when you do I-89 is nearby, making the rest of the Upper Valley readily accessible.
Description:Located on a rise overlooking the pastoral gateway that extends east to the village of Lyme and west towards the Connecticut River is this iconic brick cape, built and continuously owned by the famous Grant family since 1799. Now for the first time in 200+ years, this very special historic homestead is being offered for sale on 24.03+/- acres. The house requires restoration but with its high ceilings, comfortable floor plan, updated double-hung windows, full basement, new roof, and furnace, it has great bones to work with. The back wing also has potential and character worth updating, but the attached post and beam barn, with lovely old beams and barn boards, needs to be taken down, salvaged and or replaced. Outside, the land is mostly comprised of fields. Directly west of the house is a large level area with fertile soils where the Grant’s used to have a prolific vegetable garden. Further below, on the 20-acre portion that is conserved with the Upper Valley Land Trust, another field slopes down to the brook, then west. Most of the acreage is suitable for livestock. The Grant Brook Trail crosses the property and leads from the village of Lyme to the Connecticut River. Across the street is an extensive network of groomed XC ski trails. Last but not least, several abutting parcels and others within view of the house are conserved thus ensuring that the beauty of this undeveloped area will remain in perpetuity.