How to wake my Mac remotely so I can use screen sharing?
The aptly called WakeOnLan is a free, simple tool for Mac, both available as application and widget.


  What is WakeOnLan?
  WakeOnLan discovers all other computers in your
  LAN, and enables you to wake them up by clicking a button. If your
  remote computer is a Mac you can put it asleep too.