app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Dresses 27 items
  • Skirts 1 item
Styles
Styles
  1. Asymmetrical Dresses 6 items
  2. Blouses 3 items
  3. Body Suits 15 items
  4. Bodycon 27 items
  5. Bracelets 0 items
  6. Crop Tops 6 items
  7. Jumpsuits 2 items
  8. Maxi Dresses 5 items
  9. Midi Dresses 2 items
  10. Nightwear Set 1 item
  11. Off-shoulder And Bandeau Dresses 13 items
  12. Pencil Dresses 3 items
  13. Sets 7 items
  14. Shirts 1 item
  15. Short And Mini Skirts 2 items
  16. Skater Dresses 7 items
  17. Skater Skirts 1 item
  18. Straight Jeans 1 item
  19. T-shirts 8 items
  20. Vests And Camis 12 items
  21. Bralette 2 items
  22. Corsets & Tube Tops 34 items
  23. Corset Dresses 5 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 4 items
  2. 2XL 8 items
  3. 3XL 6 items
  4. 4XL 4 items
  5. FS 3 items
  6. L 191 items
  7. M 180 items
  8. S 188 items
  9. XL 54 items
  10. XS 25 items
  11. XXL 3 items
  12. XXXL 1 item
Less
Price
Price
  1. Rs. 600 - 800 1 item
  2. Rs. 1000 - 1200 1 item
  3. Rs. 1200 - 1400 2 items
  4. Rs. 1400 - 1600 3 items
  5. Rs. 1600 - 1800 3 items
  6. Rs. 1800 - 2000 4 items
  7. Rs. 2000 - 2500 11 items
  8. Rs. 2500 - 3000 5 items
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Bodycon Remove This Item
  4. White Remove This Item
  5. Red Remove This Item
  6. Gold Remove This Item
  7. XS 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_660677a5268ff8_82463109` 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. 60% Off
    -60%
    WHITE SATIN FLORAL MINI SLIP DRESS
  2. 60% Off
    -60%
    SLANTED CUT-OUT SEQUIN BODYCON DRESS
  3. 58% Off
    -58%
    CUT-OUT ROSE-RED BODYCON DRESS
  4. 58% Off
    -58%
    SATIN BACKLESS WHITE BODYCON DRESS
  5. 58% Off
    -58%
    TAMARYN BEIGE SPARKLED DRESS
  6. 59% Off
    -59%
    FAUX-FUR HOLOGRAPHIC BODYCON DRESS
  7. 58% Off
    -58%
    LACE-UP-TIE WHITE BODYCON DRESS
  8. 58% Off
    -58%
    LACE-UP-TIE RED BODYCON DRESS
  9. 58% Off
    -58%
    SEQUIN WHITE LACE-UP BODYCON DRESS
  10. 58% Off
    -58%
    SEQUIN RED LACE-UP BODYCON DRESS
  11. 58% Off
    -58%
    SHIRRED WHITE CUT-OUT BODYCON DRESS
  12. 58% Off
    -58%
    HOMECOMING WHITE SEQUENED DRESS
  13. 60% Off
    -60%
    White Halter Plunge Neckline Dress
  14. 58% Off
    -58%
    SHIRRED BODYCON WHITE DRESS
  15. 60% Off
    -60%
    White Motif Print Halter Lapel Dress
Page