SELECT Id FROM new_searchtable
where town = 'Hanover' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Hanover NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This is a gem: 4.3 acres on the Connecticut River with a charming, fully renovated cape. Open floor plan provides a magical living space for your family. A great porch and large patio on the river side allow you to view the occasional boat traffic and admire the spectacular sunsets. And of course your own dock provides you the opportunity for swimming, boating and endless summer fun. With 4 bedrooms, 3 baths, a full basement for storage and an oversized garage, this is a great one!
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.