app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Dresses 48 items
  • Skirts 4 items
Styles
Styles
  1. Asymmetrical Dresses 8 items
  2. Blouses 4 items
  3. Body Suits 37 items
  4. Bodycon 48 items
  5. Cover Ups 0 items
  6. Crop Tops 11 items
  7. Denim Dresses 1 item
  8. Flare Jeans 10 items
  9. Jumpsuits 4 items
  10. Maxi Dresses 11 items
  11. Midi Dresses 5 items
  12. Midi Skirts 1 item
  13. Nightwear Set 2 items
  14. Off-shoulder And Bandeau Dresses 19 items
  15. Pencil Dresses 5 items
  16. Pencil Skirts 1 item
  17. Ripped Jeans 1 item
  18. Sets 18 items
  19. Shirts 2 items
  20. Short And Mini Skirts 7 items
  21. Skater Dresses 12 items
  22. Skater Skirts 4 items
  23. Skinny Jeans 1 item
  24. Straight Jeans 6 items
  25. T-shirts 17 items
  26. Vests And Camis 23 items
  27. Bralette 6 items
  28. Wide Leg Jeans 11 items
  29. Corsets & Tube Tops 58 items
  30. Corset Dresses 10 items
Colour
Colour
  1. Beige 4 items
  2. Black 26 items
  3. Blue 14 items
  4. Brown 10 items
  5. Gold 2 items
  6. Green 8 items
  7. Grey 3 items
  8. Orange 2 items
  9. Pink 5 items
  10. Purple 6 items
  11. Red 8 items
  12. Silver 3 items
  13. White 18 items
Less
Size
Size
  1. 1XL 13 items
  2. 2XL 20 items
  3. 3XL 16 items
  4. 4XL 8 items
  5. FS 21 items
  6. L 503 items
  7. M 495 items
  8. S 507 items
  9. XL 141 items
  10. XS 48 items
  11. XXL 6 items
  12. XXXL 1 item
Less
Price
Price
  1. Rs. 600 - 800 2 items
  2. Rs. 1000 - 1200 2 items
  3. Rs. 1200 - 1400 1 item
  4. Rs. 1400 - 1600 4 items
  5. Rs. 1600 - 1800 8 items
  6. Rs. 1800 - 2000 7 items
  7. Rs. 2000 - 2500 21 items
  8. Rs. 2500 - 3000 12 items
  9. Rs. 3000 - 3500 1 item
  1. Skater Skirts Remove This Item
  2. Bodycon Remove This Item
  3. Cover Ups Remove This Item
  4. White Remove This Item
  5. Red Remove This Item
  6. Black Remove This Item
  7. XS 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_6605a515173340_91591005` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

Page
52 styles found
  1. 58% Off
    -58%
    SEQUIN RED LACE-UP BODYCON DRESS
  2. 58% Off
    -58%
    BONING-DETAIL BLACK BODYCON DRESS
  3. 58% Off
    -58%
    LACE-UP-TIE RED BODYCON DRESS
  4. 58% Off
    -58%
    CUT-OUT ROSE-RED BODYCON DRESS
  5. 59% Off
    -59%
    FAUX-FUR HOLOGRAPHIC BODYCON DRESS
  6. 58% Off
    -58%
    SATIN BACKLESS WHITE BODYCON DRESS
  7. 58% Off
    -58%
    SHORT BLACK CORSETRY BODYCON DRESS
  8. 58% Off
    -58%
    SEQUIN WHITE LACE-UP BODYCON DRESS
  9. 58% Off
    -58%
    LACE-UP-TIE WHITE BODYCON DRESS
  10. 58% Off
    -58%
    SHIRRED WHITE CUT-OUT BODYCON DRESS
  11. 58% Off
    -58%
    LACE-UP-TIE BLACK BODYCON DRESS
  12. 58% Off
    -58%
    SHIRRED BLACK CUT-OUT BODYCON DRESS
  13. 58% Off
    -58%
    SEQUIN BLACK LACE-UP BODYCON DRESS
  14. 58% Off
    -58%
    BLACK HALTER BACKLESS BODYCON DRESS
  15. 59% Off
    -59%
    HALTER METALLIC BLACK BODYCON DRESS
  16. 58% Off
    -58%
    SHIRRED BODYCON WHITE DRESS
Page