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 scweb='van-trailer' AND lot NOT IN('x-MIA','x-POM','x-WPB') ORDER BY photo DESC, iMP_vShared.id DESC LIMIT 0, 24
VAN TRAILERS FOR SALE
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302

VAN TRAILERS FOR SALE

Show Only In-Stock Units
4 RESULTS
USED 2008 STOUGHTON COMPOSITE DRY VAN VAN TRAILER #5453
2008 STOUGHTON DRY VAN 53 X 102 AIR RIDE SWING DOOR ALUMINUM ROOF COMPOSITE PLATED LOGISTIC POSTS HARD WOOD FLOOR TANDEM AXLE DOT INSPECTION IN YOUR COMPANY NAME.. **SPECIAL FINANCING ...
$13,500
South Florida, FL   954-278-8727
Stock #:
NH253537F
USED 2007 HYUNDAI DRY VAN VAN TRAILER #5247
2007 HYUNDAI DRY VAN 53 X 102 AIR RIDE SWING DOOR ALUMINUM ROOF LOGISTIC POST TANDEM AXLE HARD WOOD FLOOR SHEET AND POST PLYWOOD LINED SCUFFLINER DOT IN YOUR COMPANIES NAME.. **SPECI...
$13,500
South Florida, FL   954-278-8727
Stock #:
NH84095F
USED 2014 GREAT DANE DRY VAN VAN TRAILER #5244
2014 GREAT DANE DRY VAN 53 X 102 AIR RIDE SWING DOOR ALUMINUM ROOF LOGISTIC POSTS COMPOSITE PLATED HENDRICKSON PIN PULL AIR SLIDE SUSPENSION TANDEM AXLE HARD WOOD FLOOR DOT INSPECTION I...
$21,500
South Florida, FL   954-278-8727
Stock #:
NH277458F
USED 2015 GREAT DANE DRY VAN VAN TRAILER #5241
2015 GREAT DANE DRY VAN 53 X 102 AIR RIDE SWING DOOR ALUMINUM ROOF LOGISTIC POSTS COMPOSITE PLATED HENDRICKSON PIN PULL AIR SLIDE SUSPENSION TANDEM AXLE HARD WOOD FLOOR DOT INSPECTION I...
$23,900
South Florida, FL   954-278-8727
Stock #:
NH280150F
4 RESULTS