app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Skirts 12 items
  • Beachwear 5 items
Styles
Styles
  1. Asymmetrical Dresses 56 items
  2. Blouses 70 items
  3. Body Suits 98 items
  4. Bodycon 348 items
  5. Bracelets 47 items
  6. Caps 7 items
  7. Cover Ups 24 items
  8. Crop Tops 157 items
  9. Cropped Jeans 1 item
  10. Culottes 2 items
  11. Dungarees 3 items
  12. Earrings 142 items
  13. Flare Jeans 4 items
  14. Hats 7 items
  15. Jumpsuits 45 items
  16. Maxi Dresses 383 items
  17. Maxi Skirts 66 items
  18. Maxi Tops 1 item
  19. Midi Dresses 141 items
  20. Midi Skirts 49 items
  21. Necklace 35 items
  22. Nightdresses 69 items
  23. Nightwear Set 129 items
  24. Off Shoulder Tops 49 items
  25. Off-shoulder And Bandeau Dresses 165 items
  26. Pencil Dresses 21 items
  27. Pencil Skirts 3 items
  28. Playsuits And Rompers 25 items
  29. Rings 79 items
  30. Sets 447 items
  31. Shift Dresses 13 items
  32. Shirt Dresses 11 items
  33. Shirts 44 items
  34. Short And Mini Skirts 85 items
  35. Skater Dresses 135 items
  36. Skater Skirts 19 items
  37. Straight Jeans 8 items
  38. Swimsuit 43 items
  39. T-shirts 265 items
  40. Tunic Dresses 3 items
  41. Tunic Tops 3 items
  42. Vests And Camis 300 items
  43. Gloves 0 items
  44. Hipster 21 items
  45. Bikini 29 items
  46. Boyshort 5 items
  47. Thong 86 items
  48. Boyleg 1 item
  49. Front Open 1 item
  50. Full Figure 2 items
  51. Sports 2 items
  52. T-Shirt Bra 2 items
  53. Bralette 7 items
  54. Padded 7 items
  55. Non Padded 4 items
  56. Sports Bra 1 item
  57. Wrap Dresses 4 items
  58. Waist Chains 6 items
  59. Boyfriend Jeans 2 items
  60. Vests 4 items
  61. Wide Leg Jeans 9 items
  62. Shawl 6 items
  63. Corsets & Tube Tops 119 items
  64. Cold Shoulder Tops 6 items
  65. Sarong 3 items
  66. Corset Dresses 14 items
  67. Dressing Gowns & Robes 21 items
  68. Full Length Sets 1 item
  69. Short Length Sets 2 items
  70. One shoulder Dresses 24 items
  71. One shoulder Tops 31 items
  72. Track Pants & Joggers 3 items
  73. Jumpers & Sweaters 2 items
  74. Playsuits & Rompers 1 item
  75. Jeans & Pants 1 item
  76. Sweatshirts & Hoodies 2 items
  77. Trousers 1 item
Colour
Colour
  1. Beige 64 items
  2. Black 125 items
  3. Blue 70 items
  4. Brown 54 items
  5. Gold 50 items
  6. Green 38 items
  7. Grey 22 items
  8. Maroon 1 item
  9. Multi 37 items
  10. Orange 9 items
  11. Pink 36 items
  12. Purple 11 items
  13. Red 23 items
  14. Silver 7 items
  15. White 121 items
  16. Yellow 13 items
Less
Size
Size
  1. 1XL 6 items
  2. 2XL 8 items
  3. 3XL 7 items
  4. 4XL 5 items
  5. 5XL 1 item
  6. FS 19 items
  7. L 45 items
  8. M 48 items
  9. S 43 items
  10. XL 18 items
  11. XS 4 items
  12. 0XL 2 items
Less
Price
Price
  1. Rs. 0 - 200 1 item
  2. Rs. 200 - 400 16 items
  3. Rs. 400 - 600 15 items
  4. Rs. 600 - 800 17 items
  5. Rs. 800 - 1000 7 items
  6. Rs. 1000 - 1200 4 items
  7. Rs. 1200 - 1400 3 items
  8. Rs. 1400 - 1600 11 items
  9. Rs. 1600 - 1800 9 items
  10. Rs. 1800 - 2000 13 items
  11. Rs. 2000 - 2500 16 items
  12. Rs. 2500 - 3000 9 items
  13. Rs. 3000 - 3500 6 items
  1. Bracelets Remove This Item
  2. Midi Skirts Remove This Item
  3. Cover Ups Remove This Item
  4. Hats Remove This Item
  5. Gloves Remove This Item
  6. Red Remove This Item
  7. Gold Remove This Item
  8. Brown 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_67aef9f00c0579_81553233` 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

127 styles found
  1. 60% Off
    -60%
    Free Size A-line Midi Skirt
  2. 85% Off
    -85%
    GOLD-PLATED CORRUGATED BRACELET
  3. 85% Off
    -85%
    GOLD-TONE BANGLE BRACELET
  4. 85% Off
    -85%
    GOLD-TONE IRREGULAR CUFF BRACELET
  5. 85% Off
    -85%
    GOLD-TONE LEAF-SHAPED BRACELET
  6. 85% Off
    -85%
    GOLD-PLATED OVAL BANGLE BRACELET
  7. 85% Off
    -85%
    GOLD-TONED LEAF CUFF BRACELET
  8. 85% Off
    -85%
    GOLD-TONE CHUNKY BANGLE BRACELET
  9. 85% Off
    -85%
    CLIP-ON GOLD-PLATED CUFF BRACELET