The 56-year-old music artist splashed out $75,000 a month for the 18,000 sq ft property, built in 1929, beginning in July 2023