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='Trailer' 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='Trailer' AND status ='Order' AND list='Public' AND iMP_co.id=1 AND UPPER(lcity)=UPPER('tampa') 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
TRAILERS FOR SALE IN TAMPA-FL
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302

TRAILERS FOR SALE IN TAMPA-FL

16 RESULTS
USED 2009 WABASH DURAPLATE VAN TRAILER #7670
WABASH DURAPLATE DRY VAN STAINLESS CORNER PANELS SIDE SKIRTS HARDWOOD FLOORS SCUFF AND LOADING GUARDS HAZARDOUS MATERIAL PLACARDS SWING DOORS ***SPECIAL FINANCING AVAILABLE*** CALL NATIONWID...
$12,900
Tampa, FL   813-413-5130
Stock #:
KWA09LAK
USED 2008 WABASH DURAPLATE VAN TRAILER #7659
WABASH DURAPLATE DRY VAN STAINLESS CORNER PANELS SIDE SKIRTS HARDWOOD FLOORS SCUFF AND LOADING GUARDS HAZARDOUS MATERIAL PLACARDS SWING DOORS ***SPECIAL FINANCING AVAILABLE*** CALL NATIONWID...
$11,900
Tampa, FL   813-413-5130
Stock #:
KWA08LAK
NEW 2019 STOUGHTON PURE BLUE **NO REEFER IN REEFER TRAILER #7401
2019 STOUGHTON PURE BLUE REEFER TRAILER ***NO REEFER UNIT INSTALLED*** MODEL: RVCW-535T-S-AR ALUMINUM CORRUGATED SIDE REFRIGERATED VAN TRAILER LENGTH: OVERALL - 53'-0" WIDTH: OVERALL - 102"...
Call for Price
Tampa, FL   813-413-5130
Stock #:
STPB19T
NEW 2019 STOUGHTON PURE BLUE W/THERMO KING REEFER TRAILER #7394
2019 STOUGHTON PURE BLUE REEFER TRAILER W/THERMO KING C600 MODEL: RVCW-535T-S-AR ALUMINUM CORRUGATED SIDE REFRIGERATED VAN TRAILER LENGTH: OVERALL - 53'-0" WIDTH: OVERALL - 102" INSIDE - 98...
Call for Price
Tampa, FL   813-413-5130
Stock #:
STPB19KT
NEW 2019 STOUGHTON PURE BLUE W/CARRIER X4 7 REEFER TRAILER #7388
2019 STOUGHTON PURE BLUE REEFER TRAILER W/CARRIER X4 7300 MODEL: RVCW-535T-S-AR ALUMINUM CORRUGATED SIDE REFRIGERATED VAN TRAILER LENGTH: OVERALL - 53'-0" WIDTH: OVERALL - 102" INSIDE - 98...
Call for Price
Tampa, FL   813-413-5130
Stock #:
STPB19CT
NEW 2019 MAC TRAILER MFG ALUMINUM TRI-AXLE 24' END DUMP TRAILER #7381
2019 MAC TRI-AXLE END DUMP W/FRAME SPECS: - ALL ALUMINUM - TRI-AXLE (2 PRIMARY; 1 LIFT) - 80K GVWR - 24' LENGTH X 96" WIDE - SHEET/POST SIDES - TIRE INFLATION SYSTEM AUTO INFLATE TIR...
Call for Price
Tampa, FL   813-413-5130
Stock #:
NH24FDPTAMS
Lease/Rental Available

NEW 2020 MAC TRAILER MFG ALUMINUM 53' DROP DE DROP DECK TRAILER #7373
2020 MAC 53' ALL ALUMINUM DROP DECK CUSTOM BUILD BUILT TO ORDER ALL ALUMINUM DROP DECK TRAILERS. CALL AND CUSTOM BUILD TO YOUR VERY OWN SPECIFICATIONS. PROUD TO BE FLORIDA'S #1 CHOIC...
Call for Price
Tampa, FL   813-413-5130
Stock #:
NH53DPTAM
Lease/Rental Available

NEW 2020 MAC TRAILER MFG ALL ALUM. 53' CUSTOM FLATBED TRAILER #7366
2020 MAC 53' FLATBED CUSTOM BUILD VIRTUALLY ANY CONFIGURATION YOU CAN CREATE. CALL US WITH YOUR SPECS AND WE WILL BUILD IT! CALL AND CUSTOM BUILD TO YOUR VERY OWN SPECIFICATIONS. PROUD ...
Call for Price
Tampa, FL   813-413-5130
Stock #:
NH53CFTAM
Lease/Rental Available

