app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 170 items
  2. Beach Shorts 2 items
  3. Beach Tops 1 item
  4. Blouses 295 items
  5. Body Suits 484 items
  6. Bodycon 1006 items
  7. Bracelets 21 items
  8. Caps 7 items
  9. Cover Ups 143 items
  10. Crop Tops 675 items
  11. Cropped Jeans 2 items
  12. Culottes 2 items
  13. Denim Dresses 0 items
  14. Denim Tops 4 items
  15. Dungarees 8 items
  16. Earrings 75 items
  17. Flare Jeans 32 items
  18. Hats 5 items
  19. Jumpsuits 207 items
  20. Maxi Dresses 1053 items
  21. Maxi Skirts 150 items
  22. Maxi Tops 8 items
  23. Midi Dresses 354 items
  24. Midi Skirts 99 items
  25. Necklace 19 items
  26. Nightdresses 255 items
  27. Nightwear Set 454 items
  28. Off Shoulder Tops 166 items
  29. Off-shoulder And Bandeau Dresses 566 items
  30. Pencil Dresses 64 items
  31. Pencil Skirts 16 items
  32. Pinafore 1 item
  33. Playsuits And Rompers 161 items
  34. Rings 23 items
  35. Ripped Jeans 1 item
  36. Sets 1192 items
  37. Shift Dresses 60 items
  38. Shirt Dresses 42 items
  39. Shirts 183 items
  40. Short And Mini Skirts 219 items
  41. Skater Dresses 507 items
  42. Skater Skirts 49 items
  43. Skinny Jeans 2 items
  44. Straight Jeans 57 items
  45. Swimsuit 233 items
  46. T-shirts 1081 items
  47. Tunic Dresses 10 items
  48. Tunic Tops 5 items
  49. Vests And Camis 1046 items
  50. Gloves 1 item
  51. Hipster 50 items
  52. Bikini 76 items
  53. Boyshort 13 items
  54. Thong 246 items
  55. Boyleg 3 items
  56. Halter Neck Bra 2 items
  57. Front Open 10 items
  58. Full Figure 8 items
  59. Sports 11 items
  60. Racerback 3 items
  61. T-Shirt Bra 11 items
  62. Bralette 37 items
  63. Backless 1 item
  64. Padded 67 items
  65. Non Padded 23 items
  66. Sports Bra 4 items
  67. Collars 35 items
  68. Wrap Dresses 28 items
  69. Waist Chains 5 items
  70. Mom Jeans 3 items
  71. Baggy Jeans 8 items
  72. Boyfriend Jeans 3 items
  73. Vests 10 items
  74. Wide Leg Jeans 28 items
  75. Shawl 9 items
  76. Corsets & Tube Tops 447 items
  77. Cold Shoulder Tops 39 items
  78. Sarong 14 items
  79. Corset Dresses 78 items
  80. Dressing Gowns & Robes 90 items
  81. Full Length Sets 1 item
  82. Short Length Sets 3 items
  83. One shoulder Dresses 81 items
  84. One shoulder Tops 79 items
  85. Track Pants & Joggers 1 item
  86. Jumpers & Sweaters 2 items
  87. Sweatshirts & Hoodies 2 items
  88. Leggings & Jeggings 1 item
  89. Swim Dress 8 items
Colour
Colour
  1. Beige 5 items
  2. Black 84 items
  3. Blue 140 items
  4. Brown 23 items
  5. Green 12 items
  6. Grey 38 items
  7. Maroon 1 item
  8. Multi 8 items
  9. Orange 2 items
  10. Pink 11 items
  11. Purple 3 items
  12. Red 4 items
  13. Silver 2 items
  14. White 21 items
  15. Yellow 4 items
Less
Size
Size
  1. 1XL 9 items
  2. 2XL 27 items
  3. 3XL 12 items
  4. 4XL 8 items
  5. 5XL 2 items
  6. FS 8 items
  7. L 83 items
  8. M 85 items
  9. S 84 items
  10. XL 50 items
  11. XS 20 items
  12. XXL 6 items
  13. XXXL 1 item
  14. 0XL 6 items
Less
Price
Price
  1. Rs. 0 - 200 1 item
  2. Rs. 600 - 800 4 items
  3. Rs. 800 - 1000 2 items
  4. Rs. 1000 - 1200 1 item
  5. Rs. 1200 - 1400 7 items
  6. Rs. 1400 - 1600 4 items
  7. Rs. 1600 - 1800 7 items
  8. Rs. 1800 - 2000 11 items
  9. Rs. 2000 - 2500 25 items
  10. Rs. 2500 - 3000 25 items
  11. Rs. 3000 - 3500 19 items
  12. Rs. 3500 - 4000 3 items
  13. Rs. 4000 - 4500 2 items
  1. Skater Skirts Remove This Item
  2. Wrap Dresses Remove This Item
  3. Denim Dresses Remove This Item
  4. Flare Jeans Remove This Item
  5. White Remove This Item
  6. Red Remove This Item
  7. Black 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`, `e`.`size_price`, `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=1539 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_67ad115365b6b7_16776981` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`special_price` DESC, `e`.`entity_id` DESC LIMIT 24

109 styles found
  1. 60% Off
    -60%
    Black Elasticated-waist Flared Jeans
  2. 60% Off
    -60%
    Black Plus Size Flare Jeans
  3. 60% Off
    -60%
    Grey Mid Wash Bootcut Jeans
  4. 60% Off
    -60%
    STYLE IN DENIM BLACK JEANS
  5. 60% Off
    -60%
    Black Pleated A-line Skirt
  6. 60% Off
    -60%
    Black Ultra High-rise Flared Jeans
  7. 60% Off
    -60%
    ESCAPE WITH ME BLACK JEANS
  8. 60% Off
    -60%
    Black Distressed Washed Jeans
  9. 60% Off
    -60%
    Black Washed Pattern Flare Fit Jeans
  10. 60% Off
    -60%
    Black Overlap-waist Flare Jeans
  11. 60% Off
    -60%
    Black Bow-knot Detail Flare Jeans
  12. 60% Off
    -60%
    Black Motif Print Tie-waist Dress
  13. 60% Off
    -60%
    Black Skater Skirt Comes W/ Belt
  14. 60% Off
    -60%
    SHIRRING-DETAIL BLACK FLARE JEANS
  15. 60% Off
    -60%
    Black Beaded Detail Low Flared Jeans
  16. 60% Off
    -60%
    BUTTON-DOWN BLACK FLARE JEANS
  17. 60% Off
    -60%
    BLACK RETRO FLARED JEANS
  18. 60% Off
    -60%
    Black Hooded Wrap Dress