Flight
You could also fly into SFO (San Francisco International) or SJC (San Jose), but these are both farther.
House Or Rental
If you haven't used it before, it's pretty simple. You're renting other people's houses. Here is a tutorial on how to use it: https://www.youtube.com/watch?v=ZoxKQpl3fCQ
Hotel
We did some research and it wasn't worth it to do a group rate. You can look at these hotels, or other hotels close by these areas, to help you decide where you want to stay. La Quinta Inn & Suites (by the Oakland Airport) - http://www.laquintaoaklandairportcoliseum.com/ Waterfront Hotel (in Jack London Square) Clarion Hotel (Downtown Oakland) Courtyard by Marriott Oakland Emeryville (in Emeryville) But AirBnB seems to be the most economical ;D