We visited for a little less than a week and it was perfect for us. It had all of the supplies we needed and was a 2 minute walk to the grocery store, so it's in a very convenient location. We stayed in the summer so we were able to walk to the train station without any issues! Vancouver happened to have a heat wave when we arrived, so it was a little hot without any air conditioning, but it cooled down during the night making it comfortable to sleep.
All in all, great place to stay!