app-download-header
Everything under Rs.999
20% Cashback* on Buy 4 items. , Use Code: CB20
20% Cashback* on Buy 4 items.
Use Code: CB20
HR
:
MN
:
SC
ENDS IN

Jeans

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Cropped Jeans 10 items
  2. Culottes 1 item
  3. Flare Jeans 121 items
  4. Ripped Jeans 4 items
  5. Skinny Jeans 16 items
  6. Straight Jeans 317 items
  7. Mom Jeans 18 items
  8. Baggy Jeans 31 items
  9. Boyfriend Jeans 35 items
  10. Wide Leg Jeans 165 items
Colour
Colour
  1. Beige 4 items
  2. Black 99 items
  3. Blue 457 items
  4. Brown 14 items
  5. Green 14 items
  6. Grey 55 items
  7. Multi 14 items
  8. Orange 1 item
  9. Pink 19 items
  10. Purple 4 items
  11. Red 3 items
  12. White 23 items
  13. Yellow 17 items
Less
Size
Size
  1. 1XL 7 items
  2. 25 3 items
  3. 26 8 items
  4. 27 20 items
  5. 28 18 items
  6. 29 17 items
  7. 2XL 306 items
  8. 30 19 items
  9. 31 12 items
  10. 32 13 items
  11. 34 12 items
  12. 36 1 item
  13. 3XL 116 items
  14. 4XL 65 items
  15. 5XL 51 items
  16. L 628 items
  17. M 626 items
  18. S 621 items
  19. XL 517 items
  20. XS 269 items
  21. XXL 17 items
  22. 0XL 7 items
Less
Price
Price
  1. Rs. 200 - 400 5 items
  2. Rs. 1000 - 1200 4 items
  3. Rs. 1200 - 1400 8 items
  4. Rs. 1400 - 1600 14 items
  5. Rs. 1600 - 1800 18 items
  6. Rs. 1800 - 2000 14 items
  7. Rs. 2000 - 2500 116 items
  8. Rs. 2500 - 3000 197 items
  9. Rs. 3000 - 3500 207 items
  10. Rs. 3500 - 4000 91 items
  11. Rs. 4000 - 4500 7 items
  12. Rs. 4500 - 5000 4 items
  13. Rs. 5000 - 5500 2 items

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=483 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_672aa8f3a591d3_28825826` 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

719 styles found
  1. 75% Off
    -75%
    RIPPED MID-WAIST FLARE BLUE JEANS
  2. 64% Off
    -64%
    BUTTON-DOWN LIGHT-BLUE FLARE JEANS
  3. 64% Off
    -64%
    Beige Mid-waist Straight Jeans
  4. 64% Off
    -64%
    SHIRRING-DETAIL BLACK FLARE JEANS
  5. 75% Off
    -75%
    TAKE ME AWAY BLUE DENIM JEANS
  6. 75% Off
    -75%
    LOOSE WIDE-LEG BLUE CASUAL JEANS
  7. 75% Off
    -75%
    BLUE HIGH V-WAIST FLARE JEANS
  8. 63% Off
    -63%
    Faded-effect Front Slit Flare Jeans
  9. 63% Off
    -63%
    Deep Blue Plus Size Jeans
  10. 58% Off
    -58%
    SLIM WAIST DARK-BLUE WIDE JEANS
  11. 58% Off
    -58%
    LIGHT BLUE STRAIGHT LEG JEANS
  12. 58% Off
    -58%
    THROUGH THE CROWD BLACK JEANS
  13. 60% Off
    -60%
    Straight Fit Frayed-detail Jeans
  14. 75% Off
    -75%
    WASHED-OUT HIGH-WAIST STRAIGHT JEANS
  15. 58% Off
    -58%
    BUTTON-DOWN DARK-BLUE FLARE JEANS
  16. 75% Off
    -75%
    RIPPED LIGHT BLUE WIDE LEG JEANS
  17. 58% Off
    -58%
    SLIM WAIST BLACK WIDE JEANS
  18. 60% Off
    -60%
    Light Blue Mid-waist Straight Jeans