This is a fantastic location and a great apartment. It's located on a main thoroughfare into downtown but far enough out of town to offer a quiet secluded respite in the backyard and in the house. It was a short walk to the grocery, liquor store and Starbucks so everyone was easily kept happy and we found it quiet easy to jump on a bus, or grab a blacktop cab into downtown.
However things really took off for us once we rented a car, as we could then go quickly and easily all over the city, and beyond. Hitting GasTown, Stanley Park, Steveston Fishermans Wharf, and Granville Public Market just to name a few of the places we saw. So I would recommend renting a car if you really wanted traverse the entirety of Vancouver and explore; and if you want to know where to go I would recommend talking to Harvey. He's better than any guide book you might have about the area and more than happy to help. He helped make our stay a great experience And now that I've been I cannot think of a better place to stay; this apt was perfect.