app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 61 items
  2. Blouses 85 items
  3. Body Suits 121 items
  4. Bodycon 295 items
  5. Caps 6 items
  6. Cover Ups 25 items
  7. Crop Tops 206 items
  8. Cropped Jeans 1 item
  9. Denim Dresses 1 item
  10. Hats 2 items
  11. Jumpsuits 68 items
  12. Maxi Dresses 239 items
  13. Maxi Skirts 31 items
  14. Maxi Tops 1 item
  15. Midi Dresses 141 items
  16. Midi Skirts 39 items
  17. Nightdresses 50 items
  18. Nightwear Set 127 items
  19. Off Shoulder Tops 36 items
  20. Off-shoulder And Bandeau Dresses 130 items
  21. Pencil Dresses 49 items
  22. Pencil Skirts 1 item
  23. Playsuits And Rompers 42 items
  24. Ripped Jeans 1 item
  25. Sets 632 items
  26. Shift Dresses 26 items
  27. Shirt Dresses 18 items
  28. Shirts 61 items
  29. Short And Mini Skirts 21 items
  30. Skater Dresses 85 items
  31. Skater Skirts 14 items
  32. Straight Jeans 7 items
  33. Swimsuit 125 items
  34. T-shirts 378 items
  35. Tunic Dresses 10 items
  36. Tunic Tops 4 items
  37. Vests And Camis 200 items
  38. Gloves 2 items
  39. Hipster 18 items
  40. Bikini 50 items
  41. Boyshort 14 items
  42. Thong 264 items
  43. Boyleg 3 items
  44. Sports 13 items
  45. Racerback 1 item
  46. T-Shirt Bra 2 items
  47. Bralette 8 items
  48. Padded 2 items
  49. Non Padded 2 items
  50. Sports Bra 4 items
  51. Collars 26 items
  52. Wrap Dresses 5 items
  53. Mom Jeans 2 items
  54. Baggy Jeans 1 item
  55. Vests 1 item
  56. Wide Leg Jeans 6 items
  57. Neck Warmer 1 item
  58. Shawl 5 items
  59. Corsets & Tube Tops 151 items
  60. Cold Shoulder Tops 4 items
  61. Sarong 12 items
  62. Corset Dresses 24 items
  63. Dressing Gowns & Robes 5 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 1 item
  2. 2XL 10 items
  3. 3XL 5 items
  4. FS 1 item
  5. L 97 items
  6. M 92 items
  7. S 97 items
  8. XL 38 items
  9. XS 9 items
  10. XXL 3 items
  11. 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 17 items
  9. Rs. 2500 - 3000 14 items
  10. Rs. 3000 - 3500 4 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. White Remove This Item
  5. Red Remove This Item
  6. Green Remove This Item
  7. Multi 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`, `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_6605b97c511923_31751109` 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

110 styles found
  1. 60% Off
    -60%
    White Off-shoulder Ruffly Y2k Top
  2. 60% Off
    -60%
    Red One-shoulder Cut-out Long Dress
  3. 60% Off
    -60%
    White Asymmetrical Beach Dress
  4. 60% Off
    -60%
    White Tie-up Off-the-shoulder Top
  5. 60% Off
    -60%
    Dark Green Diagonal Hem Long Dress
  6. 60% Off
    -60%
    Asymmetrical Claret Long Dress
  7. 60% Off
    -60%
    Asymmetrical White Long Dress
  8. 60% Off
    -60%
    White Off-shoulder Slim Top
  9. 60% Off
    -60%
    Halter Strap Green Off-shoulder Top
  10. 60% Off
    -60%
    Off-shoulder White Slim Top
  11. 60% Off
    -60%
    Red Plunging Irregular Hem Dress
  12. 60% Off
    -60%
    Off-shoulder Long Lace Sleeved Top
  13. 60% Off
    -60%
    Multicolor Floral Asymmetrical Dress