The pink mansion where the drug kingpin lived has been razed from the waterfront plot of land