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 '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Discreetly tucked away to ensure privacy and leisure, this Mascoma Lake estate has it all. A rare opportunity on Mascoma Lake, this property has a grandfathered boathouse to store all your toys. Leading you out of the boathouse is your own personal dock. When you aren’t on your boat exploring the lake, sit on the oversized deck and soak in the views. An ideal location for hosting all of your get-togethers. The 180 degree views from every room allows pure natural light to permeate through this home. With the ability to connect to the town sewer system, this 3 bedroom home has the opportunity to be a 5+ bedroom home. Should you seek an in-law suite/studio, there is a bonus suite on the upper level that is plumbed for a kitchen. The basement contains finished space with a partial kitchen, allowing convenience for your hosting needs. This is luxury living.
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.