Is the dream of a decent education gone for the children of middle-class Americans?  A new study by RealtyTrac indicates that if you consider standardized test scores a realistic measure of a good education, that dream might be on life support.

RealtyTrac looked at school test scores for nearly 27,000 elementary schools in more than 7,200 U.S. zip codes, analyzing them in conjunction with data on home price affordability.     Out of 1,823 zip codes with at least one good school, RealtyTrac found that 1,181 or 65 percent would be out of reach price-wise for average wage earners. RealtyTrac defined this by a need to spend more than a third of household income in order to purchase a median-priced home.

Metro areas with the most affordable zip codes with good schools were Chicago (179), Detroit (44), Phoenix (22), Miami (20) and Charlotte (18).

The median sales price in 2015 for homes in zips with good schools was $411,573 on average, 95 percent higher than the median home sales price in zip codes without any good schools ($210,662).

Home prices in 2015 increased at the same annual pace in the 1,823 zip codes with at least one good school as in the 5,424 zip codes with no good schools, an average of 7 percent.

The least affordable elementary school listed by RealtyTrac was in Atherton, California where the median home price was just over $6 million. There it would require 412% of a median income to buy a home.

The list of 25 least affordable schools overall however appeared to be unaffordable more as a function of income than of housing prices. Ten had median prices below $500,000 and two were below $300,000. Even living in the district of school number 25 in Shreveport, Louisiana it would cost 39 percent of median income to purchase the median $220,000 home.

Metro areas with the most unaffordable zip codes with good schools were Los Angeles (184), New York (158), San Francisco (77), Chicago (58) and San Diego (49).

 

The list of 25 most affordable areas, on the other hand, was topped by schools where homes were very low in price.  The top nine had median prices below $100,000 while the highest median price, $267,000 (in Beaverton, Oregon) took only 30 percent of a median income.

While RealtyTrac's issue of affordability is a valid one, the issue that seems most important in this study is the question of why there are 1,800 zip codes with at least one good school and 5,400 with none.

Only zip codes with at least 50 sales of single family homes and condos, not including multiple-parcel transactions, in both 2014 and 2015 were included in the analysis. School data is from each state's Department of Education in 2014 with scores for the study based on the test average for each state. The higher above the state average the school is, the higher the grade.

Home price data is from publicly recorded sales deeds and mortgages for single family homes and condos or in some cases loan amounts and estimated property value at time of sale. Average wage data came from the Bureau of Labor Statistics and was from the first quarter of 2015, the most recent available.