Good apartment, especially for a longer stay. My family stayed for almost 2 weeks while I was between jobs in the area. Kitchen is well stocked in some ways, but missing a few key things. We managed okay and appreciated having a place to cook. We were surprised and delighted by having a coffee grinder, but there weren't any baking sheets, for example, so we had to adapt some of our planned meals for the stovetop.
Apartment gets hot during the day in the summer, but I've stayed/lived in worse in the Bay Area. Two fans were provided, one was super powerful. The big bed was memory foam, which is not my fave and extra sweaty in the summer, but it's probably plenty comfy for many other people.
Lots of space in the main living/dining area, which was great for our kiddo to play while we worked during the day. Construction noise next door was intermittent. Very loud (throwing things off a second floor balcony into a dumpster) maybe 2-3 days of the 9 weekdays that we were there, no work at all on some of the days as well. Overall not a problem for us.
Neighbourhood was quiet, with lots of places nearby to walk for takeout as well as groceries and essentials. Parking was easy during the day, a little more difficult the times that we came back in the evenings. We didn't take any transit on this trip, but I saw buses while we were out walking. Highway access is great.
Overall a decent value for the Oakland area.