We have a 2003 Odyssey with about 80K miles on it. Bought it used in 2007 with around 33K miles. It’s been a great vehicle overall; I’ve been very mindful of the transmission as I know that’s historically a weak spot. So far so good, though.
The only bit of advice I’d offer is to verify whether or not the Odyssey you’re looking at has a trailer hitch installed. Personally, given the transmission reputation of this vintage Odyssey, I’d walk away from one that had any indication of having been used for towing.
Good luck.