A Canadian Company
filters
Select pa.*,
b.title bnm, b.title_seo bnmseo, b.discount bdiscount,
c.title cnm, c.title_seo cnmseo, c.discount cdiscount,
c1.title scnm, c1.title_seo scnmseo, c1.discount scdiscount
from pa
LEFT JOIN brands b ON pa.brand_id = b.id and b.visible=0
LEFT JOIN categories c ON pa.category_id = c.id and c.visible=0
LEFT JOIN categories c1 ON pa.subcategory_id = c1.id and c1.visible=0
where pa.visible=0 and pa.delflag=0 and pa.category_id=4078 and pa.subcategory_id=4081 order by pa.featured desc,pa.sort_order,FIELD(status,1,3,6,5,1,4,2)
Showing 1 to x of xx results
| # | name | brand | price | category | stock | sale | OilType | OilVol | OilGrade | |
|---|---|---|---|---|---|---|---|---|---|---|
| FLEXIBLE CLAW PICKUP TOOL, 24" LONG | vim-tools | 27 | CAT4081XZ |
C$ 27.00
In Stock
| Yes | No | ||||
| 1 | TELESCOPING MAGNETIC PICK-UP TOOL - NO.15XHV | ullman | 14.15 | CAT4081XZ |
C$ 14.15
In Stock
| Yes | No | |||
| 2 | TELESCOPING MAGNETIC PICK-UP TOOL - HT-10 | ullman | 27 | CAT4081XZ |
C$ 27.00
In Stock
| Yes | No | |||
| 3 | PG50 - CAMERA ASSISTED MAGNETIC RETRIEVAL TOOL | ullman | 168.3 | CAT4081XZ |
C$ 168.30
In Stock
| Yes | No | |||
| 4 | PG50 - BACKSCRATCHER MAGNETIC PICK UP TOOL | titan-tools | 5.93 | CAT4081XZ |
C$ 5.93
In Stock
| Yes | No | |||
| 5 | PG50 - 3 LB. TELESCOPING MAGNETIC PICKUP TOOL | titan-tools | 4.16 | CAT4081XZ |
C$ 4.16
In Stock
| Yes | No | |||
| 6 | PG50 - 3-PC PICK UP TOOL SET | sunex | 64.31 | CAT4081XZ |
C$ 64.31
In Stock
| Yes | No | |||
| 7 | PG50 - 5 LLBS MAGNETIC PICK-UP TOOL, 6-1/4" TO 34-1/4" | mayhew | 15.84 | CAT4081XZ |
C$ 15.84
In Stock
| Yes | No | |||
| 8 | PG50 - 2-1/2 LBS MAGNETIC PICK-UP TOOL, 6-1/4" TO 34-1/4" | mayhew | 13.15 | CAT4081XZ |
C$ 13.15
In Stock
| Yes | No | |||
| 9 | PG50 - TELESCOPING MAGNETIC PICK-UP TOOL, 3 LB MAGNET, FIXED HEAD | mayhew | 25.25 | CAT4081XZ |
C$ 25.25
In Stock
| Yes | No | |||
| 10 | PG50 - TELESCOPING MAGNETIC PICK-UP TOOL, 14 LB MAGNET, SWIVEL HEAD | mayhew | 39.28 | CAT4081XZ |
C$ 39.28
In Stock
| Yes | No | |||
| 11 | PG50 - TELESCOPING MAGNETIC PICK-UP TOOL, 14 LB MAGNET, FIXED HEAD | mayhew | 31.97 | CAT4081XZ |
C$ 31.97
In Stock
| Yes | No | |||
| 12 | 14" LONG MANTUS TIGHT ACCESS PICK-UP TOOL | ipa-tools | 33.32 | CAT4081XZ |
C$ 33.32
In Stock
| Yes | No | |||
| 13 | PG50 - 1.5 LBS CAPACITY TELESCOPING MAGNETIC PICKUP TOOL | gearwrench | 7.61 | CAT4081XZ |
C$ 7.61
In Stock
| Yes | No | |||
| 14 | MAGNET ON INSULATED FLEXIBLE HANDLE, 1000VAC - 1500 VDC, 19" LONG, 6MM DIAMETER MAGNET | catu | 228.62 | CAT4081XZ |
CATU
MAGNET ON INSULATED FLEXIBLE HANDLE, 1000VAC - 1500 VDC, 19" LONG, 6MM DIAMETER MAGNETPart# CTU-MO7582DC$ 228.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | MAGNET ON INSULATED FLEXIBLE HANDLE, 1000VAC - 1500 VDC, 19" LONG, 6MM DIAMETER MAGNET | catu | 228.62 | CAT4081XZ |
CATU
MAGNET ON INSULATED FLEXIBLE HANDLE, 1000VAC - 1500 VDC, 19" LONG, 6MM DIAMETER MAGNETPart# CTU-MO7582DC$ 228.62
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | FLEXIBLE LIGHTED PICK-UP TOOL | mayhew | 43.46 | CAT4081XZ |
C$ 43.46
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | PG50 - 10 LBS MAGNETIC PICK-UP TOOL, 6-1/4" TO 30-1/4" | mayhew | 19.45 | CAT4081XZ |
C$ 19.45
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |