I stayed two weeks, would have extended but it was already booked.
The one big drawback is that you can hear footsteps and running water from the unit above, so it's best if you plan to get up by 8 AM anyway, or are a deeper sleeper than I was.
An older review complained about the mattresses; I liked the big mattress, myself. It was fairly firm with some give.
The closest full supermarket is a 19 minute walk for me, but Benny's (surprisingly complete corner store, 3 minutes) and Sunrise Market (Chinese+, 10 minutes) comprise a good alternative, though they close by 6 PM.
The immediate neighborhood is quite nice (Benny's is kind of fancy, and not the only nice business near by); Hastings is skid row but is probably not really dangerous, is avoidable, and the transition is very sharp as you go south of Hastings.