Home in one of Cork’s most desirable addresses is as fresh as a daisy after careful expansions and renovations, writes Tommy Barker.