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
Google Reviews
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302
Google Reviews

TRAILERS FOR SALE IN LAKELAND -FL

Show Only In-Stock Units
3 RESULTS
USED 2015 UTILITY VS2RA REEFER TRAILER #10128
2015 UTILITY MODEL VS2RA ALUMINUM REFRIGERATED VAN TRAILER CORRUGATED SIDES REAR VENT DOOR 53 FT. LONG, 102 INCHES WIDE, SWING DOORS, ALUMINUM FLOOR, AIR RIDE SUSPENSION, SLIDING TANDEM...
$35,900
Lakeland , FL   954-884-8205
Stock #:
GT2015UTFL
Trans:

USED 2014 UTILITY 3000R REEFER TRAILER #9822
2014 UTILITY MODEL VS2RA 3000R ALUMINUM REFRIGERATED VAN TRAILER, 53 FT. LONG, 102 INCHES WIDE, 13 FT. 6 INCHES HIGH, KEMLITE LINED, SWING DOORS, SINGLE CAM LOCKS, ALUMINUM T-DUCT FLOOR, 12 INCH STEEL...
$27,900
Lakeland , FL   954-884-8205
Stock #:
GT2014UTFL
Trans:

USED 2014 UTILITY 3000R W/ CARRIER REEFER TRAILER #9716
2014 UTILITY MODEL VS2RA 3000R ALUMINUM REFRIGERATED VAN TRAILER 53 FT. LONG, 102 INCHES WIDE, 13 FT. 6 INCHES HIGH, KEMLITE LINED, SWING DOORS, SINGLE CAM LOCKS, HEAVY DUTY ALUMINUM DU...
$27,900
Lakeland , FL   954-884-8205
Stock #:
GT2014UCFL
Trans:

3 RESULTS