Let me start by saying that the information and pictures provided in the advertisement are very accurate (which is something I do not often experience).
Overall, I had a very comfortable stay. I rented the apartment while I was a visiting researcher at UBC. It's a perfect place for someone visiting UBC -- 5 mins walk to the bus stop and then roughly 10 mins by bus to UBC. There are also direct buses to Vancouver downtown. Public transport to the airport is a bit inconvenient, but since the airport is quite close, it is preferable to take a taxi (the taxi fare is not that much, about 30 CAD).
The Dunbar street neighbourhood is very nice and safe. The apartment itself is quite spacious for two people. The bedroom, as advertised, is actually quite big, and the kitchen is fully equipped with all the necessary utensils and kitchenware.
Kate and Edward are very good hosts too, always ready to help in case of any problems. They also provided me and my wife with bikes and helmets (unfortunately, the weather was too cold for us to bike).
I guess the only downside was that the apartment is a basement suite, but this is something I knew beforehand (so no complaints as such).