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=3974 and pa.subcategory_id=3978 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG293 - 5-PC TRIM REMOVAL SET | lisle-corporation | 73.55 | CAT3978XZ |
C$ 73.55
In Stock
| Yes | No | ||||
| 1 | PG294 - 2-PC PUSH PIN REMOVAL PLIERS, (#V230 & #V231), STRAIGHT & OFFSET | vim-tools | 126.64 | CAT3978XZ |
C$ 126.64
In Stock
| Yes | No | |||
| 2 | PG294 - 6 PC. MULTI WEDGE PRY TOOL SET | titan-tools | 15.84 | CAT3978XZ |
C$ 15.84
In Stock
| Yes | No | |||
| 3 | EASY PRY | steck | 11.54 | CAT3978XZ |
| Yes | No | |||
| 4 | PG294 - RIGHT ANGLE SURE GRIP TRIM CLIP PLIER | steck | 41.8 | CAT3978XZ |
C$ 41.80
In Stock
| Yes | No | |||
| 5 | PG294 - SURE GRIP TRIM CLIP PLIERS | steck | 41.8 | CAT3978XZ |
C$ 41.80
In Stock
| Yes | No | |||
| 6 | PG293 - 2-PC CLIP REMOVAL PRY TOOLS KIT, 3/4" & 1-1/2" WIDE TIPS | sandg-tool-aid | 40.2 | CAT3978XZ |
C$ 40.20
In Stock
| Yes | No | |||
| 7 | PG293 - 7 3/4" LONG TACK PULLER | sandg-tool-aid | 10.3 | CAT3978XZ |
C$ 10.30
In Stock
| Yes | No | |||
| 8 | PG293 - UPHOLSTERY CLIP REMOVAL TOOL | sandg-tool-aid | 11.81 | CAT3978XZ |
C$ 11.81
In Stock
| Yes | No | |||
| 9 | PG293 - 5-PIECE CLIP LIFTER SET | mueller-kueps | 120.19 | CAT3978XZ |
C$ 120.19
In Stock
| Yes | No | |||
| 10 | PG293 - CLIP LIFTER | mueller-kueps | 22.19 | CAT3978XZ |
C$ 22.19
In Stock
| Yes | No | |||
| 11 | PG294 - COMBI WEDGE | mueller-kueps | 13.73 | CAT3978XZ |
C$ 13.73
In Stock
| Yes | No | |||
| 12 | PG294 - 3" WIDE MOLDING STRIP TOOL WITH SHARP EDGE | lisle-corporation | 17.1 | CAT3978XZ |
C$ 17.10
In Stock
| Yes | No | |||
| 13 | PG294 - 5 PIECE WEDGE ASSORTMENT SET | lisle-corporation | 35.66 | CAT3978XZ |
C$ 35.66
In Stock
| Yes | No | |||
| 14 | PG294 - ANGLED HOG RING PLIER | lisle-corporation | 32.56 | CAT3978XZ |
C$ 32.56
In Stock
| Yes | No | |||
| 15 | PG294 - STRAIGHT HOG RING PLIER | lisle-corporation | 32.05 | CAT3978XZ |
C$ 32.05
In Stock
| Yes | No | |||
| 16 | PG294 - MIRROR REMOVAL WRENCH | lisle-corporation | 12.9 | CAT3978XZ |
C$ 12.90
In Stock
| Yes | No | |||
| 17 | PG294 - PLASTIC CLIP REMOVAL PLIERS FOR PUSH PIN TYPE PANEL FASTENERS WITH CENTER PINS | lisle-corporation | 27.26 | CAT3978XZ |
Lisle Corporation
PG294 - PLASTIC CLIP REMOVAL PLIERS FOR PUSH PIN TYPE PANEL FASTENERS WITH CENTER PINSPart# LIS-42810C$ 27.26
In Stock
| Yes | No | |||
| 18 | PG294 - PUSH PIN PLIERS, 80 TIP | lisle-corporation | 30.46 | CAT3978XZ |
C$ 30.46
In Stock
| Yes | No | |||
| 19 | PG293 - 19.75" LONG DOOR PANEL UPHOLSTERY CLIP REMOVAL TOOL, FOR PLASTIC AND METAL CLIPS | lisle-corporation | 23.06 | CAT3978XZ |
Lisle Corporation
PG293 - 19.75" LONG DOOR PANEL UPHOLSTERY CLIP REMOVAL TOOL, FOR PLASTIC AND METAL CLIPSPart# LIS-35600C$ 23.06
In Stock
| Yes | No | |||
| 20 | PG293 - DOOR UPHOLSTERY REMOVER | lisle-corporation | 12.4 | CAT3978XZ |
C$ 12.40
In Stock
| Yes | No | |||
| 21 | PG293 - V-GROOVE PLASTIC CLIP REMOVER | lisle-corporation | 14.41 | CAT3978XZ |
C$ 14.41
In Stock
| Yes | No | |||
| 22 | PG293 - WEATHER STRIP REMOVER | lisle-corporation | 14.92 | CAT3978XZ |
C$ 14.92
In Stock
| Yes | No | |||
| 23 | PG293 - KIT DOOR PANEL 4PC | gearwrench | 58.18 | CAT3978XZ |
C$ 58.18
In Stock
| Yes | No | |||
| 24 | PG294 - 2PC PUSH PIN PLIERS SET, 30 & 80 OFFSET | gearwrench | 55.99 | CAT3978XZ |
C$ 55.99
In Stock
| Yes | No | |||
| 25 | PG294 - PUSH PIN REMOVAL PLIERS - 30 OFFSET | gearwrench | 34.49 | CAT3978XZ |
C$ 34.49
In Stock
| Yes | No | |||
| 26 | PG294 - ADJUSTABLE INDEXING TRIM CLIP PLIERS FOR PLASTIC ANCHORS WITH CENTER PINS | calvan-horizon-tools | 67.08 | CAT3978XZ |
Calvan Horizon Tools
PG294 - ADJUSTABLE INDEXING TRIM CLIP PLIERS FOR PLASTIC ANCHORS WITH CENTER PINSPart# CAL-54C$ 67.08
In Stock
| Yes | No | |||
| 27 | PG293 - 4-PC UPHOLSTERY TOOL SET | astro-pneumatics | 46.75 | CAT3978XZ |
C$ 46.75
In Stock
| Yes | No | |||
| 28 | PG294 - SLIM, LOW PROFILE PRECISION PANEL CLIP PLIERS | astro-pneumatics | 18.7 | CAT3978XZ |
C$ 18.70
In Stock
| Yes | No | |||
| 29 | PG293 - 11PC. AUTO FASTENER & MOLDING REMOVAL TOOL SET | astro-pneumatics | 28.44 | CAT3978XZ |
C$ 28.44
In Stock
| Yes | No | |||
| 30 | PG293 - 5P FASTBR REMR | astro-pneumatics | 14.58 | CAT3978XZ |
C$ 14.58
In Stock
| Yes | No | |||
| 31 | PG293 - 5-PC TRIM REMOVAL SET | lisle-corporation | 73.55 | CAT3978XZ |
C$ 73.55
In Stock
| Yes | No | |||
| 32 | PG294 - ADJUSTABLE INDEXING TRIM CLIP PLIERS FOR PLASTIC ANCHORS WITH CENTER PINS | calvan-horizon-tools | 67.08 | CAT3978XZ |
Calvan Horizon Tools
PG294 - ADJUSTABLE INDEXING TRIM CLIP PLIERS FOR PLASTIC ANCHORS WITH CENTER PINSPart# CAL-54C$ 67.08
In Stock
| Yes | No | |||
| 33 | PG294 - BODY CLIP REMOVAL PLIERS | vim-tools | 51.29 | CAT3978XZ |
C$ 51.29
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 34 | PG293 - OMEGA CLIP PRY LEVER FOR USE ON AUDI/PORSCHE/VW/TESLA | assenmacher | 63.8 | CAT3978XZ |
C$ 63.80
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 35 | PG294 - ANGLED HEAD PLASTIC CLIP POPPER PLIERS | otc-tools | 75.12 | CAT3978XZ |
C$ 75.12
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 36 | PG293 - 23" LONG GLASS CHANNEL CLEANING TOOL WITH HOOKED TIP | lisle-corporation | 28.36 | CAT3978XZ |
C$ 28.36
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |