U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > U.S. Forums > General U.S.
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
 
Old 05-09-2007, 10:37 PM
 
61 posts, read 529,282 times
Reputation: 55

Advertisements

I just finished running a query on a database containing Summary File 3 and pulled data from table H76, which contains the median home values for all United States geographies as of the Census 2000, the latest census for while data for all geographic areas is available. The data is based on a State -> MSA -> County -> Place hierarchy.

The problem with median housing unit value data, however, is that it never stays up-to-date for very long. For this reason, you should think dollar values as scores, and pay attention to only the relative values (rather then absolute) when comparing geographies. Thus if a dollar value is much higher then another, you should have a pretty good idea of how the geographies compare at present.

The data is best viewed at a high resolution.

All geographies with a population of over 20,000: top 30

(template=place_name; county_name; metro_area; state_name; geography_type; population; median_home_value)

New York County (Manhattan borough); New York County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; County; 1,537,195; $1,000,001
Beverly Hills city; Los Angeles County; Los Angeles—Riverside—Orange County, CA CMSA; California; Place; 33,784; $1,000,001
Saratoga city; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 29,843; $1,000,001
Los Altos city; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 27,693; $983,000
Palo Alto city; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 58,598; $811,800
Los Gatos town; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 28,592; $784,600
Menlo Park city; San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 30,785; $778,500
Newport Beach city; Orange County; Los Angeles—Riverside—Orange County, CA CMSA; California; Place; 70,032; $708,200
Burlingame city; San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 28,158; $685,900
Coronado city; San Diego County; San Diego, CA MSA; California; Place; 24,100; $683,400
Manhattan Beach city; Los Angeles County; Los Angeles—Riverside—Orange County, CA CMSA; California; Place; 33,852; $672,600
Lake Forest city; Lake County; Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Place; 20,059; $662,400
Laguna Beach city; Orange County; Los Angeles—Riverside—Orange County, CA CMSA; California; Place; 23,727; $653,900
Cupertino city; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 50,546; $649,000
San Carlos city; San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 27,718; $626,400
Santa Monica city; Los Angeles County; Los Angeles—Riverside—Orange County, CA CMSA; California; Place; 84,084; $625,900
Westport CDP; Fairfield County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; Connecticut; Place; 25,749; $625,800
Brookline CDP; Norfolk County; Boston—Worcester—Lawrence, MA—NH—ME—CT CMSA; Massachusetts; Place; 57,107; $599,500
Belmont city; San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 25,123; $593,200
La Canada Flintridge city; Los Angeles County; Los Angeles—Riverside—Orange County, CA CMSA; California; Place; 20,318; $587,800
Lafayette city; Contra Costa County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 23,908; $583,000
Harrison village; Westchester County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; Place; 24,154; $578,700
Mercer Island city; King County; Seattle—Tacoma—Bremerton, WA CMSA; Washington; Place; 22,036; $573,900
Foster City city; San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 28,803; $566,500
Rancho Palos Verdes city; Los Angeles County; Los Angeles—Riverside—Orange County, CA CMSA; California; Place; 41,145; $560,500
Millbrae city; San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 20,718; $552,500
University Park city; Dallas County; Dallas—Fort Worth, TX CMSA; Texas; Place; 23,324; $549,400
Wellesley CDP; Norfolk County; Boston—Worcester—Lawrence, MA—NH—ME—CT CMSA; Massachusetts; Place; 26,613; $548,100
Mountain View city; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 70,708; $546,900
Danville town; Contra Costa County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 41,715; $541,400
Redwood City city; San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 75,402; $517,800

$1,000,001=$1,000,000+
metro_areas are only given if applicable
duplicate rows were deleted

Counties: top 30

(template=county_name; metro_area; state_name; geography_type; population; median_home_value)

