Alkaline-earth metal ions were used to tune four new heterometallic frameworks, {[Cd2.07Mg0.93(BTC)2(H2O)4]·2H2O}n (1), {[Cd2Ca(BTC)2(H2O)4]·2H2O}n (2), {[Cd2Sr(BTC)2(H2O)5]·H2O}n (3) and [Cd6Ba3(BTC)3(H2O)10]n (4) (H3BTC = 1,3,5-benzenetricarboxylic acid), synthesized from H3BTC and the corresponding metal salts. Single-crystal X-ray analysis shows that compound 1 is a three-dimensional (3D) framework based on heterometallic Cd–O–Cd–O–Mg inorganic chain subunits, compounds 2 and 3 are basically isostructural and feature a 3D framework based on Ca(II) or Sr(II) polyhedrons decorated with Cd–O–Cd inorganic chains. Compound 4 is a 3D framework templated by disordered inorganic hydrate Ba(II) ions, and also features inorganic Cd–O–Cd chains, which are connected together through corner sharing with the {Cd1O6} polyhedrons by {Ba1O6} polyhedrons, giving rise to a rare heterometallic 3D inorganic skeleton. Moreover, the solid-state fluorescence of compounds 1–4 and NLO properties of compounds 2–4 have also been investigated at room temperature.