I know what you're thinking, this place can't possibly in this good of a location, right across the street from the famous Temple Bar. It is and it's actually a good flat too. Good sitting area and view from the loft, as well as well as the full amenities of a typical flat. Didn't feel cramped like a lot of places in central Dublin.
I was pleasantly surprised at the noise level given it's location. You can definitely hear the revelers on the street from the sitting area, but there's two doors you can close to the back of the flat towards the bedroom, which very effectively shut it out.
My only cautions would be that if you have mobility issues that would limit your ability to navigate cobblestone streets and climb several flights of stairs, that might be an issue for you. However, I imagine that most of the people who would want this location don't have that concern.
You'll be able to walk almost everywhere. Only a 7 minute taxi ride to the train station if you're looking to take day trips out of Dublin. It was very easy for us. Overall a very fun stay with great access to all the pubs, restaurants and points of interest we were looking for.