Array ( [0] => [1] => for-rent [2] => Winnipesaukee%20River [3] => NH [4] => Commercial%20Lease [5] => )
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