Consider the new X1. It isn't far off the size of the current X3. We have an X3 now, a family member has an X1. I've driven it, and like it.

X1 only comes with an automatic.

__________________
2007 X3 3.0si, 6 MT, Premium, White

Retired:
2008 535i, 6 MT, M Sport, Premium, Space Grey
2003 X5 3.0 Steptronic, Premium, Titanium Silver
2002 325xi 5 MT, Steel Grey
2004 Z4 3.0 Premium, Sport, SMG, Maldives Blue