My brother and his wife both have CR-Vs, and they seeminly love them. They don't have kids, but they have 2 labs they haul around just fine. I know you said you were against vans, but our Odyssey does everything my wife needs it to, and the resale you are looking for is definitely there. If you buy right, you can drive it for a year for little to no money.
Tom