Research has revealed the UK town which is most expensive to buy a home in but is still a popular staycation spot for Brits.