app-download-header
Banner 12

Banner 12

Lingerie

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Sets 47 items
  2. Hipster 17 items
  3. Bikini 35 items
  4. Boyshort 27 items
  5. Thong 144 items
  6. Cycling Short 2 items
  7. Boyleg 2 items
  8. Full Figure 2 items
  9. Sports 8 items
  10. Racerback 2 items
  11. T-Shirt Bra 3 items
  12. Bralette 10 items
  13. Padded 2 items
  14. Non Padded 2 items
  15. Sports Bra 4 items
  16. Thongbody 3 items
Colour
Colour
  1. Beige 93 items
  2. Black 248 items
  3. Blue 147 items
  4. Brown 60 items
  5. Gold 1 item
  6. Green 118 items
  7. Grey 39 items
  8. Maroon 11 items
  9. Multi 158 items
  10. Orange 18 items
  11. Pink 231 items
  12. Purple 67 items
  13. Red 180 items
  14. White 200 items
  15. Yellow 12 items
Less
Size
Size
  1. 2XL 6 items
  2. 36E 1 item
  3. 3XL 6 items
  4. 40B 1 item
  5. 40C 1 item
  6. 42B 2 items
  7. 42C 2 items
  8. 44B 1 item
  9. 4XL 1 item
  10. 70A 13 items
  11. 70ABC-S 5 items
  12. 70B 18 items
  13. 70C 18 items
  14. 70D 9 items
  15. 70E 4 items
  16. 75A 13 items
  17. 75ABC-M 6 items
  18. 75B 20 items
  19. 75C 21 items
  20. 75D 14 items
  21. 75E 4 items
  22. 80A 12 items
  23. 80ABC-L 6 items
  24. 80B 21 items
  25. 80C 21 items
  26. 80D 14 items
  27. 80E 4 items
  28. 85B 21 items
  29. 85C 21 items
  30. 85D 14 items
  31. 85E 4 items
  32. 90C 7 items
  33. 90D 7 items
  34. 95C 7 items
  35. 95D 7 items
  36. FS 90 items
  37. L 189 items
  38. M 180 items
  39. S 120 items
  40. XL 96 items
  41. XS 3 items
  42. XXL 15 items
  43. XXXL 2 items
Less
Price
Price
  1. Rs. 0 - 200 45 items
  2. Rs. 200 - 400 80 items
  3. Rs. 400 - 600 99 items
  4. Rs. 600 - 800 20 items
  5. Rs. 800 - 1000 10 items
  6. Rs. 1000 - 1200 5 items
  7. Rs. 1200 - 1400 14 items
  8. Rs. 1400 - 1600 20 items
  9. Rs. 1600 - 1800 34 items
  10. Rs. 1800 - 2000 5 items
  11. Rs. 2000 - 2500 6 items
  12. Rs. 2500 - 3000 39 items
  1. Beige Remove This Item
  2. 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` 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=1522 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_66054e7172a221_74682943` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

339 styles found
  1. 58% Off
    -58%
    BLACK SOLID LACY FITTED BRALETTE
  2. 59% Off
    -59%
    CARTOON PRINT BLACK 2PC LINGERIE SET
  3. 59% Off
    -59%
    TWO PIECE BLACK LACY LINGERIE SET
  4. 59% Off
    -59%
    BLACK BOW KNOT SATIN LINGERIE SET
  5. 60% Off
    -60%
    BLACK ONE SHOULDER STRAP SPORTS BRA
  6. 60% Off
    -60%
    Black Lace Cut-out Strappy Thongbody
  7. 59% Off
    -59%
    3PC SATIN NIGHT BLACK LINGERIE SET