Here are some pictures of the spray foam in the garage, basement and main floor (Made it look like Barney's house - all purple). The application is a closed cell foam (Mike Holmes recommends this stuff) applied three inches thick between the wall studs. Since the foam is impermeable to water a vapor barrier is not required.

Chad and Mike wanted their names to be permanently enshrined in the house so they spray foamed their names on the walls with a different color spray foam.