app-download-header
25% Cashback On Dresses
25% Cashback On Dresses, Use Code: DRESS25
25% Cashback On Dresses
Use Code: DRESS25
HR
:
MN
:
SC
ENDS IN

Lingerie

Filter
Shopping Options
Styles
Styles
  1. Sets 39 items
  2. Skater Skirts 0 items
  3. Hipster 12 items
  4. Bikini 25 items
  5. Boyshort 9 items
  6. Thong 89 items
  7. Boyleg 2 items
  8. Sports 4 items
  9. Racerback 1 item
  10. T-Shirt Bra 2 items
  11. Bralette 5 items
  12. Padded 2 items
  13. Non Padded 1 item
  14. Sports Bra 1 item
  15. Cold Shoulder Tops 0 items
Colour
Colour
  1. Beige 4 items
  2. Black 12 items
  3. Blue 11 items
  4. Brown 3 items
  5. Green 6 items
  6. Grey 3 items
  7. Multi 1 item
  8. Orange 3 items
  9. Pink 13 items
  10. Purple 11 items
  11. Red 8 items
  12. White 9 items
  13. Yellow 1 item
Less
Size
Size
  1. 70A 1 item
  2. 70B 1 item
  3. 70C 1 item
  4. 70D 1 item
  5. 70E 1 item
  6. 75A 1 item
  7. 75B 1 item
  8. 75C 1 item
  9. 75D 1 item
  10. 75E 1 item
  11. 80A 1 item
  12. 80B 1 item
  13. 80C 1 item
  14. 80D 1 item
  15. 80E 1 item
  16. 85B 1 item
  17. 85C 1 item
  18. 85D 1 item
  19. 85E 1 item
  20. 90C 1 item
  21. 90D 1 item
  22. 95C 1 item
  23. 95D 1 item
  24. FS 4 items
  25. L 8 items
  26. M 6 items
  27. S 4 items
  28. XL 8 items
  29. XXL 6 items
Less
Price
Price
  1. Rs. 200 - 400 9 items
  2. Rs. 400 - 600 3 items
  3. Rs. 1400 - 1600 2 items
  4. Rs. 1800 - 2000 3 items
  1. Skater Skirts Remove This Item
  2. Hipster Remove This Item
  3. Cold Shoulder Tops Remove This Item
  4. Non Padded Remove This Item
  5. Sports Remove This Item
  6. White Remove This Item
  7. Red 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`, `e`.`size_price`, `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=1957 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_6704c638c660b7_56369386` 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

17 styles found
  1. 65% Off
    -65%
    Red Low-waisted Hipster
  2. 65% Off
    -65%
    White Low-waisted Hipster
  3. 60% Off
    -60%
    HALTER WHITE RUNNING SPORTS BRA
  4. 60% Off
    -60%
    TWISTED HALTER NECK WHITE SPORTS BRA
  5. 58% Off
    -58%
    WHITE FULL-SUPPORT PADDED SPORT BRA
  6. 60% Off
    -60%
    WHITE FANCY-STRAP SHEER LACE BRA