Housing affordability has fallen to the lowest rate on record, with households earning a typical income only able to afford around one in every 10 properties sold across the country in the last financial year.