The most haunted royal residence revealed