The condo is exactly as described by the photos.
I recommend renting a car or being prepared to walk (about 1.5km to Granville St.) or take public transit to get around.
The host was very honest about the location. It is in a state of gentrification and a walk toward West Hastings will include some obvious signs of disparity. However, the condo itself is great, there are a few cool coffee shops and breweries near by, and the overall value for money is great.