I'm moving to San Francisco this summer, and it's becoming painfully obvious to me that the bikes I have are completely impractical for riding in The City. I currently ride either a 1987 GT Performer, a 1991 Bridgestone City Limit, and a 1960-something Schwinn Collegiate. Riding a freestyle bike daily isn't going to work in San Francisco's terrain, and the Schwinn is too heavy, with too few gears. The Bridgestone is awesome, but way too small. I'm looking for something to use for around-town riding, and I'd prefer something old and funky over something new and shiny. Budget? $500 or less. Preferably much less. I'm a cheap bastard.
So, what would you recommend? All I really care is that it's a realistic, do-all city bike.