SELECT Id FROM new_searchtable
where (water_body like 'Newfound%' and water_body_type ='Lake') and type ='M'
and subdivision like'%Bear Mountain Cove, Inc.' and subdivision like'%Bear Mountain Cove, Inc.'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Newfound Lake NH Multi Family Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:NEWFOUND LAKE FAMILY COMPOUND: Owned by the same family for three generations, this unique offering includes a year round home with seasonal cottage and 120 feet of privately owned frontage on the shores of Newfound Lake; across the street is a garage with 1 bedroom year round apartment above, next to that, another seasonal cottage and adjacent to that, another lot with two cottages in need of removal but they have been left to preserve the "grandfathered status" of the footprints. All this on 3 separate lots comprising .60+/- acres all together. The view from the main house looks out over the broadest part of the lake. There is significant waterfront development including a concrete pier in the lake that could not be done by today's standards. The lot across the street provides a place for a future septic system. This property is owned as a corporation; if a buyer was interested in continuing that ownership model the seller would transfer all the shares of the corporation. It is a model that could allow for separate ownership of the buildings: sell "Shares of the corporation" . This property offers limitless possibilities and a place for your family to make memories at the lake! Property is being sold in as-is condition. The seller shall not be requested or required to make repairs as a condition of sale. Represented square footage, room count & bath count is for only main house & apt which are both year round. It does not include square footage or room & bath counts in the 2 seasonal cottages.