Hydrophobic coating system for application to an inorganic, organic or metallic substrate