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=3916 and pa.subcategory_id=3931 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG97 - GBD 5-1/2" (140MM) 120SC FLEX-HONE | brush-research-manufacturing | 144.7 | CAT3931XZ |
C$ 144.70
In Stock
| Yes | No | ||||
| 1 | PG97 - GBD 5" (127MM) 120SC FLEX-HONE | brush-research-manufacturing | 131.93 | CAT3931XZ |
C$ 131.93
In Stock
| Yes | No | |||
| 2 | PG97 - GBD 4-1/4" (108MM) 120SC FLEX-HONE | brush-research-manufacturing | 108.91 | CAT3931XZ |
C$ 108.91
In Stock
| Yes | No | |||
| 3 | PG97 - GBD 4-1/2" (114MM) 120SC FLEX-HONE | brush-research-manufacturing | 115.97 | CAT3931XZ |
C$ 115.97
In Stock
| Yes | No | |||
| 4 | PG97 - GBD 4" (101MM) 120SC FLEX-HONE | brush-research-manufacturing | 101.94 | CAT3931XZ |
C$ 101.94
In Stock
| Yes | No | |||
| 5 | PG97 - GBD 3-3/4" (95MM) 120SC FLEX-HONE | brush-research-manufacturing | 95.47 | CAT3931XZ |
C$ 95.47
In Stock
| Yes | No | |||
| 6 | PG97 - GBD 3-1/4" (83MM) 120SC FLEX-HONE | brush-research-manufacturing | 88.25 | CAT3931XZ |
C$ 88.25
In Stock
| Yes | No | |||
| 7 | PG97 - GBD 3-1/2" (89MM) 120SC FLEX-HONE | brush-research-manufacturing | 89.09 | CAT3931XZ |
C$ 89.09
In Stock
| Yes | No | |||
| 8 | PG97 - GBD 3" (76MM) 120SC FLEX-HONE | brush-research-manufacturing | 85.56 | CAT3931XZ |
C$ 85.56
In Stock
| Yes | No | |||
| 9 | PG97 - BC9MM (.354") 180SC FLEX-HONE | brush-research-manufacturing | 17.69 | CAT3931XZ |
C$ 17.69
In Stock
| Yes | No | |||
| 10 | PG97 - BC8MM (.315") 180SC FLEX-HONE | brush-research-manufacturing | 17.02 | CAT3931XZ |
C$ 17.02
In Stock
| Yes | No | |||
| 11 | PG97 - BC7MM (.276") 180SC FLEX-HONE | brush-research-manufacturing | 16.26 | CAT3931XZ |
C$ 16.26
In Stock
| Yes | No | |||
| 12 | PG97 - BC7/8" (22MM) 180SC FLEX-HONE | brush-research-manufacturing | 23.74 | CAT3931XZ |
C$ 23.74
In Stock
| Yes | No | |||
| 13 | PG97 - BC6.4MM (.250") 180SC FLEX-HONE | brush-research-manufacturing | 16.09 | CAT3931XZ |
C$ 16.09
In Stock
| Yes | No | |||
| 14 | PG97 - BC5MM (.197") 180SC FLEX-HONE | brush-research-manufacturing | 23.06 | CAT3931XZ |
C$ 23.06
In Stock
| Yes | No | |||
| 15 | PG97 - BC5/8" (16MM) 180SC FLEX-HONE | brush-research-manufacturing | 22.31 | CAT3931XZ |
C$ 22.31
In Stock
| Yes | No | |||
| 16 | PG97 - BC3/4" (19MM) 180SC FLEX-HONE | brush-research-manufacturing | 23.48 | CAT3931XZ |
C$ 23.48
In Stock
| Yes | No | |||
| 17 | PG97 - BC3" (76MM) 180SC FLEX-HONE | brush-research-manufacturing | 51.29 | CAT3931XZ |
C$ 51.29
In Stock
| Yes | No | |||
| 18 | PG97 - BC2-3/4" (70MM) 180SC FLEX-HONE | brush-research-manufacturing | 44.23 | CAT3931XZ |
C$ 44.23
In Stock
| Yes | No | |||
| 19 | PG97 - BC2-1/4" (57MM) 180SC FLEX-HONE | brush-research-manufacturing | 37.18 | CAT3931XZ |
C$ 37.18
In Stock
| Yes | No | |||
| 20 | PG97 - BC2-1/2" (64MM) 180SC FLEX-HONE | brush-research-manufacturing | 40.03 | CAT3931XZ |
C$ 40.03
In Stock
| Yes | No | |||
| 21 | PG97 - BC20MM (.787") 180SC FLEX-HONE | brush-research-manufacturing | 23.57 | CAT3931XZ |
C$ 23.57
In Stock
| Yes | No | |||
| 22 | PG97 - GBD 8" (203MM) 120SC FLEX-HONE | brush-research-manufacturing | 218.36 | CAT3931XZ |
C$ 218.36
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 23 | PG97 - GBD 7-1/2" (190MM) 120SC FLEX-HONE | brush-research-manufacturing | 199.8 | CAT3931XZ |
C$ 199.80
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 24 | PG97 - GBD 7" (178MM) 120SC FLEX-HONE | brush-research-manufacturing | 181.66 | CAT3931XZ |
C$ 181.66
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 25 | PG97 - GBD 6-1/2" (165MM) 120SC FLEX-HONE | brush-research-manufacturing | 168.97 | CAT3931XZ |
C$ 168.97
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 26 | PG97 - GBD 6" (152MM) 120SC FLEX-HONE | brush-research-manufacturing | 156.79 | CAT3931XZ |
C$ 156.79
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 27 | PG97 - BC9.5MM (.375") 180SC FLEX-HONE | brush-research-manufacturing | 19.54 | CAT3931XZ |
C$ 19.54
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 28 | PG97 - BC5.5MM (.217") 180SC FLEX-HONE | brush-research-manufacturing | 23.4 | CAT3931XZ |
C$ 23.40
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |