app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Lingerie 1 item
  • Skirts 9 items
Styles
Styles
  1. Asymmetrical Dresses 38 items
  2. Beach Shorts 1 item
  3. Beach Tops 1 item
  4. Blouses 149 items
  5. Body Suits 131 items
  6. Bodycon 210 items
  7. Bracelets 21 items
  8. Caps 1 item
  9. Cover Ups 68 items
  10. Crop Tops 261 items
  11. Denim Tops 1 item
  12. Dungarees 1 item
  13. Earrings 73 items
  14. Flare Jeans 1 item
  15. Hats 1 item
  16. Jumpsuits 24 items
  17. Maxi Dresses 241 items
  18. Maxi Skirts 44 items
  19. Maxi Tops 3 items
  20. Midi Dresses 85 items
  21. Midi Skirts 26 items
  22. Necklace 19 items
  23. Nightdresses 88 items
  24. Nightwear Set 165 items
  25. Off Shoulder Tops 69 items
  26. Off-shoulder And Bandeau Dresses 146 items
  27. Pencil Dresses 15 items
  28. Pencil Skirts 2 items
  29. Playsuits And Rompers 40 items
  30. Rings 20 items
  31. Sets 335 items
  32. Shift Dresses 15 items
  33. Shirt Dresses 15 items
  34. Shirts 105 items
  35. Short And Mini Skirts 55 items
  36. Skater Dresses 150 items
  37. Skater Skirts 15 items
  38. Straight Jeans 7 items
  39. Swimsuit 62 items
  40. T-shirts 476 items
  41. Tunic Dresses 5 items
  42. Tunic Tops 3 items
  43. Vests And Camis 418 items
  44. Gloves 1 item
  45. Hipster 10 items
  46. Bikini 19 items
  47. Boyshort 4 items
  48. Thong 76 items
  49. Boyleg 1 item
  50. Halter Neck Bra 1 item
  51. Front Open 4 items
  52. Full Figure 2 items
  53. Sports 5 items
  54. Racerback 2 items
  55. T-Shirt Bra 6 items
  56. Bralette 11 items
  57. Padded 26 items
  58. Non Padded 10 items
  59. Sports Bra 1 item
  60. Collars 19 items
  61. Wrap Dresses 3 items
  62. Waist Chains 5 items
  63. Mom Jeans 2 items
  64. Baggy Jeans 3 items
  65. Vests 7 items
  66. Head Chains 0 items
  67. Wide Leg Jeans 2 items
  68. Shawl 2 items
  69. Corsets & Tube Tops 137 items
  70. Cold Shoulder Tops 11 items
  71. Sarong 5 items
  72. Corset Dresses 19 items
  73. Dressing Gowns & Robes 36 items
  74. Full Length Sets 1 item
  75. One shoulder Dresses 16 items
  76. One shoulder Tops 16 items
  77. Track Pants & Joggers 1 item
  78. Sweatshirts & Hoodies 1 item
  79. Swim Dress 1 item
Colour
Colour
  1. Beige 28 items
  2. Black 84 items
  3. Blue 51 items
  4. Brown 51 items
  5. Gold 48 items
  6. Green 21 items
  7. Grey 38 items
  8. Maroon 2 items
  9. Multi 21 items
  10. Orange 2 items
  11. Pink 24 items
  12. Purple 10 items
  13. Red 14 items
  14. Silver 6 items
  15. White 72 items
  16. Yellow 8 items
Less
Size
Size
  1. 100CD 1 item
  2. 2XL 1 item
  3. 40CD 1 item
  4. 70A 2 items
  5. 70B 3 items
  6. 70C 1 item
  7. 70D 1 item
  8. 70E 1 item
  9. 75A 2 items
  10. 75B 3 items
  11. 75C 3 items
  12. 75D 1 item
  13. 75E 1 item
  14. 80A 2 items
  15. 80B 3 items
  16. 80C 3 items
  17. 80D 1 item
  18. 80E 1 item
  19. 85B 3 items
  20. 85C 2 items
  21. 85CD 1 item
  22. 85D 1 item
  23. 85E 1 item
  24. 90C 1 item
  25. 90CD 1 item
  26. 90D 1 item
  27. 95C 1 item
  28. 95CD 1 item
  29. 95D 1 item
  30. FS 6 items
  31. L 33 items
  32. M 35 items
  33. S 34 items
  34. XL 11 items
  35. XS 5 items
  36. XXL 2 items
Less
Price
Price
  1. Rs. 0 - 200 1 item
  2. Rs. 200 - 400 10 items
  3. Rs. 400 - 600 7 items
  4. Rs. 600 - 800 6 items
  5. Rs. 800 - 1000 3 items
  6. Rs. 1000 - 1200 1 item
  7. Rs. 1200 - 1400 4 items
  8. Rs. 1400 - 1600 8 items
  9. Rs. 1600 - 1800 7 items
  10. Rs. 1800 - 2000 6 items
  11. Rs. 2000 - 2500 10 items
  12. Rs. 2500 - 3000 9 items
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Midi Skirts Remove This Item
  4. Head Chains Remove This Item
  5. Non Padded Remove This Item
  6. White 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_67b4bfacee4b25_13143152` 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

Page
72 styles found
  1. 60% Off
    -60%
    White Contrast Applique Tiered Skirt
  2. 60% Off
    -60%
    Off-white Crinkle-effect Midi Skirt
  3. 60% Off
    -60%
    White Motif Print A-line Midi Skirt
  4. 60% Off
    -60%
    Off-white Side-slit Midi Slip Skirt
  5. 60% Off
    -60%
    Mini White Knife Pleat Skater Skirt
  6. 60% Off
    -60%
    White Mini Balloon Skirt
  7. 60% Off
    -60%
    White Irregular Ruffle Y2k Skirt
  8. 60% Off
    -60%
    White Lace-up Detail Mini Skirt
  9. 60% Off
    -60%
    White 3d Floral Detail Slit Skirt
  10. 60% Off
    -60%
    Free Size Asymmetric Hem Skirt
  11. 60% Off
    -60%
    White Asymmetrical A-line Skirt
  12. 60% Off
    -60%
    White Mini Skater Skirt
  13. 60% Off
    -60%
    SATIN WHITE DRAPED MIDI SKIRT
  14. 70% Off
    -70%
    White Mid-length Denim Skirt
  15. 60% Off
    -60%
    Fs Mini A-line Ribbed Skirt
  16. 60% Off
    -60%
    High-waisted A-line Midi Skirt
  17. 60% Off
    -60%
    White Polka Dot Pattern A-line Skirt
  18. 60% Off
    -60%
    White Tie-drawstrings Circular Skirt
  19. 60% Off
    -60%
    White Pleated Mini Skater Skirt
  20. 60% Off
    -60%
    LACY WHITE ASYMMETRICAL MIDI SKIRT
  21. 60% Off
    -60%
    White Tiered Short Skater Skirt
Page