app-download-header

Special Prices

Upto 90% Off

Sale Ends In
Hours
:
Mins
:
Secs
  • 24 - Hours - Only

Special Prices

Filter
Shopping Options
Styles
Styles
  1. Asymmetrical Dresses 4 items
  2. Blouses 20 items
  3. Bodycon 48 items
  4. Crop Tops 1 item
  5. Cropped Jeans 3 items
  6. Flare Jeans 4 items
  7. Jumpsuits 1 item
  8. Maxi Dresses 12 items
  9. Midi Dresses 19 items
  10. Midi Skirts 5 items
  11. Nightdresses 1 item
  12. Nightwear Set 7 items
  13. Off Shoulder Tops 2 items
  14. Off-shoulder And Bandeau Dresses 17 items
  15. Pencil Dresses 2 items
  16. Playsuits And Rompers 1 item
  17. Sets 1 item
  18. Shift Dresses 27 items
  19. Shirt Dresses 1 item
  20. Shirts 1 item
  21. Short And Mini Skirts 3 items
  22. Skater Dresses 8 items
  23. Skinny Jeans 4 items
  24. Straight Jeans 2 items
  25. T-shirts 4 items
  26. Tunic Dresses 11 items
  27. Vests And Camis 1 item
  28. Hipster 8 items
  29. Bikini 28 items
  30. Boyshort 107 items
  31. Thong 3 items
  32. Cycling Short 1 item
  33. Full Figure 8 items
  34. T-Shirt Bra 35 items
  35. Padded 5 items
  36. Non Padded 28 items
Colour
Colour
  1. Beige 12 items
  2. Black 74 items
  3. Blue 58 items
  4. Brown 11 items
  5. Green 52 items
  6. Grey 24 items
  7. Maroon 13 items
  8. Multi 102 items
  9. Orange 11 items
  10. Pink 42 items
  11. Purple 15 items
  12. Red 69 items
  13. White 29 items
  14. Yellow 11 items
Less
Size
Size
  1. 1XL 3 items
  2. 25 2 items
  3. 26 2 items
  4. 27 5 items
  5. 28 3 items
  6. 29 2 items
  7. 2XL 12 items
  8. 30 1 item
  9. 31 1 item
  10. 32B 8 items
  11. 32C 16 items
  12. 32D 1 item
  13. 32E 1 item
  14. 34B 8 items
  15. 34C 5 items
  16. 34D 1 item
  17. 36B 7 items
  18. 36C 4 items
  19. 36D 1 item
  20. 38B 10 items
  21. 38C 7 items
  22. 38D 2 items
  23. 38E 2 items
  24. 3XL 10 items
  25. 40B 15 items
  26. 40C 12 items
  27. 40D 1 item
  28. 42B 18 items
  29. 42C 16 items
  30. 44B 6 items
  31. 4XL 8 items
  32. 5XL 6 items
  33. L 220 items
  34. M 212 items
  35. S 284 items
  36. XL 184 items
  37. XS 6 items
  38. XXL 42 items
  39. XXXL 3 items
Less
Price
Price
  1. Rs. 0 - 200 212 items
  2. Rs. 200 - 400 248 items
  3. Rs. 400 - 600 7 items
  4. Rs. 800 - 1000 1 item
  5. Rs. 2500 - 3000 230 items

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=642 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_6605e407659515_97640719` 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

468 styles found
  1. 90% Off
    -90%
    PINK SIMPLY SOFT T-SHIRT BRA
  2. 90% Off
    -90%
    CONTRAST PRINT PURPLE PADDED BRA
  3. 90% Off
    -90%
    PRINTED FULL FIGURE MARRON BRA
  4. 90% Off
    -90%
    LACE DETAIL NON-WIRED T-SHIRT BRA
  5. 90% Off
    -90%
    WHITE-BLUE WAVY-PRINT T-SHIRT BRA
  6. 90% Off
    -90%
    PINK NON-WIRED PADDED T-SHIRT BRA
  7. 95% Off
    -95%
    CASUAL SUMMER BEIGE SKATER DRESS
  8. 90% Off
    -90%
    SOFT MESH PADDED PRINTED PINK BRA
  9. 95% Off
    -95%
    MOTIF-PRINT BROWN V-NECK BLOUSE
  10. 95% Off
    -95%
    PRINTED BLACK/WHITE REGULAR SHIRT
  11. 95% Off
    -95%
    BLUE PLEATED & RUFFLE TRIM BLOUSE
  12. 95% Off
    -95%
    RUFFLE TRIM BLUE MANDARIN BLOUSE
  13. 95% Off
    -95%
    PRINTED CINCHED-NECK-HEM BLOUSES