app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 77 items
  2. Beach Shorts 1 item
  3. Beach Tops 1 item
  4. Blouses 93 items
  5. Body Suits 150 items
  6. Bodycon 357 items
  7. Bracelets 0 items
  8. Caps 5 items
  9. Cover Ups 95 items
  10. Crop Tops 233 items
  11. Cropped Jeans 4 items
  12. Culottes 1 item
  13. Denim Dresses 20 items
  14. Denim Tops 7 items
  15. Dungarees 4 items
  16. Flare Jeans 36 items
  17. Hats 4 items
  18. Jumpsuits 86 items
  19. Maxi Dresses 364 items
  20. Maxi Skirts 31 items
  21. Maxi Tops 2 items
  22. Midi Dresses 156 items
  23. Midi Skirts 53 items
  24. Nightdresses 76 items
  25. Nightwear Set 158 items
  26. Off Shoulder Tops 47 items
  27. Off-shoulder And Bandeau Dresses 163 items
  28. Pencil Dresses 38 items
  29. Pencil Skirts 3 items
  30. Pinafore 2 items
  31. Playsuits And Rompers 62 items
  32. Ripped Jeans 2 items
  33. Sets 681 items
  34. Shift Dresses 21 items
  35. Shirt Dresses 15 items
  36. Shirts 67 items
  37. Short And Mini Skirts 57 items
  38. Skater Dresses 126 items
  39. Skater Skirts 18 items
  40. Skinny Jeans 3 items
  41. Straight Jeans 142 items
  42. Swimsuit 113 items
  43. T-shirts 417 items
  44. Tunic Dresses 5 items
  45. Tunic Tops 5 items
  46. Vests And Camis 345 items
  47. Gloves 3 items
  48. Hipster 21 items
  49. Bikini 43 items
  50. Boyshort 16 items
  51. Thong 151 items
  52. Boyleg 4 items
  53. Sports 17 items
  54. Racerback 1 item
  55. T-Shirt Bra 2 items
  56. Bralette 9 items
  57. Padded 2 items
  58. Non Padded 1 item
  59. Sports Bra 4 items
  60. Collars 24 items
  61. Wrap Dresses 9 items
  62. Mom Jeans 3 items
  63. Baggy Jeans 14 items
  64. Vests 1 item
  65. Wide Leg Jeans 52 items
  66. Neck Warmer 1 item
  67. Shawl 5 items
  68. Corsets & Tube Tops 203 items
  69. Cold Shoulder Tops 4 items
  70. Sarong 8 items
  71. Corset Dresses 27 items
  72. Dressing Gowns & Robes 10 items
Colour
Colour
  1. Beige 72 items
  2. Black 335 items
  3. Blue 134 items
  4. Brown 101 items
  5. Gold 2 items
  6. Green 61 items
  7. Grey 72 items
  8. Maroon 4 items
  9. Multi 43 items
  10. Orange 10 items
  11. Pink 100 items
  12. Purple 18 items
  13. Red 45 items
  14. Silver 13 items
  15. White 223 items
  16. Yellow 21 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 18 items
  3. 3XL 4 items
  4. 4XL 2 items
  5. 5XL 1 item
  6. FS 23 items
  7. L 370 items
  8. M 376 items
  9. S 379 items
  10. XL 101 items
  11. XS 42 items
  12. XXL 6 items
  13. 0XL 1 item
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 400 - 600 6 items
  3. Rs. 600 - 800 20 items
  4. Rs. 800 - 1000 80 items
  5. Rs. 1000 - 1200 91 items
  6. Rs. 1200 - 1400 77 items
  7. Rs. 1400 - 1600 34 items
  8. Rs. 1600 - 1800 29 items
  9. Rs. 1800 - 2000 23 items
  10. Rs. 2000 - 2500 25 items
  11. Rs. 2500 - 3000 5 items
  12. Rs. 3000 - 3500 14 items
  13. Rs. 3500 - 4000 11 items
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Vests And Camis Remove This Item
  4. Shift Dresses Remove This Item
  5. Flare Jeans Remove This Item
  6. White Remove This Item
  7. Red Remove This Item
  8. Blue Remove This Item
  9. Purple 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`, `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=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_6692455c7ff1b7_91028187` 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

420 styles found
  1. 60% Off
    -60%
    Blue Washed-effect Flare Jeans
  2. 60% Off
    -60%
    Y2k Blue Mid-rise Lined Jeans
  3. 60% Off
    -60%
    VINTAGE BLUE FLARED RETRO JEANS
  4. 58% Off
    -58%
    ESCAPE WITH ME LIGHT BLUE JEANS
  5. 60% Off
    -60%
    STYLE IN DENIM DARK BLUE JEANS
  6. 60% Off
    -60%
    STYLE IN DENIM BLUE JEANS
  7. 60% Off
    -60%
    BLACK  MID-WAIST RETRO FLARE JEANS
  8. 60% Off
    -60%
    Blue Ripped Detail Bootcut Jeans
  9. 58% Off
    -58%
    SHIRRING-DETAIL BLUE FLARE JEANS
  10. 60% Off
    -60%
    Light Blue Bootcut Retro Jeans
  11. 60% Off
    -60%
    MID-WAIST WASHED BLUE FLARED JEANS
  12. 58% Off
    -58%
    BUTTON-DOWN DARK-BLUE FLARE JEANS
  13. 58% Off
    -58%
    BUTTON-DOWN LIGHT-BLUE FLARE JEANS
  14. 58% Off
    -58%
    DARK-BLUE RETRO FLARED JEANS
  15. 58% Off
    -58%
    LIGHT-BLUE RETRO FLARED JEANS
  16. 60% Off
    -60%
    Blue Frayed-edge Bootcut Jeans