app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Dresses 76 items
Styles
Styles
  1. Asymmetrical Dresses 20 items
  2. Blouses 7 items
  3. Body Suits 26 items
  4. Bodycon 82 items
  5. Crop Tops 27 items
  6. Jumpsuits 19 items
  7. Maxi Dresses 60 items
  8. Midi Dresses 36 items
  9. Midi Skirts 1 item
  10. Nightwear Set 6 items
  11. Off Shoulder Tops 5 items
  12. Off-shoulder And Bandeau Dresses 35 items
  13. Pencil Dresses 16 items
  14. Playsuits And Rompers 5 items
  15. Sets 122 items
  16. Shift Dresses 4 items
  17. Shirt Dresses 1 item
  18. Shirts 5 items
  19. Short And Mini Skirts 3 items
  20. Skater Dresses 19 items
  21. Skater Skirts 1 item
  22. Straight Jeans 1 item
  23. Swimsuit 5 items
  24. T-shirts 24 items
  25. Tunic Dresses 1 item
  26. Vests And Camis 20 items
  27. Hipster 4 items
  28. Bikini 4 items
  29. Thong 21 items
  30. Sports 1 item
  31. T-Shirt Bra 1 item
  32. Bralette 2 items
  33. Corsets & Tube Tops 46 items
  34. Cold Shoulder Tops 1 item
  35. Corset Dresses 7 items
Colour
Colour
  1. Beige 33 items
  2. Black 227 items
  3. Blue 95 items
  4. Brown 52 items
  5. Gold 10 items
  6. Green 77 items
  7. Grey 15 items
  8. Multi 42 items
  9. Orange 22 items
  10. Pink 80 items
  11. Purple 18 items
  12. Red 80 items
  13. Silver 11 items
  14. White 96 items
  15. Yellow 20 items
Less
Size
Size
  1. 1XL 1 item
  2. 2XL 5 items
  3. 3XL 4 items
  4. 4XL 1 item
  5. 5XL 2 items
  6. L 71 items
  7. M 70 items
  8. S 73 items
  9. XL 23 items
  10. XS 6 items
  11. XXL 1 item
Less
Price
Price
  1. Rs. 1000 - 1200 1 item
  2. Rs. 1200 - 1400 6 items
  3. Rs. 1400 - 1600 6 items
  4. Rs. 1600 - 1800 13 items
  5. Rs. 1800 - 2000 5 items
  6. Rs. 2000 - 2500 25 items
  7. Rs. 2500 - 3000 13 items
  8. Rs. 3000 - 3500 2 items
  9. Rs. 3500 - 4000 1 item
  10. Rs. 4000 - 4500 3 items
  1. Asymmetrical Dresses Remove This Item
  2. Maxi Dresses Remove This Item
  3. Red Remove This Item
  4. S Remove This Item
  5. XXL 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_6605607abb7ea5_66311310` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`special_price` DESC, `e`.`entity_id` DESC LIMIT 24

Page
80 styles found
  1. 58% Off
    -58%
    SLIT CORSETRY MAXI RED DRESS
  2. 60% Off
    -60%
    EVERYTHING CLASSY RED SLIT DRESS
  3. 60% Off
    -60%
    Red A-line Midi Asymmetrical Dress
  4. 60% Off
    -60%
    Claret Hanging Back Long Dress
  5. 60% Off
    -60%
    RUFFLED SIDE SLIT RED MAXI DRESS
  6. 60% Off
    -60%
    Red Halter Neck High Slit Dress
  7. 60% Off
    -60%
    Asymmetrical Claret Long Dress
  8. 58% Off
    -58%
    RED V-NECK SLIT MAXI DRESS
  9. 58% Off
    -58%
    CRIMSON V-NECK SLIT MAXI DRESS
  10. 60% Off
    -60%
    RED IREGULAR HEM TRUMPET MAXI DRESS
  11. 58% Off
    -58%
    ROSE RED RUFFLY SLIT MAXI DRESS
  12. 58% Off
    -58%
    COCKTAIL RED ASYMMETRICAL MIDI DRESS
  13. 60% Off
    -60%
    Red Bow Side Slit Cut-out Maxi Dress
  14. 60% Off
    -60%
    RED FLORAL PRINT SHEATH MAXI DRESS
  15. 60% Off
    -60%
    Deep Red Velour Long Dress
  16. 60% Off
    -60%
    Red Ruffle-trimmed Long Sheath Dress
  17. 58% Off
    -58%
    RED HOLLOW-CUT SLIM MAXI DRESS
Page