Literally the best location. You can walk anywhere in downtown, ferries to Granville Island are close, a nice 20 min walk to Stanley Park just to name a very few.
The flat is really clean and bright.
For sure, it is noisy with the traffic, but reading the other reviews it didn't come as a surprise and could prepare for it.
100% recommended, could have not enjoyed my stay more.