Location, location, location! Honestly, the location is as good as it possibly gets. The spot is just out of the way enough that you won't have a bunch of noise or people driving or walking by, but you're literally thirty seconds away from the main bridge. From there you have access to the castle, the city center, or wherever else you want to go. It's perfect! Kilkenny is a lovely little town with an excellent selection of restaurants, pubs, and live music. I regret not spending more time there during my tour of Ireland.
The place itself was perfectly clean, cosy, and very charming. It has a cute cottage feel to it and a nice little sitting area outside as well. Catherine was always quick to answer my messages whenever I had a question.
Highly recommended!