SELECT Id FROM new_searchtable
where town = 'Sunapee' and state='NH' and (type = 'R' or type ='O')
and wf_owned = 'Owned' and wf_owned = 'Owned'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Sunapee NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Beautiful waterfront on Mountain View Lake! Enter this warm cottage to find an open living room with large screened porch to take in the views, along with a first-floor bedroom and bathroom. Upstairs are two additional sleeping rooms. Head down a set of stairs to your waterside deck with storage shed. Mountain View Lake is just over 100 acres and offers a serene escape. Pop in a kayak or paddle board to explore the lake and enjoy the serenity of the water. This property is located less than a mile from Mount Sunapee Resort and close to Lake Sunapee. 30 minutes to Concord or the Upper Valley and 1 1/2 hrs from Boston. A short drive will take you to the town center of New London for local shopping, dining and entertainment. Close to many golf courses and hiking trails for outdoor activities. This can be your perfect escape. Come enjoy everything Sunapee has to offer!