app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 49 items
  2. Blouses 42 items
  3. Body Suits 55 items
  4. Bodycon 243 items
  5. Caps 5 items
  6. Cover Ups 17 items
  7. Crop Tops 112 items
  8. Cropped Jeans 1 item
  9. Culottes 1 item
  10. Denim Dresses 12 items
  11. Denim Tops 8 items
  12. Dungarees 2 items
  13. Earrings 2 items
  14. Flare Jeans 36 items
  15. Hats 2 items
  16. Jumpsuits 59 items
  17. Maxi Dresses 232 items
  18. Maxi Skirts 27 items
  19. Midi Dresses 130 items
  20. Midi Skirts 32 items
  21. Necklace 4 items
  22. Nightdresses 32 items
  23. Nightwear Set 73 items
  24. Off Shoulder Tops 13 items
  25. Off-shoulder And Bandeau Dresses 106 items
  26. Pencil Dresses 29 items
  27. Pencil Skirts 2 items
  28. Pinafore 1 item
  29. Playsuits And Rompers 32 items
  30. Retro Sunglasses 1 item
  31. Rings 5 items
  32. Ripped Jeans 4 items
  33. Sets 465 items
  34. Shift Dresses 18 items
  35. Shirt Dresses 10 items
  36. Shirts 36 items
  37. Short And Mini Skirts 25 items
  38. Skater Dresses 61 items
  39. Skater Skirts 8 items
  40. Skinny Jeans 3 items
  41. Straight Jeans 119 items
  42. Swimsuit 77 items
  43. T-shirts 176 items
  44. Tunic Dresses 3 items
  45. Tunic Tops 3 items
  46. Vests And Camis 126 items
  47. Gloves 3 items
  48. Hipster 15 items
  49. Bikini 29 items
  50. Boyshort 8 items
  51. Thong 138 items
  52. Boyleg 2 items
  53. Sports 12 items
  54. T-Shirt Bra 1 item
  55. Bralette 4 items
  56. Padded 1 item
  57. Non Padded 1 item
  58. Sports Bra 5 items
  59. Collars 4 items
  60. Wrap Dresses 7 items
  61. Mom Jeans 3 items
  62. Baggy Jeans 13 items
  63. Wide Leg Jeans 55 items
  64. Shawl 4 items
  65. Corsets & Tube Tops 102 items
  66. Cold Shoulder Tops 2 items
  67. Sarong 5 items
  68. Corset Dresses 20 items
  69. Dressing Gowns & Robes 5 items
Colour
Colour
  1. Beige 45 items
  2. Black 401 items
  3. Blue 88 items
  4. Brown 84 items
  5. Gold 14 items
  6. Green 80 items
  7. Grey 35 items
  8. Maroon 3 items
  9. Multi 44 items
  10. Orange 21 items
  11. Pink 101 items
  12. Purple 32 items
  13. Red 109 items
  14. Silver 15 items
  15. White 137 items
  16. Yellow 19 items
Less
Size
Size
  1. 1XL 9 items
  2. 2XL 10 items
  3. 3XL 9 items
  4. 4XL 5 items
  5. FS 4 items
  6. L 252 items
  7. M 252 items
  8. S 254 items
  9. XL 59 items
  10. XS 31 items
  11. XXL 5 items
  12. XXXL 2 items
Less
Price
Price
  1. Rs. 800 - 1000 5 items
  2. Rs. 1000 - 1200 20 items
  3. Rs. 1200 - 1400 31 items
  4. Rs. 1400 - 1600 49 items
  5. Rs. 1600 - 1800 29 items
  6. Rs. 1800 - 2000 35 items
  7. Rs. 2000 - 2500 60 items
  8. Rs. 2500 - 3000 37 items
  9. Rs. 3000 - 3500 12 items
  10. Rs. 3500 - 4000 7 items
  11. Rs. 4000 - 4500 2 items
  1. Asymmetrical Dresses Remove This Item
  2. Bodycon Remove This Item
  3. Red Remove This Item
  4. Blue Remove This Item
  5. Green Remove This Item
  6. Silver 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`, `at_special_price`.`value` AS `special_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_662221b393adf3_85594620` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 0) WHERE (stock_status_index.stock_status = 1) ORDER BY `special_price` DESC, `e`.`entity_id` DESC LIMIT 24

292 styles found
  1. 60% Off
    -60%
    ASYMMETRICAL SEQUIN BLUE SLIT DRESS
  2. 60% Off
    -60%
    EVERYTHING CLASSY RED SLIT DRESS
  3. 60% Off
    -60%
    Red Cut-out Detail Bodycon Dress
  4. 60% Off
    -60%
    SILVER LACE-UP HOLLOW BODYCON DRESS
  5. 60% Off
    -60%
    Red Sheer Lace Detail Sheath Dress
  6. 60% Off
    -60%
    Dark Green Sheath Sequin Dress
  7. 60% Off
    -60%
    Deep Blue Sheath Sequin Dress
  8. 60% Off
    -60%
    Green Ruched Zip-back Dress
  9. 60% Off
    -60%
    Red Sequin Long Strap Dress
  10. 60% Off
    -60%
    Silver Sequin Short Sheath Dress
  11. 60% Off
    -60%
    Red A-line Midi Asymmetrical Dress
  12. 60% Off
    -60%
    Red Surplice Neck Bodycon Dress
  13. 60% Off
    -60%
    Dark Green Short Velvet Dress
  14. 60% Off
    -60%
    Short Sheath Velvet Dress
  15. 60% Off
    -60%
    SEQUIN EMBROIDERY RED BODYCON DRESS