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=4554 and pa.subcategory_id=4749 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| MB15 Welding tip .023 (10/pk) | amh-canada-ltd | 2.05 | CAT4749XZ |
C$ 2.05
| No | No | ||||
| 1 | MB15 Welding tip .030 (10/pk) | amh-canada-ltd | 2.05 | CAT4749XZ |
C$ 2.05
| No | No | |||
| 2 | MB15 Welding tip .035 (10/pk) | amh-canada-ltd | 2.05 | CAT4749XZ |
C$ 2.05
| No | No | |||
| 3 | Wiggle wire 16 GA (Pkt 1lb) | amh-canada-ltd | 46.74 | CAT4749XZ |
C$ 46.74
| No | No | |||
| 4 | Cart for CompuSpot 160 DIGITAL & DUAL | amh-canada-ltd | 373.44 | CAT4749XZ |
C$ 373.44
| No | No | |||
| 5 | Nozzle spring MB15 | amh-canada-ltd | 2.71 | CAT4749XZ |
C$ 2.71
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 6 | Carbon rod | amh-canada-ltd | 5.5 | CAT4749XZ |
C$ 5.50
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 7 | Swan neck MB15 | amh-canada-ltd | 43.84 | CAT4749XZ |
C$ 43.84
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 8 | Spool gun (20ft) | amh-canada-ltd | 1943.87 | CAT4749XZ |
C$ 1,943.87
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 9 | Mig gun MB15 | amh-canada-ltd | 494.11 | CAT4749XZ |
C$ 494.11
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 10 | MB15 Welding tip .045 (10/pk) | amh-canada-ltd | 20.48 | CAT4749XZ |
C$ 20.48
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 11 | MB15 Welding tip .040 (10/pk) | amh-canada-ltd | 20.48 | CAT4749XZ |
C$ 20.48
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 12 | Washer tip | amh-canada-ltd | 39.6 | CAT4749XZ |
C$ 39.60
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 13 | Shrinking tip | amh-canada-ltd | 19.87 | CAT4749XZ |
C$ 19.87
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 14 | Single spot tip | amh-canada-ltd | 31.55 | CAT4749XZ |
C$ 31.55
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | Long stud tip (nails) | amh-canada-ltd | 32.11 | CAT4749XZ |
C$ 32.11
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | Wiggles wire tip | amh-canada-ltd | 23.94 | CAT4749XZ |
C$ 23.94
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | Adapter holder for carbon rod | amh-canada-ltd | 57.19 | CAT4749XZ |
C$ 57.19
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | Conical nozzle MB15 | amh-canada-ltd | 12.31 | CAT4749XZ |
C$ 12.31
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 19 | Cylindrical nozzle MB15 | amh-canada-ltd | 12.8 | CAT4749XZ |
C$ 12.80
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | Spot nozzle MB15 | amh-canada-ltd | 18.9 | CAT4749XZ |
C$ 18.90
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | Puller mandrel 4mm | amh-canada-ltd | 31.38 | CAT4749XZ |
C$ 31.38
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | Puller mandrel 5mm | amh-canada-ltd | 28.45 | CAT4749XZ |
C$ 28.45
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | Puller mandrel 6mm | amh-canada-ltd | 27.82 | CAT4749XZ |
C$ 27.82
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | Stars (Pkt 10) | amh-canada-ltd | 2.22 | CAT4749XZ |
C$ 2.22
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | 2 Finger bear claw | amh-canada-ltd | 83.94 | CAT4749XZ |
C$ 83.94
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | 5 Finger bear claw | amh-canada-ltd | 120.37 | CAT4749XZ |
C$ 120.37
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 27 | Wiggle wire 12 GA (Pkt 1/2lb) | amh-canada-ltd | 26.14 | CAT4749XZ |
C$ 26.14
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 28 | Wiggle wire 16 GA (Pkt 5lb) | amh-canada-ltd | 218.14 | CAT4749XZ |
C$ 218.14
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 29 | Wiggle wire 16 GA (Pkt 1/2lb) | amh-canada-ltd | 26.14 | CAT4749XZ |
C$ 26.14
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 30 | Wiggle wire 12 GA (Pkt 1lb) | amh-canada-ltd | 46.74 | CAT4749XZ |
C$ 46.74
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 31 | Wiggle wire 12 GA (Pkt 5lb) | amh-canada-ltd | 218.14 | CAT4749XZ |
C$ 218.14
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 32 | Standard hand lifter for CPS160 | amh-canada-ltd | 481.66 | CAT4749XZ |
C$ 481.66
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 33 | Automatic spot pulling gun | amh-canada-ltd | 1030.8 | CAT4749XZ |
C$ 1,030.80
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 34 | Pulling bar | amh-canada-ltd | 1204.02 | CAT4749XZ |
C$ 1,204.02
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 35 | Straightening bar | amh-canada-ltd | 724.75 | CAT4749XZ |
C$ 724.75
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 36 | Angle support | amh-canada-ltd | 958.21 | CAT4749XZ |
C$ 958.21
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 37 | Energic slide hammer with adaptor | amh-canada-ltd | 572.48 | CAT4749XZ |
C$ 572.48
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 38 | Energic slide hammer with hook | amh-canada-ltd | 298.39 | CAT4749XZ |
C$ 298.39
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 39 | Mandrel for nail | amh-canada-ltd | 98.1 | CAT4749XZ |
C$ 98.10
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 40 | Ground plate holder | amh-canada-ltd | 72.88 | CAT4749XZ |
C$ 72.88
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 41 | Nails (Pkt 100) | amh-canada-ltd | 0.23 | CAT4749XZ |
C$ 0.23
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 42 | Washer (Pkt 100) | amh-canada-ltd | 0.24 | CAT4749XZ |
C$ 0.24
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |