A historical city has been named for having the street with the most expensive homes in the UK outside the capital.