I bought this car with over a 100K on it and have had it for about a year. So far it has been fantastic! It has nice power and runs very well. A couple months ago I hit a big Ohio deer and I barely felt it. Me and my family were completely safe, which made me very happy I bought this SUV. Last winter I could not get my Odyssey up my long driveway in the snow, with this, it's a breeze. The leather is comfortable. The kids love the heated seats. I'm 6'4" and it's very roomy. Sound system is awesome. I average about 19.6mpg. On a long trip through Canada I actually had 25mpg highway. It's used, buy the extended warranty if you're worried about the tranny going and drive worry free!
I bought my 2004 Pilot EX-L in Dec 2008 with 52,900 miles. I'm now at 110,300 miles. I am a DIY mechanic and have done all the scheduled maintenance myself. The 17 city and 22 hwy fuel ratings are not accurate. Best highway was 21 and routinely get 18-19mpg in mixed driving at high altitude in Colorado and Wyoming. When I lived in Southern California, I routinely got 15-16mpg in mixed driving and a highway best of 19. So fuel quality and altitude definitely effect fuel economy. I've replaced motor mounts, spark plugs, shocks/struts, timing belt, and valve adjustments. Overall a great vehicle with no transmission problems.
I bought this car new in October 2003 and it had 31 miles on it when I drove it off the lot. I now have over 240K miles on it and the only issues I have ever had with it are: driver's door handle had to be replaced after not being able to open the door from the inside, AC compressor went out once. This car has been subject to at least 3 Honda recalls, one being the transmission issue. I will continue to drive it until the wheels fall off. My 1st gen (1997) CRV, which I also bought brand new, is still on the road today with another owner as well. Bought my daughter a new 2009 Fit as a graduation gift. She treats it like her baby! I stand by Honda, trying to decide which I will buy next.
We bought our Pilot in Feb. 2012. It had approximately 87,000 miles on it. I upgraded from a Honda Civic to get more space for kids, cargo, and to have a great roadtrip vehicle for the family. Our Pilot has been everything we needed and more. All we've done is regular maintenance, and we have had no problems. It drives like a dream on the highway and has TONS of space for carseats, kid stuff, and other cargo. We are adding a hitch for a cargo rack and the running boards next, and it'll be perfect. We are very pleased with our Pilot and will be keeping it as long as it runs!
My 2004 Pilot EXL is still great after 8 years and over 200,000 miles. I bought it in spring of '06 when it had 50k miles, so someone before me drove a lot, too. I've not had all the issues I've read about, but I don't abuse the vehicle. I get oil changes every 5-6k miles, but do spread out the scheduled maintenances and fluid changes a bit more due to quickly rolling up highway miles. My Pilot replaced a Jeep Grand Cherokee Limited 4x4 that had the gas-guzzling 5.2 liter V8. The main reason I replaced the JGC was due to terrible gas mileage (9-15) and slipping transmission. I've not had any transmission issues with my Pilot, but I don't abuse it, either!