=> for-rent
 => Winnipesaukee%20River
 => NH
 => Commercial%20Lease
SELECT Id FROM new_nnerenrentals
where (town like 'Winnipesaukee River%' or water_body like 'Winnipesaukee River%') and state='NH' and PropertyType ='Commercial Lease'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price ASC
Winnipesaukee River NH Rental Properties page 0
603-393-7227 348 Intervale Rd
Gilford NH 03249
Viewing Commercial Lease Change Town change to Winnipesaukee River NH Rentals by Type