Humans face a severe shortage of fresh water due to economic growth, climate change, overpopulation, and overutilization. Atmospheric water harvesting (AWH) is a promising solution where clean water is collected from the air through various approaches, including dropwise condensation. However, designing surfaces that balance rapid condensation with efficient water removal is challenging. To address this issue, inspired by the efficient water collection mechanisms in the skin of cold-blooded tree frogs, we propose an eco-friendly approach to collect fresh water from cooled window glass. We fabricated various planar and TiO₂ nanostructured surfaces including surfaces mimicking a lotus leaf and a hybrid surface mimicking a desert beetle and a cactus, with different wettability levels such as superhydrophilic, hydrophilic, hydrophobic, superhydrophobic, and biphilic. Sub-cooling of glass substrates between 5 and 15 °C using a Peltier device significantly enhanced the condensation process for all surfaces, with modest dependency on surface properties. This cooling temperature regime could be achieved by geothermal cooling methods that consume little energy. To improve visibility for window applications, we developed hydrophobic polymer nanofilm-modified glass substrates using a simple spin-coating technique, and achieved comparable water harvesting efficiency to that of nanostructured substrates. Our study provides insight into the optimal surface structures and cooling temperature for window glass AWH systems that could be used with an underground cooling system.