The flat is very central and a great starting point to explore Cork City. The host, in our case Tracy, was always on hand to answer questions or bring anything we needed.
As other reviews mentioned, it does get very noisy because of a number of clubs in the neighbourhood.