The latest from UNFLUX was a big challenge for us based on it’s purpose for the “big picture.” The site is an SEO project as well, so we had to work with the SEO consultant as well. This posed numerous design and build issues, but ultimately we are all extremely happy with the final product.
The site uses php in a number or ways to manage the content, and a mysql database to run the property listings. Of course it also has a flash header. 
=)
