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('pensacola') 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 PENSACOLA-FL
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302

TRAILERS FOR SALE IN PENSACOLA-FL

Show Only In-Stock Units
2 RESULTS
NEW 2020 MAC TRAILER MFG ALUMINUM TRI-AXLE 24' END DUMP TRAILER #9372
2020 MAC TRI-AXLE END DUMP W/FRAME F.O.B. FACTORY TARPS NOT INCLUDED IN PRICING SPECS: - ALL ALUMINUM - TRI-AXLE (2 PRIMARY; 1 LIFT) - 80K GVWR - 24' LENGTH X 96" WIDE - INSET SMOOTH ...
$48,724
Pensacola, FL   954-884-8205
Stock #:
NH24FDPENCP
Lease/Rental Available

NEW 2020 MAC TRAILER MFG ALUMINUM TRI-AXLE 24' END DUMP TRAILER #8767
2020 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
Pensacola, FL   954-884-8205
Stock #:
NH24FDPENC
Lease/Rental Available

2 RESULTS