Wonderful location for wandering around the city - a short walk to the Canada Line skytrain and city buses are right outside, but it's also really easy to walk around downtown, or catch the aqua bus to Granville Island or elsewhere.
The apartment itself is fine - nothing special but nothing to complain about. It's not a fancy place and the bathroom is small so if that matters to you, look elsewhere. But if you need a place to sleep and store your stuff that's decently priced and reasonably quiet, it works well.
Check-in/out was straightforward and easy and Brian answered our questions within a reasonable amount of time, which was great.