According to the National Association of Home Builders/Wells Fargo Housing Opportunity Index (HOI), nationwide housing affordability dipped in the second quarter of 2014 as several markets saw a firming of home prices.

In all, 63% of new and existing homes that were sold between the beginning of April and the end of June were affordable to families earning the US median income of $63,900 (£38,440). This is down from the 66% of homes sold that were affordable to median-income earners in the first quarter.

The national median home price increased from $195,000 in the first quarter to $214,000 (£129,340) in the second quarter. Meanwhile, average mortgage interest rates decreased from 4.57% to 4.44% during the same period.

The Youngstown metropolitan area in Northeast Ohio claimed the title of the nation’s most affordable major housing market, as 90% of all new and existing homes sold in this year’s second quarter were affordable to families earning the area’s median income of $52,700 (£31,710). For a seventh consecutive quarter, San Francisco was the nation’s least affordable major housing market. There, just 11% of homes sold in Q2 were affordable to families earning the area’s median income of $100,400 (£60,410).