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

Women

Filter
Shopping Options
Category
Category
  • Jeans And Trousers 3 items
    • Jeans 3 items
  • Denim 1 item
    • Jeans 1 item
Styles
Styles
  1. Asymmetrical Dresses 13 items
  2. Blouses 26 items
  3. Body Suits 10 items
  4. Bodycon 24 items
  5. Crop Tops 11 items
  6. Cropped Jeans 12 items
  7. Culottes 1 item
  8. Flared Jeans 3 items
  9. Jumpsuits 7 items
  10. Maxi Dresses 3 items
  11. Midi Dresses 10 items
  12. Midi Skirts 1 item
  13. Mini Skirts 12 items
  14. Off Shoulder Tops 4 items
  15. Off-shoulder And Bandeau Dresses 4 items
  16. Pencil Dresses 2 items
  17. Playsuits And Rompers 7 items
  18. Ripped Jeans 2 items
  19. Sets 9 items
  20. Shift Dresses 20 items
  21. Shirt Dresses 1 item
  22. Shirts 4 items
  23. Skater Dresses 12 items
  24. Skater Skirts 5 items
  25. Skinny Jeans 2 items
  26. Straight Jeans 3 items
  27. Swimsuit 7 items
  28. T-shirts 26 items
  29. Tunic Dresses 25 items
  30. Tunic Tops 24 items
  31. Vests And Camis 9 items
Size
Size
  1. 25 2 items
  2. 26 1 item
  3. 27 3 items
  4. 28 1 item
  5. 29 2 items
  6. S-9 0 items
  7. XL 0 items
Less
  1. Flared Jeans Remove This Item
  2. XL Remove This Item
  3. 27 Remove This Item
  4. S-9 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_5efda0bc5ba142_56393019` 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

3 styles found
  1. 85% Off
    SPREAD LOVE DARK BLUE FLARED DENIMS
    New
    Spread Love Dark Blue Flared Denims
    ₹4,249
    ₹637 (85% Off)
  2. 85% Off
    I'VE GOT MY CORSET ON BLUE BOOTCUT JEANS
    Sale
    I've Got My Corset On Blue Bootcut Jeans
    ₹8,299
    ₹1,245 (85% Off)
  3. 85% Off
    NEVER MIND MY FLARE BLUE CROPPED JEANS
    Sale
    Never Mind My Flare Blue Cropped Jeans
    ₹6,699
    ₹1,005 (85% Off)