The extrerior shots used on the show really does look like a San Francisco house.

Is it somewhere in the city? I remember traveling to San Francisco, and while driving around, I couldn't help but wonder if the house was somewhere nearby.

Look after the thread "To King Creole". In that thread a serching after the FH House going on.