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=4541 and pa.subcategory_id=4702 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 16 In. Chainsaw Bar | milwaukee | 33.28 | CAT4702XZ |
C$ 33.28
In Stock
| Yes | No | ||||
| 1 | Trimmer Line | milwaukee | 16.24 | CAT4702XZ |
C$ 16.24
In Stock
| Yes | No | |||
| 2 | Trimmer Line | milwaukee | 29.86 | CAT4702XZ |
C$ 29.86
In Stock
| Yes | No | |||
| 3 | Trimmer Head | milwaukee | 42.23 | CAT4702XZ |
C$ 42.23
In Stock
| Yes | No | |||
| 4 | Chainsaw Chain | milwaukee | 34.76 | CAT4702XZ |
C$ 34.76
In Stock
| Yes | No | |||
| 5 | String Trimmer Attachment | milwaukee | 208.19 | CAT4702XZ |
C$ 208.19
In Stock
| Yes | No | |||
| 6 | Edger Attachment | milwaukee | 196.49 | CAT4702XZ |
C$ 196.49
In Stock
| Yes | No | |||
| 7 | Hedge Trimmer Attachment | milwaukee | 289.57 | CAT4702XZ |
C$ 289.57
In Stock
| Yes | No | |||
| 8 | Pole Saw Attachment | milwaukee | 277.88 | CAT4702XZ |
C$ 277.88
In Stock
| Yes | No | |||
| 9 | 3 Ft. Attachment Extension | milwaukee | 113.84 | CAT4702XZ |
C$ 113.84
In Stock
| Yes | No | |||
| 10 | Shoulder Strap | milwaukee | 26.92 | CAT4702XZ |
C$ 26.92
In Stock
| Yes | No | |||
| 11 | 10 in. Saw Chain | milwaukee | 33.31 | CAT4702XZ |
C$ 33.31
In Stock
| Yes | No | |||
| 12 | Repl Hose, Handle, Wand Assembly | milwaukee | 115.13 | CAT4702XZ |
C$ 115.13
In Stock
| Yes | No | |||
| 13 | Replacement Sprayer Nozzles | milwaukee | 46.48 | CAT4702XZ |
C$ 46.48
In Stock
| Yes | No | |||
| 14 | 18 Short Sprayer Wand | milwaukee | 51.76 | CAT4702XZ |
C$ 51.76
In Stock
| Yes | No | |||
| 15 | Replacement Water Supply Hose | milwaukee | 115.13 | CAT4702XZ |
C$ 115.13
In Stock
| Yes | No | |||
| 16 | 4-Gallon Sprayer Tank Assembly | milwaukee | 212.08 | CAT4702XZ |
C$ 212.08
In Stock
| Yes | No | |||
| 17 | 6" Saw Chain | milwaukee | 51.94 | CAT4702XZ |
C$ 51.94
Limited Stock
| Yes | No | |||
| 18 | 6" Guide Bar | milwaukee | 51.94 | CAT4702XZ |
C$ 51.94
Limited Stock
| Yes | No | |||
| 19 | Concrete Sprayer Tank Assembly | milwaukee | 245.75 | CAT4702XZ |
C$ 245.75
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | Water Supply Tank Assembly | milwaukee | 223.31 | CAT4702XZ |
C$ 223.31
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |