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('new kingstown') AND UPPER(lstate)=UPPER('pa') AND lot NOT IN('x-MIA','x-POM','x-WPB') GROUP BY iMP_vShared.id ORDER BY photo DESC, iMP_vShared.id DESC LIMIT 0, 24
TRAILERS FOR SALE IN NEW KINGSTOWN-PA
CONTACT NATIONWIDE HAUL
877-659-8302 877-659-8302
Google Reviews

TRAILERS FOR SALE IN NEW KINGSTOWN-PA

Show Only In-Stock Units
3 RESULTS
USED 2012 UTILITY 3000R REEFER TRAILER #10280
2012 UTILITY 3000R (CARRIER X2500A) SPRING RIDE SUSPENSION 53' LENGTH X102" WIDE X 13'6" HEIGHT CARRIER X2500A SIDE SKIRTS LOW HOURS CORRUGATED SIDE PANELS STAINLESS STEEL FRONT CO...
$17,900
New Kingstown, PA   954-884-8205
Stock #:
CR12UPA
Trans:

USED 2013 GREAT DANE W/ CARRIER REEFER REEFER TRAILER #9926
CARRIER REEFER LOW HOURS 53' X 102" SPRING RIDE SWING DOOR HEAVY DUTY DUCT FLOOR DUAL TIRES 22.5LP TIRES SIDE SKIRTS ***SPECIAL FINANCING AVAILABLE*** CALL NATIONWIDE HAUL TODAY! "...
$19,900
New Kingstown, PA   954-884-8205
Stock #:
CR13GDPA
Trans:

USED 2013 UTILITY 3000R REEFER TRAILER #9857
2013 UTILITY 3000R (CARRIER X2500A) SPRING RIDE SUSPENSION 53' LENGTH X102" WIDE X 13'6" HEIGHT CARRIER X2500A SIDE SKIRTS 9500 HOURS! CORRUGATED SIDE PANELS STAINLESS STEEL FRONT ...
$19,900
New Kingstown, PA   954-884-8205
Stock #:
CR13UPA
Trans:

3 RESULTS