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 SuitableUse like '%Horse%' and SuitableUse like '%Horse%'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:HERMIT HILL FARM- One of the most rare and spectacular estates in the region, the property sits on 700 pristine acres minutes from Lyme Village and a very short trip to Hanover, home of Dartmouth College. The farm has been in the same family for generations. The area around the main house is idyllic, with rolling fields, a large swimming pond with beach, apple orchard, gorgeous landscaped grounds, quaint barns, and western views from several areas. The farm operated as an equestrian estate for many years and has a 11-stall central barn with solar array, large indoor riding arena, outdoor arena, and fenced paddocks with run-in sheds. There are miles of trails to explore the property, perfect for hikes, walks with the dogs, snowshoeing or x-country skiing, ATV riding, and mountain biking. The main hill on the south side of the house even once had its own ski-tow, later replaced by snowmobiles. The main house is spacious and sophisticated and has been expanded over the years to include a private bedroom wing and large great room for family gatherings. There are 5 bedrooms and 5 baths in total. The historic details of the interiors are beautiful– warm woodwork and original paneling with modern sophistication such as radiant flooring and top of the line appliances. The farm is in conservation but allows for potential subdivision and there is significant timber value. This farm is a true New England gem and needs to be experienced. Note: some interior photos were virtually staged.