app-download-header
Everything under Rs.999
20% Cashback* on Buy 4 items. , Use Code: CB20
20% Cashback* on Buy 4 items.
Use Code: CB20
HR
:
MN
:
SC
ENDS IN

Beachwear

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Body Suits 41 items
  2. Cover Ups 5 items
  3. Sets 100 items
  4. Skater Skirts 0 items
  5. Swimsuit 111 items
  6. Sarong 4 items
Colour
Colour
  1. Beige 4 items
  2. Black 52 items
  3. Blue 38 items
  4. Brown 21 items
  5. Gold 1 item
  6. Green 34 items
  7. Grey 1 item
  8. Multi 53 items
  9. Orange 8 items
  10. Pink 23 items
  11. Purple 8 items
  12. Red 22 items
  13. White 30 items
  14. Yellow 14 items
Less
Size
Size
  1. 1XL 3 items
  2. 2XL 6 items
  3. 3XL 5 items
  4. 4XL 3 items
  5. 5XL 1 item
  6. FS 4 items
  7. L 82 items
  8. M 69 items
  9. S 48 items
  10. XL 49 items
  11. XXL 2 items
  12. 0XL 1 item
Less
Price
Price
  1. Rs. 400 - 600 1 item
  2. Rs. 600 - 800 5 items
  3. Rs. 800 - 1000 5 items
  4. Rs. 1000 - 1200 6 items
  5. Rs. 1200 - 1400 18 items
  6. Rs. 1400 - 1600 12 items
  7. Rs. 1600 - 1800 21 items
  8. Rs. 1800 - 2000 10 items
  9. Rs. 2000 - 2500 21 items
  10. Rs. 2500 - 3000 5 items
  1. Skater Skirts Remove This Item
  2. Sets Remove This Item
  3. Sarong Remove This Item
  4. White Remove This Item
  5. Red Remove This Item
  6. Black 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=1966 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_672d3bddba40a1_30435970` 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

104 styles found
  1. 58% Off
    -58%
    FOUR PIECE WHITE SWIMWEAR SET
  2. 60% Off
    -60%
    BEACH TIME BLACK BIKINI SET
  3. 63% Off
    -63%
    BEACH TIME RED BIKINI SET
  4. 64% Off
    -64%
    WHITE HOLLOW KNIT 2PC BEACHWEAR SET
  5. 60% Off
    -60%
    TRANSLUCENT 3PC BLACK SWIMWEAR SET
  6. 64% Off
    -64%
    MY POOL SIDE BASIC WHITE BIKINI SET
  7. 60% Off
    -60%
    Black Two Piece Beachwear Set
  8. 60% Off
    -60%
    RED FANCY RUFFLED SLEEVE BIKINI SET
  9. 60% Off
    -60%
    BLACK BOW-KNOT DECOR SWIMWEAR SET
  10. 60% Off
    -60%
    WHITE TIE-UP STRAPS SWIMWEAR SET
  11. 60% Off
    -60%
    Red Frilly Two Piece Beachwear Set
  12. 60% Off
    -60%
    Black Beachwear Two Piece Set
  13. 64% Off
    -64%
    BLACK PRINTED STRAP 2PC BIKINI SET
  14. 60% Off
    -60%
    TEXTURED PINK BIKINI SET