Aaron and Anna's place was my HQ in Vancouver while establishing myself in the city, and I was pretty lucky to find it. Central location with enough stuff around (not super walkable, but you'll find everything needed), and getting around the city is easy with transit or bike (try Mobi).
I appreciated their friendliness, though as others mentioned, you'll often have the place to yourself. Last but not least, I must mention the great view of Vancouver, the creek and the northern mountains!