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 78 items
  2. Cover Ups 39 items
  3. Sets 427 items
  4. Swimsuit 309 items
  5. Sarong 26 items
Colour
Colour
  1. Beige 20 items
  2. Black 176 items
  3. Blue 99 items
  4. Brown 48 items
  5. Gold 1 item
  6. Green 85 items
  7. Grey 15 items
  8. Maroon 1 item
  9. Multi 125 items
  10. Orange 21 items
  11. Pink 63 items
  12. Purple 27 items
  13. Red 58 items
  14. Silver 1 item
  15. White 102 items
  16. Yellow 37 items
Less
Size
Size
  1. 1XL 27 items
  2. 2XL 44 items
  3. 3XL 43 items
  4. 4XL 38 items
  5. 5XL 15 items
  6. FS 64 items
  7. L 727 items
  8. M 723 items
  9. S 449 items
  10. XL 424 items
  11. XS 8 items
  12. XXL 11 items
  13. 0XL 17 items
Less
Price
Price
  1. Rs. 600 - 800 11 items
  2. Rs. 800 - 1000 55 items
  3. Rs. 1000 - 1200 29 items
  4. Rs. 1200 - 1400 98 items
  5. Rs. 1400 - 1600 144 items
  6. Rs. 1600 - 1800 92 items
  7. Rs. 1800 - 2000 93 items
  8. Rs. 2000 - 2500 200 items
  9. Rs. 2500 - 3000 72 items
  10. Rs. 3000 - 3500 20 items
  11. Rs. 3500 - 4000 7 items
  12. Rs. 4000 - 4500 2 items

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_65f97bc0228451_71877894` 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

879 styles found
  1. 60% Off
    -60%
    Green Floral Pattern 2pc Bikini Set
  2. 60% Off
    -60%
    Polka Dot 3pc Beachwear Set
  3. 60% Off
    -60%
    Tie-dye Two Piece Strappy Bikini Set
  4. 60% Off
    -60%
    Printed Three Piece Swimwear Set
  5. 60% Off
    -60%
    Green Animal Pattern 2pc Bikini Set
  6. 60% Off
    -60%
    YELLOW PRINT-TRIM SWIMWEAR SET
  7. 60% Off
    -60%
    BLACK ONE-SHOULDER CUT-OUT SWIMSUIT
  8. 60% Off
    -60%
    PINK FLORAL DECOR BEACHWEAR SET
  9. 60% Off
    -60%
    RED FLORAL DECOR BEACHWEAR SET
  10. 60% Off
    -60%
    BLACK FLORAL DECOR BEACHWEAR SET
  11. 60% Off
    -60%
    TROPICAL PRINT BLACK BEACHWEAR SET