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` = 1) WHERE (`e`.`entity_id` IN('242', '9', '58', '102')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') Whetman Equipment Nose Clip
Welcome to AS Watersports
My Cart

Whetman Equipment Nose Clip


For high energy kayaking, canoeing, surfing this nose clip will stay on your nose.

It is the most effective & positive nose clip available.

It has a powerful stainless spring with positive rubber nose mounts & a leash to attach to a helmet.

More Information
Manufacturer's Part Number N/A
Brand Whetman Equipment
Colour N/A
Length N/A
Rope Type N/A
Strength N/A
Thickness N/A
Size N/A
Colour N/A
Weight N/A
Material N/A
Other Features N/A
Only registered users can write reviews. Please Sign in or create an account