Large second level deck
Structure is the key. Many deck builders cut corners to save money. Using as few and as small pier pads as possible. Many of the decks which I have removed have joists laid out on 24" centers. This leads to a "spongy" deck and a shorter life span. We use all "corrosive resistant" hangers and fasteners and joists are laid out on 16" centers. All ledger boards are lag bolted to "structural members" of the house. In all sloped grade or heavy moisture applications we use 18" diameter round pier pads. The larger the foot print, the larger the foot! We can build any rail design imaginable. Several different designs are viewable here, and all rails will meet code.
Trex deck with step lights
There are several different materials available for the decking.  Traditional decks are cedar. These decks require treatment every two years or so depending on exposure.  This service can be provided upon request. Next there are composite products. These products are a combination of recycled plastics, wood fibers, and glue. No treatment required. Trex and Timber Tech are two of the most common brands and both have a variety of textures and colors. I'm a big fan of composite decks. The lack of maintenance as well as a lack of slivers is very attractive to me. There are also "Dry Deck" systems available to keep patios below decks, dry!
Rest your cursor on the 'Before' pictures to see the 'During' and 'After' pictures. Click on any picture to view it in a new window.