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 '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 35
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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:Farmhouse with attached garage. If you need space, this is the place for you. Four level barn with over 6000 sq ft. The house has been recently professionally painted and has newer carpeting. Plenty of built ins, four seasons porch. Extra garages behind, nice open lot close to town.
Description:Discover a rare gem in the heart of Lebanon—this expansive single level 4-bedroom, 4-bathroom home is nestled on 43 picturesque acres. Enjoy stunning westerly views, ample living space, and the perfect blend of privacy and convenience. This unique property offers the tranquility of country living with all the benefits of being close to town. With several acres of open pasture land and a barn/stable the property would be well suited for horses or other grazing animals. The 10 KW solar array reduces current power demands with room for future expansion. A fantastic opportunity to create your ultimate dream home. Imagine snowshoeing, and cross-country skiing on your own land in the winter while enjoying the pollinator flowers and organic vegetable gardens by the half basketball court. The downstairs includes a library, bar, and a large space to create what you want. In addition, the property benefits from easy access to downtown Lebanon, Dartmouth College, Dartmouth-Hitchcock, I89 and I91, Lebanon Airport, and Dartmouth Coach goes to New York or Boston. Don’t miss out on this exceptional opportunity located at the end of a dead-end road! Home is being sold as is.
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.