Denis was a really wonderful host. He greeted us as soon as we arrived, let us in and showed us around. He offered up several maps and tips for the city along with a few tips for the flat. Unfortunately I got extremely sick during our stay (nothing to do with the flat) so I did not get to experience much of Dublin but before I got sick, it was clear that the location of this place was great. There are a few little pubs, stores and grocers in the neighborhood. I'd recommend The Hut pub just two blocks down the road for some friendly conversation and a pint.
While I was sick, my wife was able to walk to the more tourist-sentric locations (Temple Bar and Trinity College area), its not a super short walk but can definitely be done. I'd imagine it would be a cheap cab ride or bus trip too.
There was some snacks and food provided (eggs, bread and fruits along with coffees and teas). The flat is sort of a basement but seemed to get really good light with full windows in the front and rear.
When I wasn't able to find the power cord for the DVD player and Denis came down right away to get me all set up. He then also offered me his mother's "cure all" for a stomach ache...red lemonade. When I told him I had never had it, he ran upstairs and brought me down a bottle. I like to think it contributed to me kicking the stomach bug.