Close Extra 5% OFF* On App Only
Use Code: APP5

Women

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 1 item
  2. Blouses 3 items
  3. Crop Tops 2 items
  4. Mini Skirts 3 items
  5. Off-shoulder And Bandeau Dresses 1 item
  6. Pencil Skirts 1 item
  7. Skater Dresses 1 item
  8. Skater Skirts 1 item
Colour
Colour
  1. Beige 52 items
  2. Black 240 items
  3. Blue 165 items
  4. Brown 82 items
  5. Gold 3 items
  6. Green 106 items
  7. Grey 109 items
  8. Maroon 21 items
  9. Multi 25 items
  10. Orange 24 items
  11. Pink 134 items
  12. Purple 44 items
  13. Red 109 items
  14. Silver 0 items
  15. White 125 items
  16. Yellow 67 items
Less
Size
Size
  1. 2XL 1 item
  2. 32B 12 items
  3. 32C 19 items
  4. 32D 1 item
  5. 34B 19 items
  6. 34C 20 items
  7. 34D 1 item
  8. 36B 23 items
  9. 36C 18 items
  10. 36D 1 item
  11. 38B 16 items
  12. 38C 16 items
  13. 40B 11 items
  14. 40C 13 items
  15. 42B 11 items
  16. 42C 10 items
  17. 4XL 0 items
  18. FS 2 items
  19. L 21 items
  20. M 13 items
  21. S 16 items
  22. S-9 0 items
  23. XL 22 items
  24. XS 1 item
  25. XXL 8 items
  26. XXXL 1 item
Less
Price
Price
  1. Rs. 0 - 1,500 18 items
  1. Silver Remove This Item
  2. Maroon Remove This Item
  3. S-9 Remove This Item
  4. 4XL Remove This Item
  5. L 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=469 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_61a58a3b67f577_86679266` 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

21 styles found
  1. 90% Off
    -90%
    GET SPONTANEOUS MAROON WHITE BOY SHORTS SET
    New
    Get Spontaneous Maroon White Boy Shorts Set
    ₹1,799
    ₹180 (90% Off)
  2. 90% Off
    -90%
    WHIMSICAL COLORBLOCK BURGUNDY STRIPED JUMPER
    New
    Whimsical Colorblock Burgundy Striped Jumper
    ₹4,949
    ₹495 (90% Off)
  3. 90% Off
    -90%
    PLAY IT CHIC BURGUNDY DRESS
    New
    Play It Chic Burgundy Dress
    ₹5,249
    ₹525 (90% Off)
  4. 90% Off
    -90%
    Berry Lush Burgundy Dress
    New
    Berry Lush Burgundy Dress
    ₹5,499
    ₹550 (90% Off)
  5. 90% Off
    -90%
    HAVING FUN BURGUNDY TOP
    New
    Having Fun Burgundy Top
    ₹2,499
    ₹250 (90% Off)
  6. 90% Off
    -90%
    Maroon Grey Bikini bottoms combo
    New
    Maroon Grey Bikini Bottoms Combo
    ₹1,339
    ₹134 (90% Off)
  7. 90% Off
    -90%
    ACTION IN BOLD MAROON ACTIVEWEAR
    New
    Action In Bold Maroon Activewear
    ₹3,769
    ₹377 (90% Off)
  8. 90% Off
    -90%
    MAROON AND SKY BLUE POWERNET BIKINI BOTTOMS COMBO
  9. 80% Off
    PREMIUM
    A LITTLE TALKATIVE BURGUNDY NIGHTGOWN
    New
    A Little Talkative Burgundy Nightgown
    ₹10,529
    ₹2,106 (80% Off)
  10. 90% Off
    -90%
    WHEN THE HEAT GOES UP BURGUNDY CROP TOP
    New
    When The Heat Goes Up Burgundy Crop Top
    ₹1,849
    ₹185 (90% Off)
  11. 90% Off
    -90%
    BREATHE THROUGH ME BUGUNDY INNERWEAR
    New
    Breathe Through Me Bugundy Innerwear
    ₹1,999
    ₹200 (90% Off)
  12. 90% Off
    -90%
    TRACE THE SHOW STOPPER BURGUNDY DRESS
    New
    Trace The Show Stopper Burgundy Dress
    ₹3,099
    ₹310 (90% Off)
  13. 90% Off
    -90%
    WHEN THE HEAT TAKES ON YOU BURGUNDY
    New
    When The Heat Takes On You Burgundy
    ₹1,849
    ₹185 (90% Off)
  14. 79% Off
    PREMIUM
    TWO FACED BURGUNDY SWEATSHIRT
    New
    Two Faced Burgundy Sweatshirt
    ₹10,253
    ₹2,151 (79% Off)
  15. 80% Off
    PREMIUM
    TAKE CARE THREE PIECE BURGUNDY NIGHTGOWN
    New
    Take Care Three Piece Burgundy Nightgown
    ₹16,903
    ₹3,381 (80% Off)
  16. 90% Off
    -90%
    FRINGE ZONED BURGUNDY KNITTED SHRUG
    New
    Fringe Zoned Burgundy Knitted Shrug
    ₹4,949
    ₹495 (90% Off)
  17. 90% Off
    -90%
    AT A STRETCH BURGUNDY MINI BODYCON SKIRT
    New
    At A Stretch Burgundy Mini Bodycon Skirt
    ₹4,299
    ₹430 (90% Off)
  18. 90% Off
    -90%
    DONE WITH WORK BURGUNDY TOP
    New
    Done With Work Burgundy Top
    ₹4,249
    ₹425 (90% Off)
  19. 90% Off
    -90%
    NO TIME TO REGRET RED A-LINE SKIRT
    New
    No Time To Regret Red A-line Skirt
    ₹4,449
    ₹445 (90% Off)
  20. 90% Off
    -90%
    FOR AFTER DARK APPEARANCE BURGUNDY MINI SKIRT
    New
    For After Dark Appearance Burgundy Mini Skirt
    ₹4,449
    ₹445 (90% Off)
  21. 90% Off
    -90%
    WINTER SUNSET MAROON RIBBED TOP
    New
    Winter Sunset Maroon Ribbed Top
    ₹2,899
    ₹290 (90% Off)