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

Women

Filter
Shopping Options
Category
Category
  • Dresses 1 item
  • Jeans And Trousers 14 items
    • Jeans 14 items
  • Denim 6 items
    • Jeans 6 items
Styles
Styles
  1. Cropped Jeans 7 items
  2. Dungarees 0 items
  3. Flared Jeans 6 items
  4. Ripped Jeans 3 items
  5. Skinny Jeans 12 items
  6. Straight Jeans 8 items
  7. Tunic Dresses 1 item
Colour
Colour
  1. Black 4 items
  2. Blue 10 items
  3. Pink 1 item
  4. White 1 item
Less
Size
Size
  1. 10 1 item
  2. 12 1 item
  3. 16 0 items
  4. 25 3 items
  5. 26 6 items
  6. 27 7 items
  7. 28 9 items
  8. 29 12 items
  9. 30 10 items
  10. 31 11 items
  11. 32 6 items
  12. 33 1 item
  13. L 36 items
  14. M 25 items
  15. S 18 items
  16. UK12 0 items
  17. XL 37 items
  18. XS 1 item
  19. XXL 16 items
Less
Price
Price
  1. Rs. 0 - 1,500 7 items
  2. Rs. 1,501 - 3,000 8 items
  1. Tunic Dresses Remove This Item
  2. Dungarees Remove This Item
  3. Flared Jeans Remove This Item
  4. Straight Jeans Remove This Item
  5. 16 Remove This Item
  6. UK12 Remove This Item
  7. 12 Remove This Item
  8. 31 Remove This Item
  9. 26 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=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_61ef5c7245ec99_86339691` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`created_at` ASC, `e`.`entity_id` DESC LIMIT 24

15 styles found
  1. 95% Off
    -95%
    BLOCK ME WITH COLORS PINK TUNIC DRESS
    Sale
    Block Me With Colors Pink Tunic Dress
    ₹3,349
    ₹167 (95% Off)
  2. 88% Off
    -88%
    RIP ALL BAD THOUGHTS BLUE CROPPED JEANS
    New
    Rip All Bad Thoughts Blue Cropped Jeans
    ₹3,649
    ₹420 (88% Off)
  3. 89% Off
    -89%
    POCKET FULL OF SUNSHINE BLUE JEANS
    New
    Pocket Full Of Sunshine Blue Jeans
    ₹4,899
    ₹563 (89% Off)
  4. 89% Off
    -89%
    IS IT NOT A STRAIGHT FIT BLACK JEANS
    New
    Is It Not A Straight Fit Black Jeans
    ₹4,899
    ₹563 (89% Off)
  5. 89% Off
    -89%
    FIT IN TO MY POCKET DARK BLUE JEANS
    New
    Fit In To My Pocket Dark Blue Jeans
    ₹4,899
    ₹563 (89% Off)
  6. 89% Off
    -89%
    FIT IN TO MY POCKET BLACK JEANS
    New
    Fit In To My Pocket Black Jeans
    ₹4,899
    ₹563 (89% Off)
  7. 89% Off
    -89%
    LET THE FUN FLARE BLUE JEANS
    New
    Let The Fun Flare Blue Jeans
    ₹4,899
    ₹563 (89% Off)
  8. 89% Off
    -89%
    TOP THE LOOK DARK BLUE JEANS
    New
    Top The Look Dark Blue Jeans
    ₹5,749
    ₹661 (89% Off)
  9. 89% Off
    -89%
    PLAYFUL WEEKEND DEEP BLUE JEANS
    New
    Playful Weekend Deep Blue Jeans
    ₹5,499
    ₹632 (89% Off)
  10. 89% Off
    -89%
    SIMPLISTIC LIGHT BLUE JEANS
    New
    Simplistic Light Blue Jeans
    ₹5,949
    ₹684 (89% Off)
  11. 89% Off
    -89%
    EMBRACING IT BLACK JEANS
    New
    Embracing It Black Jeans
    ₹5,949
    ₹684 (89% Off)
  12. 89% Off
    -89%
    LOUNGING AROUND BLUE JEANS
    New
    Lounging Around Blue Jeans
    ₹5,749
    ₹661 (89% Off)
  13. 89% Off
    -89%
    ELEVATE YOURSELF BLUE JEANS
    New
    Elevate Yourself Blue Jeans
    ₹5,749
    ₹661 (89% Off)
  14. 89% Off
    -89%
    FINISHING TOUCHES LIGHT BLUE JEANS
    New
    Finishing Touches Light Blue Jeans
    ₹5,949
    ₹684 (89% Off)
  15. 89% Off
    -89%
    RIPPING APART DEEP BLUE JEANS
    New
    Ripping Apart Deep Blue Jeans
    ₹5,749
    ₹661 (89% Off)