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=4505 and pa.subcategory_id=4573 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1" Dry Core Masonry Bit | milwaukee | 111.44 | CAT4573XZ |
C$ 111.44
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | ||||
| 1 | 1-1/2" Dry Core Masonry Bit | milwaukee | 127.87 | CAT4573XZ |
C$ 127.87
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 2 | 2" Dry Core Masonry Bit | milwaukee | 173.71 | CAT4573XZ |
C$ 173.71
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 3 | 2-1/2" Dry Core Masonry Bit | milwaukee | 204.29 | CAT4573XZ |
C$ 204.29
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 4 | 3" Dry Core Masonry Bit | milwaukee | 262.5 | CAT4573XZ |
C$ 262.50
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 5 | 3-1/2" Dry Core Masonry Bit | milwaukee | 283.86 | CAT4573XZ |
C$ 283.86
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 6 | 4" Dry Core Masonry Bit | milwaukee | 316.74 | CAT4573XZ |
C$ 316.74
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 7 | 4-1/2" Dry Core Masonry Bit | milwaukee | 366.02 | CAT4573XZ |
C$ 366.02
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 8 | 5" Dry Core Masonry Bit | milwaukee | 398.83 | CAT4573XZ |
C$ 398.83
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 9 | 6" Dry Core Masonry Bit | milwaukee | 456.31 | CAT4573XZ |
C$ 456.31
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |