Three inorganic–organic hybrid materials based on octamolybdates, d10 metals, and multidentate N-donor ligands, namely, [Zn4(htpmb)2(θ-Mo8O26)(H2O)6.5]·0.5H2O (1), [Zn6(htpmb)2(γ-Mo8O26)2(SO4)(H2O)6]·6.5H2O (2), and [Cd2(htpmb)(γ-Mo8O26)(H2O)2]·4.5H2O (3), where htpmb = hexakis(3-(1,2,4-triazol-4-yl)phenoxy-methyl)benzene, have been synthesized under hydrothermal conditions. Compound 1 shows a 3D framework based on a rare [θ-Mo8O26]4− isomer with binodal (5,6)-connected (32·43·5·63·7)(32·44·54·62·73) topology. Compound 2 displays a 3D framework with pentanodal (4,5,6,6,7)-connected (32·4·5·62)(32·42·52·63·8)(34·42·52·64·72·8)(34·42·52·66·9)(34·43·5·68·75) topology. Compound 3 exhibits a 3D framework with pentanodal (3,4,4,6,6)-connected (3·6·7)(32·4·62·7)(34·42)(32·66·76·10)(33·4·63·74·84) topology. Their structures have been characterized by infrared spectra (IR), elemental analyses, powder X-ray diffraction (PXRD), thermogravimetric analysis, and optical band gaps. The luminescent properties and electrochemistry behaviors of compounds 1–3 have been studied. Moreover, the photocatalytic activities for methylene blue (MB) degradation of 1–3 under UV light irradiation have also been investigated in detail.