Close Extra 5% OFF* On App Only
Use Code: APP5
TODAY'S SALE - UPTO 90% OFF ON BAGS | Till noon today
Extra 10% OFF* on Spend ₹4995
Use code: SKY15
Sale Ends In
Hours
:
Mins
:
Secs

Brassiere

Filter
Shopping Options
Colour
Colour
  1. Blue 1 item
  2. Grey 1 item
  3. Multi 1 item
  4. Pink 1 item
Less
Size
Size
  1. 32B 55 items
  2. 32C 75 items
  3. 32D 14 items
  4. 34B 75 items
  5. 34C 82 items
  6. 34D 16 items
  7. 36B 71 items
  8. 36C 64 items
  9. 36D 15 items
  10. 38B 62 items
  11. 38C 55 items
  12. 40B 29 items
  13. 40C 21 items
  14. 42B 3 items
  15. 42C 3 items
  16. FS 41 items
  17. L 4 items
  18. M 2 items
  19. S 1 item
Less
  1. L 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=1523 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_61706ad262aeb1_94292820` 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

4 styles found
  1. 88% Off
    POPULAR
    MULTI HIPSTER BRIEFS
    New
    Multi Hipster Briefs
    ₹1,249
    ₹150 (88% Off)
  2. 89% Off
    TRENDING
    PINK SCOOP NECK SPORTS BRALETTE
    New
    Pink Scoop Neck Sports Bralette
    ₹1,799
    ₹205 (89% Off)
  3. 89% Off
    TRENDING
    GREY SCOOP NECK SPORTS BRALETTE
    New
    Grey Scoop Neck Sports Bralette
    ₹1,799
    ₹205 (89% Off)
  4. 89% Off
    TRENDING
    LIGHTLY PADDED NAVY STRIPED BRA
    New
    Lightly Padded Navy Striped Bra
    ₹2,099
    ₹235 (89% Off)