SELECT COUNT(DISTINCT(iMP_vShared.id)) FROM (iMP_vShared, iMP_vSpec) LEFT JOIN iMP_co ON iMP_co.id=iMP_vShared.cid LEFT JOIN iMP_lotM ON labbr=lot WHERE iMP_vShared.id=iMP_vSpec.id AND iMP_vShared.class IN('Truck','Tractor','Dump','LightDuty') AND ((status IN('Live','Order') AND list='Public' AND utype='New') OR (status IN('Live','Order','Pend') AND list='Public' AND utype='Used')) AND iMP_co.id>0 AND model LIKE '%567%'

567 TRUCKS FOR SALE

Inventory

567 TRUCKS FOR SALE

Click to View
Show Only In-Stock Units
0 RESULTS

Oops! No Results Found

You may have too many filters selected.

Try clearing some of your selections using the list below

Alabama Locations

Birmingham
Birmingham
Montgomery
Montgomery
Huntsville
Hunstville

Virginia Locations

Glade Spring
Fancy Gap

Click to Visit Fitzgerald USA

Fitzgerald USA