app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 175 items
  2. Beach Shorts 3 items
  3. Beach Tops 1 item
  4. Blouses 278 items
  5. Body Suits 419 items
  6. Bodycon 827 items
  7. Caps 7 items
  8. Cover Ups 143 items
  9. Crop Tops 675 items
  10. Cropped Jeans 2 items
  11. Denim Dresses 1 item
  12. Denim Tops 2 items
  13. Dungarees 9 items
  14. Flare Jeans 27 items
  15. Hats 6 items
  16. Joggers 6 items
  17. Jumpsuits 189 items
  18. Maxi Dresses 796 items
  19. Maxi Skirts 116 items
  20. Maxi Tops 7 items
  21. Midi Dresses 284 items
  22. Midi Skirts 82 items
  23. Nightdresses 86 items
  24. Nightwear Set 257 items
  25. Off Shoulder Tops 119 items
  26. Off-shoulder And Bandeau Dresses 390 items
  27. Pencil Dresses 60 items
  28. Pencil Skirts 13 items
  29. Playsuits And Rompers 146 items
  30. Ripped Jeans 1 item
  31. Sets 1088 items
  32. Shift Dresses 43 items
  33. Shirt Dresses 32 items
  34. Shirts 125 items
  35. Short And Mini Skirts 167 items
  36. Skater Dresses 336 items
  37. Skater Skirts 38 items
  38. Skinny Jeans 3 items
  39. Straight Jeans 55 items
  40. Swimsuit 178 items
  41. T-shirts 1028 items
  42. Tunic Dresses 8 items
  43. Tunic Tops 5 items
  44. Vests And Camis 930 items
  45. Gloves 2 items
  46. Hipster 49 items
  47. Bikini 51 items
  48. Boyshort 16 items
  49. Thong 204 items
  50. Boyleg 3 items
  51. Halter Neck Bra 2 items
  52. Front Open 10 items
  53. Full Figure 9 items
  54. Sports 11 items
  55. Racerback 3 items
  56. T-Shirt Bra 11 items
  57. Bralette 40 items
  58. Backless 1 item
  59. Padded 65 items
  60. Non Padded 23 items
  61. Sports Bra 4 items
  62. Collars 41 items
  63. Wrap Dresses 28 items
  64. Mom Jeans 3 items
  65. Baggy Jeans 8 items
  66. Boyfriend Jeans 3 items
  67. Vests 19 items
  68. Wide Leg Jeans 21 items
  69. Shawl 9 items
  70. Corsets & Tube Tops 420 items
  71. Cold Shoulder Tops 18 items
  72. Sarong 16 items
  73. Corset Dresses 76 items
  74. Dressing Gowns & Robes 17 items
  75. One shoulder Dresses 21 items
  76. One shoulder Tops 25 items
Colour
Colour
  1. Beige 103 items
  2. Black 634 items
  3. Blue 280 items
  4. Brown 187 items
  5. Gold 12 items
  6. Green 159 items
  7. Grey 98 items
  8. Maroon 4 items
  9. Multi 117 items
  10. Orange 40 items
  11. Pink 183 items
  12. Purple 48 items
  13. Red 175 items
  14. Silver 23 items
  15. White 355 items
  16. Yellow 47 items
Less
Size
Size
  1. 1XL 18 items
  2. 2XL 61 items
  3. 3XL 32 items
  4. 4XL 10 items
  5. FS 45 items
  6. L 959 items
  7. M 960 items
  8. S 949 items
  9. XL 274 items
  10. XS 97 items
  11. XXL 29 items
  12. XXXL 1 item
  13. 0XL 5 items
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 400 - 600 11 items
  3. Rs. 600 - 800 28 items
  4. Rs. 800 - 1000 68 items
  5. Rs. 1000 - 1200 53 items
  6. Rs. 1200 - 1400 121 items
  7. Rs. 1400 - 1600 169 items
  8. Rs. 1600 - 1800 191 items
  9. Rs. 1800 - 2000 127 items
  10. Rs. 2000 - 2500 218 items
  11. Rs. 2500 - 3000 118 items
  12. Rs. 3000 - 3500 45 items
  13. Rs. 3500 - 4000 5 items
  14. Rs. 4000 - 4500 1 item
  1. Skater Skirts Remove This Item
  2. Bodycon Remove This Item
  3. Blouses Remove This Item
  4. Wide Leg Jeans Remove This Item
  5. White Remove This Item
  6. Red Remove This Item
  7. 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_672fcf25046847_07276857` 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

1164 styles found
  1. 63% Off
    -63%
    Black Grey Wide Leg Jeans W/o Belt
  2. 60% Off
    -60%
    Wide Jeans W/ Contrast Stitching
  3. 60% Off
    -60%
    Straight  Wide Leg White Jeans
  4. 63% Off
    -63%
    Red Cut-out Detail Bodycon Dress
  5. 60% Off
    -60%
    Black Washed Effect Wide Leg Jeans
  6. 63% Off
    -63%
    High-rise Wide Jeans
  7. 60% Off
    -60%
    Black Wide Fit Jeans W/ Belt
  8. 60% Off
    -60%
    Black Clean Wide Fit Jeans
  9. 60% Off
    -60%
    Black Mid Wash Style Wide Jeans
  10. 63% Off
    -63%
    Red Sheer Lace Detail Sheath Dress
  11. 63% Off
    -63%
    KEEP YOUR COOL WHITE TOP
  12. 63% Off
    -63%
    Black Seamless Body-hugging Dress
  13. 60% Off
    -60%
    Black Mini Tiered Tulle Dress
  14. 60% Off
    -60%
    Red Embellished Strap Bodycon Dress
  15. 60% Off
    -60%
    White Ruffle Trim Collared Blouse