app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 39 items
  2. Blouses 50 items
  3. Body Suits 101 items
  4. Bodycon 180 items
  5. Cover Ups 4 items
  6. Crop Tops 134 items
  7. Jumpsuits 41 items
  8. Maxi Dresses 138 items
  9. Maxi Skirts 7 items
  10. Maxi Tops 1 item
  11. Midi Dresses 70 items
  12. Midi Skirts 8 items
  13. Nightdresses 10 items
  14. Nightwear Set 58 items
  15. Off Shoulder Tops 27 items
  16. Off-shoulder And Bandeau Dresses 87 items
  17. Pencil Dresses 34 items
  18. Pencil Skirts 1 item
  19. Playsuits And Rompers 29 items
  20. Sets 314 items
  21. Shift Dresses 13 items
  22. Shirt Dresses 8 items
  23. Shirts 27 items
  24. Short And Mini Skirts 16 items
  25. Skater Dresses 57 items
  26. Skater Skirts 9 items
  27. Straight Jeans 4 items
  28. Swimsuit 52 items
  29. T-shirts 241 items
  30. Tunic Dresses 5 items
  31. Tunic Tops 2 items
  32. Vests And Camis 132 items
  33. Hipster 7 items
  34. Bikini 8 items
  35. Thong 75 items
  36. Sports 6 items
  37. T-Shirt Bra 2 items
  38. Bralette 4 items
  39. Sports Bra 1 item
  40. Collars 2 items
  41. Wrap Dresses 1 item
  42. Mom Jeans 1 item
  43. Baggy Jeans 1 item
  44. Vests 1 item
  45. Wide Leg Jeans 1 item
  46. Corsets & Tube Tops 114 items
  47. Cold Shoulder Tops 3 items
  48. Corset Dresses 21 items
Colour
Colour
  1. Beige 26 items
  2. Black 214 items
  3. Blue 28 items
  4. Brown 48 items
  5. Gold 2 items
  6. Green 26 items
  7. Grey 16 items
  8. Multi 13 items
  9. Orange 6 items
  10. Pink 31 items
  11. Purple 3 items
  12. Red 46 items
  13. Silver 5 items
  14. White 94 items
  15. Yellow 10 items
Less
Size
Size
  1. 1XL 1 item
  2. 2XL 9 items
  3. 3XL 7 items
  4. FS 2 items
  5. L 131 items
  6. M 126 items
  7. S 131 items
  8. XL 35 items
  9. XS 20 items
Less
Price
Price
  1. Rs. 600 - 800 1 item
  2. Rs. 800 - 1000 22 items
  3. Rs. 1000 - 1200 30 items
  4. Rs. 1200 - 1400 31 items
  5. Rs. 1400 - 1600 13 items
  6. Rs. 1600 - 1800 14 items
  7. Rs. 1800 - 2000 7 items
  8. Rs. 2000 - 2500 10 items
  9. Rs. 2500 - 3000 9 items
  10. Rs. 3000 - 3500 2 items
  1. Asymmetrical Dresses Remove This Item
  2. Body Suits Remove This Item
  3. White Remove This Item
  4. Red Remove This Item
  5. S Remove This Item
  6. XL 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_6605c14b3fcd21_54577502` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`created_at` ASC, `e`.`entity_id` DESC LIMIT 24

139 styles found
  1. 60% Off
    -60%
    EVERYTHING CLASSY RED SLIT DRESS
  2. 58% Off
    -58%
    TASSLES AND TIES WHITE SET
  3. 60% Off
    -60%
    FLORAL DREAM GIRL WHITE DRESS
  4. 60% Off
    -60%
    FLORAL DREAM GIRL RED DRESS
  5. 58% Off
    -58%
    COCKTAIL RED ASYMMETRICAL MIDI DRESS
  6. 58% Off
    -58%
    WHITE MESH-DETAIL SEAMLESS BODYSUIT
  7. 58% Off
    -58%
    WHITE CRISS-CROSS HALTER BODYSUIT
  8. 58% Off
    -58%
    LAYERED CUT-OUT WHITE BODYSUIT
  9. 58% Off
    -58%
    ROSE-RED HOLLOW ASYMMETRICAL DRESS
  10. 58% Off
    -58%
    RED MESH-DETAIL SEAMLESS BODYSUIT
  11. 60% Off
    -60%
    RED CAPE-DETAIL ASYMMETRICAL DRESS
  12. 58% Off
    -58%
    CURVED-V NECK WHITE BODYSUIT
  13. 58% Off
    -58%
    CURVED-V NECK CRIMSON BODYSUIT
  14. 58% Off
    -58%
    DEEP U-NECK WHITE BODYSUIT
  15. 58% Off
    -58%
    RIBBED ROSE-RED HIGH-CUT BODYSUIT
  16. 58% Off
    -58%
    RIBBED WHITE HIGH-CUT BODYSUIT
  17. 58% Off
    -58%
    RIBBED SQUARE-NECK WHITE BODYSUIT