A process for manufacturing the composition coating may include selecting a wood or masonry material substrate and utilizing a sol-gel comprising a silane or silane derivative and metal oxide precursor to coat the substrate. The process may utilize an all solution process or controlled environment for manufacturing a composition coating that prevent wetting and/or staining of a substrate. The composition coatings for treating wood or masonry materials improves weather-resistance, microbial resistance, stain-resistance and fungal-resistance of the materials. The reduced permeability of the resulting masonry materials can also delay or inhibit degradation caused by permeation of ions such as chlorides and sulfates. In addition, a stain comprising the composite solution and pigments may impart additional property to wood or masonry materials whilst retaining or improving the original appearance, particularly for the visibility and contrast of the wood grain as seen after the application of the coating.