New
Pre-Owned
- All Makes -
- All Models -
- All Body Style -
SELECT id, bodystyle FROM bodystyle WHERE id IN (select distinct body from vehicles where status IN ('N', 'A') AND body NOT IN ('40', '43') and dealerid = 'jensen') ORDER BY bodystyle
2 Door
4 Door
Convertible
Crossover
Pickup - Compact
Pickup - Full Size
Sport Utility
Van - Mini
Wagon
JENSEN DEALERSHIPS
1901 E. 6TH STREET, SIOUX CITY, IA 51101 - [
VIEW MAP
]
PHONE: (712) 255-3000
TOLL FREE: 1-866-969-9666
COPYRIGHT (C) 2005-2008
LUMINOUS SOFTWARE, LLC
. ALL RIGHTS RESERVED
POWERED BY CARBASE.COM
DEALER WEB SITES
