I ran across the Using Spotlight form the OS X Commandline post a while back and have used this Spotlight command line utility ever since largely as a replacement for the traditional Unix find and locate commands. The -onlyin and -name (new in 10.6) flags are especially handy.