[Greengoose]

http://www.keyhole.com

Download the free trial. It zooms in 3d to your address and you can tilt and spin the map to get an almost true visual of your address.

 

[billmeek]

Or if you're cheap (like me) and don't need the flashy stuff use :

http://terraserver.microsoft.com/