app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Dresses 18 items
  • Skirts 2 items
Styles
Styles
  1. Asymmetrical Dresses 2 items
  2. Blouses 12 items
  3. Body Suits 29 items
  4. Bodycon 18 items
  5. Bracelets 0 items
  6. Caps 2 items
  7. Cover Ups 2 items
  8. Crop Tops 33 items
  9. Jumpsuits 4 items
  10. Maxi Dresses 1 item
  11. Maxi Skirts 1 item
  12. Midi Dresses 9 items
  13. Midi Skirts 1 item
  14. Nightdresses 5 items
  15. Nightwear Set 9 items
  16. Off Shoulder Tops 4 items
  17. Off-shoulder And Bandeau Dresses 1 item
  18. Playsuits And Rompers 3 items
  19. Sets 13 items
  20. Shift Dresses 1 item
  21. Shirts 3 items
  22. Short And Mini Skirts 1 item
  23. Skater Skirts 2 items
  24. Swimsuit 1 item
  25. T-shirts 60 items
  26. Vests And Camis 48 items
  27. Gloves 1 item
  28. Bralette 1 item
  29. Wrap Dresses 1 item
  30. Corsets & Tube Tops 32 items
Colour
Colour
  1. Beige 1 item
  2. Black 22 items
  3. Blue 5 items
  4. Brown 6 items
  5. Gold 3 items
  6. Green 5 items
  7. Grey 1 item
  8. Multi 8 items
  9. Orange 2 items
  10. Pink 4 items
  11. Purple 3 items
  12. Red 7 items
  13. Silver 2 items
  14. White 8 items
Less
Size
Size
  1. FS 1 item
  2. L 19 items
  3. M 18 items
  4. S 15 items
  5. XL 1 item
  6. XS 1 item
Less
Price
Price
  1. Rs. 600 - 800 1 item
  2. Rs. 800 - 1000 3 items
  3. Rs. 1000 - 1200 20 items
  4. Rs. 1200 - 1400 26 items
  5. Rs. 1400 - 1600 54 items
  6. Rs. 1600 - 1800 31 items
  7. Rs. 1800 - 2000 32 items
  8. Rs. 2000 - 2500 59 items
  9. Rs. 2500 - 3000 31 items
  10. Rs. 3000 - 3500 10 items
  11. Rs. 3500 - 4000 4 items
  12. Rs. 4000 - 4500 2 items
  13. Rs. 5000 - 5500 1 item
  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. Green Remove This Item
  7. Rs. 1000 - 1200 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_6605dc16077243_66728253` 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

20 styles found
  1. 58% Off
    -58%
    ONE-SHOULDER GREEN FEATHERY DRESS
  2. 60% Off
    -60%
    Rhinestone Strap Bodycon White Dress
  3. 60% Off
    -60%
    Red Strappy Backless Short Dress
  4. 58% Off
    -58%
    PRINTED WHITE BODYCON CASUAL DRESS
  5. 59% Off
    -59%
    TIE-DYE HOLLOW TWIST BODYCON DRESS
  6. 60% Off
    -60%
    TEXTURED SHORT BACKLESS WHITE DRESS
  7. 59% Off
    -59%
    SATIN GREEN COWL-NECK BODYCON DRESS
  8. 60% Off
    -60%
    Printed Strappy Sheath Short Dress
  9. 60% Off
    -60%
    HALTER NECK RED BOMSHELL DRESS
  10. 59% Off
    -59%
    METALLIC GREEN SLIT BODYCON DRESS
  11. 59% Off
    -59%
    WHITE SLIT U-NECK BODYCON DRESS
  12. 59% Off
    -59%
    PINK SLIT U-NECK BODYCON DRESS
  13. 60% Off
    -60%
    SATIN COWL-NECK PINK BODYCON DRESS
  14. 60% Off
    -60%
    SATIN RED COWL-NECK BODYCON DRESS
  15. 60% Off
    -60%
    SATIN WHITE COWL-NECK BODYCON DRESS
  16. 58% Off
    -58%
    A-LINE WHITE TULLE SKATER SKIRT
  17. 60% Off
    -60%
    RED HIGH-RISE SKATER SKIRT