app-download-header
24 Hours Sale - 95% Off on Everything
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 6 items
  2. Cover Ups 6 items
  3. Sets 37 items
  4. Swimsuit 60 items
Colour
Colour
  1. Beige 16 items
  2. Black 102 items
  3. Blue 53 items
  4. Brown 24 items
  5. Gold 1 item
  6. Green 43 items
  7. Grey 9 items
  8. Maroon 1 item
  9. Multi 51 items
  10. Orange 10 items
  11. Pink 33 items
  12. Purple 13 items
  13. Red 28 items
  14. White 61 items
  15. Yellow 20 items
Less
Size
Size
  1. 1XL 6 items
  2. 2XL 7 items
  3. 3XL 7 items
  4. 4XL 7 items
  5. 5XL 1 item
  6. FS 13 items
  7. L 150 items
  8. M 155 items
  9. S 97 items
  10. S-9 0 items
  11. XL 97 items
  12. XS 1 item
  13. XXL 1 item
  14. 0XL 3 items
Less
Price
Price
  1. Rs. 800 - 1000 5 items
  2. Rs. 1000 - 1200 2 items
  3. Rs. 1200 - 1400 8 items
  4. Rs. 1400 - 1600 9 items
  5. Rs. 1600 - 1800 7 items
  6. Rs. 1800 - 2000 14 items
  7. Rs. 2000 - 2500 39 items
  8. Rs. 2500 - 3000 10 items
  9. Rs. 3000 - 3500 5 items
  10. Rs. 3500 - 4000 2 items
  11. Rs. 4000 - 4500 1 item
  1. White Remove This Item
  2. Green Remove This Item
  3. XL Remove This Item
  4. S-9 Remove This Item
  5. 4XL Remove This Item

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`, `stock_status_index`.`stock_status` AS `is_salable`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`size`, `e`.`size_value`, `e`.`eancode`, `e`.`wallet_credit_based_on`, `e`.`wallet_credit_based_on_value`, `e`.`wallet_cash_back`, `e`.`hsn_code`, `e`.`dateofupload`, `e`.`heel_size`, `e`.`heel_size_value`, `e`.`product_color`, `e`.`price_filter`, `e`.`price_filter_value`, `e`.`styles`, `e`.`app_special_price`, `e`.`swatch_image`, `e`.`disable_cod`, `e`.`product_tag`, `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_flat_1` 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=481 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_66061db6642469_21924499` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

103 styles found
  1. 60% Off
    -60%
    LIGHT GREEN SWIMWEAR TOP & SHORTS
  2. 59% Off
    -59%
    WHITE SEAMLESS ONE-SHOULDER SWIMSUIT
  3. 59% Off
    -59%
    SOLID WHITE CUT-OUT 2PC BIKINI SET
  4. 59% Off
    -59%
    WHITE CONTRAST STRAP 2PC BIKINI SET
  5. 59% Off
    -59%
    CUT-OUT ONE-SHOULDER WHITE SWIMSUIT
  6. 60% Off
    -60%
    SOLID WHITE-BLUE 2PC BIKINI SET
  7. 58% Off
    -58%
    GREEN SHIRRING 2PC SWIMWEAR SET
  8. 58% Off
    -58%
    SHIRRED TIE-UP LIGHT GREEN SWIMSUIT
  9. 58% Off
    -58%
    WHITE KNOTTY ONE-SHOULDER BIKINI SET
  10. 58% Off
    -58%
    WHITE TWO PIECE SWIMWEAR SET
  11. 59% Off
    -59%
    3PC GREEN-YELLOW SWIMWEAR SET
  12. 58% Off
    -58%
    3PC GREEN-PINK SWIMWEAR SET
  13. 58% Off
    -58%
    HALTERNECK LIGHT GREEN SWIMSUIT
  14. 58% Off
    -58%
    SOLID HALTERNECK WHITE SWIMSUIT
  15. 58% Off
    -58%
    WHITE ONE-SHOULDER SLIM SWIMSUIT
  16. 58% Off
    -58%
    MULTI-STYLE PLUNGE GREEN SWIMSUIT
  17. 58% Off
    -58%
    MULTI-STYLE PLUNGE WHITE SWIMSUIT
  18. 60% Off
    -60%
    GREEN TIE-STRAP BIKINI SET
  19. 58% Off
    -58%
    CONTRAST WHITE SOLID SWIMSUIT
  20. 58% Off
    -58%
    THREE PIECE GREEN SWIMWEAR SET
  21. 58% Off
    -58%
    THREE PIECE WHITE SWIMWEAR SET