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=4085 and pa.subcategory_id=4174 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG222 - MOLDED RUBBER WHEEL CHOCK | ame-intl | 25.39 | CAT4174XZ |
C$ 25.39
In Stock
| Yes | No | ||||
| 1 | PG222 - 8-PC SUPER STACKER CRIBBING KIT | ame-intl | 2789.69 | CAT4174XZ |
C$ 2,789.69
In Stock
| Yes | No | |||
| 2 | PG222 - 10-PC CRIBBING BLOCKS, FR INDUSTRIAL KIT | ame-intl | 2358.23 | CAT4174XZ |
C$ 2,358.23
In Stock
| Yes | No | |||
| 3 | PG222 - SUPER STACKER CRIBBING BLOCK 6"X7"X24" BLACK | ame-intl | 346.22 | CAT4174XZ |
C$ 346.22
In Stock
| Yes | No | |||
| 4 | PG222 - 200 TONS CAPACITY JACK PLATE, 12 X 18 X 3 | ame-intl | 425.62 | CAT4174XZ |
C$ 425.62
In Stock
| Yes | No | |||
| 5 | PG222 - TITAN 12"X12"X1" JACK PLATE WITH NON-SKID SURFACE | ame-intl | 145.49 | CAT4174XZ |
C$ 145.49
In Stock
| Yes | No | |||
| 6 | PG222 - SUPER STACKER CRIBBING BLOCKS 6" X 7" X 24" | ame-intl | 383.09 | CAT4174XZ |
C$ 383.09
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 7 | PG222 - CRIBBING BLOCK - BLACK - 4" X 4" X 18" | ame-intl | 119.76 | CAT4174XZ |
C$ 119.76
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No | |||
| 8 | PG222 - TITAN 12"X12"X1.5" JACK PLATE WITH NON-SKID SURFACE | ame-intl | 214.22 | CAT4174XZ |
C$ 214.22
Call For Availability
Currently Out of Stock. Call 647-330-5754 or email support@partsdealer.ca for availability. | No | No |