The one product that has seemed to survive the subprime meltdown is the 40 year loan. I am not a fan of the 40 year loan. Mostly because the savings are minimal. Lets look at the current mortgage interest rates from Wells Fargo for a 40 year, 30 year and 15 year loan.
40 Year Loan = 6.375
30 Year Loan = 5.75
15 Year Loan = 5.125
Now using a mortgage calculator lets look at the mortgage payments on a 200k house.
40 Year Loan = 1153.14
30 Year Loan = 1167.14
15 Year Loan = 1594.64
While the difference between a 30 year loan and a 15 year is substantial, $441.50, the difference between a 40 year loan and a 15 year loan is only $14 per month. A little savings but is it really worth adding a whole extra 10 years to your mortgage. So over 30 years $14 dollars a month amounts to $5040. On the other hand an extra 10 years of mortgage payments comes out to $138,377. To run the numbers a different way by putting down a mere $2400 on your 30 year loan you would get the same mortgage payment as you would on a 40 year loan.
Obviously everyone's situation is different and in a small number of cases a 40 year loan might be warranted. But in general the 40 year loan adds extra years to a person's loan for a minimal benefit.
Ki works as a realtor in the Austin real estate market. He provides updated stats on the market on his Austin real estate blog along with a free search of the Austin MLS.

