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=4543 and pa.subcategory_id=4707 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Stapler | milwaukee | 200.17 | CAT4707XZ |
| Yes | No | ||||
| 1 | 30 Degree Framing Nailer | milwaukee | 671.47 | CAT4707XZ |
C$ 671.47
In Stock
| Yes | No | |||
| 2 | 30 Degree Framing Nailer Kit | milwaukee | 810.89 | CAT4707XZ |
C$ 810.89
In Stock
| Yes | No | |||
| 3 | 23 Gauge Pin Nailer | milwaukee | 379.28 | CAT4707XZ |
C$ 379.28
Limited Stock
| Yes | No | |||
| 4 | 18 Gauge Brad Nailer | milwaukee | 506.12 | CAT4707XZ |
C$ 506.12
Limited Stock
| Yes | No | |||
| 5 | 18 Gauge Brad Nailer Kit | milwaukee | 624.43 | CAT4707XZ |
C$ 624.43
Limited Stock
| Yes | No | |||
| 6 | Compact Quiet Compressor | milwaukee | 556.46 | CAT4707XZ |
C$ 556.46
Limited Stock
| Yes | No | |||
| 7 | 21 Degree Framing Nailer Kit | milwaukee | 810.89 | CAT4707XZ |
C$ 810.89
| No | No | |||
| 8 | 30 Degree Ext. Capacity Magazine | milwaukee | 135.18 | CAT4707XZ |
C$ 135.18
| No | No | |||
| 9 | M12 PALM NAILER TOOL ONLY | milwaukee | 165.04 | CAT4707XZ |
C$ 165.04
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 10 | M12 PALM NAILER KIT | milwaukee | 256.94 | CAT4707XZ |
C$ 256.94
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 11 | 23 Gauge Pin Nailer Kit | milwaukee | 485.6 | CAT4707XZ |
C$ 485.60
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 12 | 16ga Nailer | milwaukee | 546.01 | CAT4707XZ |
C$ 546.01
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 13 | 21 Degree Framing Nailer | milwaukee | 671.47 | CAT4707XZ |
C$ 671.47
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 14 | 18 Gauge Narrow Crown Stapler | milwaukee | 485.6 | CAT4707XZ |
C$ 485.60
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | 21 Degree Ext. Capacity Magazine | milwaukee | 170.53 | CAT4707XZ |
C$ 170.53
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |