Google certainly has 3D view. It's on my iPad with Google Earth. They also have the more useful non-textured 3D maps in Google Maps for Android which is a lot more smooth (way less data transfer and being vector it's scalable) and you can even use them offline.

http://www.google.com/mobile/maps/3d/