app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Dresses 25 items
Styles
Styles
  1. Asymmetrical Dresses 2 items
  2. Blouses 6 items
  3. Body Suits 4 items
  4. Bodycon 26 items
  5. Cover Ups 3 items
  6. Crop Tops 4 items
  7. Denim Dresses 1 item
  8. Denim Tops 1 item
  9. Jumpsuits 3 items
  10. Maxi Dresses 17 items
  11. Maxi Skirts 1 item
  12. Midi Dresses 11 items
  13. Midi Skirts 6 items
  14. Nightdresses 6 items
  15. Nightwear Set 14 items
  16. Off-shoulder And Bandeau Dresses 7 items
  17. Pencil Dresses 3 items
  18. Playsuits And Rompers 4 items
  19. Sets 34 items
  20. Shirt Dresses 0 items
  21. Shirts 6 items
  22. Skater Dresses 5 items
  23. Skater Skirts 1 item
  24. Straight Jeans 1 item
  25. Swimsuit 10 items
  26. T-shirts 17 items
  27. Tunic Tops 2 items
  28. Vests And Camis 6 items
  29. T-Shirt Bra 1 item
  30. Corsets & Tube Tops 6 items
  31. Corset Dresses 1 item
  32. Dressing Gowns & Robes 1 item
Colour
Colour
  1. Beige 7 items
  2. Black 54 items
  3. Blue 14 items
  4. Brown 13 items
  5. Gold 2 items
  6. Green 16 items
  7. Grey 8 items
  8. Maroon 1 item
  9. Multi 5 items
  10. Orange 5 items
  11. Pink 13 items
  12. Purple 4 items
  13. Red 14 items
  14. Silver 1 item
  15. White 26 items
  16. Yellow 3 items
Less
Size
Size
  1. FS 2 items
  2. L 23 items
  3. M 23 items
  4. S 24 items
  5. XL 1 item
  6. XS 1 item
Less
Price
Price
  1. Rs. 600 - 800 1 item
  2. Rs. 800 - 1000 4 items
  3. Rs. 1000 - 1200 13 items
  4. Rs. 1200 - 1400 26 items
  5. Rs. 1400 - 1600 28 items
  6. Rs. 1600 - 1800 27 items
  7. Rs. 1800 - 2000 30 items
  8. Rs. 2000 - 2500 47 items
  9. Rs. 2500 - 3000 25 items
  10. Rs. 3000 - 3500 4 items
  11. Rs. 3500 - 4000 5 items
  12. Rs. 4000 - 4500 2 items
  1. Asymmetrical Dresses Remove This Item
  2. Bodycon Remove This Item
  3. Shirt Dresses Remove This Item
  4. Red Remove This Item
  5. Blue Remove This Item
  6. Rs. 1400 - 1600 Remove This Item

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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`, `at_special_price`.`value` AS `special_price` FROM `catalog_product_entity` 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_6606bbb66de198_18723035` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '76') AND (`at_special_price`.`store_id` = 0) WHERE (stock_status_index.stock_status = 1) ORDER BY `special_price` DESC, `e`.`entity_id` DESC LIMIT 24

Page
28 styles found
  1. 58% Off
    -58%
    TWISTED CUT-OUT BLUE BODYCON DRESS
  2. 60% Off
    -60%
    Red Full-sleeved Midi Sheath Dress
  3. 59% Off
    -59%
    SHIMMERY BLUE ASYMMETRICAL HEM DRESS
  4. 60% Off
    -60%
    PU RED SHORT BODYCON DRESS
  5. 60% Off
    -60%
    3D PRINT BLUE MAXI BODYCON DRESS
  6. 60% Off
    -60%
    BLUE MARBLE PRINT CUT-OUT BACK DRESS
  7. 60% Off
    -60%
    PRINTED RED MAXI BODYCON DRESS
  8. 60% Off
    -60%
    Blue Floral Motifs Short Dress
  9. 60% Off
    -60%
    Blue Halter Neck Backless Dress
  10. 60% Off
    -60%
    Blue Zip-fly Back Bodycon Dress
  11. 59% Off
    -59%
    BACKLESS FUCHSIA MAXI BODYCON DRESS
  12. 60% Off
    -60%
    Red Spaghetti Strap Slim Short Dress
  13. 60% Off
    -60%
    SQUARE NECK BLUE MIDI BODYCON DRESS
  14. 60% Off
    -60%
    SQUARE NECK RED MIDI BODYCON DRESS
Page