General Comments:
I think this is a great car, if a bit over priced.
I bought mine with 229,000 miles, which is a lot, but it still has the original engine and transmission YES! The original transmission, which was recalled to install a cooling jet for a clutch pack.
The trick? Not much. The previous owner who's my friend used to change the tranny oil every 15,000 miles, and did not race the car and NEVER parked the car without applying the parking brake. Some people might find this irrelevant, but parking the car with applying the parking brake might over stress the transmission parking mechanism, specially when parking on an up or down hill. Try to park your car without the parking brake, then let go of the brake and you'll notice that the car shakes back and forth. My friend, that is the transmission parking mechanism being stressed. When you turn on the car after parking like that and change into drive or reverse, you'll notice that the parking mechanism will shake the car violently, Trust me, it's not good for the transmission.
And also change your transmission oil on time OR DO NOT! Yes, do not. If you leave the transmission oil without changing it, then you change it, your tranny will blow up real fast. So you either do it right or just don't.
Now the car has 232,000 miles. The transmission is smooth shifting. But it whines. Most likely the transaxle, but could be the bearings. But come on, 232,000 miles? I think that's enough. I love Hondas. They're great cars.