The syntheses, crystal structures, spectral characterization, electrochemical, photoredox properties and biological studies of three sodium coordination polymers viz. (ImH)4[(µ2-HMo7O24)Na(H2O)8]∙7H2O 1 (Im = Imidazole), [(TEAH)Na5(H2O)12(µ5-Mo7O24)] 2 (TEA=triethanolamine) and [Na2(PyrH)2(µ2-Mo8O26)(H2O)7]∙8H2O 3 (Pyr = pyrazole) are reported. The unique Na atom in 1 exhibits ten coordination unlike hexa coordination observed in 2 and 3. The µ2-bridging heptamolybdate (or octamolybdate) anion in 1 (or 3) links the sodium cations into an infinite chain resulting in a one-dimensional coordination polymer. In 2, the heptamolybdate anion exhibits an unprecedented µ5-nonadentate binding resulting in a three- dimensional (3D) structure. Compounds 1–3 exhibit characteristic Raman bands. Solar irradiation of 2 results in photodimerization, which is further supported by electrochemical studies. Compounds 1–3 exhibit antibacterial activity, with 3 being the most effective against S. Pyogenes, followed by P. aeruginosa, S.typhi and S. aureus. Compound 3 exhibits excellent antidiabetic and anti-inflammatory properties. A comparative study of the binding modes of several heptamolybdates and octamolybdates based compounds is presented.