NEW 2020 MAC TRAILER MFG ALL ALUM. 48' CUSTOM FLATBED TRAILER #7361
2020 MAC 48' FLATBED CUSTOM BUILD VIRTUALLY ANY CONFIGURATION YOU CAN CREATE. CALL US WITH YOUR SPECS AND WE WILL BUILD IT! CALL AND CUSTOM BUILD TO YOUR VERY OWN SPECIFICATIONS. PROUD ...
Call for Price
Tampa, FL   813-413-5130
Stock #:
NH48CFTAM
Lease/Rental Available

NEW 2020 MAC TRAILER MFG ALUMINUM HALF ROUND CUST END DUMP TRAILER #7355
2020 MAC TRAILER MANUFACTURING ALUMINUM HALF ROUND CUSTOM BUILD BUILT TO ORDER ALL ALUMINUM HALF ROUND TRAILERS. CALL AND CUSTOM BUILD TO YOUR VERY OWN SPECIFICATIONS. PROUD TO BE FLORIDA...
Call for Price
Tampa, FL   813-413-5130
Stock #:
NHHRDTAM4
Lease/Rental Available

NEW 2019 MAC TRAILER MFG ALUMINUM TRI-AXLE 24' END DUMP TRAILER #7348
2019 MAC TRI-AXLE END DUMP W/FRAME SPECS: - ALL ALUMINUM - TRI-AXLE (2 PRIMARY; 1 LIFT) - 80K GVWR - 24' LENGTH X 96" WIDE - INSET SMOOTH SIDE PANELS - 52" WALL HEIGHT - 8" TOP RAIL...
Call for Price
Tampa, FL   813-413-5130
Stock #:
NH24FDTAMC
Lease/Rental Available

NEW 2019 MAC TRAILER MFG ALUMINUM 48' FLATBED FLATBED TRAILER #7343
2019 MAC ROAD WARRIOR 48' FLATBED *COIL PACKAGE INCLUDED SPECS: - 48'' X 102" - 80K GVWR - REAR GRIP STRUT STEP - HENDRICKSON AIR RIDE SUSPENSION - 22.5 LP TIRES - 2 OUTER NAIL...
Call for Price
Tampa, FL   813-413-5130
Stock #:
NH48FBTAMC
Lease/Rental Available

NEW 2019 MAC TRAILER MFG ALUMINUM 39' TANDEM END DUMP TRAILER #7328
2019 MAC ALUMINUM 39' TANDEM FRAMELESS END DUMP - 80K GVWR - ALL ALUMINUM - 39' LENGTH X 96" WIDE - INSET SMOOTH SIDE PANEL - 60' WALL HEIGHT - SOLID TOP RAIL - RADIUS CORNER...
Call for Price
Tampa, FL   813-413-5130
Stock #:
NH39DTAM4
Lease/Rental Available

USED 2013 GREAT DANE SUPER SEAL REEFER TRAILER #7313
2013 GREAT DANE W/THERMO KING SB230 53' X 102" AIR RIDE ETRACK SWING DOOR THERMOKING SB230 REEFER SIDE SKIRTS DUAL TIRES ALUMINUM RIMS STAINLESS STEEL CORNERS STAINLESS STEEL RE...
$26,900
Tampa, FL   813-413-5130
Stock #:
TD13FLT
Lease/Rental Available

USED 2012 GREAT DANE SUPER SEAL REEFER TRAILER #7312
2012 GREAT DANE W/THERMO KING SB230 53' X 102" AIR RIDE ETRACK SWING DOOR THERMOKING SB230 REEFER SIDE SKIRTS DUAL TIRES ALUMINUM RIMS STAINLESS STEEL CORNERS STAINLESS STEEL RE...
$24,250
Tampa, FL   813-413-5130
Stock #:
TD12FLT
Lease/Rental Available

USED 2014 GREAT DANE SUPER SEAL REEFER TRAILER #7310
2014 GREAT DANE W/THERMO KING SB230 53' X 102" AIR RIDE ETRACK SWING DOOR THERMOKING SB230 REEFER SIDE SKIRTS DUAL TIRES ALUMINUM RIMS STAINLESS STEEL CORNERS STAINLESS STEEL RE...
$30,750
Tampa, FL   813-413-5130
Stock #:
TD14FLT
Lease/Rental Available

16 RESULTS