app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 170 items
  2. Blouses 232 items
  3. Body Suits 418 items
  4. Bodycon 1032 items
  5. Bracelets 1 item
  6. Caps 49 items
  7. Cover Ups 65 items
  8. Crop Tops 631 items
  9. Cropped Jeans 3 items
  10. Culottes 1 item
  11. Denim Dresses 18 items
  12. Denim Tops 10 items
  13. Dungarees 2 items
  14. Earrings 6 items
  15. Flare Jeans 64 items
  16. Hats 21 items
  17. Jumpsuits 264 items
  18. Maxi Dresses 735 items
  19. Maxi Skirts 120 items
  20. Maxi Tops 1 item
  21. Midi Dresses 377 items
  22. Midi Skirts 204 items
  23. Necklace 2 items
  24. Nightdresses 171 items
  25. Nightwear Set 341 items
  26. Off Shoulder Tops 107 items
  27. Off-shoulder And Bandeau Dresses 387 items
  28. Pencil Dresses 147 items
  29. Pencil Skirts 16 items
  30. Pinafore 1 item
  31. Playsuits And Rompers 159 items
  32. Retro Sunglasses 2 items
  33. Rings 1 item
  34. Ripped Jeans 5 items
  35. Sets 1893 items
  36. Shift Dresses 70 items
  37. Shirt Dresses 41 items
  38. Shirts 131 items
  39. Short And Mini Skirts 122 items
  40. Skater Dresses 230 items
  41. Skater Skirts 77 items
  42. Skinny Jeans 4 items
  43. Straight Jeans 185 items
  44. Swimsuit 301 items
  45. T-shirts 1246 items
  46. Tunic Dresses 23 items
  47. Tunic Tops 9 items
  48. Vests And Camis 635 items
  49. Wayfarers And Square Frame Sunglasses 4 items
  50. Gloves 6 items
  51. Hipster 53 items
  52. Bikini 136 items
  53. Boyshort 42 items
  54. Thong 699 items
  55. Cycling Short 3 items
  56. Boyleg 9 items
  57. Sports 56 items
  58. Racerback 3 items
  59. T-Shirt Bra 4 items
  60. Bralette 24 items
  61. Padded 4 items
  62. Non Padded 4 items
  63. Sports Bra 20 items
  64. Nose Pins 1 item
  65. Collars 56 items
  66. Wrap Dresses 21 items
  67. Mom Jeans 4 items
  68. Baggy Jeans 14 items
  69. Vests 1 item
  70. Wide Leg Jeans 76 items
  71. Boot Cuffs 2 items
  72. Neck Warmer 1 item
  73. Shawl 14 items
  74. Thongbody 1 item
  75. Corsets & Tube Tops 481 items
  76. Cold Shoulder Tops 21 items
  77. Sarong 26 items
  78. Corset Dresses 89 items
  79. Dressing Gowns & Robes 16 items
Colour
Colour
  1. Beige 40 items
  2. Black 345 items
  3. Blue 75 items
  4. Brown 71 items
  5. Gold 13 items
  6. Green 74 items
  7. Grey 35 items
  8. Maroon 3 items
  9. Multi 35 items
  10. Orange 22 items
  11. Pink 77 items
  12. Purple 25 items
  13. Red 88 items
  14. Silver 21 items
  15. White 98 items
  16. Yellow 12 items
Less
Size
Size
  1. 1XL 21 items
  2. 2XL 27 items
  3. 3XL 24 items
  4. 4XL 12 items
  5. FS 13 items
  6. L 912 items
  7. M 915 items
  8. S 928 items
  9. XL 220 items
  10. XS 81 items
  11. XXL 9 items
  12. XXXL 3 items
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 400 - 600 2 items
  3. Rs. 600 - 800 1 item
  4. Rs. 800 - 1000 27 items
  5. Rs. 1000 - 1200 70 items
  6. Rs. 1200 - 1400 105 items
  7. Rs. 1400 - 1600 172 items
  8. Rs. 1600 - 1800 139 items
  9. Rs. 1800 - 2000 139 items
  10. Rs. 2000 - 2500 221 items
  11. Rs. 2500 - 3000 108 items
  12. Rs. 3000 - 3500 31 items
  13. Rs. 3500 - 4000 17 items
  14. Rs. 4000 - 4500 5 items
  15. Rs. 4500 - 5000 2 items
  16. Rs. 5000 - 5500 1 item
  17. Rs. 5500 - 6000 1 item
  1. Bodycon Remove This Item
  2. Necklace 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_6605da186c0fa5_87722999` 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

1027 styles found
  1. 60% Off
    -60%
    Yellow Floral Pattern Sheath Dress
  2. 60% Off
    -60%
    Textured Short Green Bodycon Dress
  3. 60% Off
    -60%
    Cold-shoulder Short Sleeved Dress
  4. 60% Off
    -60%
    Black Mock Neck Slim Midi Dress
  5. 60% Off
    -60%
    Dark Brown Mock Neck Slim Dress
  6. 60% Off
    -60%
    Brown Polka Dot Patterned Dress
  7. 60% Off
    -60%
    Black Mesh Splicing Side Slit Dress
  8. 60% Off
    -60%
    Black Full-sleeved Midi Sheath Dress
  9. 60% Off
    -60%
    Red Full-sleeved Midi Sheath Dress
  10. 60% Off
    -60%
    Black High Slit Draped Midi Dress
  11. 60% Off
    -60%
    Black Cut-out Faux-fur-trim Dress
  12. 60% Off
    -60%
    Pink Printed V-neck Bodycon Dress
  13. 60% Off
    -60%
    Off-white Sheath Mid Length Dress