app-download-header
Trending Now

Premium collection

Premium

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

6 styles found
  1. 60% Off
    -60%
    Red Lace-Detailed Skater Dress
  2. 60% Off
    -60%
    CONTRAST-EDGE PLEATED SKATER SKIRT
  3. 60% Off
    -60%
    ROSEY DAYS PINK DRESS
  4. 58% Off
    -58%
    WHITE SWEETHEART-NECK SKATER DRESS
  5. 60% Off
    -60%
    SWEETHEART WHITE PINK DRESS