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('springfield') AND UPPER(lstate)=UPPER('mo') 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 SPRINGFIELD-MO
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302

TRAILERS FOR SALE IN SPRINGFIELD-MO

13 RESULTS
USED 2014 WABASH ARCTICLITE - VIRGIN TIRE REEFER TRAILER #7513
2014 WABASH ARCTICLITE WITH CARRIER UNIT (ALL NEW VIRGIN TIRES!!) SPECS. MANUFACTURER: WABASH MODEL: ARCTICLITE REEFER UNIT: CARRIER 2500A ENGINE DIMENSION: LENGTH 53 FT. X WIDTH 102 IN. X H...
$38,400
Springfield, MO   888-712-1294
Stock #:
PR14WVMO
USED 2015 WABASH ARCTICLITE - VIRGIN TIRE REEFER TRAILER #7507
2015 WABASH ARCTICLITE WITH CARRIER UNIT (ALL NEW VIRGIN TIRES!!) SPECS. MANUFACTURER: WABASH MODEL: ARCTICLITE REEFER UNIT: CARRIER 7500A ENGINE DIMENSION: LENGTH 53 FT. X WIDTH 102 IN. X HEI...
$46,400
Springfield, MO   888-712-1294
Stock #:
PR15WVMOS
Lease/Rental Available

USED 2016 WABASH ARCTICLITE - VIRGIN TIRE REEFER TRAILER #7504
2016 WABASH ARCTICLITE WITH CARRIER UNIT (ALL NEW VIRGIN TIRES!!) SPECS. MANUFACTURER: WABASH MODEL: ARCTICLITE REEFER UNIT: CARRIER 7500A ENGINE DIMENSION: LENGTH 53 FT. X WIDTH 102 IN. X H...
$49,400
Springfield, MO   888-712-1294
Stock #:
PR16WVMO
Lease/Rental Available

USED 2014 WABASH ARCTICLITE W/ SIDE SKIRT REEFER TRAILER #7498
2014 WABASH ARCTICLITE WITH CARRIER UNIT SPECS. MANUFACTURER: WABASH MODEL: ARCTICLITE REEFER UNIT: CARRIER 2500A ENGINE DIMENSION: LENGTH 53 FT. X WIDTH 102 IN. X HEIGHT 13 FT. 6 IN. SUSP...
$36,900
Springfield, MO   888-712-1294
Stock #:
PR14WMO
Lease/Rental Available

USED 2015 WABASH ARCTICLITE W/ SIDE SKIRT REEFER TRAILER #7494
2015 WABASH ARCTICLITE WITH CARRIER UNIT SPECS. MANUFACTURER: WABASH MODEL: ARCTICLITE REEFER UNIT: CARRIER 7500A ENGINE DIMENSION: LENGTH 53 FT. X WIDTH 102 IN. X HEIGHT 13 FT. 6 IN. SUSPEN...
$44,900
Springfield, MO   888-712-1294
Stock #:
PR15WMO
Lease/Rental Available

USED 2016 WABASH ARCTICLITE W/ SIDE SKIRT REEFER TRAILER #7488
2016 WABASH ARCTICLITE WITH CARRIER UNIT SPECS. MANUFACTURER: WABASH MODEL: ARCTICLITE REEFER UNIT: CARRIER 7500A ENGINE DIMENSION: LENGTH 53 FT. X WIDTH 102 IN. X HEIGHT 13 FT. 6 IN. SUSP...
$47,900
Springfield, MO   888-712-1294
Stock #:
PR16WMO
Lease/Rental Available

USED 2014 UTILITY 3000R W/ NEW THERMO KING REEFER TRAILER #7471
2014 UTILITY REEFER TRAILER (3000R) W/ BRAND NEW THERMO KING C600 REEFER UNIT SPECS MANUFACTURER: UTILITY MODEL: 3000R REEFER UNIT: BRAND NEW THERMO KING C600 REEFER UNIT DIMENSION: LENGTH 53 FT....
$51,900
Springfield, MO   888-712-1294
Stock #:
PR14TC6UMO
Lease/Rental Available

USED 2014 UTILITY 3000R VIRGIN TIRES INCLU REEFER TRAILER #7451
2014 UTILITY REEFER TRAILER (3000R) W/ CARRIER UNIT (ALL NEW VIRGIN TIRES!!) SPECS MANUFACTURER: UTILITY MODEL: 3000R REEFER UNIT: CARRIER DIMENSION: LENGTH 53 FT. X WIDTH 102 IN. X HEIGHT 13 ...
$38,400
Springfield, MO   888-712-1294
Stock #:
PR14UVMO
Lease/Rental Available

USED 2014 UTILITY 3000R W/ NEW THERMO KING REEFER TRAILER #7446
2014 UTILITY REEFER TRAILER (3000R) W/ BRAND NEW THERMO KING S600 REEFER UNIT SPECS MANUFACTURER: UTILITY MODEL: 3000R REEFER UNIT: BRAND NEW THERMO KING S600 REEFER UNIT DIMENSION: LENGTH 53 FT....
$55,900
Springfield, MO   888-712-1294
Stock #:
PR14TS6UMO
Lease/Rental Available

USED 2016 UTILITY 3000R VIRGIN TIRES INCLU REEFER TRAILER #7442
2016 UTILITY REEFER TRAILER (3000R) W/ CARRIER UNIT (NEW VIRGIN TIRES!!!) SPECS MANUFACTURER: UTILITY MODEL: 3000R REEFER UNIT: CARRIER DIMENSION: LENGTH 53 FT. X WIDTH 102 IN. X HEIGHT 13 F...
$49,500
Springfield, MO   888-712-1294
Stock #:
PR16UVMO
Lease/Rental Available

USED 2014 UTILITY 3000R W/ NEW CARRIER X4 REEFER TRAILER #7434
2014 UTILITY REEFER TRAILER (3000R) W/ NEW CARRIER X4 7500 REEFER UNIT SPECS MANUFACTURER: UTILITY MODEL: 3000R REEFER UNIT: 2018 CARRIER X4 7400 NEW REEFER UNIT DIMENSION: LENGTH 53 FT. X WID...
$50,900
Springfield, MO   888-712-1294
Stock #:
PR1418UMO
Lease/Rental Available

USED 2014 UTILITY 3000R W/ SIDE SKIRTS REEFER TRAILER #7420
2014 UTILITY REEFER TRAILER (3000R) W/ CARRIER UNIT SPECS MANUFACTURER: UTILITY MODEL: 3000R REEFER UNIT: CARRIER DIMENSION: LENGTH 53 FT. X WIDTH 102 IN. X HEIGHT 13 FT. 6 IN. SUSPENSION: A...
$36,900
Springfield, MO   888-712-1294
Stock #:
PR14UMO
Lease/Rental Available

USED 2016 UTILITY 3000R - SIDE SKIRTS REEFER TRAILER #7415
2016 UTILITY REEFER TRAILER (3000R) W/ CARRIER UNIT SPECS MANUFACTURER: UTILITY MODEL: 3000R REEFER UNIT: CARRIER DIMENSION: LENGTH 53 FT. X WIDTH 102 IN. X HEIGHT 13 FT. 6 IN. SUSPENSION:...
$47,900
Springfield, MO   888-712-1294
Stock #:
PR16UMO
Lease/Rental Available

13 RESULTS