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` = 90) WHERE (`e`.`entity_id` IN('1460', '1547', '1548', '1550')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') SNOW SHOVEL - SNOW PUSHES, SHOVELS,ICE SCRAPER - SNOW & ICE REMOVAL EQUIPMENT CHE - LAWN AND GARDEN
  1. See Detail

SNOW SHOVEL


View as Grid List

21 items

Page
per page
Set Descending Direction
  1. 18'' POLY PROMOTIONAL SNOW SHOVEL Call for Price
    1573700 18" POLY SNOW SHOVEL Learn More
  2. CHILDS SNOW SHOVEL Call for Price
    1185 CHILDS SNOW SHOVEL Learn More
  3. POLY SNOW SHOVEL Call for Price
    1199BS POLY SNOW SHVL 13X18 AL/HNDL Learn More
  4. SNOW SHOVEL STEEL ERGO HANDLE Call for Price
    1603072 SNW SHVL 18PLY STL ERGO HDL Learn More
  5. SNOW SHOVEL STEEL CORE HANDLE Call for Price
    1673300 SNW SHVL 16PLY STL CORE HDL Learn More
  6. SNOW SHOVEL POLY Call for Price
    NPM18KDU SNOW SHOVEL POLY18" DH Learn More
  7. SNOW SHOVEL POLY WEAR STRIP Call for Price
    APM18KDRU SNOW SHOVEL POLY WSTRIP Learn More
  8. SNOW SHOVEL POLY WITH FIBERGLASS HANDLE Call for Price
    YPM18FKDU SNOW POLY 18 F/GLASS HDL Learn More
  9. SNOW SHOVEL POLY Call for Price
    1199D SNOW SHOVEL POLY 14" Learn More
View as Grid List

21 items

Page
per page
Set Descending Direction