On the street where I live
Pretty cool 1-meter-resolution aerial photos of the Bay Area at MSN's HomeAdvisor. For example, this is where I live, and here's San Francisco and parts of the East Bay. Not exactly the easiest interface to navigate in, but it helps to use the Small, Medium, and Large versions of the maps, and you can do a search on (I think) any city in the US. Images are all from the USGS, mostly taken in the early 1990s (so some recent development doesn't appear, of course).