I found a report yesterday that tracks housing values and transaction counts for 25 of the largest MSAs (Metropolitan Statistical Areas) in the country.  The report, compiled by radarlogic.com, compares (among other metrics) housing values on a $/sq.ft. basis and tracks M-o-M and Y-o-Y percent changes.

Of particular interest is the year-over-year percent change in housing values.  It probably comes to no surprise that every area tracked experienced a decrease in house values in June 2008 compared to June 2007.  The 25 MSAs and their one-year % change can be found in the table below.

25 Metropolitan Statistical Areas
Ranked by 1-Year % Change

 

MSA

price/sq.ft.

June ‘08 vs.
June ‘07

1

Las Vegas, NV

$121.17

-30.8%

2

Sacramento, CA

$155.71

-27.8%

3

Phoenix, AZ

$115.28

-26.9%

4

Los Angeles, CA

$289.15

-26.5%

5

San Diego, CA

$235.76

-25.6%

6

San Francisco, CA

$340.51

-25.0%

7

Miami, FL

$155.61

-21.9%

8

Tampa, FL

$112.36

-18.5%

9

San Jose, CA

$398.18

-17.0%

10

Washington, DC

$197.02

-16.0%

11

Detroit, MI

$90.71

-15.2%

12

St. Louis, MO

$102.23

-13.5%

13

Boston, MA

$220.01

-10.2%

14

Jacksonville, FL

$112.43

-10.2%

15

Minneapolis, MN

$143.92

-10.0%

16

Chicago, IL

$184.46

-10.0%

17

Denver, CO

$137.68

-9.4%

18

Cleveland, OH

$88.55

-9.0%

19

New York, NY

$283.36

-8.3%

20

Seattle, WA

$216.79

-7.9%

21

Atlanta, GA

$97.34

-6.6%

22

Philadelphia, PA

$152.14

-5.1%

23

Milwaukee, WI

$124.97

-2.0%

24

Columbus, OH

$100.26

-0.7%

25

Charlotte, NC

$100.62

-0.2%

Note: the data in the table above taken from the RPX Monthly Housing Market Report - June 2008.

Notice that Western cities took that top six spots.  I wanted to see where Reno ranked, so I compared all sales in June 2007 to all sales in June 2008.  The percent change over this period was ~15%, which ranks Reno, NV somewhere between Detroit, MI and St. Louis, MO.

Take a look at the complete report and the associated site.  Lots of good info here for the data fans.