Paul O’Grady’s luxury multi-million-pound estate has been pulled from the market after a year-long struggle to sell.