Social Explorer; Federal Housing Finance Agency House Price Index (HPI).
House Price Index Technical Documentation
20. How can the HPI for an MSA be linked to ZIP codes within that MSA?
Although FHFA has published experimental house price indexes for some ZIP codes, those indexes are annual (i.e. quarterly index values are not provided). Researchers needing quarterly values for ZIP codes may be interested in using index values for the applicable metropolitan area.
Because ZIP codes sometimes overlap county boundaries, a single ZIP code can be located partially inside and outside of a Metropolitan Area. Thus, the development of a crosswalk between ZIP codes and Metropolitan Areas is not a straightforward exercise. The Department of Housing and Urban Development has released a lookup table that maps ZIP codes to the Metropolitan Area(s) that they fall within. That lookup file, as well as a discussion of the underlying technical issues, can be found here: http://www.huduser.org/portal/datasets/usps_crosswalk.html.