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

UNIVERSAL EQUIPMENT FOR SALE
(570) 471-3069
CARBONDALE, PA
 

UNIVERSAL EQUIPMENT FOR SALE

1 RESULTS
USED 2010 UNIVERSAL HDD 12X15 DIRECTIONAL DR VERTICAL DRILLING RIG EQUIPMENT #12766
2010 UNIVERSAL HDD 12X15 DIRECTIONAL DRILL, COMES WITH ONE FULL RACK OF DRILL PIPE, JOHN DEERE TURBO DIESEL ENGINE, OPEN OPERATOR STATION, 2100 HOURS, KERR MUD PUMP, UMBILICAL REMOTE CONTROL, 12K LBS ...
$22,500
Carbondale, PA   570-471-3069
Unit #:
12766
1 RESULTS