Flight
SFO and OAK are the most convenient airports to fly into - just a quick BART ride or taxi/lyft to downtown San Francisco.
House Or Rental
San Francisco has a plethora of amazing airbnb rentals and hotels all around the city. North Beach, the Mission, Inner Richmond, Union Square and NOPA are great, centrally-located neighborhoods with lots of great restaurants and shops - but SF is small and pretty easy to get around, so anywhere you pick will be perfect.
Travel Note
October is one of the warmest months here in San Francisco. No fog and lots of sun! Expect warm days and cool nights.