Transformed a water-stained eyesore into a curb-appeal dream: find out how!