The property was transformed on Homes Under the Hammer with Dion Dublin spotting its huge potential