ExXB,
A warning.
Last year, I arrived at Calgary late at night, took the shuttle bus to my pre-booked hotel and the next morning I went to pick up my pre-booked rental car at a non-airport location.
This is where I discovered the scam. I was required to sign a declaration that I had arrived more than 24 hours previously, otherwise I would have had to pay the inflated airport rental rates!
Also, you may want to say you are dropping off at the same location and then just drop it off at YVR.
Finally, the CDW is a rip-off. Check your personal insurance and/or your credit cards, which may give you rental car insurance. I've saved thousands of dollars over the years, by declining the CDW.