SELECT DISTINCT(year) AS year FROM (iMP_vShared, iMP_vSpec) 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_vSClass.subclass=iMP_vShared.subclass WHERE iMP_vShared.id=iMP_vSpec.id AND status ='Order' AND list='Public' AND iMP_co.id=1 AND lot NOT IN('x-MIA','x-POM','x-WPB') AND iMP_vShared.class IN('Truck','Tractor','Dump','LightDuty') ORDER BY year DESC
SELECT iMP_vShared.*,iMP_vShared.id AS vid,iMP_vSpec.*,iMP_co.*,iMP_lotM.*,scseo,pl,scweb,DATEDIFF(CURDATE(),msdate) AS msexp FROM (iMP_vShared, iMP_vSpec) 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_vSClass.subclass=iMP_vShared.subclass WHERE iMP_vShared.id=iMP_vSpec.id AND iMP_vShared.class IN('Truck','Tractor','Dump','LightDuty') AND status ='Order' AND list='Public' AND iMP_co.id=1 AND UPPER(lcity)=UPPER('south florida') AND UPPER(lstate)=UPPER('fl') AND lot NOT IN('x-MIA','x-POM','x-WPB') ORDER BY photo DESC, iMP_vShared.id DESC LIMIT 0, 24
TRUCKS FOR SALE IN SOUTH FLORIDA-FL
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302

TRUCKS FOR SALE IN SOUTH FLORIDA-FL

Show Only In-Stock Units
3 RESULTS
USED 2013 ISUZU NPR HD BOX VAN TRUCK #7811
2013 ISUZU NPR HD 16' BOX 16' ISUZU BOX TRUCK GVW 14,500- 150AWB 4HK1-TC, 215HP AIR CONDITIONING AUTOMATIC TRANSMISSION HARD WOOD FLOOR ROLL UP DOOR SINGLE AXLE FLEET MAINTAINED ...
$18,900
South Florida, FL   954-278-8727
Stock #:
NH491195FTL
Mileage:
149,000
Engine:
Isuzu 4HK1-TC215 HP
USED 2015 FREIGHTLINER CASCADIA 125 SLEEPER TRUCK #7789
2015 FREIGHTLINER CASCADIA 125 CUMMINS ISX ENGINE 10 SPEED MANUAL TRANSMISSION ALUMINUM RIMS TRIPAK APU CALL NATIONWIDE HAUL TODAY! SPECIAL FINANCING AVAILABLE "WE'LL GET YOU ROL...
$54,900
South Florida, FL   954-278-8727
Stock #:
NHGA3432F
Mileage:
387,258
Engine:
Cummins ISX
Whlbase:
226
USED 2014 FREIGHTLINER CASCADIA 125 SLEEPER TRUCK #7788
2014 FREIGHTLINER CASCADIA 125 DETROIT DD13 ENG 450 HP 10 SPEED MANUAL TRANSMISSION 3.42 RATIO 226 WHEELBASE DUAL 120 GAL FUEL TANKS ALUMINUM RIMS THERMOKING TRI-PACK APU SLIDING 5TH W...
$44,900
South Florida, FL   954-278-8727
Stock #:
FC1120F
Mileage:
473,112
Engine:
Detroit DD13450 HP
Whlbase:
226
3 RESULTS