A picturesque city known for its shimmering lakes has become an unlikely symbol of the growing strain in America's housing market.