I suggest looking up on AirBNB as well, depending on your budget and comfort level/amenities you can find the perfect room/place yourself.
The skytrain services and public transit can take you to most of the scenic places you wish to visit. Enjoy your stay in Vancouver.