app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 171 items
  2. Beach Shorts 1 item
  3. Beach Tops 1 item
  4. Blouses 275 items
  5. Body Suits 407 items
  6. Bodycon 814 items
  7. Bracelets 0 items
  8. Caps 7 items
  9. Cover Ups 143 items
  10. Crop Tops 665 items
  11. Cropped Jeans 2 items
  12. Denim Dresses 1 item
  13. Denim Tops 2 items
  14. Dungarees 9 items
  15. Earrings 1 item
  16. Flare Jeans 27 items
  17. Hats 6 items
  18. Joggers 3 items
  19. Jumpsuits 183 items
  20. Maxi Dresses 789 items
  21. Maxi Skirts 114 items
  22. Maxi Tops 9 items
  23. Midi Dresses 266 items
  24. Midi Skirts 82 items
  25. Nightdresses 91 items
  26. Nightwear Set 249 items
  27. Off Shoulder Tops 119 items
  28. Off-shoulder And Bandeau Dresses 384 items
  29. Pencil Dresses 59 items
  30. Pencil Skirts 12 items
  31. Playsuits And Rompers 142 items
  32. Ripped Jeans 1 item
  33. Sets 1076 items
  34. Shift Dresses 42 items
  35. Shirt Dresses 27 items
  36. Shirts 105 items
  37. Short And Mini Skirts 165 items
  38. Skater Dresses 312 items
  39. Skater Skirts 38 items
  40. Skinny Jeans 4 items
  41. Straight Jeans 55 items
  42. Swimsuit 168 items
  43. T-shirts 1005 items
  44. Tunic Dresses 7 items
  45. Tunic Tops 5 items
  46. Vests And Camis 923 items
  47. Gloves 2 items
  48. Hipster 47 items
  49. Bikini 51 items
  50. Boyshort 14 items
  51. Thong 200 items
  52. Boyleg 3 items
  53. Halter Neck Bra 2 items
  54. Front Open 9 items
  55. Full Figure 9 items
  56. Sports 11 items
  57. Racerback 3 items
  58. T-Shirt Bra 11 items
  59. Bralette 37 items
  60. Backless 1 item
  61. Padded 62 items
  62. Non Padded 20 items
  63. Sports Bra 4 items
  64. Collars 37 items
  65. Wrap Dresses 27 items
  66. Mom Jeans 3 items
  67. Baggy Jeans 8 items
  68. Boyfriend Jeans 3 items
  69. Vests 17 items
  70. Wide Leg Jeans 22 items
  71. Shawl 9 items
  72. Corsets & Tube Tops 408 items
  73. Cold Shoulder Tops 18 items
  74. Sarong 13 items
  75. Corset Dresses 74 items
  76. Dressing Gowns & Robes 18 items
  77. One shoulder Dresses 13 items
  78. One shoulder Tops 24 items
Colour
Colour
  1. Beige 47 items
  2. Black 164 items
  3. Blue 77 items
  4. Brown 51 items
  5. Gold 3 items
  6. Green 61 items
  7. Grey 37 items
  8. Maroon 2 items
  9. Multi 31 items
  10. Orange 10 items
  11. Pink 62 items
  12. Purple 13 items
  13. Red 46 items
  14. Silver 8 items
  15. White 91 items
  16. Yellow 16 items
Less
Size
Size
  1. 1XL 3 items
  2. 2XL 13 items
  3. 3XL 3 items
  4. 4XL 2 items
  5. 5XL 1 item
  6. FS 40 items
  7. L 229 items
  8. M 225 items
  9. S 234 items
  10. XL 68 items
  11. XS 29 items
  12. XXL 11 items
  13. 0XL 1 item
Less
Price
Price
  1. Rs. 400 - 600 2 items
  2. Rs. 600 - 800 5 items
  3. Rs. 800 - 1000 14 items
  4. Rs. 1000 - 1200 16 items
  5. Rs. 1200 - 1400 25 items
  6. Rs. 1400 - 1600 35 items
  7. Rs. 1600 - 1800 31 items
  8. Rs. 1800 - 2000 39 items
  9. Rs. 2000 - 2500 69 items
  10. Rs. 2500 - 3000 33 items
  11. Rs. 3000 - 3500 20 items
  12. Rs. 3500 - 4000 6 items
  13. Rs. 4000 - 4500 1 item
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Midi Skirts Remove This Item
  4. Asymmetrical Dresses Remove This Item
  5. Sarong Remove This Item
  6. White Remove This Item
  7. Red Remove This Item
  8. Gold Remove This Item
  9. Black 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_6728b780beb3a8_19460433` 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

301 styles found
  1. 60% Off
    -60%
    EVERYTHING CLASSY RED SLIT DRESS
  2. 60% Off
    -60%
    Black Fishtail Silhouette Midi Skirt
  3. 63% Off
    -63%
    Black Long Ruffle-detail Dress
  4. 58% Off
    -58%
    Black Asymmetrical Sequin Slim Dress
  5. 59% Off
    -59%
    A-LINE ROSE RED CARGO MIDI SKIRT
  6. 63% Off
    -63%
    Red A-line One-shoulder Long Dress
  7. 60% Off
    -60%
    HIGH-WAIST RIBBED BLACK MIDI SKIRT
  8. 60% Off
    -60%
    Black Ribbed Slanted Hem Dress
  9. 60% Off
    -60%
    Free Size White Crochet Midi Skirt
  10. 63% Off
    -63%
    A-line Black High-waist Midi Skirt
  11. 60% Off
    -60%
    Black Clean Wash Denim Skirt
  12. 63% Off
    -63%
    White Tiered Mid-length A-line Skirt
  13. 63% Off
    -63%
    Black Floral Detail Midi Skirt
  14. 60% Off
    -60%
    Black Skater Skirt Comes W/ Belt
  15. 63% Off
    -63%
    Black Jacquard Pleated A-line Skirt
  16. 60% Off
    -60%
    White Bell Sleeve Asymmetrical Dress
  17. 60% Off
    -60%
    Faux Leather Golden Midi Skirt
  18. 60% Off
    -60%
    Faux Leather Black Midi Skirt