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 50
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:42 HIGHBRIDGE- Sited in one of the most desirable locales in Lyme, this stunning reproduction colonial is nestled on 21.30 private acres with gorgeous northerly views. The interiors are bright and well-appointed with a sizable chef's kitchen that steps down into a formal dining room surrounded by windows and a walk-out to the landscaped grounds and gardens. Adjoining the kitchen and dining room is an expansive living room with wood-burning fireplace which opens through French doors to a lovely covered porch/patio and in-ground swimming pool. Rounding out the first floor is a light-filled office to the front of the house and a functional laundry/mudroom entry from the breezeway to the attached two-car garage. An en suite primary bedroom with wood-burning stove on the second floor is complemented by two additional bedrooms with a shared bath, while a versatile open space on the uppermost level is perfectly suited for a rec room or additional living space. Above the garage is a generously-sized accessory studio with a kitchenette, 3/4 bath, and its own private entry. The renovated sugar shack is incredible. The grounds are a lovely mixture of landscaped gardens and lawns and curated mixed forest, all of which overlooks the gorgeous long-range vistas. Located just minutes from downtown Lyme and a short drive from Hanover, Dartmouth College, and area schools, this property offers the convenience of proximity coupled with the luxury of privacy. Note: Some photos virtually staged.
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.