app-download-header
24 Hours Sale - 95% Off on Everything
20% OFF on Buy 4 any items, Use Code: MERRY
20% OFF on Buy 4 any items
Use Code: MERRY
HR
:
MN
:
SC
ENDS IN

Women

Filter
Shopping Options
Category
Category
  • Dresses 39 items
Styles
Styles
  1. Asymmetrical Dresses 7 items
  2. Blouses 10 items
  3. Body Suits 5 items
  4. Bodycon 42 items
  5. Crop Tops 14 items
  6. Denim Dresses 1 item
  7. Jumpsuits 5 items
  8. Maxi Dresses 39 items
  9. Maxi Skirts 6 items
  10. Midi Dresses 24 items
  11. Midi Skirts 3 items
  12. Nightwear Set 7 items
  13. Off Shoulder Tops 1 item
  14. Off-shoulder And Bandeau Dresses 16 items
  15. Pencil Dresses 3 items
  16. Playsuits And Rompers 3 items
  17. Sets 75 items
  18. Shift Dresses 5 items
  19. Shirt Dresses 5 items
  20. Shirts 21 items
  21. Skater Dresses 17 items
  22. Skater Skirts 1 item
  23. Swimsuit 22 items
  24. T-shirts 24 items
  25. Tunic Dresses 4 items
  26. Vests And Camis 10 items
  27. Bikini 12 items
  28. Boyshort 55 items
  29. Thong 7 items
  30. Wrap Dresses 1 item
  31. Wide Leg Jeans 1 item
  32. Corsets & Tube Tops 26 items
  33. Cold Shoulder Tops 1 item
Colour
Colour
  1. Beige 36 items
  2. Black 192 items
  3. Blue 76 items
  4. Brown 41 items
  5. Gold 8 items
  6. Green 65 items
  7. Grey 15 items
  8. Multi 39 items
  9. Orange 16 items
  10. Pink 70 items
  11. Purple 18 items
  12. Red 69 items
  13. Silver 10 items
  14. White 81 items
  15. Yellow 17 items
Less
Size
Size
  1. 2XL 1 item
  2. L 35 items
  3. M 36 items
  4. S 33 items
  5. XL 6 items
  6. XS 1 item
Less
Price
Price
  1. Rs. 1000 - 1200 1 item
  2. Rs. 1200 - 1400 3 items
  3. Rs. 1400 - 1600 7 items
  4. Rs. 1600 - 1800 5 items
  5. Rs. 1800 - 2000 4 items
  6. Rs. 2000 - 2500 9 items
  7. Rs. 2500 - 3000 1 item
  8. Rs. 3000 - 3500 3 items
  9. Rs. 3500 - 4000 5 items
  10. Rs. 4000 - 4500 1 item
  1. Maxi Dresses Remove This Item
  2. Multi Remove This Item
  3. S 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=469 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_662a08ee4fc775_71648048` 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
39 styles found
  1. 59% Off
    -59%
    HALTER HANGING NECK MAXI DRESS
  2. 60% Off
    -60%
    CASUAL FLORAL-PRINT MAXI DRESS
  3. 58% Off
    -58%
    COLD-SHOULDER CHIFFON MAXI DRESS
  4. 58% Off
    -58%
    PRINTED BLUE SLIM MAXI DRESSES
  5. 60% Off
    -60%
    Floral Print Long Thigh Slit Dress
  6. 58% Off
    -58%
    CRISS-CROSS STRAP PRINTED MAXI DRESS
  7. 58% Off
    -58%
    PRINTED MOPPING MAXI SLIT DRESS
  8. 58% Off
    -58%
    PRINTED A-LINE PURPLE MAXI DRESS
  9. 60% Off
    -60%
    BACKLESS ANIMAL-PRINT MAXI DRESS
  10. 60% Off
    -60%
    FLORAL-PRINT V-NECK MAXI DRESS
  11. 60% Off
    -60%
    MULTICOLOUR TURTLE NECK MAXI DRESS
  12. 60% Off
    -60%
    SMOCKED WHITE PRINTED MAXI DRESS
  13. 59% Off
    -59%
    PRINTED BACKLESS SUMMER MAXI DRESS
  14. 59% Off
    -59%
    MULTICOLOUR STRIPED KNIT MAXI DRESS
  15. 60% Off
    -60%
    Long Tie-up Shoulder Straps Dress
  16. 60% Off
    -60%
    Black Red Floral Strappy Long Dress
  17. 60% Off
    -60%
    FLORAL PRINT SHEATH MAXI DRESS
Page