2 bed apartment overlooking water