Awesome location, just a few blocks away from lake Merritt. I spent many afternoons exploring the area, walking around the lake / grand lake area. visit Baggys by the lake for a fun nightcap, or walk downtown for a concert in the city. Easy access to Bart stations with a 5 minute scooter ride (scattered all around the lake), so getting into SF is a breeze as well.
Parking is a bit of a chore (as mentioned in the listing) but I was always able to find a spot somewhere nearby, with a bit of wandering. if you don't need a car, ditching it would be wise.