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

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

CORNELL EQUIPMENT FOR SALE

2 RESULTS
USED 2011 CORNELL 14NHGH 14
2011 CORNELL 14NHGH 14" WATER PUMP TRASH DEWATERING VIDEO! 13K GPM! JOHN DEERE 2011 CORNELL 14NHGH WATER PUMP, 14" INLET, 14" DISCHARGE, UP TO 13800 GPM FLOW RATES !! SUPER HIGH CAPACITY PUMP -- DOES...
$21,595
Carbondale, PA   570-471-3069
Unit #:
11992
USED CORNELL 8NHTA-EM18DB WATER PUMP EQUIPMENT #11979
CORNELL 8NHTA-EM18DB 8" WATER PUMP VIDEO! DEERE DIESEL 5000 GPM! TRASH PRESSURE GOOD RUNNING AND WORKING PUMP, 8NHTA-EM18DB. JOHN DEERE 6090 ENGINE, 350 HP. HEAVY DUTY PUMP -- FULL SPEC SHEET AVAILAB...
$17,595
Carbondale, PA   570-471-3069
Unit #:
11979
2 RESULTS