SELECT DISTINCT a.masterindex as master_index, a.masterhead as header, e.picthumb FROM CSMasterItems a JOIN CS_Xref_Items b ON (a.masterindex = b.masterindex) JOIN CSProducts csp ON (b.itemnum = csp.itemnum) JOIN category_lookup c ON (b.masterindex = c.master_index) LEFT JOIN Web_ItemImageXRef d on (csp.itemnum=d.item_number and 1=d.`primary` and 1=d.visible) LEFT JOIN Web_Images e on (d.picid=e.picid) Where c.CATEGORY_NUMBER = 109 and c.companynum=1 and csp.active = 1 and csp.peconosale=0 ORDER BY a.masterHead
Fire Extinguishers

Page: 1  Results 1 - 8 of 8
 
There are 8 products in this category

Products 1 - 8


  AMEREX® ABC Stored Pressure Multi-Purpose Dry Chemical Fire Extinguishers
AMEREX® ABC Stored Pressure Multi-Purpose Dry Chemical Fire Extinguishers
  AMEREX® Water Stored Pressure Fire Extinguisher
AMEREX® Water Stored Pressure Fire Extinguisher
  Fire Gone™ Fire Extinguisher
Fire Gone™ Fire Extinguisher
  Justrite® 40-Gallon Class III Liquids Cabinet
Justrite® 40-Gallon Class III Liquids Cabinet
 
  Justrite® 45-Gallon Capacity Safety Can Cabinet
Justrite® 45-Gallon Capacity Safety Can Cabinet
  Justrite® 60-Gallon Capacity Safety Can Cabinet
Justrite® 60-Gallon Capacity Safety Can Cabinet
  Justrite® Mini Safety Cabinet
Justrite® Mini Safety Cabinet
  Justrite®30-Gallon Capacity Safety Can Cabinet
Justrite®30-Gallon Capacity Safety Can Cabinet
 

Peco Sales.com   |  US: 800-346-6939   |   Customer Service: 800-752-8460   |   Tech Support: 800-430-5566

Home   |  About Us   |  Contact Us   |  Track an Order   |   Terms of Use   |   Online Privacy