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 17 items
  2. Cover Ups 21 items
  3. Sets 198 items
  4. Swimsuit 231 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 52 items
  10. Orange 10 items
  11. Pink 33 items
  12. Purple 13 items
  13. Red 29 items
  14. White 61 items
  15. Yellow 20 items
Less
Size
Size
  1. 1XL 27 items
  2. 2XL 44 items
  3. 3XL 42 items
  4. 4XL 37 items
  5. 5XL 15 items
  6. FS 68 items
  7. L 721 items
  8. M 716 items
  9. S 449 items
  10. XL 428 items
  11. XS 7 items
  12. XXL 11 items
  13. 0XL 17 items
Less
Price
Price
  1. Rs. 800 - 1000 14 items
  2. Rs. 1000 - 1200 4 items
  3. Rs. 1200 - 1400 37 items
  4. Rs. 1400 - 1600 56 items
  5. Rs. 1600 - 1800 51 items
  6. Rs. 1800 - 2000 47 items
  7. Rs. 2000 - 2500 158 items
  8. Rs. 2500 - 3000 51 items
  9. Rs. 3000 - 3500 15 items
  10. Rs. 3500 - 4000 7 items
  11. Rs. 4000 - 4500 1 item
  1. XL Remove This Item
  2. 2XL 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=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_6606baec8fd7d3_50754034` 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

446 styles found
  1. 60% Off
    -60%
    VACAY READY WHITE SWIMSUIT
  2. 60% Off
    -60%
    MY LACE WHITE SWIMSUIT
  3. 60% Off
    -60%
    LACE OVER ME APRICOT SWIMSUIT
  4. 60% Off
    -60%
    OUT ON THE BEACH GREEN BIKINI
  5. 60% Off
    -60%
    SUNNY VIBES YELLOW SWIMSUIT
  6. 60% Off
    -60%
    SUNNY VIBES BLACK SWIMSUIT
  7. 60% Off
    -60%
    MY FUN BLACK BEACH DRESS
  8. 60% Off
    -60%
    LET'S GO TO THE BEACH BLACK SWIMSUIT
  9. 60% Off
    -60%
    PERFECT FOR BEACH APRICOT SWIMSUIT
  10. 60% Off
    -60%
    FLORAL PARADISE ORANGE SWIMSUIT
  11. 60% Off
    -60%
    FLORAL PARADISE WHITE SWIMSUIT
  12. 60% Off
    -60%
    I'M ON MY WAY BLACK SWIMSUIT
  13. 60% Off
    -60%
    I'M ON MY WAY GREEN SWIMSUIT
  14. 60% Off
    -60%
    SOAKING UP THE SUN WHITE BIKINI
  15. 60% Off
    -60%
    BASICS FOR ME DARK BLUE BIKINI
  16. 60% Off
    -60%
    BASICS FOR ME LIGHT BLUE BIKINI
  17. 60% Off
    -60%
    UP FOR A SWIM WHITE SWIMSUIT
  18. 60% Off
    -60%
    UP FOR A SWIM BLACK SWIMSUIT
  19. 60% Off
    -60%
    IT'S A SUNNY DAY GREEN BIKINI
  20. 60% Off
    -60%
    IT'S A SUNNY DAY BLACK BIKINI
  21. 60% Off
    -60%
    LET'S GO SURFING BLACK BIKINI
  22. 60% Off
    -60%
    MY BEACH ATTIRE BLACK SWIMSUIT