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=4531 and pa.subcategory_id=4675 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Dial Type Tire Pressure Gauge | surewerx-jet | 39.25 | CAT4675XZ |
C$ 39.25
In Stock
| Yes | No | ||||
| 1 | Pencil Tire Pressure Gauge - Chrome Plated | surewerx-jet | 24.72 | CAT4675XZ |
C$ 24.72
Limited Stock
| Yes | No | |||
| 2 | Pencil Tire Pressure Gauge - Metal Body | surewerx-jet | 33.01 | CAT4675XZ |
C$ 33.01
Limited Stock
| Yes | No | |||
| 3 | Tire Tread Depth Gauge | surewerx-jet | 28.84 | CAT4675XZ |
C$ 28.84
| No | No | |||
| 4 | Dual Head Tire Gauge | surewerx-jet | 104.21 | CAT4675XZ |
C$ 104.21
| No | No | |||
| 5 | Dual Head Tire Gauge | surewerx-jet | 39.25 | CAT4675XZ |
C$ 39.25
| No | No | |||
| 6 | Dial Type Tire Pressure Gauge | surewerx-jet | 47.51 | CAT4675XZ |
C$ 47.51
| No | No | |||
| 7 | Digital Tire Pressure Gauge | surewerx-jet | 150.96 | CAT4675XZ |
C$ 150.96
| No | No | |||
| 8 | Air Line Inflator With Tire Gauge | surewerx-jet | 190.32 | CAT4675XZ |
C$ 190.32
| No | No | |||
| 9 | Air Line Inflator With Tire Gauge - Dial Type | surewerx-jet | 413.83 | CAT4675XZ |
C$ 413.83
| No | No | |||
| 10 | Tire Bead Breaker-Combination | surewerx-strongarm | 1353.61 | CAT4675XZ |
C$ 1,353.61
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 11 | Heavy Duty Giant Tire Bead Breaker | surewerx-strongarm | 1230.56 | CAT4675XZ |
C$ 1,230.56
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |