We just bought a Pilot, (wish we'd known about this, we would have waited) anyway I love it! Hope you'll like yours
I traded in an '03 with 40,000 miles that looked like brand new. My auto "advisor" told me it was time to trade, sell, or plan to drive it a few more years. He knows this stuff pretty good and told me the value begins to decline rapidly after 40,000.
We loved the '03 and I'm sure you will love the Pilot. Great SUV.