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 35 items
  2. Black 155 items
  3. Blue 47 items
  4. Brown 63 items
  5. Gold 1 item
  6. Green 32 items
  7. Grey 34 items
  8. Maroon 3 items
  9. Multi 8 items
  10. Orange 5 items
  11. Pink 45 items
  12. Purple 10 items
  13. Red 21 items
  14. Silver 9 items
  15. White 118 items
  16. Yellow 4 items
Less
Size
Size
  1. 2XL 3 items
  2. 3XL 1 item
  3. 4XL 1 item
  4. FS 29 items
  5. L 176 items
  6. M 183 items
  7. S 177 items
  8. XL 44 items
  9. XS 18 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 50 items
  5. Rs. 1200 - 1400 31 items
  6. Rs. 1400 - 1600 12 items
  7. Rs. 1600 - 1800 15 items
  8. Rs. 1800 - 2000 9 items
  9. Rs. 2000 - 2500 5 items
  10. Rs. 2500 - 3000 5 items
  11. Rs. 3000 - 3500 3 items
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Vests And Camis Remove This Item
  4. Skinny Jeans 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_6605d3008f5f07_96350378` 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

184 styles found
  1. 58% Off
    -58%
    DARK-BLUE SKINNY SLIT JEANS
  2. 58% Off
    -58%
    LIGHT-BLUE SKINNY SLIT JEANS
  3. 60% Off
    -60%
    PRINTED BLUE COTTON VEST TOP
  4. 60% Off
    -60%
    MIDI PARACHUTE WHITE SKATER SKIRT
  5. 60% Off
    -60%
    Blue V-neck Knitted Slim Top
  6. 60% Off
    -60%
    White V-neck Regular Linen Mix Cami
  7. 60% Off
    -60%
    Low-rise White Mock Buttons Skirt
  8. 60% Off
    -60%
    WHITE HALTER DRAWSTRING VEST
  9. 60% Off
    -60%
    White Sleeveless Fitted Tank Top
  10. 60% Off
    -60%
    White Strappy Cami Top
  11. 60% Off
    -60%
    OFF-SHOULDER FLORAL-D
  12. 60% Off
    -60%
    WHITE V-NECK POLYESTER VEST TOP
  13. 58% Off
    -58%
    RHINESTONE-DETAIL WHITE VEST TOP
  14. 60% Off
    -60%
    White Sleeveless Slim Fit Vest
  15. 60% Off
    -60%
    White Motif Print Summer Cami
  16. 60% Off
    -60%
    Tie-up Shoulder Straps Crimson Top
  17. 60% Off
    -60%
    White Square Neck Sleeveless Top
  18. 60% Off
    -60%
    Blue Strappy Tie-up Front Cami