A toasted transmission in a 2000 Honda is a sign of an abused car. You don't say how many miles it has but if they are willing to sell it for $1500 (really cheap) I would wonder what else is going to fail and when.