There is a clear divide in terms of housing affordability between the north and south of the country, a new study reveals.