If you're looking for a really good Waterfront place to stay, this is it.