Monthly mortgage payments in the city came in at £510 a month – about 16% of the area’s average monthly salary