[polymonster]

Command + double click a search item in spotlight to open the containing folder in finder.

[kristjansson]

Cmd + Enter opens the containing folder too - no clicking required!

[clairity]

neat, just pressing cmd while a search item is focused gives you a little path preview popup as well. something i want often enough to be slightly annoyed but not often enough to have wanted to seek out specifically before. =)

[haddr]

Press Cmd to reveal the path