[smartician]

I don't think what you're asking for is too unrealistic if you're willing to adjust your price range a bit. This one looks like it would fit the bill:

https://sfbay.craigslist.org/pen/apa/d/only-1-studio-availab...

It's just across the train tracks from downtown, Safeway and a Mexican supermarket are close by.