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:Open House 10/5 12-2, visit this spectacular new home! Ready for immediate occupancy! Located just a mile from Mt. Sunapee ski area and adventure zone and 1 mile to State Beach. Be dazzled by the large open plan with soaring vaulted ceilings! Prepare memorable gatherings and meals around this 6 Ft. Elegant Corian island. Relax in the tranquility of a partially wooded backyard and grill on the deck. The front porch may be where you enjoy a morning coffee...Single-story living, gracious primary suite with custom tile shower, walk-in closet, and double vanity. Bring your toys; the three-stall garage is heated and thoughtfully equipped with shelving for your storage needs. Radiant heat in the entire house will keep you cozy on those cold winter days. Natural light streams through the many windows. Located within a 5-mile radius are at least five dining opportunities and local entertainment. Agent interest