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 ='C'
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Commercial Listing page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Discover this extraordinary investment opportunity from a Motivated Seller at Mascoma Lake, offering a 21-unit portfolio consisting of 3 prime locations on NH Rt. 4a. The portfolio includes two single-family waterfront homes located at 117 and 125 NH Rt. 4a, providing stunning lake views and private beach access, perfect for year-round enjoyment. Adjacent to 117 NH Rt. 4a is a versatile 11-unit multifamily property, featuring waterfront apartments, with large trex deck overlooking the lake. It has its owned beach access, offering tenants direct lakefront enjoyment and enhancing its rental appeal. Across the street at 118 NH Rt. 4a, are 8 townhomes, each with 2-3 bedrooms. They offer immense potential for a condo conversion, making this an exciting opportunity for developers or investors. Whether you’re looking for a long-term rental income opportunity or a chance to develop a premium lakeside community, this portfolio delivers with a blend of residential and multifamily potential. Don’t miss your chance to own a rare slice of Mascoma Lake living.