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

ROUND POINT SHOVELS & SPADES


View as Grid List

52 items

Page
per page
Set Descending Direction
  1. ROUND POINT FIBERGLASS SHOVEL Call for Price
    49450 SV-LR40 RP FIBERGLASS Learn More
  2. DURA-TORQUE¨ROUND POINT SHOVEL Call for Price
    45106 DURA TORQUE LHRP SHVL Learn More
  3. TAPERED DITCHING SHOVEL Call for Price
    47115 RAZORBK TRENCHN SHOVL Learn More
  4. HEAVY-DUTY FIBERGLASS HANDLE ROUND POINT SHOVEL Call for Price
    2584300 SHOVEL LHRP FIBERGLS Learn More
  5. RAZOR-BACK¨ CONTRACTOR-DUTY POWERFLEX TM SHOVEL Call for Price
    45013 LHRP SHOVEL CLOSED BACK FBRGL Learn More
  6. LONG HANDLE OPEN BACK ROOF RIPPER Call for Price
    46141 RAZORBK NOTCH RF RIPR Learn More
  7. D HANDLE OPEN BACK SHARPSHOOTER DRAIN SPADE Call for Price
    47107 14" DRAIN SPADE Learn More
  8. EAGLE LONG HANDLEROUND POINT SHOVEL Call for Price
    1554300 EAGLE LHRP SHOVEL Learn More
  9. RAZOR BACK LONG HANDLE ROUND POINTSHOVEL Call for Price
    45519 RZBK LHRP SHOVEL Learn More
View as Grid List

52 items

Page
per page
Set Descending Direction