Back when Google Earth allowed users to upload SketchUp models to the map, I made 3D models of the buildings I worked in and textured them with photographs I took. The model itself was easy to build but getting all the textures to line up and be small enough in size (but still detailed) was the challenge. You can see below the model where on Google Earth the building resides.
