app-download-header
90% Off on Shoes
20% OFF on Buy 4 any items, Use Code: MERRY
20% OFF on Buy 4 any items
Use Code: MERRY
HR
:
MN
:
SC
ENDS IN

Beachwear

Filter
Shopping Options
Styles
Styles
  1. Body Suits 48 items
  2. Cover Ups 11 items
  3. Sets 148 items
  4. Skater Skirts 0 items
  5. Swimsuit 142 items
  6. Sarong 7 items
Colour
Colour
  1. Beige 2 items
  2. Black 51 items
  3. Blue 42 items
  4. Brown 20 items
  5. Gold 1 item
  6. Green 35 items
  7. Grey 2 items
  8. Multi 49 items
  9. Orange 7 items
  10. Pink 26 items
  11. Purple 7 items
  12. Red 24 items
  13. White 31 items
  14. Yellow 16 items
Less
Size
Size
  1. 1XL 6 items
  2. 2XL 9 items
  3. 3XL 8 items
  4. 4XL 7 items
  5. 5XL 1 item
  6. L 130 items
  7. M 124 items
  8. S 85 items
  9. XL 76 items
  10. XXL 3 items
  11. 0XL 4 items
Less
Price
Price
  1. Rs. 400 - 600 1 item
  2. Rs. 600 - 800 2 items
  3. Rs. 800 - 1000 4 items
  4. Rs. 1000 - 1200 2 items
  5. Rs. 1200 - 1400 24 items
  6. Rs. 1400 - 1600 20 items
  7. Rs. 1600 - 1800 20 items
  8. Rs. 1800 - 2000 22 items
  9. Rs. 2000 - 2500 42 items
  10. Rs. 2500 - 3000 8 items
  11. Rs. 3000 - 3500 3 items
  1. Skater Skirts Remove This Item
  2. Sets Remove This Item
  3. White Remove This Item
  4. Red Remove This Item
  5. Black Remove This Item
  6. Blue 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` 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_669f0a1fb126e7_41516370` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24

148 styles found
  1. 63% Off
    -63%
    BLUE GINGHAM PATTERN SWIMWEAR SET
  2. 60% Off
    -60%
    TEXTURED BLUE BIKINI SET
  3. 60% Off
    -60%
    TEXTURED PINK BIKINI SET
  4. 63% Off
    -63%
    BLACK CONTRAST STRIPES BIKINI SET
  5. 60% Off
    -60%
    BLACK BOW-KNOT DECOR SWIMWEAR SET
  6. 60% Off
    -60%
    BLUE RIB-KNIT TWO PIECE SWIMWEAR SET
  7. 63% Off
    -63%
    RED MINI BOW-KNOT DECOR SWIMWEAR SET
  8. 63% Off
    -63%
    RED POLKA DOTS PRINTS BIKINI SET
  9. 60% Off
    -60%
    WHITE TIE-UP STRAPS SWIMWEAR SET
  10. 63% Off
    -63%
    WHITE COLOURBLOCKING SWIMWEAR SET