no waterfront view, do not be fooled by the picture posted (it's a mural across the apartment).