Usually limestone, sandstone, or fieldstone, a well built and maintained stone foundation can last centuries. While the stones may be bonded or repaired with mortar, they stay in place without it.
Most weren’t built watertight. Frost, roots, and poor drainage can cause shifting. The stones can settle, causing movement and creating gaps for pests.