New York County (Manhattan borough); New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; County; 1,537,195; $1,000,001
Marin County; San Francisco—Oakland—San Jose, CA CMSA; California; County; 247,289; $514,600
San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; County; 707,161; $469,200
Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; County; 1,682,585; $446,400
San Francisco County; San Francisco—Oakland—San Jose, CA CMSA; California; County; 776,733; $396,400
Santa Cruz County; San Francisco—Oakland—San Jose, CA CMSA; California; County; 255,602; $377,500
Eagle County; ; Colorado; County; 41,659; $369,100
Westchester County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; County; 923,459; $325,800
Summit County; ; Colorado; County; 23,548; $317,500
Honolulu County; Honolulu, HI MSA; Hawaii; County; 876,156; $309,000
Alameda County; San Francisco—Oakland—San Jose, CA CMSA; California; County; 1,443,741; $303,100
Summit County; ; Utah; County; 29,736; $296,000
Santa Barbara County; Santa Barbara—Santa Maria—Lompoc, CA MSA; California; County; 399,347; $293,000
Fairfield County; ; Connecticut; County; 882,567; $288,900
San Benito County; ; California; County; 53,234; $284,000
Sonoma County; San Francisco—Oakland—San Jose, CA CMSA; California; County; 458,614; $273,200
Orange County; Los Angeles—Riverside—Orange County, CA CMSA; California; County; 2,846,289; $270,000
Contra Costa County; San Francisco—Oakland—San Jose, CA CMSA; California; County; 948,816; $267,800
Monterey County; Salinas, CA MSA; California; County; 401,762; $265,800
Arlington County; Washington—Baltimore, DC—MD—VA—WV CMSA; Virginia; County; 189,453; $262,400
Morris County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New Jersey; County; 470,212; $257,400
Alexandria city; Washington—Baltimore, DC—MD—VA—WV CMSA; Virginia; County; 128,283; $252,800
Napa County; San Francisco—Oakland—San Jose, CA CMSA; California; County; 124,279; $251,300
Bergen County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New Jersey; County; 884,118; $250,300
Maui County; ; Hawaii; County; 128,094; $249,900
Ventura County; Los Angeles—Riverside—Orange County, CA CMSA; California; County; 753,197; $248,700
Middlesex County; Boston—Worcester—Lawrence, MA—NH—ME—CT CMSA; Massachusetts; County; 1,465,396; $247,900
Hunterdon County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New Jersey; County; 121,989; $245,000
Rockland County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; County; 286,753; $242,500
Nassau County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; County; 1,334,544; $242,300
Boulder County; Denver—Boulder—Greeley, CO CMSA; Colorado; County; 291,288; $241,900

$1,000,001=$1,000,000+
metro_areas are only given if applicable

Metro Areas: top 30 (constrained by state boundaries)

(template=metro_area; state_name; geography_type; population; median_home_value)

San Francisco—Oakland—San Jose, CA CMSA; California; Metropolitan Statistical Area; 7,039,362; $353,500
Honolulu, HI MSA; Hawaii; Metropolitan Statistical Area; 876,156; $309,000
Santa Barbara—Santa Maria—Lompoc, CA MSA; California; Metropolitan Statistical Area; 399,347; $293,000
Salinas, CA MSA; California; Metropolitan Statistical Area; 401,762; $265,800
San Luis Obispo—Atascadero—Paso Robles, CA MSA; California; Metropolitan Statistical Area; 246,681; $230,000
San Diego, CA MSA; California; Metropolitan Statistical Area; 2,813,833; $227,200
New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; Metropolitan Statistical Area; 12,689,665; $216,200
Los Angeles—Riverside—Orange County, CA CMSA; California; Metropolitan Statistical Area; 16,373,645; $203,300
Boston—Worcester—Lawrence, MA—NH—ME—CT CMSA; Massachusetts; Metropolitan Statistical Area; 5,029,148; $203,000
New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; Connecticut; Metropolitan Statistical Area; 1,802,148; $199,500
Washington—Baltimore, DC—MD—VA—WV CMSA; Virginia; Metropolitan Statistical Area; 2,167,757; $198,200
Santa Fe, NM MSA; New Mexico; Metropolitan Statistical Area; 147,635; $196,300
Seattle—Tacoma—Bremerton, WA CMSA; Washington; Metropolitan Statistical Area; 3,554,760; $195,400
New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New Jersey; Metropolitan Statistical Area; 6,661,750; $191,300
Denver—Boulder—Greeley, CO CMSA; Colorado; Metropolitan Statistical Area; 2,581,506; $179,500
Barnstable—Yarmouth, MA MSA; Massachusetts; Metropolitan Statistical Area; 162,582; $177,000
Fort Collins—Loveland, CO MSA; Colorado; Metropolitan Statistical Area; 251,494; $172,000
Corvallis, OR MSA; Oregon; Metropolitan Statistical Area; 78,153; $169,800
Naples, FL MSA; Florida; Metropolitan Statistical Area; 251,377; $168,000
Portland—Salem, OR—WA CMSA; Oregon; Metropolitan Statistical Area; 1,919,985; $167,000
Chicago—Gary—Kenosha, IL—IN—WI CMSA; Illinois; Metropolitan Statistical Area; 8,376,601; $165,300
Reno, NV MSA; Nevada; Metropolitan Statistical Area; 339,486; $161,600
Anchorage, AK MSA; Alaska; Metropolitan Statistical Area; 260,283; $160,700
Sacramento—Yolo, CA CMSA; California; Metropolitan Statistical Area; 1,796,857; $159,700
Washington—Baltimore, DC—MD—VA—WV CMSA; District of Columbia; Metropolitan Statistical Area; 572,059; $157,200
Portland—Salem, OR—WA CMSA; Washington; Metropolitan Statistical Area; 345,238; $156,600
Provo—Orem, UT MSA; Utah; Metropolitan Statistical Area; 368,536; $156,400
Bellingham, WA MSA; Washington; Metropolitan Statistical Area; 166,814; $155,700
Providence—Fall River—Warwick, RI—MA MSA; Massachusetts; Metropolitan Statistical Area; 233,064; $151,700
Boston—Worcester—Lawrence, MA—NH—ME—CT CMSA; Maine; Metropolitan Statistical Area; 41,375; $151,600
Salt Lake City—Ogden, UT MSA; Utah; Metropolitan Statistical Area; 1,333,914; $151,400

