San Francisco had the 3rd-lowest house value appreciation in June