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','Pseudo','Prep') AND list='Public' AND iMP_co.id=1 GROUP BY scweb ORDER by scseo

TRAILERS FOR SALE
(570) 471-3069
CARBONDALE, PA
 

TRAILERS FOR SALE

3 RESULTS
USED 2006 WAGNER SMITH T-DP-300 TRAILER #12138
2006 WAGNER SMITH T-DP-300 PULLER TENSIONER REEL TRAILER SINGLE DRUM PULLER GOOD RUNNING, WORKING UNIT, COMPLETE AS PICTURED. HEAVY TRAILER -- WEIGHS JUST UNDER 20 TON LOADED W/ CABLE REEL. JOHN DEER...
$27,595
Carbondale, PA   570-471-3069
Unit #:
12138
USED 2012 VERMEER V500LE-LTHD VACUUM TANKER TRAILER #11577
2012 VERMEER V500LE-LTHD VACUUM EXCAVATOR VAC TRAILER RUNS EXC. DIESEL! 2012 VERMEER/MCLAUGHLIN V500LE VACUUM EXCAVATOR -- TRAILER MOUNTED, KUBOTA DIESEL ENGINE, 500 GALLON TANK, RUNS AND OPERATES, 1...
$21,500
Carbondale, PA   570-471-3069
Unit #:
11577
USED 2004 AMERICAN TAG A LONG TILT DECK TRA TAG TRAILER #11475
2004 AMERICAN TAGALONG TILT DECK TRAILER GALVANIZED NO RUST! HYDRAULIC EQUIPMENT ...
$6,295
Carbondale, PA   570-471-3069
Unit #:
11475
3 RESULTS