Provided are polymer-aerogel composite coatings, devices and articles including polymer-aerogel composite coatings, and methods for preparing the polymer-aerogel composite. The exemplary article can include a surface, wherein the surface includes at least one region and a polymer-aerogel composite coating disposed over the at least one region, wherein the polymer-aerogel composite coating has a water contact angle of at least about 140° and a contact angle hysteresis of less than about 1°. The polymer-aerogel composite coating can include a polymer and an ultra high water content catalyzed polysilicate aerogel, the polysilicate aerogel including a three dimensional network of silica particles having surface functional groups derivatized with a silylating agent and a plurality of pores.