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=4267 and pa.subcategory_id=4271 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| MARVEL 2016 SPIDER-MAN SUM2 SPORT UTILITY MASK/FACESHIELD | save-phace | 78.17 | CAT4271XZ |
C$ 78.17
In Stock
| Yes | No | ||||
| 1 | WELD RFP HELMETS 40VIZI2 SERIES KANNIBAL | save-phace | 235.03 | CAT4271XZ |
C$ 235.03
In Stock
| Yes | No | |||
| 2 | WELD: RFP - LENS: ADF BACK COVER LENS FOR RFP - 5 PACK | save-phace | 6.35 | CAT4271XZ |
C$ 6.35
In Stock
| Yes | No | |||
| 3 | ADF FRONT COVER LENS FOR RFP | save-phace | 7.07 | CAT4271XZ |
C$ 7.07
In Stock
| Yes | No | |||
| 4 | WELD EFP HELMETS GEN Y SERIES GATE KEEPER | save-phace | 266.53 | CAT4271XZ |
C$ 266.53
In Stock
| Yes | No | |||
| 5 | PG308 - SKULL&FIRE AUTO-DARK HELMET | victor | 204.82 | CAT4271XZ |
C$ 204.82
In Stock
| Yes | No | |||
| 6 | PG308 - PISTON/PLUG AUTO-DARK HELMET | victor | 204.82 | CAT4271XZ |
C$ 204.82
In Stock
| Yes | No | |||
| 7 | PG308 - PINSTRIPE AUTO-DARK HELMET | victor | 204.82 | CAT4271XZ |
C$ 204.82
In Stock
| Yes | No | |||
| 8 | PG308 - WELDING HELMET ADF BIKER GIRLS | titan-tools | 135.29 | CAT4271XZ |
C$ 135.29
In Stock
| Yes | No | |||
| 9 | PG308 - WELDING HELMET ADF GEAR HEAD | titan-tools | 135.29 | CAT4271XZ |
C$ 135.29
In Stock
| Yes | No | |||
| 10 | PG308 - SOLAR POWERED AUTO DARK WELDING HELMET | titan-tools | 135.29 | CAT4271XZ |
C$ 135.29
In Stock
| Yes | No | |||
| 11 | PG308 - WELDING HELMET ADF FLAMES | titan-tools | 135.29 | CAT4271XZ |
C$ 135.29
In Stock
| Yes | No | |||
| 12 | PG308 - CLEAR PROTECTIVE REPLACEMENT LENSES | titan-tools | 4.92 | CAT4271XZ |
C$ 4.92
In Stock
| Yes | No | |||
| 13 | PG308 - WELDING GLOVES | titan-tools | 17.18 | CAT4271XZ |
C$ 17.18
In Stock
| Yes | No | |||
| 14 | PG308 - PREMIUM TIG/MIG WELDING GLOVES | hands-autoshot | 25.97 | CAT4271XZ |
C$ 25.97
In Stock
| Yes | No | |||
| 15 | PG308 - AUTO-PRO SOLAR & BATTERY POWERED AUTO-DARKENING WELDING HELMET, 9-13 DIN | hands-autoshot | 262.22 | CAT4271XZ |
H&S Autoshot
PG308 - AUTO-PRO SOLAR & BATTERY POWERED AUTO-DARKENING WELDING HELMET, 9-13 DINPart# HAS-HSW-7030C$ 262.22
In Stock
| Yes | No | |||
| 16 | PARIOT WLDNG HLMT I SERIES | save-phace | 128.21 | CAT4271XZ |
C$ 128.21
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | BLACK ASP EXTREME FACE PROTECTOR 2" X 4" LENS 23 SQ./IN. V | save-phace | 137.47 | CAT4271XZ |
C$ 137.47
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | PG308 - WELDING MASK KIT FOR MIG/TIG/ARC/PLASMA OXY, GRINDING MODE, DIN 4-13 | steel-vision-tools | 207.44 | CAT4271XZ |
Steel Vision Tools
PG308 - WELDING MASK KIT FOR MIG/TIG/ARC/PLASMA OXY, GRINDING MODE, DIN 4-13Part# SVT-32000C$ 207.44
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |