SELECT Id FROM new_searchtable
where town = 'Sunapee' and state='NH' and (type = 'R' or type ='O')
and subdivision like'%Blueberry ridge' and subdivision like'%Blueberry ridge'
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:Welcome to your new home! Located just a mile from Mt. Sunapee ski area and Sunapee state beach! Ski in the winter, play in Sunapee harbor all summer, relax and enjoy lake activities at Dewey Beach. Located just under 5 min. to many local restaurants and pubs. Foundation is in! This new home features vaulted ceilings, a deck for relaxing and spending time with loved ones taking in the outdoors. You will love the warmth of radiant heat after a day of skiing, drop all your gear in the heated garage. This home offers open concept living with great space for entertaining your guests. Buyer may choose flooring color, cabinet layout, windows (up until framing). Completion is aprox. 6 months from accepting contract. AGENT INTEREST Interior pictures represent other similar homes built by same builder.