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

DESTINATION DENIM

Denim

Filter
Shopping Options
Category
Category
Brand Name
Brand Name
  1. LULUANDSKY 11 items
Styles
Styles
  1. Crop Tops 0 items
  2. Cropped Jeans 4 items
  3. Denim Dresses 2 items
  4. Dungarees 6 items
  5. Flared Jeans 15 items
  6. Midi Skirts 14 items
  7. Mini Skirts 5 items
  8. Ripped Jeans 5 items
  9. Skinny Jeans 15 items
  10. Straight Jeans 22 items
Colour
Colour
  1. Black 3 items
  2. Blue 17 items
  3. Grey 7 items
Less
Size
Size
  1. 25 3 items
  2. 26 16 items
  3. 27 18 items
  4. 28 20 items
  5. 29 23 items
  6. 2XL 6 items
  7. 30 20 items
  8. 31 21 items
  9. 32 18 items
  10. 3XL 4 items
  11. 4XL 4 items
  12. 5XL 4 items
  13. FREESIZE 0 items
  14. L 11 items
  15. M 11 items
  16. S 8 items
  17. XL 8 items
  18. XS 2 items
Less
Price
Price
  1. Rs. 0 - 1,500 8 items
  1. Skinny Jeans Remove This Item
  2. Cropped Jeans Remove This Item
  3. Dungarees Remove This Item
  4. Crop Tops Remove This Item
  5. Denim Dresses Remove This Item
  6. FREESIZE Remove This Item
  7. M Remove This Item
  8. 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=503 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_62c3eb7a605149_60323354` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24

17 styles found
  1. 80% Off
    PREMIUM
    SUMMERTIME FAVORITE DARK BLUE DUNGAREE
    New
    Summertime Favorite Dark Blue Dungaree
    ₹9,519
    ₹1,904 (80% Off)
  2. 80% Off
    PREMIUM
    SUMMERTIME FAVORITE LIGHT BLUE DUNGAREE
    New
    Summertime Favorite Light Blue Dungaree
    ₹9,519
    ₹1,904 (80% Off)
  3. 80% Off
    PREMIUM
    MY SUNDAY OUTING'S BLUE DUNGAREE
    New
    My Sunday Outing's Blue Dungaree
    ₹9,649
    ₹1,930 (80% Off)
  4. 80% Off
    PREMIUM
    YOUR GO TO LIGHT BLUE DUNGAREE
    New
    Your Go To Light Blue Dungaree
    ₹10,443
    ₹2,089 (80% Off)
  5. 80% Off
    PREMIUM
    YOUR GO TO GREY DUNGAREE
    New
    Your Go To Grey Dungaree
    ₹10,443
    ₹2,089 (80% Off)
  6. 80% Off
    PREMIUM
    ALL RETRO FEELS BLUE DENIM DRESS
    New
    All Retro Feels Blue Denim Dress
    ₹10,834
    ₹2,167 (80% Off)
  7. 80% Off
    PREMIUM
    TOO SEXY IN BLUE DENIM DRESS
    New
    Too Sexy In Blue Denim Dress
    ₹10,414
    ₹2,083 (80% Off)
  8. 90% Off
    -90%
    TOO FUNCTIONAL LIGHT BLUE JEANS
    New
    Too Functional Light Blue Jeans
    ₹6,149
    ₹645 (90% Off)
  9. 86% Off
    PREMIUM
    FULL OF CHARM BLUE JEANS
    New
    Full Of Charm Blue Jeans
    ₹8,456
    ₹1,184 (86% Off)
  10. 80% Off
    PREMIUM
    TOO MUCH FLATTERING BLUE JEANS
    New
    Too Much Flattering Blue Jeans
    ₹9,313
    ₹1,863 (80% Off)
  11. 90% Off
    -90%
    CHASING THE FUN BLUE JEANS
    New
    Chasing The Fun Blue Jeans
    ₹4,899
    ₹514 (90% Off)
  12. 90% Off
    -90%
    HOPPING IN BLUE JEANS
    New
    Hopping In Blue Jeans
    ₹4,899
    ₹514 (90% Off)
  13. 90% Off
    -90%
    STRIKE WHEN ITS HOT BLACK JEANS
    New
    Strike When Its Hot Black Jeans
    ₹4,899
    ₹514 (90% Off)
  14. 90% Off
    -90%
    THE GOING-OUT BLUE DENIM DUNGAREE
    New
    The Going-out Blue Denim Dungaree
    ₹4,599
    ₹482 (90% Off)
  15. 90% Off
    -90%
    RIP HOPPER BLUE CROPPED JEANS
    New
    Rip Hopper Blue Cropped Jeans
    ₹3,499
    ₹367 (90% Off)
  16. 90% Off
    -90%
    RIP ALL BAD THOUGHTS BLUE CROPPED JEANS
    New
    Rip All Bad Thoughts Blue Cropped Jeans
    ₹3,649
    ₹383 (90% Off)
  17. 90% Off
    -90%
    NEVER COMPROMISE BLUE CROPPED JEANS
    New
    Never Compromise Blue Cropped Jeans
    ₹3,649
    ₹383 (90% Off)