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('1460', '1574', '1583', '1584')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') SHINGLE REMOVER ROOF SHOVEL SPADE - ROUND POINT SHOVELS & SPADES - SHOVELS, SPADES, SCOOPS, DIGGERS - LAWN AND GARDEN
  1. See Detail

SHINGLE REMOVER ROOF SHOVEL SPADE


View as Grid List

5 Items

per page
Set Descending Direction
  1. SHINGLE REMOVER BLADE KIT
    $20.49 /EA
    SP16003/1035 SHNGL REMOVE BLADE KIT Learn More
  2. PROSHINGLE
    $50.99 /EA
    91110 PRO SHINGLE REMOVE D-GRP FBGL Learn More
  3. LONG HANDLE OPEN BACK ROOF RIPPER
    $46.99 /EA
    46141 RAZORBK NOTCH RF RIPR Learn More
  4. D HANDLE NOTCHED ROOF RIPPER
    $48.49 /EA
    46142 DH NOTCHED ROOF RIPPR Learn More
  5. PROFESSIONAL SHINGLE REMOVER
    $48.99 /EA
    49749/SG1 SHINGLE REMOVER Learn More
View as Grid List

5 Items

per page
Set Descending Direction