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', '1535', '1541')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') POWER GARDEN TILLERS & HOES - SPECIAL PURPOSE LAWN/GARDEN EQUI - LAWN AND GARDEN
  1. See Detail

POWER GARDEN TILLERS & HOES


View as Grid List

4 Items

per page
Set Descending Direction
  1. 43CC 2 CYCLE ENGINE CULTIVATOR Call for Price
    SCV43 CULTVATOR 8" TINE REAR WHLS Learn More
  2. POULAN PRO REAR TINE TILLER Call for Price
    960920037 PPCRT17.208CC LCT.CRT TIL Learn More
  3. TROY-BILT 4 CYCLE CULTIVATOR Call for Price
    21AK146G766 TB 4CYCLE CULTIVATOR Learn More
  4. HUSQVARNA FRONT TILLER Call for Price
    HUSQ960830009 B&S 208CC FRT Learn More
View as Grid List

4 Items

per page
Set Descending Direction