Ugly duckling no more after massive three-year renovation