app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 196 items
  2. Beach Shorts 3 items
  3. Beach Tops 1 item
  4. Blouses 337 items
  5. Body Suits 511 items
  6. Bodycon 1141 items
  7. Bracelets 21 items
  8. Caps 9 items
  9. Cover Ups 171 items
  10. Crop Tops 749 items
  11. Cropped Jeans 7 items
  12. Culottes 3 items
  13. Denim Dresses 31 items
  14. Denim Tops 39 items
  15. Dungarees 16 items
  16. Earrings 75 items
  17. Flare Jeans 120 items
  18. Hats 7 items
  19. Jumpsuits 250 items
  20. Maxi Dresses 1274 items
  21. Maxi Skirts 171 items
  22. Maxi Tops 8 items
  23. Midi Dresses 464 items
  24. Midi Skirts 138 items
  25. Necklace 19 items
  26. Nightdresses 278 items
  27. Nightwear Set 545 items
  28. Off Shoulder Tops 180 items
  29. Off-shoulder And Bandeau Dresses 664 items
  30. Pencil Dresses 78 items
  31. Pencil Skirts 20 items
  32. Pinafore 3 items
  33. Playsuits And Rompers 194 items
  34. Rings 24 items
  35. Ripped Jeans 3 items
  36. Sets 1508 items
  37. Shift Dresses 75 items
  38. Shirt Dresses 59 items
  39. Shirts 265 items
  40. Short And Mini Skirts 267 items
  41. Skater Dresses 576 items
  42. Skater Skirts 62 items
  43. Skinny Jeans 11 items
  44. Straight Jeans 292 items
  45. Swimsuit 271 items
  46. T-shirts 1241 items
  47. Tunic Dresses 14 items
  48. Tunic Tops 7 items
  49. Vests And Camis 1192 items
  50. Gloves 2 items
  51. Hipster 55 items
  52. Bikini 87 items
  53. Boyshort 16 items
  54. Thong 302 items
  55. Boyleg 4 items
  56. Halter Neck Bra 2 items
  57. Front Open 10 items
  58. Full Figure 9 items
  59. Sports 15 items
  60. Racerback 3 items
  61. T-Shirt Bra 13 items
  62. Bralette 38 items
  63. Backless 1 item
  64. Padded 73 items
  65. Non Padded 28 items
  66. Sports Bra 6 items
  67. Collars 37 items
  68. Wrap Dresses 35 items
  69. Waist Chains 5 items
  70. Mom Jeans 15 items
  71. Baggy Jeans 34 items
  72. Boyfriend Jeans 25 items
  73. Vests 10 items
  74. Wide Leg Jeans 160 items
  75. Shawl 11 items
  76. Corsets & Tube Tops 487 items
  77. Cold Shoulder Tops 43 items
  78. Sarong 16 items
  79. Corset Dresses 83 items
  80. Dressing Gowns & Robes 102 items
  81. Full Length Sets 1 item
  82. Short Length Sets 6 items
  83. One shoulder Dresses 92 items
  84. One shoulder Tops 86 items
  85. Track Pants & Joggers 4 items
  86. Sleepwear Dresses 1 item
  87. Jumpers & Sweaters 5 items
  88. Jeans & Pants 5 items
  89. Sweatshirts & Hoodies 2 items
  90. Leggings & Jeggings 1 item
  91. Swim Dress 12 items
Colour
Colour
  1. Beige 4 items
  2. Black 85 items
  3. Blue 108 items
  4. Brown 23 items
  5. Gold 141 items
  6. Green 13 items
  7. Grey 38 items
  8. Maroon 1 item
  9. Multi 27 items
  10. Orange 2 items
  11. Pink 11 items
  12. Purple 3 items
  13. Red 5 items
  14. Silver 22 items
  15. White 94 items
  16. Yellow 4 items
Less
Size
Size
  1. 1XL 10 items
  2. 2XL 73 items
  3. 3XL 22 items
  4. 4XL 11 items
  5. 5XL 3 items
  6. FS 10 items
  7. L 177 items
  8. M 182 items
  9. S 182 items
  10. XL 122 items
  11. XS 58 items
  12. XXL 7 items
  13. XXXL 1 item
  14. 0XL 6 items
Less
Price
Price
  1. Rs. 0 - 200 1 item
  2. Rs. 200 - 400 60 items
  3. Rs. 400 - 600 14 items
  4. Rs. 600 - 800 6 items
  5. Rs. 800 - 1000 5 items
  6. Rs. 1000 - 1200 2 items
  7. Rs. 1200 - 1400 11 items
  8. Rs. 1400 - 1600 5 items
  9. Rs. 1600 - 1800 9 items
  10. Rs. 1800 - 2000 19 items
  11. Rs. 2000 - 2500 39 items
  12. Rs. 2500 - 3000 49 items
  13. Rs. 3000 - 3500 53 items
  14. Rs. 3500 - 4000 20 items
  15. Rs. 4000 - 4500 2 items
  1. Skater Skirts Remove This Item
  2. Wrap Dresses Remove This Item
  3. Earrings Remove This Item
  4. Flare Jeans Remove This Item
  5. White Remove This Item
  6. Red Remove This Item
  7. Black Remove This Item
  8. Blue 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_67aefd8ad44bb0_11851995` 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

292 styles found
  1. 60% Off
    -60%
    Black Washed Effect Flared Low Jeans
  2. 60% Off
    -60%
    Blue Self-design Flared Jeans
  3. 60% Off
    -60%
    Washed Effect Blue Flare Fit Jeans
  4. 60% Off
    -60%
    Blue Washed Effect Flare Fit Jeans
  5. 60% Off
    -60%
    White Asymmetrical A-line Skirt
  6. 60% Off
    -60%
    Black Pleated A-line Skort
  7. 60% Off
    -60%
    Contrast Stripe Mini Pleated Skirt
  8. 60% Off
    -60%
    Black Beaded Detail Low Flared Jeans
  9. 85% Off
    -85%
    SILVER-TONE SWIRL-SHAPED EARRINGS
  10. 85% Off
    -85%
    SILVER-TONE LEAF EARRINGS
  11. 85% Off
    -85%
    SILVER-TONE DROP LEAF EARRINGS