The home first went on the market for $9.45 million in September 2018 after the singer's drug overdose