The space is done very nicely and we were super comfortable there for a week. Really a perfect little space that was very clean and liveable.
It is relatively accessible to different parts of the city. Weather permitting you can walk to Gastown and Downtown (20-30 mins). The area between the apartment and Gastown is the HQ for Vancouver's housing disadvantaged. So it's a bit rough in places but we never felt any danger and you can avoid most of it by not walking on East Hastings. We also took the bus a few times and you have some characters riding along but again nothing sketchy. It's uncomfortable and unfortunate to see but we shouldn't hide from the reality that others are living. There were some cool bars and restaurants in the area on Commercial Drive to the East (20min walk).
We were up early every morning with the kids upstairs stomping around. Which was fine for us because we were working anyways and we already knew when we booked. If you're not chill with that then it's not for you.