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('macon') AND UPPER(lstate)=UPPER('ga') 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 MACON-GA
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302
Google Reviews

TRAILERS FOR SALE IN MACON-GA

Show Only In-Stock Units
8 RESULTS
USED 2012 GREAT DANE SUPER SEAL REEFER TRAILER #10617
2012 GREAT DANE SUPER SEAL REEFER TRAILER FEATURES: -THERMO KING SB-230 REEFER UNIT -REAR DOOR VENT -CORRUGATED SIDES -ALUMINUM RIM WHEELS -HAZARDOUS MATERIALS PLACARDS -HEAVY DUTY DUCT FLOO...
$19,900
Macon, GA   678-880-4696
Stock #:
NH10465
Trans:

USED 2012 GREAT DANE SUPER SEAL REEFER TRAILER #10613
2012 GREAT DANE SUPER SEAL REEFER TRAILER FEATURES: -THERMO KING SB-230 REEFER UNIT -REAR DOOR VENT -CORRUGATED SIDES -ALUMINUM RIM WHEELS -HAZARDOUS MATERIALS PLACARDS -HEAVY DUTY DUCT FLOO...
$19,900
Macon, GA   678-880-4696
Stock #:
NH10466
Trans:

USED 2012 GREAT DANE SUPER SEAL REEFER TRAILER #10612
2012 GREAT DANE SUPER SEAL REEFER TRAILER FEATURES: -THERMO KING SB-230 REEFER UNIT -REAR DOOR VENT -CORRUGATED SIDES -ALUMINUM RIM WHEELS -HAZARDOUS MATERIALS PLACARDS -HEAVY DUTY DUCT FLOO...
$19,900
Macon, GA   678-880-4696
Stock #:
NH10467
Trans:

USED 2015 UTILITY 3000R REEFER TRAILER #10512
2015 UTILITY 3000R W/ THERMO KING SB-230 REEFER UNIT FEATURING: -TIRE INFLATION -CORRUGATED SIDES -SIDE SKIRTS -STAINLESS CORNER PANELS ***SPECIAL FINANCING AVAILABLE*** CALL NATIONWIDE HAU...
$33,900
Macon, GA   678-880-4696
Stock #:
NH15002
Trans:

USED 2015 UTILITY 3000R REEFER TRAILER #10433
2015 UTILITY 3000R W/ THERMO KING SB-230 REEFER UNIT FEATURING: -TIRE INFLATION -CORRUGATED SIDES -SIDE SKIRTS -STAINLESS CORNER PANELS ***SPECIAL FINANCING AVAILABLE*** CALL NATIONWIDE HAU...
$35,900
Macon, GA   678-880-4696
Stock #:
NH15003
Trans:

USED 2014 UTILITY W/ CARRIER REEFER UNIT REEFER TRAILER #10270
2014 UTILITY W/CARRIER REEFER TIRE INFLATION SIDE SKIRTS 53AX102A AIR RIDE SUSPENSION SWING DOORS HEAVY DUTY DUCT FLOOR DUCT SCUFF PANEL ***SPECIAL FINANCING AVAILABLE*** CALL NATIONWID...
$30,900
Macon, GA   678-880-4696
Stock #:
NH20715
Trans:

USED 2013 UTILITY 3000R W/ 2015 REEFER REEFER TRAILER #10269
2013 UTILITY 3000R W/2015 CARRIER REEFER UNIT STAINLESS STEEL CORNER PANELS AIR RIDE SWING DOORS SIDE SKIRTS SIDEWALL SCUFF TANDEM AXLE HAZARDOUS MATERIALS TRUCK PLACARDS ALUMINUM WHEELS ...
$29,900
Macon, GA   678-880-4696
Stock #:
NH130583
Trans:

USED 2013 UTILITY W/ CARRIER REEFER UNIT REEFER TRAILER #10268
2013 UTILITY REEFER TRAILER (CARRIER) 53AX102A AIR RIDE EQUIPPED HAZARDOUS MATERIALS TRUCK PLACARDS SIDEWALL SCUFF HEAVY DUTY DUCT FLOORS SIDE SKIRTS INCLUDED SWING DOORS TANDEM AXLE ***S...
$24,900
Macon, GA   678-880-4696
Stock #:
NH19956
Trans:

8 RESULTS