Real estate investor Mahmood Alam has emerged as the buyer of the allegedly haunted Hotel Union Square in San Francisco.