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('nashville') AND UPPER(lstate)=UPPER('tn') 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 NASHVILLE-TN
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302

TRAILERS FOR SALE IN NASHVILLE-TN

4 RESULTS
NEW 2019 MAC TRAILER MFG ALUMINUM 53' FLATBED FLATBED TRAILER #7696
2019 MAC ROAD WARRIOR 53' FLATBED $31,895* (*TRANSPORT AND FED/LOCAL TAXES NOT INCLUDED IN LIST PRICE.) *COIL PACKAGE INCLUDED SPECS: - 53' X 102" - 80K GVWR - REAR GRIP STRUT STEP...
$31,895
Nashville, TN   --
Stock #:
NH53FBNASC
Lease/Rental Available

USED 2016 WABASH ARCTIC LITE (LOW HOURS) REEFER TRAILER #7526
WABASH REEFER CARRIER X4 7300 REEFER UNIT LOW HOURS (AVERAGE HOURS 5,750-6,750) SIDE SKIRTS AIR RIDE SWING DOOR DUAL TIRES CORRUGATED SIDE PANELS HAZARDOUS LOAD PLACARDS TIRE INFLATION HEAV...
$45,500
Nashville, TN   --
Stock #:
T2016GNAS
Lease/Rental Available

USED 2015 WABASH ARCTIC LITE (LOW HOURS) REEFER TRAILER #7523
WABASH REEFER CARRIER X4 7300 REEFER UNIT LOW HOURS (AVERAGE HOURS 6,750-7,750) SIDE SKIRTS AIR RIDE SWING DOOR DUAL TIRES CORRUGATED SIDE PANELS HAZARDOUS LOAD PLACARDS TIRE INFLATION HEAV...
$39,500
Nashville, TN   --
Stock #:
T2015GNAS
Lease/Rental Available

USED 2014 GREAT DANE EVEREST (LOW HOURS) REEFER TRAILER #7322
2014 GREAT DANE REEFER UNITS 53AX102AX13A6A CARRIER X4 7300 REEFER UNIT LOW HOURS SIDE SKIRTS AIR RIDE SWING DOOR DUAL TIRES CORRUGATED SIDE PANELS HAZARDOUS LOAD PLACARDS TIRE INFLATION B...
$36,500
Nashville, TN   --
Stock #:
T2014GNAS
Lease/Rental Available

4 RESULTS