SELECT Id FROM new_searchtable
where ( town like 'Enfield' or town like 'Canaan') and (type = 'R' or type ='O')
and (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Canaan Enfield NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Your NH retreat awaits! Set on 5.5 private acres in a quiet rural setting, this well-built 2008 log home offers the warmth and character so many buyers are looking for. With 3 bedrooms and soaring cathedral ceilings, cherry and red oak hardwood flooring, the home feels open, comfortable, and connected to its natural surroundings. Recent improvements include a new heating system, adding efficiency and peace of mind. A large wraparound deck creates great outdoor living space for relaxing, entertaining, or taking in the peaceful setting. The property abuts conservation land with established trails, giving you direct access to hiking, snowshoeing, and year-round outdoor recreation right from the backyard. The location offers a nice balance of privacy and convenience, with close proximity to Dartmouth/Hanover Center, Mt Sunapee, Whaleback, DH Medical Center and all Upper Valley amenities. Close to Mascoma Lake town beach, Crystal Lake and boat dock. Access to four ponds near property. Whether you're looking for a year-round home or a getaway in New Hampshire, this property captures the classic feel of log home living in a beautiful Enfield setting.
Description:APPLEWOOD FARM- Well-maintained, newer construction home in an idyllic setting with stunning westerly views and sunsets. This picturesque property features a substantial apple orchard on the west side of the land and is sited within a neighborhood of lovely homes. It is located just minutes from Goose Pond to the west and Canaan Street Lake to the southeast, home to the prestigious Cardigan Mountain School. The home’s bright interior spaces are thoughtfully designed to capture the surrounding mountain views and natural landscape. The main level offers a spacious open floor plan, where the well-appointed kitchen flows seamlessly into the dining area and large living room, while a recently updated sunroom to the north provides a peaceful place to relax. This level also includes a spacious primary bedroom suite with beautiful finishing touches and a large walk-in closet. On the second floor are two bedrooms–both positioned to take in the views–with generous walk-in closets and a shared centrally located full bathroom. The partially finished walkout lower level is versatile as recreation or entertainment space and includes a den/theater room, private bonus room, and a ¾ bathroom. Outside, the wraparound west-facing deck includes a hot tub from which to enjoy the landscaped grounds and vistas in every season, while a charming detached barn provides parking and additional storage. Nestled in a former apple orchard with over 80 beautiful mature apple trees the property also includes blueberries, raspberries, blackberries, cherries, and Christmas tree plantings. And the large barn combined with over 6 open flat acres in a country setting makes this property ideal as a hobby farm. Conveniently located for an easy commute throughout the Upper Valley including Hanover, Lebanon, Dartmouth College, and Lake Mascoma.
Description:GREEN EAGLE LANDING, Incredible setting right on the water’s edge of Canaan Street Lake, this turnkey Gambrel sits on 2.9 acres with a second abutting 8-acre waterfront parcel. The views are expansive, stretching up the lake toward Cardigan Mountain School, across the reservoir, and toward distant long-range hills and mountains, including Smarts Mountain and Holt’s Ledge at the Dartmouth Skiway. The Timberpeg construction creates a warm, inviting, open-concept interior, featuring a well-appointed kitchen on the main level with plenty of storage in the adjoining pantry entry. The adjacent dining room captures beautiful views over the water and opens to the exterior deck, while the living room—anchored by a central wood stove and a cozy corner perfect for unwinding at the end of the day—connects seamlessly to the dining area to showcase the impressive vistas. Completing the level is a laundry area and 3/4 bathroom. Upstairs, the cathedral ceiling creates a bright, spacious setting for three bedrooms—a generously sized en suite primary and two additional bedrooms that share a central bath. Outside, the large deck is ideal for entertaining, gathering, and enjoying the surrounding landscape, while a nearby screened gazebo provides the perfect spot for dining or playing cards. Just steps away, a dock extends into the water with a landing for boats. There is a large detached shed for additional storage, as well as ample parking. The property is an easy drive to Hanover, Dartmouth College, Dartmouth Health, Lebanon, and surrounding Upper Valley communities.
Description:Gorgeous New Hampshire Lakefront! Wake up to breathtaking unobstructed views of Mascoma Lake in this beautifully situated Shaker Village home. Located across from the peaceful Shaker Museum walking grounds, this end-lot offers privacy while still being part of the sought-after Chosen Vale community. Outdoor enthusiasts will love the easy access to boating, swimming, ice fishing, skating, sledding, snowshoeing, hiking trails in the Lower Shaker Wildlife Management Area, and nearby skiing at Whaleback Mountain. This home boasts direct access to a dock slip and is just a short walk to two shared beaches. Additional features include heat pumps, Powerwall backup battery system, electric vehicle charger, and recently installed on-demand boiler. Conveniently located just 15–20 minutes from Dartmouth Hitchcock Medical Center, Dartmouth College, and White River Junction, this property offers the perfect balance of lakeside tranquility and accessibility. Open house Fri 7/10 3-5pm and Sat 7/11 10am-12pm
Description:Super Sunsets on Crystal Lake! This private 2006 lakefront home offers 112' of pristine waterfront with 3 bedrooms, 2 baths, cathedral ceilings, and an open-concept living area filled with natural light and stunning lake views. The finished walkout basement provides extra space for family and guests, while the full-length screened porch, lakeside deck, grassy yard, and established docks make outdoor living easy. A drilled well, storage shed, and shared ownership of 21+ wooded acres with trails across the road complete this exceptional property. Location, location, location!