Renovated Waterfront Stunner