app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Lingerie 10 items
  • Skirts 20 items
Styles
Styles
  1. Asymmetrical Dresses 85 items
  2. Blouses 89 items
  3. Body Suits 271 items
  4. Bodycon 521 items
  5. Crop Tops 302 items
  6. Denim Dresses 1 item
  7. Denim Tops 3 items
  8. Dungarees 1 item
  9. Flare Jeans 18 items
  10. Jumpsuits 135 items
  11. Maxi Dresses 321 items
  12. Maxi Skirts 30 items
  13. Maxi Tops 1 item
  14. Midi Dresses 138 items
  15. Midi Skirts 20 items
  16. Nightdresses 64 items
  17. Nightwear Set 103 items
  18. Off Shoulder Tops 52 items
  19. Off-shoulder And Bandeau Dresses 194 items
  20. Pencil Dresses 73 items
  21. Pencil Skirts 6 items
  22. Playsuits And Rompers 85 items
  23. Ripped Jeans 1 item
  24. Sets 674 items
  25. Shift Dresses 34 items
  26. Shirt Dresses 13 items
  27. Shirts 44 items
  28. Short And Mini Skirts 54 items
  29. Skater Dresses 114 items
  30. Skater Skirts 20 items
  31. Skinny Jeans 1 item
  32. Straight Jeans 29 items
  33. Swimsuit 125 items
  34. T-shirts 486 items
  35. Tunic Dresses 9 items
  36. Tunic Tops 2 items
  37. Vests And Camis 272 items
  38. Hipster 12 items
  39. Bikini 31 items
  40. Boyshort 2 items
  41. Thong 149 items
  42. Cycling Short 1 item
  43. Sports 13 items
  44. T-Shirt Bra 3 items
  45. Bralette 11 items
  46. Sports Bra 4 items
  47. Collars 6 items
  48. Wrap Dresses 6 items
  49. Mom Jeans 2 items
  50. Baggy Jeans 3 items
  51. Vests 1 item
  52. Wide Leg Jeans 14 items
  53. Corsets & Tube Tops 236 items
  54. Cold Shoulder Tops 10 items
  55. Corset Dresses 56 items
  56. Dressing Gowns & Robes 2 items
Colour
Colour
  1. Beige 3 items
  2. Black 18 items
  3. Blue 4 items
  4. Brown 7 items
  5. Gold 1 item
  6. Green 1 item
  7. Grey 6 items
  8. Maroon 1 item
  9. Multi 1 item
  10. Pink 5 items
  11. Red 3 items
  12. Silver 3 items
  13. White 10 items
  14. Yellow 1 item
Less
Size
Size
  1. 2XL 5 items
  2. 3XL 3 items
  3. 4XL 1 item
  4. 70ABC-S 2 items
  5. 75ABC-M 2 items
  6. 80ABC-L 2 items
  7. FS 9 items
  8. L 31 items
  9. M 28 items
  10. S 31 items
  11. XL 14 items
  12. XS 9 items
  13. XXL 1 item
Less
Price
Price
  1. Rs. 600 - 800 2 items
  2. Rs. 800 - 1000 6 items
  3. Rs. 1000 - 1200 4 items
  4. Rs. 1200 - 1400 4 items
  5. Rs. 1400 - 1600 5 items
  6. Rs. 1600 - 1800 2 items
  7. Rs. 1800 - 2000 1 item
  8. Rs. 2000 - 2500 3 items
  9. Rs. 2500 - 3000 3 items
  10. Rs. 3000 - 3500 1 item
  1. Skater Skirts Remove This Item
  2. Bralette Remove This Item
  3. White Remove This Item
  4. Red Remove This Item
  5. Black Remove This Item
  6. L 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` 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_660540fd1f9968_86772914` 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

Page
31 styles found
  1. 60% Off
    -60%
    Black Spaghetti Straps Bralette
  2. 60% Off
    -60%
    Side Zipper White Skater Skirt
  3. 60% Off
    -60%
    Side Zipper Black Skater Skirt
  4. 60% Off
    -60%
    Low-rise White Mock Buttons Skirt
  5. 60% Off
    -60%
    White Floral Lace Short Skater Skirt
  6. 60% Off
    -60%
    Low-rise White A-line Skater Skirt
  7. 60% Off
    -60%
    CONTRAST-EDGE PLEATED SKATER SKIRT
  8. 60% Off
    -60%
    BLACK HIGH-WAIST SKATER MINI SKIRT
  9. 60% Off
    -60%
    WHITE HIGH-WAIST SKATER MINI SKIRT
  10. 60% Off
    -60%
    CRIMSON LACY TRIANGULAR-CUP BRALETTE
  11. 60% Off
    -60%
    BLACK LACY TRIANGULAR-CUP BRALETTE
  12. 60% Off
    -60%
    RED HIGH-RISE SKATER SKIRT
  13. 60% Off
    -60%
    BLACK HIGH-RISE SKATER SKIRT
Page