A new microporous cadmium metal organic framework was synthesized both mechanochemically and in solution by using a sulfonyl-functionalized dicarboxylate linker and an acylhydrazone colinker. The three-dimensional framework is highly stable upon heating to 300 degrees C as well as in aqueous solutions at elevated temperatures or acidic conditions. The thermally activated material exhibits steep water vapor uptake at low relative pressures at 298 K and excellent recyclability up to 260 degrees C as confirmed by both quasi-equilibrated temperature-programmed desorption and adsorption (QE-TPDA) method as well as adsorption isotherm measurements. Reversible isotherms and hysteretic isobars recorded for the desorption adsorption cycles indicate the maximum uptake of 0.19 g/g (at 298 K, up to p/p(0) = 1) or 0.18 g/g (at 1 bar, within 295-375 K range), respectively. The experimental isosteric heat of adsorption (48.9 kJ/mol) indicates non coordinative interactions of water molecules with the framework. Exchange of the solvent molecules in the as-made material with water, performed in the single-crystal to single-crystal manner, allows direct comparison of both X-ray crystal structures. The single-crystal X-ray diffraction for the water-loaded framework demonstrates the orientation of water clusters in the framework cavities and reveals their strong hydrogen bonding with sulfonyl, acyl, and carboxylate groups of the two linkers. The grand canonical Monte Carlo (GCMC) simulations of H2O adsorption corroborate the experimental findings and reveal preferable locations of guest molecules in the framework voids at various pressures. Additionally, both experimental and GCMC simulation insights into the adsorption of CO2 (at 195 K) on the activated framework are presented.