I booked Joseph's place for a full month when I first moved to Vancouver. The apartment was perfect for me; it had everything I could need, it had a great location with lots of access to transit (sky train station is around the corner), and there were plenty of restaurants and shops nearby for me to shop for food from.
the apartment is also part of a residential complex which offers a nice pool which opens until midnight, a gym, a jacuzzi, and a lovely courtyard.
the only downside about this place I could think of is the how load the street the apartment is on can get at some hours of the night and the early morning, but that's about it.
Would recommend this place for both short and long-term visits.