Burnt-out eyesore in Harrogate: Hopes grow of 'prestige' red