Tilt-shift photos are also called "fake model photos", for the effect they give the picture.
The really good, sharp, tilt-shift pictures use special lenses and cameras - but it's actually pretty easy to do something similar just using Photoshop..... here's one I made last year of Regent's College following this tutorial

http://www.recedinghairline.co.uk/tutorials/fakemodel