SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
and subdivision like'%Mascoma Heights' and subdivision like'%Mascoma Heights'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:OPEN HOUSE CANCELLED – Perfectly positioned in the heart of the Upper Valley, this rare find offers a unique combination of privacy, convenience, and year-round recreation with Mascoma Lake steps away. Enjoy four seasons of lakeside living without the premium lakefront taxes! Nestled discreetly off the road, surrounded by mature trees, and set on a beautiful private 2-acre lot, this well-maintained two-story ranch offers over 2,800 sqft of living space, including a fully equipped detached cottage (ideal for rental income at $2K/month, or multi-generational living), and private beach access just a stroll away. The primary residence’s upper level features a spacious kitchen/dining area with scenic views of your private woods, a cozy living room with a wood-burning fireplace, two bedrooms, a full bath, and a balcony with stunning westerly sunset views over the lake. The lower walkout level has three finished rooms, a half bath, and a flexible workshop with ample storage. The detached cottage serves as a fully functional studio or in-law suite with a washer, cooktop, AC, full bath, parking, and a deck with lovely lake views. Additional features include a cute chicken coop w/ a custom-built run, two storage sheds, perennial gardens, a stone fire pit, and ample open yard space. Truly a unique property offering serene country living with easy access to outdoor recreation, minutes from Dartmouth Hitchcock Medical Center, Hanover, and Lebanon. Assumable VA Loan at 3% Interest (for Veterans only)! Seller is an NH Real Estate Agent.