The apartment has been beautifully renovated. Niels provided a comprehensive list of recommendations nearby. There are two more rooms listed, so it feels more like a very nice guesthouse rather than a private home.
It is a little bit on the "wrong side of the tracks", ie. Interstate 80, from downtown, but that puts you closer to Oracle Park. All in all, a pretty convenient location.