Highly desirable locations do not necessarily mean you are immune from a real estate bust. Look what happened to median home prices in the LA, Orange County, Riverside and San Diego counties from 1989 to 1996/97:
http://www.laalmanac.com/economy/ec37.htm
That is a fascinating chart.
The 2000-2006 figures scream "bubble".