does it have water coasters?

Yes. The amusement park has the Saw Mill Log Flume. And of course, there are a lot of things to do at the waterpark, Hurricane Harbor.

Yes. Log ride like Scoott Rooney wrote. Also another water ride. There is a Water Park Hurricane Harbor

Yes, You need to buy separate tickets for hurricane harbor water park ,10 mins walk from six flags .

Yes

Hurricane Harbor is the water park for Great Adventures

Yes it does.