http://terraserver-usa.com/
http://www.terraserver.com/
Search Google for more...
Those sites are not up-to-date... it's impossible for regular people to get current satellite photos of any location they want. You'd have to be a company or agency with the required access/authorization/technology/money, and even then it would probably be difficult, because there are a limited number of satellites, and each camera can only be looking at one place at a time.
Also, you can't really zoom in on people's houses. At best, you can identify each house, but the satellites typically don't zoom in enough to get any details. Here's an example of a standard satellite photo of a city zoomed in as much as possible without losing quality...
You can identify a house if you know where to look, but there are no details at all.