Is it legal to obtain a search warrant of a friends house he does not live at for drugs?

First, you cannot obtain a search warrant. Police and prosecutors can, but only if they have enough evidence that there has been a crime, and that searching might solve it. Search warrants must be issued by judges.