The Urban Ore Ecopark in Berkeley/Emeryville. To some, nothing but a huge junkyard. To others, a treasure trove of oddities. You can get a door, a mantel, a claw-foot bathtub, or maybe a vintage side table. It's pretty random and bizarre but definitely cool. If you're into old stuff.
And, Lake Merritt in Oakland.