Your best bet is to work with a rental agent from a property management company who can help you find a suitable location.
If you go to Craigslist, you can find several rental agents posting their listings. Or google oakland property management companies. Choose one or two to talk with.
Also, not all rentals show up on apartments.com or homes.com. And not all rentals are apartments. I just rented my duplex to a nice lady with a medium-sized dog...and she found my place through the rental agency I used to publicize my vacancy.
Also, you may want to consider other cities besides Oakland, such as Oakland, Alameda, Berkeley --- all of which offer commuting options.