SELECT * FROM Inventory where Type='N' Order By Make, Model desc
2011 BUICK
REGAL
CXL
|
2010 BUICK
LUCERNE
CXL V6
|
2010 BUICK
LUCERNE
CXL V6
|
2011 BUICK
LUCERNE
CXL
|
2011 BUICK
LUCERNE
CXL
|
2010 BUICK
LACROSSE
CXL FWD
|
2010 BUICK
LACROSSE
CX FWD
|
2010 BUICK
LACROSSE
CX FWD
|
2010 BUICK
LACROSSE
CXL FWD
|
2011 BUICK
ENCLAVE
CXL AWD
|
2010 BUICK
ENCLAVE
CXL AWD
|
2010 BUICK
ENCLAVE
CXL AWD
|
2010 BUICK
ENCLAVE
CXL AWD
|
2010 BUICK
ENCLAVE
CXL AWD
|
2011 BUICK
ENCLAVE
CXL
|
2011 BUICK
ENCLAVE
CXL AWD
|
2010 GMC
YUKON XL
1/2 4X4 SLT 4DR
|
2010 GMC
TERRAIN
AWD SLT-1 4DR
|
2011 GMC
SIERRA
1/2 4X4 X-CAB SLE
|
2010 GMC
SIERRA
3/4 4X2 REG CAB WT
|
2010 GMC
SIERRA
3/4 4X4 CREW SLE DSL
|
2011 GMC
SIERRA
3/4 4X4 CREW SLE
|
2010 GMC
SIERRA
1/2 4X4 CREW SLE
|
2010 GMC
SIERRA
1/2 4X2 REG CAB WT V6
|
2010 GMC
SIERRA
1/2 4X4 CREW WT
|
2010 GMC
SIERRA
1/2 4X4 X-CAB WT 4.8 V8
|
2011 GMC
SIERRA
3/4 4X4 CREW SLE
|
2011 GMC
ACADIA
AWD SLT-1 4DR
|
2010 GMC
ACADIA
AWD SLT-2 4DR
|