A "fantasist" who fell into debt because of his cocaine addiction and stored over €500,000 worth of the drug in his bedroom for criminals in an effort to reduce the liability has been given a seven-year sentence.