I enjoyed staying at Trevor's Airbnb. It had an amazing view of the Yaletown marina and it's walking proximity to restaurants, shops and Granville market (easily accessible by the Aquabus) made for a very comfortable visit.
I would highly recommend!