Previously ranked one of the most unaffordable places to live in the UK, the city has reported 111 new affordable homes will be built.