I live not too far from the Burnaby Cariboo RV Park. Pricey at +60.00 per night but cheaper by the week, which I believe is a 2 week min. The park is situated next to an active train (locomotive) line and beside/below from a busy overpass. Depending on how much of a light sleeper you are, the noise may be a problem.
There is rapid transit (Production Way Skytrain station) about a 10 minute walk north and up a short hill past a Costco. Going west, the Millennium Line train, with a switch to another train (Expo Line at Broadway) will take you into the heart of downtown Vancouver far faster then you could drive.
Google Maps (Earth View)