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 Currently there are no listings for Our Listings NH Condos

Sorry No Results were found
change property type or
click back button to search again.
or Change Town

Our Listings NH Condos $0 to $30000000