Check out this link to a 720 megapixel photo of Sydney. Your normal camera probably takes pics at about 5 megapixels, so this is some serious resolution. His blog says that he creates these things by stitching together hundreds of individual photos. He must have a mean zoom, a good tripod and some real patience to get it right.
This is a screenshot of part of the zoomed out image.
And this is a zoom in on the bottom left of that screenshot.
He also has links to other photo’s, one at 1500 megapixels which is well worth a look.