SELECT Id FROM new_searchtable
where (water_body like 'Sunapee%') and (type = 'R' or type ='O')
and subdivision like'%White Shutter Association' and subdivision like'%White Shutter Association'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Lake Sunapee NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Experience true lakefront living in this charming home that’s been lovingly maintained by the same family for decades. Nestled in a prime location, this property boasts several inviting porches perfect for endless relaxation and entertainment, all while enjoying breathtaking views of the lake. A convenient dock slip for your boat allows for easy access to aquatic adventures. The boat slip will be reassigned and is not the one pictured. Just a short stroll away, you’ll find the picturesque Sunapee Harbor, where you can embark on a delightful dinner boat cruise or explore unique local shops. For those who love winter sports, you’re only minutes from skiing at Mount Sunapee. There is an array of nearby restaurants and shops to enhance your experience. Embrace the tranquility of lakefront living in a home that blends comfort, charm, and convenience. Turn-key and ready for the next generation.