app-download-header
24 Hours Sale - 95% Off on Everything
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 And Trousers

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Cropped Jeans 4 items
  2. Culottes 1 item
  3. Flare Jeans 63 items
  4. Ripped Jeans 4 items
  5. Skinny Jeans 5 items
  6. Straight Jeans 179 items
  7. Mom Jeans 4 items
  8. Baggy Jeans 10 items
  9. Wide Leg Jeans 72 items
Colour
Colour
  1. Beige 27 items
  2. Black 161 items
  3. Blue 228 items
  4. Brown 66 items
  5. Gold 1 item
  6. Green 36 items
  7. Grey 99 items
  8. Multi 8 items
  9. Orange 2 items
  10. Pink 32 items
  11. Purple 6 items
  12. Red 13 items
  13. Silver 5 items
  14. White 33 items
  15. Yellow 14 items
Less
Size
Size
  1. 1XL 1 item
  2. 25 4 items
  3. 26 11 items
  4. 27 15 items
  5. 28 12 items
  6. 29 9 items
  7. 2XL 189 items
  8. 30 9 items
  9. 31 3 items
  10. 32 3 items
  11. 3XL 55 items
  12. 4XL 24 items
  13. 5XL 11 items
  14. FS 45 items
  15. L 711 items
  16. M 716 items
  17. S 707 items
  18. S-14 0 items
  19. XL 492 items
  20. XS 210 items
  21. XXL 29 items
Less
Price
Price
  1. Rs. 200 - 400 11 items
  2. Rs. 800 - 1000 1 item
  3. Rs. 1000 - 1200 9 items
  4. Rs. 1200 - 1400 16 items
  5. Rs. 1400 - 1600 39 items
  6. Rs. 1600 - 1800 36 items
  7. Rs. 1800 - 2000 58 items
  8. Rs. 2000 - 2500 135 items
  9. Rs. 2500 - 3000 174 items
  10. Rs. 3000 - 3500 182 items
  11. Rs. 3500 - 4000 71 items
  12. Rs. 4000 - 4500 17 items
  13. Rs. 4500 - 5000 6 items
  1. M Remove This Item
  2. S-14 Remove This Item
  3. 27 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=482 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_660692a289c404_75407336` 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

727 styles found
  1. 60% Off
    -60%
    Light Green Straight High-rise Jeans
  2. 95% Off
    -95%
    BLACK IS BACK COFFEE JEANS
  3. 95% Off
    -95%
    FIT IN TO MY POCKET BLACK JEANS
  4. 95% Off
    -95%
    SMASH IN STYLE BLACK JEANS
  5. 95% Off
    -95%
    HOPPING IN BLUE JEANS
  6. 95% Off
    -95%
    CHASING DREAMS DARK BLUE JOGGERS
  7. 95% Off
    -95%
    CHASING DREAMS GREEN TROUSERS
  8. 95% Off
    -95%
    REACHING IN FIVE BLACK TROUSERS
  9. 95% Off
    -95%
    MAKE YOU HAPPY GREY JEANS
  10. 95% Off
    -95%
    LEGIT SMASUAL ARMY GREEN TROUSERS
  11. 60% Off
    -60%
    LOUNGE AROUND WITH BLACK TROUSERS
  12. 60% Off
    -60%
    MOTIF-PRINT SMOCK HIGH-WAIST PALAZZO
  13. 60% Off
    -60%
    BLACK V-CUT FLARED SLIT LEGGING
  14. 59% Off
    -59%
    FLAP WAIST BAGGY CARGO PANTS