SELECT scweb,scseo,pl,iMP_vSClass.class AS class FROM iMP_vShared 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_vShared.subclass=iMP_vSClass.subclass WHERE scseo IS NOT NULL AND list='Public' AND status='Live' AND iMP_vShared.class='Trailer' AND status IN('Live','Pend') AND list='Public' AND iMP_co.id=2 and iMP_lotM.labbr IN ('FRES') GROUP BY scweb ORDER by scseo

TRAILERS FOR SALE

Gurjit Gill

Cell: (559) 346-9172
ggill@singhtruckcenter.com

TRAILERS FOR SALE

Show Only In-Stock Units
2 RESULTS
USED 2014 UTILITY 3000 REEFER REEFER TRAILER #13460
BRAND NEW THERMOKING S600 REEFER UNIT AND BRAND NEW TIRES! AXLES: TANDEM, FRAME TYPE: STEEL, AIR SUSPENSION, WHEELS: ALUMINUM, TIRES: 23 VIRGIN, REEFER: DIESEL THERMOKING NEW S-600 REEFER, REEFER HOUR...
$51,900
Fresno, CA   559-346-9172
Stock #:
1761270
USED 2014 UTILITY REEFER REEFER TRAILER #13780
S-600 THERMO KING REEFER., AIR INFLATION SYSTEM, WEIGHT SCALE AIR RIDE HENDRICKON SUSPENSION, FUEL ECONOMY REAR FARING. NEW SIDE SKIRTS. AXLES: TANDEM, AIR RIDE SUSPENSION, TIRES: 23, REEFER: DIESEL T...
$47,900
Fresno, CA   559-346-9172
Stock #:
1770134
2 RESULTS
CENTRAL CALIFORNIA'S PREMIER TRUCK & TRAILER DEALER