SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 67) WHERE (`e`.`entity_id` IN('2465', '2773', '2780', '2795')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') MASONRY BLADES SEGMENTED DIAMOND - CIRCULAR SAW BLADES - POWER SAWS AND POWER SAW BLADES - HAND & POWER TOOLS
  1. See Detail

MASONRY BLADES SEGMENTED DIAMOND


View as Grid List

15 items

Page
per page
Set Descending Direction
  1. SEGMENTED DIAMOND BLADE
    $8.99 /EA
    167011 4" SGMNT DIAMD BLDE Learn More
  2. SEGMENTED DIAMOND BLADE
    $35.99 /EA
    167017 10" SEG DIAMOND BLDE Learn More
  3. Segmented Diamond Blade
    $8.99 /EA
    MP45 4.5" SEGMNT DIAMOND BL Learn More
  4. SEGMENTED RIM BLADE
    $32.49 /EA
    75455 SEGMENTD DIAM BLD 7" Learn More
  5. Segmented Diamond Blade
    $60.99 /EA
    MP12 12" SEGMNT DIAMOND BL Learn More
  6. Diamond Grit Blade
    $19.49 /EA
    RW9228 3 3/8 DIA GRIT BLADE Learn More
  7. SEGMENTED DIAMOND BLADE
    $10.49 /EA
    167012 4-1/2"SGMNT DIAM BLDE Learn More
  8. SEGMENTED DIAMOND BLADE
    $61.99 /EA
    167018 12" SEG DIAMOND BLDE Learn More
  9. Segmented Diamond Blade
    $15.99 /EA
    MP70 7" SEGMNT DIAMOND BLD Learn More
View as Grid List

15 items

Page
per page
Set Descending Direction