Great little base for exploring Vancouver. You’re close enough to downtown, kits and Granville. Close to some (pricier) grocery shops, places to eat and good transport links.
We stayed for a month and were comfortable - the apartment has all the basics you need, a huge comfy bed, and Ishtar was very responsive and helpful.
The noise wasn’t as bad as we expected from the hospital but you are on a busy intersection so bear this in mind if you want peace and quiet.
It’s pricey but was the best value place we could find on Airbnb so competitive for the area.