app-download-header
Shoes Starting Price @199
20% OFF on Buy 4 any items, Use Code: MERRY
20% OFF on Buy 4 any items
Use Code: MERRY
HR
:
MN
:
SC
ENDS IN

Jeans

Filter
Shopping Options
Styles
Styles
  1. Blouses 1 item
  2. Cropped Jeans 9 items
  3. Culottes 1 item
  4. Flare Jeans 98 items
  5. Ripped Jeans 4 items
  6. Skinny Jeans 14 items
  7. Straight Jeans 300 items
  8. Mom Jeans 11 items
  9. Baggy Jeans 24 items
  10. Boyfriend Jeans 39 items
  11. Wide Leg Jeans 137 items
Colour
Colour
  1. Beige 4 items
  2. Black 94 items
  3. Blue 399 items
  4. Brown 14 items
  5. Green 14 items
  6. Grey 53 items
  7. Multi 6 items
  8. Orange 1 item
  9. Pink 19 items
  10. Purple 3 items
  11. Red 4 items
  12. White 19 items
  13. Yellow 16 items
Less
Size
Size
  1. 1XL 7 items
  2. 25 4 items
  3. 26 9 items
  4. 27 20 items
  5. 28 20 items
  6. 29 18 items
  7. 2XL 282 items
  8. 30 21 items
  9. 31 14 items
  10. 32 15 items
  11. 34 13 items
  12. 36 2 items
  13. 3XL 121 items
  14. 4XL 69 items
  15. 5XL 57 items
  16. L 564 items
  17. M 561 items
  18. S 553 items
  19. XL 472 items
  20. XS 235 items
  21. XXL 18 items
  22. 0XL 7 items
Less
Price
Price
  1. Rs. 200 - 400 4 items
  2. Rs. 1400 - 1600 3 items
  3. Rs. 1600 - 1800 10 items
  4. Rs. 1800 - 2000 7 items
  5. Rs. 2000 - 2500 77 items
  6. Rs. 2500 - 3000 174 items
  7. Rs. 3000 - 3500 207 items
  8. Rs. 3500 - 4000 137 items
  9. Rs. 4000 - 4500 20 items
  10. Rs. 4500 - 5000 5 items
  11. Rs. 5500 - 6000 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`, `at_special_price`.`value` AS `special_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_66d05c612e9da8_19171166` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 0) WHERE (stock_status_index.stock_status = 1) ORDER BY `special_price` DESC, `e`.`entity_id` DESC LIMIT 24

646 styles found
  1. 60% Off
    -60%
    Blue High-rise Faded Cargo Jeans
  2. 58% Off
    -58%
    STRAIGHT LEG WASHED BROWN JEANS
  3. 60% Off
    -60%
    DESIGNED WITH STYLE BLUE JEANS
  4. 60% Off
    -60%
    Black Grey Wide Leg Jeans W/o Belt
  5. 60% Off
    -60%
    Blue Black Dual Tone Wide Leg Jeans
  6. 60% Off
    -60%
    Blue Retro Angled Back Pocket Jeans
  7. 60% Off
    -60%
    Light Blue Faded Plus Size Jeans
  8. 60% Off
    -60%
    Low-waisted Washed-effect Cargo Jeans
  9. 60% Off
    -60%
    STRIVING FOR YOUR LOVE BLACK JEANS
  10. 60% Off
    -60%
    BLACK RIPPED KNEE STRAIGHT LEG JEANS
  11. 60% Off
    -60%
    Washed Blue Straight Fit Cargo Jeans
  12. 60% Off
    -60%
    DELIGHTFULLY SEXY WHITE JEANS
  13. 60% Off
    -60%
    Light Blue Plus Size Straight Jeans
  14. 60% Off
    -60%
    Plus Size Light Blue Straight Jeans
  15. 60% Off
    -60%
    CHIC APPROACH BLACK JEANS
  16. 60% Off
    -60%
    Black Elasticated-waist Flared Jeans
  17. 60% Off
    -60%
    DARK GREY SEAM DETAILS CARGO JEANS
  18. 58% Off
    -58%
    CASUAL FITS BLUE JEANS
  19. 60% Off
    -60%
    Dark Grey Low-waisted Flare Jeans
  20. 60% Off
    -60%
    Retro Wide Leg Faded Jeans