First-time buyers hunting for a bargain could do a lot worse than this old mining town, named the most affordable place in the UK to put down roots.