People usually choose the typical 30 year mortgage and end up selling before the house is completely paid off, because not very many folks stay in one place for that long.
Another option that’s becoming more popular is a 15 year mortgage, meaning if you meet your monthly payments in a timely manner for 15 years, then you’ll have paid it off and will own your home. You will, of course, have much larger monthly payments than if you spread it out over 30 years, but will also save quite bit in interest since you’ll be paying the loan back twice as fast.