Nine council areas in the region have house prices that are affordable to those earning the average wage