Below is a list of 2007 and 2008 AWD sedans, wagons, hatchbacks and crossovers that you can get with a manual transmission. You can also get this list by clicking the New Cars tab and then choose a segment (like Sedans) and then a price range or "All Sedans". On the left of the resulting page you can select to only show those with manual transmission, AWD, etc.
Crossovers
2007 - 2008 BMW X3
2007 Ford Escape
2007 - 2008 Honda Element
2007 - 2008 Hyundai Santa Fe
2008 Porsche Cayenne
2007 - 2008 Subaru Forester
Wagons
2007 - 2008 Audi A4 wagon
2007 - 2008 Audi S4 wagon
2007 - 2008 BMW 3-Series wagon
2007 - 2008 BMW 5-Series wagon
2008 Saab 9-3 wagon
2007 - 2008 Subaru Impreza
2007 Subaru Legacy
2007 - 2008 Subaru Outback
2007 - 2008 Suzuki SX4
2007 Volvo V50
2007 Volvo V70
Sedans
2007 - 2008 Audi A4
2007 - 2008 Audi RS4
2007 - 2008 Audi S4
2007 - 2008 BMW 3-Series
2007 - 2008 BMW 5-Series
2008 Cadillac CTS
2007 Mazda MAZDASPEED MAZDA6
2006 Mitsubishi Lancer Evolution
2008 Saab 9-3
2007 - 2008 Subaru Impreza
2007 Subaru Legacy
2007 Volvo S40
2007 Volvo S60
Hatchbacks
2008 Audi TT
View entire answer