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('lakeland ') AND UPPER(lstate)=UPPER('fl') 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 LAKELAND -FL
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302

TRAILERS FOR SALE IN LAKELAND -FL

4 RESULTS
NEW 2019 STOUGHTON Z-PLATE DRY VAN COMPOSIT VAN TRAILER #7409
2019 STOUGHTON Z-PLATE COMPOSITE DRY VAN TRAILER MODEL CODE ZGPVW-535T-S-C-AR MODEL TYPE Z-PLATE CERTIFIED FOR USA & CANADA LENGTH 53 FEET WIDTH 102 INCHES OVERALL HEIGHT 13 FEET 6 INCHES ...
Call for Price
Lakeland , FL   888-712-1294
Stock #:
STDV19L2
NEW 2019 STOUGHTON PURE BLUE **NO REEFER IN REEFER TRAILER #7403
2019 STOUGHTON PURE BLUE REEFER TRAILER ***NO REEFER UNIT INSTALLED*** MODEL: RVCW-535T-S-AR ALUMINUM CORRUGATED SIDE REFRIGERATED VAN TRAILER LENGTH: OVERALL - 53'-0" WIDTH: OVERALL - 102"...
Call for Price
Lakeland , FL   888-712-1294
Stock #:
STPB19L
NEW 2019 STOUGHTON PURE BLUE W/THERMO KING REEFER TRAILER #7396
2019 STOUGHTON PURE BLUE REEFER TRAILER W/THERMO KING C600 MODEL: RVCW-535T-S-AR ALUMINUM CORRUGATED SIDE REFRIGERATED VAN TRAILER LENGTH: OVERALL - 53'-0" WIDTH: OVERALL - 102" INSIDE - 98...
Call for Price
Lakeland , FL   888-712-1294
Stock #:
STPB19KL
NEW 2019 STOUGHTON PURE BLUE W/CARRIER X4 7 REEFER TRAILER #7390
2019 STOUGHTON PURE BLUE REEFER TRAILER W/CARRIER X4 7300 MODEL: RVCW-535T-S-AR ALUMINUM CORRUGATED SIDE REFRIGERATED VAN TRAILER LENGTH: OVERALL - 53'-0" WIDTH: OVERALL - 102" INSIDE - 98...
Call for Price
Lakeland , FL   888-712-1294
Stock #:
STPB19CL
4 RESULTS