If you want to be walking distance from anything you might want to do around the center of Cork, this place is perfectly situated. Bus and train stations are easy walks, and you have tons of dining and entertainment options on the street below, let alone elsewhere in Cork. Gastropub below was quite nice and good service - book in advance for supper.
Two cautions: it’s 50+ stairs up to the flat from the street so pack light, and this is a busy street so expect street noise at night. Neither we’re problematic for the three of us (my wife and I and our college age daughter) - we loved our time in Cork.