SELECT Id FROM new_searchtable
where town = 'Hanover' 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
Hanover NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This is a gem: 4.3 acres on the Connecticut River with a charming, fully renovated cape. Open floor plan provides a magical living space for your family. A great porch and large patio on the river side allow you to view the occasional boat traffic and admire the spectacular sunsets. And of course your own dock provides you the opportunity for swimming, boating and endless summer fun. With 4 bedrooms, 3 baths, a full basement for storage and an oversized garage, this is a great one!