It's hard not to repeat what others have said. We had a great stay, especially convenient for us as we arrived in a Hertz rental, which we dropped off at Pacific Central station (walking distance) We also left from that station for Seatle on the train, so ideal.
Yes the area is a little run down, and a shocking amount of bums on the streets of Vancouver (esp Chinatown) but never a worry or threat. Apartment absolutely as described and pictured. Johnny responded quickly to questions (e.g we needed a fan as it was stuffy with no AC). Buses nearby (19 and 22) to the city. Get a travel card if around for a few days (like London's Oyster card).