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('charlotte') AND UPPER(lstate)=UPPER('nc') 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 CHARLOTTE-NC
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302

TRAILERS FOR SALE IN CHARLOTTE-NC

3 RESULTS
USED 2009 WABASH DURAPLATE VAN TRAILER #7723
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
Charlotte, NC   --
Stock #:
KWA09CHA
USED 2008 WABASH DURAPLATE VAN TRAILER #7721
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
Charlotte, NC   --
Stock #:
KWA08CHA
NEW 2019 MAC TRAILER MFG ALUMINUM 53' FLATBED FLATBED TRAILER #7720
2019 MAC ROAD WARRIOR 53' FLATBED $31,895* (*TRANSPORT AND FET/LOCAL TAXES NOT INCLUDED IN LIST PRICE.) *COIL PACKAGE INCLUDED SPECS: - 53' X 102" - 80K GVWR - REAR GRIP STRUT STEP...
$31,895
Charlotte, NC   --
Stock #:
NH53FBCHAC
Lease/Rental Available

3 RESULTS