app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Tops 1 item
  • Skirts 31 items
Styles
Styles
  1. Asymmetrical Dresses 34 items
  2. Blouses 68 items
  3. Body Suits 98 items
  4. Bodycon 176 items
  5. Bracelets 0 items
  6. Caps 8 items
  7. Cover Ups 28 items
  8. Crop Tops 150 items
  9. Dungarees 1 item
  10. Hats 5 items
  11. Jumpsuits 29 items
  12. Maxi Dresses 139 items
  13. Maxi Skirts 19 items
  14. Maxi Tops 1 item
  15. Midi Dresses 55 items
  16. Midi Skirts 29 items
  17. Nightdresses 56 items
  18. Nightwear Set 61 items
  19. Off Shoulder Tops 28 items
  20. Off-shoulder And Bandeau Dresses 72 items
  21. Pencil Dresses 19 items
  22. Pencil Skirts 1 item
  23. Playsuits And Rompers 34 items
  24. Retro Sunglasses 1 item
  25. Sets 291 items
  26. Shift Dresses 10 items
  27. Shirt Dresses 9 items
  28. Shirts 34 items
  29. Short And Mini Skirts 24 items
  30. Skater Dresses 54 items
  31. Skater Skirts 9 items
  32. Straight Jeans 7 items
  33. Swimsuit 49 items
  34. T-shirts 315 items
  35. Tunic Dresses 4 items
  36. Tunic Tops 2 items
  37. Vests And Camis 200 items
  38. Gloves 1 item
  39. Hipster 12 items
  40. Bikini 17 items
  41. Boyshort 10 items
  42. Thong 75 items
  43. Cycling Short 1 item
  44. Boyleg 1 item
  45. Sports 5 items
  46. Racerback 2 items
  47. T-Shirt Bra 1 item
  48. Bralette 7 items
  49. Padded 2 items
  50. Non Padded 1 item
  51. Sports Bra 2 items
  52. Collars 26 items
  53. Wrap Dresses 4 items
  54. Mom Jeans 1 item
  55. Baggy Jeans 3 items
  56. Vests 1 item
  57. Wide Leg Jeans 1 item
  58. Neck Warmer 1 item
  59. Shawl 2 items
  60. Corsets & Tube Tops 124 items
  61. Cold Shoulder Tops 2 items
  62. Sarong 3 items
  63. Corset Dresses 15 items
  64. Dressing Gowns & Robes 8 items
Colour
Colour
  1. Beige 17 items
  2. Black 48 items
  3. Blue 20 items
  4. Brown 17 items
  5. Gold 1 item
  6. Green 10 items
  7. Grey 17 items
  8. Maroon 1 item
  9. Multi 3 items
  10. Orange 2 items
  11. Pink 13 items
  12. Purple 6 items
  13. Red 5 items
  14. Silver 2 items
  15. White 22 items
  16. Yellow 2 items
Less
Size
Size
  1. 2XL 4 items
  2. 3XL 1 item
  3. 4XL 1 item
  4. FS 14 items
  5. L 25 items
  6. M 23 items
  7. S 25 items
  8. XL 9 items
  9. XS 1 item
  10. XXL 1 item
Less
Price
Price
  1. Rs. 600 - 800 2 items
  2. Rs. 1000 - 1200 2 items
  3. Rs. 1200 - 1400 4 items
  4. Rs. 1400 - 1600 10 items
  5. Rs. 1600 - 1800 3 items
  6. Rs. 1800 - 2000 8 items
  7. Rs. 2000 - 2500 5 items
  8. Rs. 2500 - 3000 5 items
  9. Rs. 3000 - 3500 1 item
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Midi Skirts Remove This Item
  4. Cold Shoulder Tops Remove This Item
  5. White Remove This Item
  6. Gold Remove This Item
  7. Beige 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_664b70150697e2_85703799` 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

Page
40 styles found
  1. 60% Off
    -60%
    Off-white Crinkle-effect Midi Skirt
  2. 60% Off
    -60%
    Off-white Side-slit Midi Slip Skirt
  3. 60% Off
    -60%
    White Irregular Ruffle Y2k Skirt
  4. 58% Off
    -58%
    SATIN WHITE DRAPED MIDI SKIRT
  5. 58% Off
    -58%
    LACE-UP WHITE JACQUARD MIDI SKIRT
  6. 60% Off
    -60%
    MIDI PARACHUTE WHITE SKATER SKIRT
  7. 58% Off
    -58%
    LACY WHITE ASYMMETRICAL MIDI SKIRT
  8. 60% Off
    -60%
    Low-rise White Mock Buttons Skirt
  9. 60% Off
    -60%
    Apricot Plisse-effect Midi Skirt
  10. 60% Off
    -60%
    PLAYGROUND APRICOT MIDI SKIRT
  11. 58% Off
    -58%
    WHITE TIERED MID-LENGTH SKIRT
  12. 58% Off
    -58%
    HOLLOW EMBROIDERY WHITE MIDI SKIRT
  13. 60% Off
    -60%
    White Fitted Cold-shoulder Lace Top
  14. 58% Off
    -58%
    SATIN GOLDEN MIDI DIAGONAL-HEM SKIRT
  15. 60% Off
    -60%
    A-LINE MIDI TIERED OFF-WHITE SKIRT
  16. 60% Off
    -60%
    White Lace A-line Midi Skirt
Page