I enjoyed a long term stay at Justin's wonderful and easily accessible apartment. Justin was very responsive and flexible, allowing early check in and responding to all of my inquiries. Key pickup uses a service called Keycafe which is very easy to use and does not require any in person exchange. The apartment is wonderful with a breathtaking view of the mountains and the harbour. The unit was clean and had come pretty well stocked with additional items that came in handy (drying rack to hang clothes, dishwashing tablets, hand soap, shampoo/conditioner, extra beddings etc.). The apartment is close to many options for transit (Skytrain and Buses) so getting around without a car was easy. Also easy access to local amenities like the Rexall across the street, T&T downstairs and some delicious food nearby.
Note that the apartment is close to the sports stadiums so on game night the streets can get busy with people and cars so a little bit of traffic and street noise is expected on these nights. You may also see some overflow of the city's homeless population more north on Abbott than on Keefer and their presence really didn't impact my stay at all. Also, the sounds of downtown are prevalent (ambulances/emergency services every night) so if you're overly sensitive to this type of noise, keep that in mind. But with the windows closed, it didn't impact my sleep in the comfy beds!
Overall, this was a great place to experience the city as a "local" and I would recommend this place!