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.
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!
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!