Bubble Markets Stagnating

When the 'speculative fervor' ends in a real estate market it will inevitably lead to price stagnation followed by price declines. The rate of price appreciation slows, until prices are stagnating (appreciation is zero in inflation adjusted dollars). Then price declines set in. So which metropolitan areas are farthest along the cycle? Here are my candidates:

1. San Diego: The year over year price appreciation (June 04 to June 05) is now a measly 6.3%. Most of that gain probably occured in the first part of that period
2. Boston:
   
3. Las Vegas
4. Others ( please provide info)