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', '1555')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') RAKES - LAWN AND GARDEN
  1. See Detail

RAKES


View as Grid List

57 items

Page
per page
Set Descending Direction
  1. HEAVY DUTY BOW RAKE
    $9.99 /EA
    BR40 BOW 14 TINE 54" FBRGLS HD 60" Learn More
  2. RAZORBACK ROAD/STONE RAKE
    $76.99 /EA
    63122 RAZORBACK ROAD/STONE RAKE Learn More
  3. CONCRETE OR BARN RAKE
    $47.49 /EA
    83148 RAZORBACK CONCRETE RK Learn More
  4. CONCRETE RAKE W/REBAR HOOK
    $39.99 /EA
    83154 CONCRETE RAKE Learn More
  5. ALUMINUM ASPHALT LUTE RAKE
    $75.99 /EA
    63-133 ALUM ASPHALT LUTE Learn More
  6. FORGED LEVEL HEAD RAKE
    $47.99 /EA
    63111 FORG LEVEL HEAD RAKE Learn More
  7. ADJUSTABLE LAWN-GROOM THATCHING RAKE
    $36.99 /EA
    2914000/1914 THATCH RAKE 15" ADJUST Learn More
  8. KODIAK¨ FORGED BOW RAKE
    $26.99 /EA
    1886700 KODIAK FORGED BOW RAKE 14T Learn More
  9. EAGLE WOOD HANDLE WELDED BOW RAKE
    $12.99 /EA
    1881600 EAGLE BOW RAKE 14T Learn More
View as Grid List

57 items

Page
per page
Set Descending Direction