app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 60 items
  2. Blouses 93 items
  3. Body Suits 136 items
  4. Bodycon 300 items
  5. Caps 14 items
  6. Cover Ups 21 items
  7. Crop Tops 220 items
  8. Hats 6 items
  9. Jumpsuits 73 items
  10. Maxi Dresses 237 items
  11. Maxi Skirts 34 items
  12. Maxi Tops 1 item
  13. Midi Dresses 136 items
  14. Midi Skirts 62 items
  15. Nightdresses 62 items
  16. Nightwear Set 112 items
  17. Off Shoulder Tops 36 items
  18. Off-shoulder And Bandeau Dresses 127 items
  19. Pencil Dresses 46 items
  20. Pencil Skirts 1 item
  21. Playsuits And Rompers 45 items
  22. Ripped Jeans 1 item
  23. Sets 621 items
  24. Shift Dresses 26 items
  25. Shirt Dresses 12 items
  26. Shirts 43 items
  27. Short And Mini Skirts 27 items
  28. Skater Dresses 83 items
  29. Skater Skirts 18 items
  30. Straight Jeans 9 items
  31. Swimsuit 90 items
  32. T-shirts 420 items
  33. Tunic Dresses 9 items
  34. Tunic Tops 3 items
  35. Vests And Camis 229 items
  36. Gloves 2 items
  37. Hipster 24 items
  38. Bikini 57 items
  39. Boyshort 20 items
  40. Thong 249 items
  41. Cycling Short 1 item
  42. Boyleg 3 items
  43. Sports 13 items
  44. Racerback 2 items
  45. T-Shirt Bra 2 items
  46. Bralette 9 items
  47. Padded 3 items
  48. Non Padded 2 items
  49. Sports Bra 5 items
  50. Collars 30 items
  51. Wrap Dresses 4 items
  52. Mom Jeans 2 items
  53. Baggy Jeans 1 item
  54. Vests 1 item
  55. Wide Leg Jeans 5 items
  56. Fake Hems 0 items
  57. Neck Warmer 1 item
  58. Shawl 5 items
  59. Corsets & Tube Tops 154 items
  60. Cold Shoulder Tops 5 items
  61. Sarong 7 items
  62. Corset Dresses 24 items
  63. Dressing Gowns & Robes 6 items
Colour
Colour
  1. Beige 11 items
  2. Black 80 items
  3. Blue 30 items
  4. Brown 21 items
  5. Gold 2 items
  6. Green 25 items
  7. Grey 11 items
  8. Multi 12 items
  9. Orange 9 items
  10. Pink 35 items
  11. Purple 14 items
  12. Red 26 items
  13. Silver 2 items
  14. White 47 items
  15. Yellow 8 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 11 items
  3. 3XL 6 items
  4. 4XL 1 item
  5. FS 2 items
  6. L 94 items
  7. M 92 items
  8. S 97 items
  9. XL 39 items
  10. XS 9 items
  11. XXL 3 items
  12. XXXL 1 item
Less
Price
Price
  1. Rs. 600 - 800 2 items
  2. Rs. 800 - 1000 2 items
  3. Rs. 1000 - 1200 7 items
  4. Rs. 1200 - 1400 11 items
  5. Rs. 1400 - 1600 12 items
  6. Rs. 1600 - 1800 21 items
  7. Rs. 1800 - 2000 17 items
  8. Rs. 2000 - 2500 16 items
  9. Rs. 2500 - 3000 15 items
  10. Rs. 3000 - 3500 3 items
  11. Rs. 3500 - 4000 1 item
  1. Asymmetrical Dresses Remove This Item
  2. Sports Remove This Item
  3. Off Shoulder Tops Remove This Item
  4. Fake Hems Remove This Item
  5. White Remove This Item
  6. Red Remove This Item
  7. Green Remove This Item
  8. Beige 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_660679d8798811_77120240` 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` ASC, `e`.`entity_id` DESC LIMIT 24

109 styles found
  1. 58% Off
    -58%
    HIGH STYLE WINE SPORTS BRA
  2. 58% Off
    -58%
    STRIKE THROUGH GREEN SPORTS BRA
  3. 59% Off
    -59%
    WHITE PLEATED OFF-SHOULDER TOP
  4. 60% Off
    -60%
    White Off-shoulder Slim Top
  5. 60% Off
    -60%
    SLANTED HALTER NECK RIB-KNIT DRESS
  6. 60% Off
    -60%
    Halter Strap Green Off-shoulder Top
  7. 60% Off
    -60%
    FLORAL DREAM GIRL RED DRESS
  8. 60% Off
    -60%
    FLORAL DREAM GIRL WHITE DRESS
  9. 60% Off
    -60%
    GREEN TRIMMED-EDGE OFF-SHOULDER TOP
  10. 60% Off
    -60%
    PRINTED PINK OFF-SHOULDER TOP
  11. 60% Off
    -60%
    IRREGULAR HEM BACKLESS WHITE DRESS