Formulate an answer to this elaborate question: In what city does 1974 American action-comedy film Freebie and the Bean, starring American actress Valerie Harper and James Caan, take place in?
San Francisco