SELECT Id FROM new_searchtable
where (lister_office_name='Granite Northland Associates' ) and type ='T'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Our Listings NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Lakeview Condominiums ~ you will feel like you are on vacation with these amenities: tennis courts, pickle ball, pool, walking trails, and access to Mascoma Lake shared sandy beach. Having two bedrooms, two baths, open-concept kitchen, dining, living sliders to your patio with a great view of the lake. A propane stove making it toasty on cold nights. Lakeview is pet friendly and an easy commute to the Upper Valley.