A series of cyclopentadienyl and indenyl molybdenum(II) compounds with intramolecularly coordinated pyridine arm, including scorpionate-like species bearing two irreversibly coordinated arms on indenyl core, was synthesized and characterized. All presented structural types were confirmed by X-ray diffraction analysis. Due to π-basicity of pyridine, the intramolecular interaction is considerably stronger than in case of analogous species bearing tertiary amines in the side chain. Although the starting compounds for syntheses are isostructural, the reaction outcomes differ considerably. The cyclopentadienyl precursor gives a pentacoordinated η 5 :κN-compound while the indenyl analogue produces a hexacoordinated species with unprecedented η 3 :κN-coordination mode of the indenyl ligand representing an unusual example of so-called indenyl effect. The unusually high stability of η 3 :κN-coordination compounds toward η 3 to η 5 haptotropic rearrangement was clarified by theoretical calculations. As the strong intramolecular interaction prevents rotation of indenyl, it cannot reach a conformation suitable for η 3 to η 5 rearrangement. As a result, the low hapticity is effectively locked.