A spacious bay fronted mid terrace situated in a former mining town created a flurry of interest when it went up for auction