app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Lingerie 17 items
  • Skirts 33 items
Styles
Styles
  1. Asymmetrical Dresses 103 items
  2. Blouses 137 items
  3. Body Suits 291 items
  4. Bodycon 608 items
  5. Caps 16 items
  6. Cover Ups 25 items
  7. Crop Tops 378 items
  8. Denim Dresses 1 item
  9. Denim Tops 3 items
  10. Dungarees 1 item
  11. Flare Jeans 18 items
  12. Hats 7 items
  13. Jumpsuits 152 items
  14. Maxi Dresses 391 items
  15. Maxi Skirts 47 items
  16. Maxi Tops 1 item
  17. Midi Dresses 186 items
  18. Midi Skirts 76 items
  19. Nightdresses 85 items
  20. Nightwear Set 183 items
  21. Off Shoulder Tops 64 items
  22. Off-shoulder And Bandeau Dresses 233 items
  23. Pencil Dresses 87 items
  24. Pencil Skirts 10 items
  25. Playsuits And Rompers 101 items
  26. Ripped Jeans 1 item
  27. Sets 925 items
  28. Shift Dresses 38 items
  29. Shirt Dresses 18 items
  30. Shirts 54 items
  31. Short And Mini Skirts 65 items
  32. Skater Dresses 143 items
  33. Skater Skirts 33 items
  34. Skinny Jeans 1 item
  35. Straight Jeans 34 items
  36. Swimsuit 146 items
  37. T-shirts 718 items
  38. Tunic Dresses 9 items
  39. Tunic Tops 4 items
  40. Vests And Camis 365 items
  41. Wayfarers And Square Frame Sunglasses 4 items
  42. Gloves 3 items
  43. Hipster 35 items
  44. Bikini 77 items
  45. Boyshort 28 items
  46. Thong 363 items
  47. Cycling Short 1 item
  48. Boyleg 6 items
  49. Sports 21 items
  50. Racerback 2 items
  51. T-Shirt Bra 4 items
  52. Bralette 19 items
  53. Padded 3 items
  54. Non Padded 3 items
  55. Sports Bra 7 items
  56. Collars 46 items
  57. Wrap Dresses 11 items
  58. Mom Jeans 2 items
  59. Baggy Jeans 3 items
  60. Vests 1 item
  61. Wide Leg Jeans 17 items
  62. Neck Warmer 1 item
  63. Shawl 7 items
  64. Thongbody 1 item
  65. Corsets & Tube Tops 298 items
  66. Cold Shoulder Tops 13 items
  67. Sarong 9 items
  68. Corset Dresses 62 items
  69. Dressing Gowns & Robes 10 items
Colour
Colour
  1. Beige 7 items
  2. Black 26 items
  3. Blue 7 items
  4. Brown 12 items
  5. Gold 1 item
  6. Green 3 items
  7. Grey 12 items
  8. Maroon 1 item
  9. Multi 2 items
  10. Pink 9 items
  11. Red 3 items
  12. Silver 3 items
  13. White 14 items
  14. Yellow 1 item
Less
Size
Size
  1. 2XL 7 items
  2. 3XL 4 items
  3. 4XL 1 item
  4. 70ABC-S 2 items
  5. 75ABC-M 2 items
  6. 80ABC-L 2 items
  7. FS 13 items
  8. L 37 items
  9. M 32 items
  10. S 37 items
  11. XL 17 items
  12. XS 10 items
  13. XXL 1 item
Less
Price
Price
  1. Rs. 200 - 400 5 items
  2. Rs. 600 - 800 3 items
  3. Rs. 800 - 1000 6 items
  4. Rs. 1000 - 1200 6 items
  5. Rs. 1200 - 1400 10 items
  6. Rs. 1400 - 1600 9 items
  7. Rs. 1600 - 1800 3 items
  8. Rs. 1800 - 2000 1 item
  9. Rs. 2000 - 2500 4 items
  10. Rs. 2500 - 3000 6 items
  11. 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. Pink 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`, `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_6605ba56b31329_96788872` 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
51 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%
    PINK LACY TRIANGULAR-CUP BRALETTE
Page