app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 41 items
  2. Beach Shorts 1 item
  3. Beach Tops 1 item
  4. Blouses 149 items
  5. Body Suits 124 items
  6. Bodycon 201 items
  7. Caps 1 item
  8. Cover Ups 68 items
  9. Crop Tops 271 items
  10. Cropped Jeans 1 item
  11. Dungarees 2 items
  12. Earrings 1 item
  13. Flare Jeans 1 item
  14. Hats 1 item
  15. Jumpsuits 30 items
  16. Maxi Dresses 242 items
  17. Maxi Skirts 39 items
  18. Maxi Tops 3 items
  19. Midi Dresses 92 items
  20. Midi Skirts 29 items
  21. Nightdresses 41 items
  22. Nightwear Set 118 items
  23. Off Shoulder Tops 63 items
  24. Off-shoulder And Bandeau Dresses 132 items
  25. Pencil Dresses 15 items
  26. Pencil Skirts 2 items
  27. Playsuits And Rompers 38 items
  28. Sets 353 items
  29. Shift Dresses 18 items
  30. Shirt Dresses 14 items
  31. Shirts 94 items
  32. Short And Mini Skirts 48 items
  33. Skater Dresses 137 items
  34. Skater Skirts 15 items
  35. Straight Jeans 12 items
  36. Swimsuit 52 items
  37. T-shirts 468 items
  38. Tunic Dresses 5 items
  39. Tunic Tops 3 items
  40. Vests And Camis 411 items
  41. Gloves 1 item
  42. Hipster 11 items
  43. Bikini 20 items
  44. Boyshort 5 items
  45. Thong 80 items
  46. Boyleg 1 item
  47. Halter Neck Bra 1 item
  48. Front Open 4 items
  49. Full Figure 2 items
  50. Sports 5 items
  51. Racerback 2 items
  52. T-Shirt Bra 6 items
  53. Bralette 14 items
  54. Padded 27 items
  55. Non Padded 10 items
  56. Sports Bra 1 item
  57. Collars 22 items
  58. Wrap Dresses 4 items
  59. Mom Jeans 2 items
  60. Baggy Jeans 5 items
  61. Vests 13 items
  62. Wide Leg Jeans 4 items
  63. Shawl 2 items
  64. Corsets & Tube Tops 130 items
  65. Cold Shoulder Tops 9 items
  66. Sarong 6 items
  67. Corset Dresses 16 items
  68. Dressing Gowns & Robes 9 items
  69. Full Length Sets 1 item
  70. One shoulder Dresses 8 items
  71. One shoulder Tops 6 items
  72. Track Pants & Joggers 1 item
  73. Sweatshirts & Hoodies 1 item
Colour
Colour
  1. Beige 74 items
  2. Black 546 items
  3. Blue 153 items
  4. Brown 146 items
  5. Gold 10 items
  6. Green 116 items
  7. Grey 70 items
  8. Maroon 3 items
  9. Multi 88 items
  10. Orange 32 items
  11. Pink 128 items
  12. Purple 41 items
  13. Red 136 items
  14. Silver 19 items
  15. White 228 items
  16. Yellow 31 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 2 items
  3. 3XL 2 items
  4. 4XL 1 item
  5. FS 20 items
  6. L 191 items
  7. M 183 items
  8. S 172 items
  9. XL 36 items
  10. XS 27 items
  11. XXL 4 items
  12. 0XL 2 items
Less
Price
Price
  1. Rs. 200 - 400 16 items
  2. Rs. 400 - 600 6 items
  3. Rs. 600 - 800 6 items
  4. Rs. 800 - 1000 5 items
  5. Rs. 1000 - 1200 9 items
  6. Rs. 1200 - 1400 17 items
  7. Rs. 1400 - 1600 24 items
  8. Rs. 1600 - 1800 32 items
  9. Rs. 1800 - 2000 23 items
  10. Rs. 2000 - 2500 52 items
  11. Rs. 2500 - 3000 25 items
  12. Rs. 3000 - 3500 11 items
  13. Rs. 3500 - 4000 1 item
  1. Bodycon Remove This Item
  2. Baggy Jeans Remove This Item
  3. Collars Remove This Item
  4. White 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_67562e89b04e54_45171753` 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

227 styles found
  1. 60% Off
    -60%
    White Lacy Backless Bodycon Dress
  2. 60% Off
    -60%
    Printed Halter Neck Short Dress
  3. 60% Off
    -60%
    White Meshed Bodycon Dress
  4. 60% Off
    -60%
    White Faux Fur Trim Bodycon Dress
  5. 60% Off
    -60%
    White Sheer Lace Bodycon Dress
  6. 60% Off
    -60%
    White Backless Halter Bodycon Dress
  7. 60% Off
    -60%
    White Ribbed Maxi Bodycon
  8. 60% Off
    -60%
    White Floral Backless Maxi Dress
  9. 60% Off
    -60%
    Hollow-knit Beach Dress
  10. 60% Off
    -60%
    Mini White Backless Lace-up Dress
  11. 60% Off
    -60%
    Flounce Hemline White Sheath Dress
  12. 60% Off
    -60%
    White 3d Print Dress
  13. 60% Off
    -60%
    White Tattered Halter Backless Dress
  14. 60% Off
    -60%
    Colour Block Lettuce Trim Maxi Dress
  15. 60% Off
    -60%
    White Ruffle Trim Detail Bodycon
  16. 60% Off
    -60%
    White Ruched Maxi Bodycon Dress
  17. 60% Off
    -60%
    Cut Out Detail White Bodycon Dress
  18. 60% Off
    -60%
    White Halter Bodycon Maxi Dress
  19. 60% Off
    -60%
    Metallic White Backless Tie-up Dress
  20. 60% Off
    -60%
    White Halter Lace Bodycon Dress