SELECT Id FROM new_searchtable
where (water_body like 'Newfound%' and water_body_type ='Lake') and (type = 'R' or type ='O')
and subdivision like'%The Kelby' and subdivision like'%The Kelby'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Newfound Lake NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Introducing The Kelby Motel, a fully reimagined 10-room boutique property with deeded Newfound Lake access, set on 19.5 acres in the heart of New Hampshire’s Lakes Region. Overlooking the crystal-clear waters of Newfound Lake and framed by mountain views at the foothills of the White Mountains, this unique property offers an exceptional blend of hospitality, recreation, and future opportunity. Current ownership has completed a comprehensive transformation of the property, including new infrastructure for septic, electrical, and plumbing. While also creating a design-forward destination featuring 10 thoughtfully reimagined guest rooms, a welcoming lounge, and a full coffee shop inspired by modern Nordic aesthetics. In just two seasons, The Kelby has established a strong market presence with proven demand and consistent growth. Being offered fully turnkey, the sale includes furnishings, fixtures, equipment, the newly installed greenhouse, and a side-by-side utility vehicle, allowing for a seamless transition to new ownership. Beyond its successful hospitality operation, the property's 19.5 acres and 10-room layout provide endless possibilities for expanded uses....think future development opportunities, family retreat, events, lodging, or other creative ventures, subject to local approvals. Year-round appeal is driven by Newfound Lake recreation, fall foliage, hiking, boating, and winter activities, making The Kelby is a rare opportunity to acquire a beautifully renovated property with established income, exceptional amenities, and significant upside potential in one of New England’s most sought-after lake destinations."