This magnificent New York estate is selling for a mere $500,000, and the owner says it's haunted by the former lady of the house