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=4082 and pa.subcategory_id=4225 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 2" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK XL | pip-dynamic | 8.41 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 2" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK XLPart# PIP-TSV2YG21C$ 8.41
In Stock
| Yes | No | ||||
| 1 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 2" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK S/M | pip-dynamic | 8.41 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 2" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK S/MPart# PIP-TSV2YG21C$ 8.41
In Stock
| Yes | No | |||
| 2 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 2" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK L | pip-dynamic | 8.41 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 2" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK LPart# PIP-TSV2YG21C$ 8.41
In Stock
| Yes | No | |||
| 3 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 2" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 4XL/5XL | pip-dynamic | 9.31 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 2" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 4XL/5XLPart# PIP-TSV2YG21C$ 9.31
In Stock
| Yes | No | |||
| 4 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 2" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 2XL/3XL | pip-dynamic | 9.31 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 2" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 2XL/3XLPart# PIP-TSV2YG21C$ 9.31
In Stock
| Yes | No | |||
| 5 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK S/M | pip-dynamic | 10.85 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK S/MPart# PIP-TSV2YG19C$ 10.85
In Stock
| Yes | No | |||
| 6 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 4XL/5XL | pip-dynamic | 11.75 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 4XL/5XLPart# PIP-TSV2YG19C$ 11.75
In Stock
| Yes | No | |||
| 7 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 2XL/3XL | pip-dynamic | 11.75 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 2XL/3XLPart# PIP-TSV2YG19C$ 11.75
In Stock
| Yes | No | |||
| 8 | CSA APPR. MESH TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK S/M | pip-dynamic | 10.85 | CAT4225XZ |
PIP Dynamic
CSA APPR. MESH TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK S/MPart# PIP-TSV2OG23C$ 10.85
In Stock
| Yes | No | |||
| 9 | CSA APPR. MESH TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 4XL/5XL | pip-dynamic | 11.75 | CAT4225XZ |
PIP Dynamic
CSA APPR. MESH TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 4XL/5XLPart# PIP-TSV2OG23C$ 11.75
In Stock
| Yes | No | |||
| 10 | CSA APPR. MESH TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 2XL/3XL | pip-dynamic | 11.75 | CAT4225XZ |
PIP Dynamic
CSA APPR. MESH TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 2XL/3XLPart# PIP-TSV2OG23C$ 11.75
In Stock
| Yes | No | |||
| 11 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK S/M | pip-dynamic | 10.85 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK S/MPart# PIP-TSV2OG18C$ 10.85
In Stock
| Yes | No | |||
| 12 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 4XL/5XL | pip-dynamic | 11.75 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 4XL/5XLPart# PIP-TSV2OG18C$ 11.75
In Stock
| Yes | No | |||
| 13 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 2XL/3XL | pip-dynamic | 11.75 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK 2XL/3XLPart# PIP-TSV2OG18C$ 11.75
In Stock
| Yes | No | |||
| 14 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK XL | pip-dynamic | 10.85 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK XLPart# PIP-TSV2YG19C$ 10.85
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 15 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK L | pip-dynamic | 10.85 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS YELLOW-GREEN, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK LPart# PIP-TSV2YG19C$ 10.85
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 16 | CSA APPR. MESH TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK XL | pip-dynamic | 10.85 | CAT4225XZ |
PIP Dynamic
CSA APPR. MESH TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK XLPart# PIP-TSV2OG23C$ 10.85
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 17 | CSA APPR. MESH TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK L | pip-dynamic | 10.85 | CAT4225XZ |
PIP Dynamic
CSA APPR. MESH TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK LPart# PIP-TSV2OG23C$ 10.85
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 18 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK XL | pip-dynamic | 10.85 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK XLPart# PIP-TSV2OG18C$ 10.85
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 19 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK, VELCRO BELT UNIVERSAL SIZE | pip-dynamic | 12.19 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK, VELCRO BELT UNIVERSAL SIZEPart# PIP-TSV2OG18C$ 12.19
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 20 | CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK L | pip-dynamic | 10.85 | CAT4225XZ |
PIP Dynamic
CSA APPR. POLYEST. TRAFFIC VEST, HI-VIS ORANGE, 4" WIDE 360 HRZ. STRIPES, 2 VRT. STRIPES, X IN BACK LPart# PIP-TSV2OG18C$ 10.85
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |