Close Extra 5% OFF* On App Only
Use Code: APP5
TRENDING NOW

LOVERS OF THE SUN

Lovers of the sun

Filter
Shopping Options
Styles
Styles
  1. Cateye Sunglasses 21 items
  2. Hats 11 items
  3. Retro Sunglasses 33 items
  4. Round Sunglasses 5 items
  5. Wayfarers And Square Frame Sunglasses 14 items
Colour
Colour
  1. Beige 3 items
  2. Black 1 item
  3. Brown 3 items
  4. Multi 1 item
  5. Purple 1 item
  6. White 1 item
  7. Yellow 1 item
Less
  1. Hats Remove This Item

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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`, `at_special_price`.`value` AS `special_price` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` 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=1472 INNER 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 `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 INNER JOIN `search_tmp_5f34ad2dcab380_15938857` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 0) WHERE (stock_status_index.stock_status = 1) ORDER BY `special_price` DESC, `e`.`entity_id` DESC LIMIT 24

11 styles found
  1. 80% Off
    WELCOME TO BAHAMAS TAN BUCKET HAT
    New
    Welcome To Bahamas Tan Bucket Hat
    ₹2,949
    ₹590 (80% Off)
  2. 80% Off
    WELCOME TO BAHAMAS BEIGE BUCKET HAT
    New
    Welcome To Bahamas Beige Bucket Hat
    ₹2,949
    ₹590 (80% Off)
  3. 80% Off
    AFTER-BRUNCH CITY STOLL WHITE BUCKET HAT
    New
    After-brunch City Stoll White Bucket Hat
    ₹2,149
    ₹430 (80% Off)
  4. 80% Off
    AFTER-BRUNCH CITY STOLL BLACK BUCKET HAT
    New
    After-brunch City Stoll Black Bucket Hat
    ₹2,149
    ₹430 (80% Off)
  5. 80% Off
    BOWS AND BEACHES BROWN DERBY
    New
    Bows And Beaches Brown Derby
    ₹2,099
    ₹420 (80% Off)
  6. 80% Off
    ON THE SEA SHORE BEIGE STRAW HAT
    New
    On The Sea Shore Beige Straw Hat
    ₹1,999
    ₹400 (80% Off)
  7. 80% Off
    PALM DOWN BABE BEIGE STRAW HAT
    New
    Palm Down Babe Beige Straw Hat
    ₹1,899
    ₹380 (80% Off)
  8. 80% Off
    SUCH A BEACH BROWN BABY HAT
    New
    Such A Beach Brown Baby Hat
    ₹1,799
    ₹360 (80% Off)
  9. 80% Off
    SUCH A BEACH BABY  BEIGE HAT
    New
    Such A Beach Baby Beige Hat
    ₹1,799
    ₹360 (80% Off)
  10. 80% Off
    BEACH TIME LOVE MULTICOLOR SUN HAT
    New
    Beach Time Love Multicolor Sun Hat
    ₹1,599
    ₹320 (80% Off)
  11. 85% Off
    SOAKING ALL SUNSHINE WITH PURPLE HAT
    Sale
    Soaking All Sunshine With Purple Hat
    ₹1,249
    ₹187 (85% Off)