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

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

TRUCKS FOR SALE

2 RESULTS
USED 0 SYKES VP150 PUMPER TRUCK #11102
RUNS & WORKS WELL AS PICTURED. SEE VIDEO BELOW. NICE WELLPOINT PUMP FOR CHEAP CHEAP MONEY -- DON'T MISS IT. HTTPS://WWW.YOUTUBE.COM/WATCH?V=XP8Y8A9AC98&FEATURE=YOUTU.BE ...
$4,595
Carbondale, PA   570-471-3069
Unit #:
11102
USED 2004 ALTEC D-3060 DIGGER DERRICK TRUCK #11015
2004 MODEL YEAR, NO USEAGE. WAS PURCHASED AS GOVERNMENT SURPLUS AND REMOVED FROM ORIGINAL TRUCK, SEE PICTURES. TOO CLEAN TO BELIEVE!! INCLUDES ALL ACCESSORIES, WIRING, AND COMPUTER. FRONT WINCH BUMPER...
$45,000
Carbondale, PA   570-471-3069
Unit #:
11015
2 RESULTS