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('texarkana') AND UPPER(lstate)=UPPER('ar') AND lot NOT IN('x-MIA','x-POM','x-WPB') GROUP BY iMP_vShared.id ORDER BY photo DESC, iMP_vShared.id DESC LIMIT 0, 24
TRAILERS FOR SALE IN TEXARKANA-AR
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302
Google Reviews

TRAILERS FOR SALE IN TEXARKANA-AR

Show Only In-Stock Units
4 RESULTS
USED 2015 WABASH NATIONAL ARCTICLITE (LOW HOURS) REEFER TRAILER #10330
WABASH REEFER CARRIER X4 7300 REEFER UNIT LOW HOURS (AVERAGE HOURS 6,750-7,750) SIDE SKIRTS SPRING RIDE SWING DOOR DUAL TIRES CORRUGATED SIDE PANELS HAZARDOUS LOAD PLACARDS TIRE INFLATION H...
$31,400
Texarkana, AR   954-884-8205
Stock #:
T2015GARK
Trans:

USED 2016 WABASH NATIONAL ARCTICLITE (LOW HOURS) REEFER TRAILER #10329
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...
$37,900
Texarkana, AR   954-884-8205
Stock #:
T2016GARK
Trans:

Lease/Rental Available

USED 2013 VANGUARD REEFER W/ CARRIE REEFER TRAILER #10328
2013 VANGUARD W/ CARRIER 2100A REEFER UNIT SPECS: -STAINLESS CORNER PANELS -REEFER INDICATOR LIGHT -CORRUGATED SIDE PANELS -SIDE SKIRTS -CARRIER 2100A REEFER UNIT -HEAVY DUTY DUCT FLOOR AND S...
$19,400
Texarkana, AR   954-884-8205
Stock #:
R3028ARK
Trans:

Lease/Rental Available

USED 2014 GREAT DANE EVEREST (LOW HOURS) REEFER TRAILER #10327
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...
$29,400
Texarkana, AR   954-884-8205
Stock #:
T2014GARK
Trans:

Lease/Rental Available

4 RESULTS