Real Estate Sites
Over the summer I did some work for a couple of realtors. One site was built with WordPress, the other two with a lightweight CMS called SlyBlueCanvas. SkyBlueCanvas is pretty well done and you can put together a nice sized site with no database requirement. Very handy for clients who want that sort of thing, or who are still on older and/or cheaper hosting.
Each site was augmented with various jQuery effects and add-ons to bring motion and styling to the sites. jQuery is pretty tough to beat for providing quick and easy integration of very whizzy functionality.
The sites are: