OK, here comes the next installment of buy what_ I_ have (I kind of hate these threads…)…
Don't buy a Jeep Patriot or Compass (pretty much an AWD wagon as you requested). They're shit cars overmarketed as softroaders. However, the AWD system is functionally very good, if not reliable (it's not). I'd say it's the best in the cute utes if you want to go offroad.
However, our 06 Pontiac Vibe has been flawless, short of T-boning the douche who did a U-turn in front of us. 90K and not a bit of a problem. It's not AWD, but you can get it in AWD. We can fit more into the Vibe than into the Patriot. Friends of ours had 2 adult DH bikes and a kids bike, and the three riders inside theirs (it's interior was trashed though…)
Insurance just poured $9K into repairing the front end, when I was sure it was a write off for a 6 year old car. How's that for holding value?
http://vancouver.en.craigslist.ca/bnc/ctd/4299365313.html
http://vancouver.en.craigslist.ca/bnc/ctd/4339160497.html