With a mix of old and new, No 148 Lower Glanmire Road, Cork, has a lot going for it, writes Tommy Barker.