Affordability was measured by comparing the average three-bed house prices with average earnings in the local area