States: desc order

(template=state_name; geography_type; population; median_home_value)

Hawaii; State; 1,211,537; $272,700
California; State; 33,871,648; $211,500
Massachusetts; State; 6,349,097; $185,700
New Jersey; State; 8,414,350; $170,800
Washington; State; 5,894,121; $168,300
Connecticut; State; 3,405,565; $166,900
Colorado; State; 4,301,261; $166,600
District of Columbia; State; 572,059; $157,200
Oregon; State; 3,421,399; $152,100
New York; State; 18,976,457; $148,700
Utah; State; 2,233,169; $146,100
Maryland; State; 5,296,486; $146,000
Alaska; State; 626,932; $144,200
Nevada; State; 1,998,257; $142,000
New Hampshire; State; 1,235,786; $133,300
Rhode Island; State; 1,048,319; $133,000
Illinois; State; 12,419,293; $130,800
Delaware; State; 783,600; $130,400
Virginia; State; 7,078,515; $125,400
Minnesota; State; 4,919,479; $122,400
Arizona; State; 5,130,632; $121,300
Michigan; State; 9,938,444; $115,600
Wisconsin; State; 5,363,675; $112,200
Vermont; State; 608,827; $111,500
Georgia; State; 8,186,453; $111,200
North Carolina; State; 8,049,313; $108,300
New Mexico; State; 1,819,046; $108,100
Idaho; State; 1,293,953; $106,300
Florida; State; 15,982,378; $105,500
Ohio; State; 11,353,140; $103,700
Montana; State; 902,195; $99,500
Maine; State; 1,274,923; $98,700
Pennsylvania; State; 12,281,054; $97,000
Wyoming; State; 493,782; $96,600
South Carolina; State; 4,012,012; $94,900
Indiana; State; 6,080,485; $94,300
Tennessee; State; 5,689,283; $93,000
Missouri; State; 5,595,211; $89,900
Nebraska; State; 1,711,263; $88,000
Kentucky; State; 4,041,769; $86,700
Alabama; State; 4,447,100; $85,100
Louisiana; State; 4,468,976; $85,000
Kansas; State; 2,688,418; $83,500
Iowa; State; 2,926,324; $82,500
Texas; State; 20,851,820; $82,500
South Dakota; State; 754,844; $79,600
Puerto Rico; State; 3,808,610; $75,100
North Dakota; State; 642,200; $74,400
Arkansas; State; 2,673,400; $72,800
West Virginia; State; 1,808,344; $72,800
Mississippi; State; 2,844,658; $71,400
Oklahoma; State; 3,450,654; $70,700

