A super hydrophobic coating composition that is a highly durable super hydrophobic transparent coating for glass, metal, and plastic, and automobile painted surfaces that is manually dispensable and may be easily applied to many substrates is provided. Moreover, the inventive super hydrophobic coating is user friendly as coating takes place at room temperature, and can be applied by a normal hand spray method. Embodiments of the coating dry within 30 minutes, and generate a super hydrophobic effect for ready use. The coating is useful to repel water droplets, dew drops, and dust particles in various applications such as solar panels, wind turbines surfaces, house hold components, metal coated furniture, marine equipment parts, marine sports equipment like speed boat screens, automobile wind shields, automobile plastic components, auto bodies and aerospace applications.