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.