All places with a median household income over $1,000,000

The Census Bureau apparently won't tell us exactly what the values are, other then that they are above $1,000,000:

(template=place_name; county_name; metro_area; state_name; geography_type; population)

New York County; New York County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; County; 1,537,195
Atherton town; San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 7,194
Belvedere city; Marin County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 2,125
Beverly Hills city; Los Angeles County; Los Angeles—Riverside—Orange County, CA CMSA; California; Place; 33,784
Diablo CDP; Contra Costa County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 988
Fairbanks Ranch CDP; San Diego County; San Diego, CA MSA; California; Place; 2,244
Hidden Hills city; Los Angeles County; Los Angeles—Riverside—Orange County, CA CMSA; California; Place; 1,875
Hillsborough town; San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 10,825
Kirkwood CDP; Alpine County; ; California; Place; 96
Los Altos Hills town; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 7,902
Loyola CDP; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 3,478
Malibu city; Los Angeles County; Los Angeles—Riverside—Orange County, CA CMSA; California; Place; 12,575
Montecito CDP; Santa Barbara County; Santa Barbara—Santa Maria—Lompoc, CA MSA; California; Place; 10,000
Monte Sereno city; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 3,483
Portola Valley town; San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 4,462
Rancho Santa Fe CDP; San Diego County; San Diego, CA MSA; California; Place; 3,252
Rolling Hills city; Los Angeles County; Los Angeles—Riverside—Orange County, CA CMSA; California; Place; 1,871
Ross town; Marin County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 2,329
Saratoga city; Santa Clara County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 29,843
Tiburon town; Marin County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 8,666
Woodside town; San Mateo County; San Francisco—Oakland—San Jose, CA CMSA; California; Place; 5,352
Aspen city; Pitkin County; ; Colorado; Place; 5,914
Mountain Village town; San Miguel County; ; Colorado; Place; 978
Snowmass Village town; Pitkin County; ; Colorado; Place; 1,822
Indian Creek village; Miami-Dade County; Miami—Fort Lauderdale, FL CMSA; Florida; Place; 33
Jupiter Island town; Martin County; Fort Pierce—Port St. Lucie, FL MSA; Florida; Place; 620
North Key Largo CDP; Monroe County; ; Florida; Place; 1,049
Palm Beach town; Palm Beach County; West Palm Beach—Boca Raton, FL MSA; Florida; Place; 10,468
Alpine borough; Bergen County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New Jersey; Place; 2,183
Brookville village; Nassau County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; Place; 2,126
Cove Neck village; Nassau County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; Place; 300
Dering Harbor village; Suffolk County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; Place; 13
Kings Point village; Nassau County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; Place; 5,076
Matinecock village; Nassau County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; Place; 836
Old Westbury village; Nassau County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; Place; 4,228
Sands Point village; Nassau County; New York—Northern New Jersey—Long Island, NY—NJ—CT—PA CMSA; New York; Place; 2,786
Hunts Point town; King County; Seattle—Tacoma—Bremerton, WA CMSA; Washington; Place; 443
Moose Wilson Road CDP; Teton County; ; Wyoming; Place; 1,439
Teton Village CDP; Teton County; ; Wyoming; Place; 175

metro_areas are only given if applicable
duplicate rows were deleted

Notes

Belvedere, Ross, and Tiburon, California (MHV=$1,000,000+) are the highest-valued places within the highest-valued county (Marin County, CA; MHV=$514,600) within the highest-income metro area (San Francisco—Oakland—San Jose, CA CMSA; MHV=$353,500).

New York, New York (which sprawls across five counties) had a median home value of $211,900.

Let me know if you would like to pull out the places, counties, metro areas, etc. within a given geography (i.e. top 30 places in New Jersey, counties in Connecticut, places in Orange County, California, places in Santa Clara County, California with a population of 10,000 and above). For 2005 (the absolute values for this survey are still out of date, I imagine) data for states, have a look in here: http://factfinder.census.gov/servlet...US-30&-_sse=on
Reply With Quote Quick reply to this message

Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:

Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > U.S. Forums > General U.S.
Follow City-Data.com founder on our Forum or

All times are GMT -6.

© 2005-2019, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 - Top