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

New

Filter
Shopping Options
Styles
Styles
  1. Aviator Sunglasses 1 item
  2. Blouses 6 items
  3. Bodycon 1 item
  4. Cateye Sunglasses 5 items
  5. Earrings 1 item
  6. Mini Skirts 1 item
  7. Pencil Dresses 0 items
  8. Retro Sunglasses 10 items
  9. Round Sunglasses 2 items
  10. Shirts 1 item
  11. Skater Dresses 1 item
  12. T-shirts 7 items
  13. Tunic Dresses 2 items
  14. Tunic Tops 5 items
  15. Wayfarers And Square Frame Sunglasses 23 items
Colour
Colour
  1. Beige 1 item
  2. Black 31 items
  3. Blue 6 items
  4. Brown 28 items
  5. Gold 7 items
  6. Green 3 items
  7. Grey 13 items
  8. Orange 2 items
  9. Pink 5 items
  10. Purple 7 items
  11. Red 6 items
  12. Silver 3 items
  13. White 3 items
  14. Yellow 1 item
Less
  1. Pencil Dresses Remove This Item
  2. Retro Sunglasses Remove This Item
  3. Cateye Sunglasses Remove This Item
  4. Grey Remove This Item
  5. Orange 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=385 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_5f7296c635b036_90581759` 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

14 styles found
  1. 85% Off
    CANT PLAY 'EM ALL GREY CATEYE SUNGLASSES
    New
    Cant Play 'em All Grey Cateye Sunglasses
    ₹4,049
    ₹607 (85% Off)
  2. 85% Off
    GHOST HIM GREY RETRO SUNGLASSES
    New
    Ghost Him Grey Retro Sunglasses
    ₹3,899
    ₹585 (85% Off)
  3. 85% Off
    OFF THE RIM GREY WAYFARERS
    New
    Off The Rim Grey Wayfarers
    ₹3,799
    ₹570 (85% Off)
  4. 85% Off
    ROLLING SLEEVES NOT EYES ORANGE RETRO SUNGLASSES
  5. 85% Off
    PATTERN-TED GREY RETRO SUNGLASSES
    New
    Pattern-ted Grey Retro Sunglasses
    ₹3,399
    ₹510 (85% Off)
  6. 85% Off
    DEEP THOUGHTS GREY RETRO SUNGLASSES
    New
    Deep Thoughts Grey Retro Sunglasses
    ₹3,399
    ₹510 (85% Off)
  7. 85% Off
    NEVER MISS A BEAT GREY RETRO SUNGLASSES
    New
    Never Miss A Beat Grey Retro Sunglasses
    ₹3,399
    ₹510 (85% Off)
  8. 85% Off
    BRIGHT AS DAY GREY RETRO SUNGLASSES
    New
    Bright As Day Grey Retro Sunglasses
    ₹3,349
    ₹502 (85% Off)
  9. 85% Off
    OLD TIMES BLUE RETRO SUNGLASSES
    New
    Old Times Blue Retro Sunglasses
    ₹3,249
    ₹487 (85% Off)
  10. 85% Off
    PERFECT ANGLE GREY RETRO SUNGLASSES
    New
    Perfect Angle Grey Retro Sunglasses
    ₹3,249
    ₹487 (85% Off)
  11. 85% Off
    CHECKIN ALL THE ANGLES GREY RETRO SUNGLASSES
    New
    Checkin All The Angles Grey Retro Sunglasses
    ₹3,099
    ₹465 (85% Off)
  12. 85% Off
    SHOWING IT OFF GREY CATEYE SUNGLASSES
    New
    Showing It Off Grey Cateye Sunglasses
    ₹2,599
    ₹390 (85% Off)
  13. 85% Off
    ALWAYS ON-POINT GREY CATEYE SUNGLASSES
    New
    Always On-point Grey Cateye Sunglasses
    ₹2,449
    ₹367 (85% Off)
  14. 88% Off
    THROW 'EM ON GREY CATEYE SUNGLASSES
    New
    Throw 'em On Grey Cateye Sunglasses
    ₹2,599
    ₹299 (88% Off)