Honda Accord 1999, should I trust it?

I'm looking into getting my very first car. I found a Honda Accord, they're selling t for 1,800$. There's 179k miles on it. They mentioned that the transmission will need work in the future. How bad is that? Is it completely fixable? How much would it cost? Other than that, should I trust this car. Thanks!

Read more: Honda Accord 1999, should I trust it?