SELECT Id FROM new_searchtable
where (town like 'Lyme' or town like 'Enfield' or town like 'Plainfield' or town like 'Cornish') and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley NH Homes page 45
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This waterfront gem has been thoughtfully enhanced with numerous recent improvements, including a newly winterized sunroom that adds 264 square feet of light-filled living space with sweeping water views. The updated exterior façade, new privacy fencing, and improved stairway leading to the private sandy beach and swimming area further elevate the property’s appeal. Offering ~3,000 sq ft across three levels, this home features 2 bedrooms plus a bonus room, 3½ baths, and flexible living areas. Enter through the generous mudroom into an open-concept kitchen, dining, and living area designed for both everyday comfort and effortless entertaining. This inviting space flows seamlessly into the newly heated, insulated sunroom perched above the water’s edge, where panoramic lake views can be enjoyed year-round. The lower level offers a full bath and two oversized rooms ideal for bedrooms, office, or family space, both with walkout access to the lakeside deck. The lowest level includes a partially finished area, full bath, workshop, and direct walkout waterfront access. Conveniently located near Dartmouth College, Dartmouth Hitchcock Medical Center, and premier ski resorts. This is the ideal year-round lakefront paradise.
Description:Rarely does an estate offer such an incredible convergence of residential potential, commercial agriculture, and investment opportunity. Spanning 81± surveyed acres with mountain views, brook frontage, a waterfall, and a private pond, the property features a custom 3,672± sq. ft. residence built in 2001 and first occupied in 2021. Offering a great design and layout with unfinished spaces ready for your finishing touches including the option to customize flooring using timber milled right from the land. The light-filled home boasts an open-concept layout, marble countertops, custom cabinetry, four bedrooms (or office options), passive solar design, four-zone hydronic heat, and expansive decks. Beyond the primary residence, the estate offers world-class commercial infrastructure powered by a high-capacity 100 GPM well. Included are four Dutch glass greenhouses for year-round growing plumbed for geothermal heating system, a nearly 4,900 sq. ft., two-story commercial warehouse with 600-amp power, upgraded transformer independent grow rooms, and high-efficiency climate controls. Farm-ready features include a 2-acre cut flower field, fenced pasture, chicken coop, separate commercial access drive, and a tiny home/employee site with existing utilities. With extensive recreational trails, mature timber, agritourism/event venue capability, and subdivision potential (subject to approvals), this exceptional retreat offers limitless opportunities for a family compound, specialty farm, or wellness sanctuary.
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!
Description:A luxurious waterfront property in Eastman located at the end of a cul-de-sac offering the utmost privacy and seclusion. This home boasts an exceptional location with stunning views of Eastman Lake from its elevated position. The design of the house takes full advantage of the scenic surroundings, featuring walls of glass with all new sliders that open up to a spacious deck, creating a seamless indoor-outdoor living experience. The interior is thoughtfully designed with an inviting floor plan. It includes a bedroom suite with a generously sized bathroom, a great room, and family room, all adorned with cozy fireplaces. The three bedrooms in the home offer breathtaking views and can be enjoyed in all seasons. Living in the Eastman Community provides an opportunity to embrace an outdoor lifestyle, taking advantage of the surroundings and the proximity to walking trails and the lake. Enjoy tennis, pickleball, golf, XC ski trails, an indoor pool, fitness center and more. Whether it's watching the sunset from the comfort of your home or indulging in various outdoor activities, this residence offers a remarkable waterfront living experience.
Description:Looking for a property that truly has it all? Look no further than 376 Orford Road, in the coveted town of Lyme, NH. With 4,500 square feet of wonderfully comfortable and functional living space, the first floor offers a primary en suite bedroom, 2 additional bedrooms and bathrooms, a large living room, spacious eat-in kitchen, mudroom and laundry. The lower level includes a media room, recreation room, exercise room and office. Attached to the main residence, and with its own entrance as well, is a two story auxiliary dwelling unit equipped with a full eat-in kitchen, living room, laundry, 3/4 bathroom and private deck - ideal for in-laws, a nanny or rental opportunity. The back of the home connects to the level, landscaped, and fenced-in backyard area with a deck, in-ground pool, and pool house - ideal for relaxing or entertaining. The oversized 3 car garage has an upper level that could easily be finished off for additional living space, or is ideal "as is" for a home office or business storage. The abutting conserved land offers lovely pastoral views and westerly sunsets. Rounding out the property is another large outbuilding and separate shed for all your storage needs. Lyme is home to one of the most highly rated K - 8th grade schools in the state and is a short drive to Hanover, Dartmouth College and Dartmouth Health. Don't miss this incredible opportunity for a property that has everything you want, and more.