SELECT Id FROM new_searchtable
where town = 'Enfield' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Enfield NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Crystal Lake Front! Don’t let the modest roadfront facade deceive you. This charming 3,000+ sq ft lakefront cottage expands into three inviting levels overlooking beautiful Crystal Lake. Enter through the spacious mudroom into an open-concept kitchen, dining, and living area designed for easy gathering and everyday comfort. The space flows seamlessly into a heated, insulated sunroom perched above the water’s edge, where panoramic lake views can be enjoyed year-round. Also capturing the stunning scenery on this level is the generous primary suite with a private ensuite bath, allowing for comfortable one-level living while hosting family and guests on the levels below. Down a level you’ll find an oversized ensuite bedroom, large family room with fireplace and al fresco porch—perfect for relaxed evenings by the lake. The lowest level offers a large partially finished space with another bath and workshop, ideal for recreation, hobbies, or guest overflow, with direct walkout access to the waterfront.Three exceptional levels designed to capture the beauty of the lake and make the most of lakeside living. Conveniently located just a short drive to Dartmouth College, Dartmouth Hitchcock Medical Center, and several area ski resorts.
Description:DRUM ROLL PLEASE!! A pleasure and a privilege to introduce this GEM - AIA Vermont Design Award 2004 winner. The design and cleverly sited Contemporary waterfront home embodies flair, creative use of space, ingenuity, workmanship, charm and a WOW factor from the minute you enter the door. Light filled, open floor plan on the main level with great large windows, living room with two-way fireplace, with black marble lintel, extends the indoor to outdoor living space on an amazing screened porch complete with views to the Lake and the Knox River at Shaker Boulevard!! AND THEN The Cottage House!! This is another GEM, totally renovated with a well thought out floor plan consisting of one bedroom, kitchen, living/dining area, 1.5 bathrooms, full basement and an amazing wraparound porch with VIEWS, up the Lake and all around!! To describe the setting: Private, level, beach area, docks and an estuary to watch the birds and ecosystem of life survive. This is a must see!!