app-download-header
Banner 12

Banner 12

Lingerie

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Sets 10 items
  2. Hipster 10 items
  3. Bikini 18 items
  4. Boyshort 12 items
  5. Thong 78 items
  6. Boyleg 2 items
  7. Sports 8 items
  8. T-Shirt Bra 1 item
  9. Bralette 1 item
  10. Sports Bra 2 items
Colour
Colour
  1. Beige 93 items
  2. Black 250 items
  3. Blue 146 items
  4. Brown 61 items
  5. Gold 1 item
  6. Green 119 items
  7. Grey 38 items
  8. Maroon 11 items
  9. Multi 158 items
  10. Orange 18 items
  11. Pink 231 items
  12. Purple 67 items
  13. Red 181 items
  14. White 201 items
  15. Yellow 12 items
Less
Size
Size
  1. 2XL 3 items
  2. 3XL 1 item
  3. 42B 1 item
  4. 44B 1 item
  5. 4XL 1 item
  6. 70A 1 item
  7. 70ABC-S 1 item
  8. 70B 1 item
  9. 70C 1 item
  10. 75A 1 item
  11. 75ABC-M 1 item
  12. 75B 1 item
  13. 75C 1 item
  14. 80A 1 item
  15. 80ABC-L 1 item
  16. 80B 1 item
  17. 80C 1 item
  18. 85B 1 item
  19. 85C 1 item
  20. FS 54 items
  21. L 78 items
  22. L/80 1 item
  23. M 76 items
  24. M/75 1 item
  25. S 48 items
  26. S/70 1 item
  27. XL 38 items
  28. XL/85 1 item
  29. XS 1 item
  30. XXL 5 items
Less
Price
Price
  1. Rs. 0 - 200 25 items
  2. Rs. 200 - 400 43 items
  3. Rs. 400 - 600 52 items
  4. Rs. 600 - 800 4 items
  5. Rs. 800 - 1000 5 items
  6. Rs. 1000 - 1200 3 items
  7. Rs. 1200 - 1400 4 items
  8. Rs. 1400 - 1600 2 items
  9. Rs. 1600 - 1800 4 items
  10. Rs. 1800 - 2000 2 items
  11. Rs. 2000 - 2500 2 items
  12. Rs. 2500 - 3000 15 items
  1. Blue 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=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_660593e1b88de6_72739148` 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

146 styles found
  1. 90% Off
    -90%
    WHITE-BLUE WAVY-PRINT T-SHIRT BRA
  2. 58% Off
    -58%
    BLUE SOLID LACY FITTED BRALETTE
  3. 60% Off
    -60%
    MESH-UP NYLON BLUE THONG BREIF
  4. 59% Off
    -59%
    TWO PIECE BLUE LACY LINGERIE SET
  5. 59% Off
    -59%
    SATIN BLUE THREE PIECE LINGERIE SET
  6. 58% Off
    -58%
    STRIKE THROUGH BLUE SPORTS BRA
  7. 58% Off
    -58%
    SHEER SHINE LIGHT BLUE SPORTS BRA