There are a lot of options for fencing. Look is not all that needs to be considered. Durability and price are huge determining factors when installing a fence. Your metal pipe fence is going to be the most expensive per linear foot, but it will also last the longest. Vinyl is a great solution for privacy. It will last 5 times longer than wood, but is not as cost effective. Cedar is estimated to last 15-30 years if treated regularly. Spruce with the same treatment will only last 4-7 years and pine for 5-12 years. This is all estimate on weather conditions and quality of wood to begin with. When installing, choose a product that is not only aesthetically appealing but also has the longest longevity.