SELECT Id FROM new_searchtable
where town = 'Hanover' and state='NH' and (type = 'R' or type ='O')
and SuitableUse like '%Horse%' and SuitableUse like '%Horse%'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Hanover NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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.