New Used - 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','J') AND body NOT IN ('40', '43') and dealerid = 'jensen') ORDER BY bodystyle2 Door4 DoorConvertibleCrossoverPickup - CompactPickup - Full SizeSport UtilityVan - Full SizeVan - MiniWagon - All Prices - Under $5,000$5,000 to $10,000$10,000 to $15,000$15,000 to $20,000$20,000 to $25,000$25,000 to $30,000$30,000 to $35,000$35,000 to $40,000Above $40,000