Ultralight Series

SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`url_key`, `e`.`msrp`, `e`.`msrp_display_actual_price_type`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`swatch_image`, `e`.`tax_class_id`, `e`.`brand`, `e`.`brand_value`, `e`.`on_special`, `e`.`on_special_until`, `e`.`published`, `e`.`on_discount`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='672' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN `search_tmp_5b281f48e2e380_12761661` AS `search_result` ON e.entity_id = search_result.entity_id ORDER BY CASE WHEN e.on_special='Y' AND e.on_special_until>=NOW() THEN e.on_special_until END DESC,CASE WHEN e.on_special='N' THEN e.on_special_until END ASC,e.position ASC, `e`.`entity_id` DESC LIMIT 12
Island Water World StoresSt. Maarten / St. MartinCuracaoSt. LuciaGrenada

7 Stores Across The Caribbean

We currently have seven stores. Two in Sint Maarten, one in French St Martin, one in St Lucia, two in Grenada and one in Curacao. With the exception of Curacao all are on the water and are easily reached by dinghy. All are easily accessible by road with adequate parking.

Island Water World

Keeps You Sailing Since 1967

Get More!

Ask for the Free Advantage Card, earn and redeem miles to benefit from many advantages!

  • Earn 1 Mile for every US $ 1 spent (100 Miles = US $ 5).
  • At 5000 Miles, we double your Miles with a US $ 500 voucher!
  • Redeem your miles in all Island Water World stores.


More Info
Island Water World Catalog

2018 Catalog

Get your printed catalog at any Island Water World store, or download the PDF version!

Download Catalog
Trouble opening this document?
You need the Adobe Acrobat software!