Playing around with PhotoShop CS2 and some actions that I downloaded.
This photo is of Bellingrath Gardens and I used Keynote Reflection Effect from Author: Gord Wall.
It can be found at: http://www.atncentral.com/download.htm