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=3897 and pa.subcategory_id=3902 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 | |
|---|---|---|---|---|---|---|---|---|---|---|
| PG15 - PREMIUM REFRIGERANT LEAK DETECTOR | robinair | 732.01 | CAT3902XZ |
C$ 732.01
In Stock
| Yes | No | ||||
| 1 | PG15 - ECONOMY LEAK DETECTOR | robinair | 477.77 | CAT3902XZ |
C$ 477.77
In Stock
| Yes | No | |||
| 2 | PG15 - RAPTOR REFRIGERANT LEAK DETECTOR WITH UV LIGHT | mastercool | 321.17 | CAT3902XZ |
C$ 321.17
In Stock
| Yes | No | |||
| 3 | PG15 - INTELLASENSE II REFRIGERANT LEAK DETECTOR | mastercool | 322.87 | CAT3902XZ |
C$ 322.87
In Stock
| Yes | No | |||
| 4 | PG15 - INTELLASENSE REFRIGERANT LEAK DETECTOR FOR COMBUSTIBLE GASES, HYDROGEN AND ALL REFRIGERANTS. WORKS WITH R1234YF, R32 AND R410A. | mastercool | 471.19 | CAT3902XZ | Yes | No | ||||
| 5 | PG15 - LEAK-SEEKER DELUXE REFRIGERANT DETECTOR | cps | 492.24 | CAT3902XZ |
C$ 492.24
In Stock
| Yes | No | |||
| 6 | PG15 - SAE PRO-SET REFRIGERANT LEAK DETECTOR W/UVMINI LIGHT | cps | 544.66 | CAT3902XZ |
C$ 544.66
In Stock
| Yes | No |