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=4005 and pa.subcategory_id=4021 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG54 - M18 COMPACT IMPACT WRENCH & GRINDER 2-TOOL COMBO KIT, (2) BATTERIES, (1) MULTI-VOLTAGE CHARGER | milwaukee-electric | 641.63 | CAT4021XZ |
Milwaukee Electric
PG54 - M18 COMPACT IMPACT WRENCH & GRINDER 2-TOOL COMBO KIT, (2) BATTERIES, (1) MULTI-VOLTAGE CHARGERPart# MLW-2991-22C$ 641.63
In Stock
| Yes | No | ||||
| 1 | PG54 - 20V MAX* XR PREMIUM COMPACT 4-TOOL COMBO KIT: HAMMER DRILL/DRIVER/RECIPROCATING SAW/LED LIGHT, (2) 20V 5AH BATTERIES, (1) CHARGER | dewalt | 651.12 | CAT4021XZ | Yes | No | ||||
| 2 | PG54 - 20V MAX* XR PREMIUM COMPACT 4-TOOL COMBO KIT: DRILL/DRIVER/CIRCULAR SAW/LED LIGHT, (2) 20V 5AH BATTERIES, (1) CHARGER | dewalt | 682.94 | CAT4021XZ |
DEWALT
PG54 - 20V MAX* XR PREMIUM COMPACT 4-TOOL COMBO KIT: DRILL/DRIVER/CIRCULAR SAW/LED LIGHT, (2) 20V 5AH BATTERIES, (1) CHARGERPart# DEW-DCK447P2C$ 682.94
In Stock
| Yes | No | |||
| 3 | PG54 - M18 2-TOOL COMBO KIT, 3/8" COMPACT IMPACT WRENCH AND WORK LIGHT | milwaukee-electric | 512.7 | CAT4021XZ |
Milwaukee Electric
PG54 - M18 2-TOOL COMBO KIT, 3/8" COMPACT IMPACT WRENCH AND WORK LIGHTPart# MLW-2693-22C$ 512.70
In Stock
| Yes | No | |||
| 4 | PG54 - 12V M12 FUEL 2-TOOL COMBO KIT: 3/8" STUBBY IMPACT WRENCH AND 1/4" HEX IMPACT DRIVER | milwaukee-electric | 527.7 | CAT4021XZ |
Milwaukee Electric
PG54 - 12V M12 FUEL 2-TOOL COMBO KIT: 3/8" STUBBY IMPACT WRENCH AND 1/4" HEX IMPACT DRIVERPart# MLW-2599-22C$ 527.70
In Stock
| Yes | No | |||
| 5 | PG54 - M18 COMPACT IMPACT WRENCH & GRINDER 2-TOOL COMBO KIT, (2) BATTERIES, (1) MULTI-VOLTAGE CHARGER | milwaukee-electric | 641.63 | CAT4021XZ |
Milwaukee Electric
PG54 - M18 COMPACT IMPACT WRENCH & GRINDER 2-TOOL COMBO KIT, (2) BATTERIES, (1) MULTI-VOLTAGE CHARGERPart# MLW-2991-22C$ 641.63
In Stock
| Yes | No | |||
| 6 | PG54 - 20V MAX* XR PREMIUM COMPACT 4-TOOL COMBO KIT: HAMMER DRILL/DRIVER/RECIPROCATING SAW/LED LIGHT, (2) 20V 5AH BATTERIES, (1) CHARGER | dewalt | 651.12 | CAT4021XZ | Yes | No | ||||
| 7 | PG54 - 20V MAX* XR PREMIUM COMPACT 4-TOOL COMBO KIT: DRILL/DRIVER/CIRCULAR SAW/LED LIGHT, (2) 20V 5AH BATTERIES, (1) CHARGER | dewalt | 682.94 | CAT4021XZ |
DEWALT
PG54 - 20V MAX* XR PREMIUM COMPACT 4-TOOL COMBO KIT: DRILL/DRIVER/CIRCULAR SAW/LED LIGHT, (2) 20V 5AH BATTERIES, (1) CHARGERPart# DEW-DCK447P2C$ 682.94
In Stock
| Yes | No |