Right in the middle of it all, seriously. About a half-mile walk from the AirCoach O'Connell Bridge stop (€6pp from the airport). Neighbors can be a bit noisy (both inside the building and out), and there are many stairs - but you should expect those things after reading the reviews. Pictures are legit, she provided a few drinks and plenty of toiletries, and having the full kitchen and combo washer-dryer in the place was great.
Great pad from which to base your Dublin pub getaway. Cheers.