app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 54 items
  2. Blouses 60 items
  3. Body Suits 113 items
  4. Bodycon 252 items
  5. Bracelets 0 items
  6. Cover Ups 6 items
  7. Crop Tops 161 items
  8. Cropped Jeans 2 items
  9. Culottes 1 item
  10. Denim Dresses 16 items
  11. Denim Tops 6 items
  12. Dungarees 1 item
  13. Flare Jeans 36 items
  14. Jumpsuits 64 items
  15. Maxi Dresses 218 items
  16. Maxi Skirts 21 items
  17. Maxi Tops 1 item
  18. Midi Dresses 107 items
  19. Midi Skirts 20 items
  20. Nightdresses 31 items
  21. Nightwear Set 101 items
  22. Off Shoulder Tops 32 items
  23. Off-shoulder And Bandeau Dresses 121 items
  24. Pencil Dresses 50 items
  25. Pencil Skirts 3 items
  26. Pinafore 1 item
  27. Playsuits And Rompers 47 items
  28. Ripped Jeans 3 items
  29. Sets 496 items
  30. Shift Dresses 16 items
  31. Shirt Dresses 16 items
  32. Shirts 40 items
  33. Short And Mini Skirts 26 items
  34. Skater Dresses 76 items
  35. Skater Skirts 12 items
  36. Skinny Jeans 3 items
  37. Straight Jeans 115 items
  38. Swimsuit 79 items
  39. T-shirts 295 items
  40. Tunic Dresses 8 items
  41. Tunic Tops 3 items
  42. Vests And Camis 171 items
  43. Hipster 10 items
  44. Bikini 29 items
  45. Boyshort 2 items
  46. Thong 133 items
  47. Sports 14 items
  48. T-Shirt Bra 2 items
  49. Bralette 5 items
  50. Sports Bra 3 items
  51. Collars 2 items
  52. Wrap Dresses 4 items
  53. Mom Jeans 2 items
  54. Baggy Jeans 10 items
  55. Vests 1 item
  56. Wide Leg Jeans 42 items
  57. Corsets & Tube Tops 138 items
  58. Cold Shoulder Tops 3 items
  59. Corset Dresses 28 items
  60. Dressing Gowns & Robes 2 items
Colour
Colour
  1. Beige 47 items
  2. Black 188 items
  3. Blue 47 items
  4. Brown 65 items
  5. Gold 7 items
  6. Green 45 items
  7. Grey 37 items
  8. Maroon 9 items
  9. Multi 10 items
  10. Orange 5 items
  11. Pink 60 items
  12. Purple 38 items
  13. Red 29 items
  14. Silver 9 items
  15. White 138 items
  16. Yellow 6 items
Less
Size
Size
  1. 2XL 4 items
  2. 3XL 1 item
  3. 4XL 1 item
  4. FS 35 items
  5. L 202 items
  6. M 209 items
  7. S 177 items
  8. XL 54 items
  9. XS 16 items
  10. XXL 3 items
Less
Price
Price
  1. Rs. 400 - 600 1 item
  2. Rs. 600 - 800 15 items
  3. Rs. 800 - 1000 34 items
  4. Rs. 1000 - 1200 52 items
  5. Rs. 1200 - 1400 37 items
  6. Rs. 1400 - 1600 20 items
  7. Rs. 1600 - 1800 19 items
  8. Rs. 1800 - 2000 14 items
  9. Rs. 2000 - 2500 9 items
  10. Rs. 2500 - 3000 9 items
  11. Rs. 3000 - 3500 2 items
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Vests And Camis Remove This Item
  4. Nightdresses Remove This Item
  5. White Remove This Item
  6. Red Remove This Item
  7. Blue Remove This Item
  8. L 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_66060605b18724_12042966` 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

212 styles found
  1. 60% Off
    -60%
    PRINTED BLUE COTTON VEST TOP
  2. 58% Off
    -58%
    WHITE TIERED SATIN LACE NIGHTDRESS
  3. 60% Off
    -60%
    MIDI PARACHUTE WHITE SKATER SKIRT
  4. 60% Off
    -60%
    Blue V-neck Knitted Slim Top
  5. 60% Off
    -60%
    White V-neck Regular Linen Mix Cami
  6. 60% Off
    -60%
    Low-rise White Mock Buttons Skirt
  7. 60% Off
    -60%
    WHITE HALTER DRAWSTRING VEST
  8. 60% Off
    -60%
    White Sleeveless Fitted Tank Top
  9. 60% Off
    -60%
    White Strappy Cami Top
  10. 60% Off
    -60%
    White A-line Short Nightdress
  11. 60% Off
    -60%
    OFF-SHOULDER FLORAL-D
  12. 60% Off
    -60%
    WHITE V-NECK POLYESTER VEST TOP
  13. 60% Off
    -60%
    Crimson Side Slits Velour Nightdress