Overall a good place to stay. Great location.
The building is a bit dated but the apartment itself is in good shape. Person who did the pictures for the place should get a bonus though. The place (specifically living room) is actually much smaller than it feels on the pictures.
Check-in process is a bit cumbersome as you will need to pick up the keys at 7-11 nearby. It is not too far away from the place but if you have luggage it will be a fairly meh experience if you are walking to 7-11. It is on a busy street and there is no parking either if you are driving. We were driving and were able to park at the gas station a block away from 7-11 and I ran to pick up the keys while my wife was ready to move the car if someone asked.
Smaller things: there is a coffee machine in the apartment, but it is on the fancier side and takes pods instead of regular coffee. There are no pods available so you will need to buy them if you would like to use the machine. As an alternative there is a good coffee place a few blocks away.
Overall if you are ok with a smaller place for a 2 bedroom and got the idea of what checkin/checkout will look like for you, it is a good option to stay in Vancouver.