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=4540 and pa.subcategory_id=4692 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 18-Volt Cordless Wet/Dry Vacuum | milwaukee | 199.43 | CAT4692XZ |
C$ 199.43
In Stock
| Yes | No | ||||
| 1 | compact vacuum | milwaukee | 121.26 | CAT4692XZ |
C$ 121.26
Limited Stock
| Yes | No | |||
| 2 | Compact Vacuum | milwaukee | 203.36 | CAT4692XZ |
C$ 203.36
| No | No | |||
| 3 | M18 FUEL 3IN1 BP VACUUM | milwaukee | 463.52 | CAT4692XZ |
C$ 463.52
| No | No | |||
| 4 | Compact Vacuum | milwaukee | 324.12 | CAT4692XZ |
C$ 324.12
| No | No | |||
| 5 | M12 FUEL 1.6 Gal. Wet/Dry Vacuum | milwaukee | 207.95 | CAT4692XZ |
C$ 207.95
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 6 | Vacuum Hose Adapter | milwaukee | 20.3 | CAT4692XZ |
C$ 20.30
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 7 | Vacuum Hose | milwaukee | 70.94 | CAT4692XZ |
C$ 70.94
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 8 | VAC BIT ADAPTER | milwaukee | 34.32 | CAT4692XZ |
C$ 34.32
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 9 | VAC BIT | milwaukee | 126.85 | CAT4692XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 10 | VAC BIT | milwaukee | 133.86 | CAT4692XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 11 | VAC BIT | milwaukee | 162.91 | CAT4692XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 12 | VAC BIT | milwaukee | 178.78 | CAT4692XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 13 | VAC BIT | milwaukee | 199.99 | CAT4692XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 14 | VAC BIT ADAPTER | milwaukee | 34.32 | CAT4692XZ |
C$ 34.32
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | VAC BIT | milwaukee | 328.5 | CAT4692XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | VAC BIT | milwaukee | 349.39 | CAT4692XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | VAC BIT | milwaukee | 361.36 | CAT4692XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | VAC BIT | milwaukee | 459.89 | CAT4692XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 19 | VAC BIT | milwaukee | 585.3 | CAT4692XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | VAC BIT | milwaukee | 609.2 | CAT4692XZ |
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 21 | VACUUM PAD KIT | milwaukee | 191.52 | CAT4692XZ |
C$ 191.52
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 22 | MILWAUKEE VACUUM PUMP ASSEMBLY | milwaukee | 845.94 | CAT4692XZ |
C$ 845.94
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | Compact Vacuum Filter | milwaukee | 34.66 | CAT4692XZ |
C$ 34.66
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | Vacuum Assisted Dust Extractor | milwaukee | 135.32 | CAT4692XZ |
C$ 135.32
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |