This urban suburb on Cork’s north side is on the way back up; so too is this much-loved home, writes Tommy Barker