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('columbus') AND UPPER(lstate)=UPPER('oh') 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 COLUMBUS-OH
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302

TRAILERS FOR SALE IN COLUMBUS-OH

Show Only In-Stock Units
5 RESULTS
USED 2011 WABASH DURAPLATE DRY VAN VAN TRAILER #9320
2011 WABASH 53X102 DURAPLATE DRY VAN - AIR RIDE SUSPENSION - AIR ASSIST SLIDING TANDEM - AERODYNAMIC SKIRTS - RIGHT WEIGH LOAD SCALES - FRESH PAINTED REAR FRAME AND WHEELS -STAINLESS CORNER PA...
$18,500
Columbus, OH   954-884-8205
Stock #:
GD23746COL
USED 2013 UTILITY 3000R REEFER TRAILER #8896
2013 UTILITY W/ THERMO KING REEFER UNIT AIR RIDE SWING DOOR DUAL TIRES STAINLESS CORNER PANELS BACK VENT DOOR HEAVY DUTY DUCT FLOOR ALUMINUM SCUFF LINER ***SPECIAL FINANCING AVAILABLE***...
$32,900
Columbus, OH   954-884-8205
Stock #:
KTK2013COL
USED 2013 UTILITY 3000R REEFER TRAILER #8890
2013 UTILITY W/ THERMO KING REEFER UNIT SIDE SKIRTS AIR RIDE SWING DOOR DUAL TIRES REEFER INDICATOR LIGHT STAINLESS CORNER PANELS BACK VENT DOOR HEAVY DUTY DUCT FLOOR ALUMINUM SCUFF LINER ...
$32,900
Columbus, OH   954-884-8205
Stock #:
KCA2013COL
USED 2013 HYUNDAI REEFER (HIGH CUBE) REEFER TRAILER #8716
2013 HYUNDAI REEFER (HIGH CUBE) -LOW HOURS -REEFER INDICATOR LIGHT -SIDE SKIRTS -CORRUGATED SIDE PANELS -HIGH CUBE -STAINLESS SWING BACK DOORS -HEAVY DUTY DUCT FLOORS AND SKID GUARDS -WELL...
$26,500
Columbus, OH   954-884-8205
Stock #:
CD13OH
USED 2016 GREAT DANE EVEREST - HIGH CUBE (THE REEFER TRAILER #8708
2016 GREAT DANE EVEREST (HIGH CUBE) 53A LENGTH X 102A WIDE HIGH CUBE: 108.25 HEIGHT AT REAR / 105.25 AT FRONT THERMO KING PRECEDENT S-600 LOW REEFER HOURS TANDEM AXLE AIR RIDE SWING DOORS...
$52,400
Columbus, OH   954-884-8205
Stock #:
CD16GDT1CO
5 RESULTS