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('ontario') AND UPPER(lstate)=UPPER('ca') 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 ONTARIO-CA
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302

TRAILERS FOR SALE IN ONTARIO-CA

Show Only In-Stock Units
3 RESULTS
USED 2014 UTILITY 3000R HIGH CUBE W/THERMO REEFER TRAILER #9037
2014 UTILITY 3000R (HIGH CUBE) REEFER (THERMO KING PRECEDENT S600 - CARB FOREVER) - THERMO KING PRECEDENT S600 (CARB COMPLIANT FOREVER!) - LOW HOURS - HIGH CUBE WEDGE TRAILER (103" IN FRONT & 107...
$39,500
Ontario, CA   954-884-8205
Stock #:
MT14UTKCA
USED 2015 UTILITY 3000R HIGH CUBE REEFER TRAILER #8919
2015 UTILITY 3000R W/ 7300X4 CARRIER REEFER UNIT 53' X 102" AIR RIDE SWING DOOR CARRIER REEFER - LOW HOURS SIDE SKIRTS DUAL TIRES TANDEM AXLE HEAVY DUTY DUCT FLOOR CALL NATIONW...
$39,900
Ontario, CA   954-884-8205
Stock #:
MT15UCC
USED 2014 UTILITY 3000R HIGH CUBE REEFER TRAILER #8874
2014 UTILITY 3000R W/ 7300X4 CARRIER REEFER UNIT 53' X 102" AIR RIDE SWING DOOR CARRIER REEFER - LOW HOURS SIDE SKIRTS DUAL TIRES TANDEM AXLE HEAVY DUTY DUCT FLOOR CALL NATIONW...
$32,900
Ontario, CA   954-884-8205
Stock #:
MT14UCC
3 RESULTS