SELECT scweb,scseo,pl,iMP_vSClass.class AS class FROM iMP_vShared LEFT JOIN iMP_co ON iMP_co.id=iMP_vShared.cid LEFT JOIN iMP_lotM ON labbr=lot LEFT JOIN iMP_vSClass ON iMP_vSClass.class=iMP_vShared.class AND iMP_vShared.subclass=iMP_vSClass.subclass WHERE scseo IS NOT NULL AND list='Public' AND status='Live' AND iMP_vShared.class IN('Truck','Tractor','Dump','LightDuty') AND status IN('Live','Pseudo','Prep') AND list='Public' AND iMP_co.id=1 AND UPPER(utype)='NEW' GROUP BY scweb ORDER by scseo

NEW TRUCKS FOR SALE

NEW TRUCKS FOR SALE

Show Only In-Stock Units
Freightliner Configurator
2 RESULTS
NEW 2018 WESTERN STAR 5700XE SLEEPER TRUCK #1977
WOOD GRAIN DASH, LEATHER SEATS, POWER W/L/M, FRIDGE, CATTLE GUARD. 1 YEAR 100K WARRANTY. 11 MILES, DETROIT DD15 ENGINE, 505 HP, 12 TRANSMISSION, OVERDRIVE, WET LINE, 3 REAR, AXLES: TANDEM 12,000 40...
Call for Price
Salt Lake City, UT   801-978-8000
Stock #:
255657
Engine:
Detroit DD15505 HP
Trans:
12 Spd.
Whlbase:
235
NEW 2018 FREIGHTLINER CASCADIA 113 CAB CHASSIS TRUCK #1869
WE HAVE (5) OF THESE AVAILABLE. 1250LB/FT, PREMIUM 2.0 DRIVER SEAT, AM/FM/WB WORLD TUNER RADIO WITH SIRUSXM,CD PLAYER, BLUETOOTH, IPOD, (2) ON/OFF SWITCHES IN DASH. DETROIT DD13 ENGINE, 370 HP, 3 12...
Call for Price
Salt Lake City, UT   801-978-8000
Stock #:
STRAIGHT
Engine:
Detroit DD13370 HP
Trans:
2.85 12 Spd.
Whlbase:
283
2 RESULTS