app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
  • Tops 92 items
  • Skirts 3 items
Styles
Styles
  1. Asymmetrical Dresses 3 items
  2. Blouses 16 items
  3. Body Suits 63 items
  4. Bodycon 39 items
  5. Bracelets 0 items
  6. Caps 3 items
  7. Cover Ups 2 items
  8. Crop Tops 59 items
  9. Denim Tops 1 item
  10. Hats 1 item
  11. Jumpsuits 4 items
  12. Maxi Dresses 4 items
  13. Maxi Skirts 2 items
  14. Midi Dresses 11 items
  15. Midi Skirts 4 items
  16. Nightdresses 7 items
  17. Nightwear Set 19 items
  18. Off Shoulder Tops 11 items
  19. Off-shoulder And Bandeau Dresses 9 items
  20. Pencil Dresses 2 items
  21. Playsuits And Rompers 11 items
  22. Sets 22 items
  23. Shift Dresses 2 items
  24. Shirt Dresses 1 item
  25. Shirts 2 items
  26. Short And Mini Skirts 3 items
  27. Skater Skirts 3 items
  28. Skinny Jeans 1 item
  29. T-shirts 117 items
  30. Vests And Camis 98 items
  31. Wayfarers And Square Frame Sunglasses 2 items
  32. Gloves 1 item
  33. Sports 2 items
  34. Bralette 2 items
  35. Wrap Dresses 1 item
  36. Thongbody 1 item
  37. Corsets & Tube Tops 70 items
  38. Cold Shoulder Tops 1 item
Colour
Colour
  1. Beige 9 items
  2. Black 42 items
  3. Blue 18 items
  4. Brown 20 items
  5. Gold 1 item
  6. Green 9 items
  7. Grey 9 items
  8. Maroon 1 item
  9. Multi 3 items
  10. Orange 1 item
  11. Pink 17 items
  12. Purple 4 items
  13. Red 6 items
  14. Silver 3 items
  15. White 35 items
Less
Size
Size
  1. FS 15 items
  2. L 82 items
  3. M 83 items
  4. S 82 items
  5. XL 17 items
  6. XS 13 items
  7. XXL 2 items
Less
Price
Price
  1. Rs. 400 - 600 8 items
  2. Rs. 600 - 800 35 items
  3. Rs. 800 - 1000 80 items
  4. Rs. 1000 - 1200 101 items
  5. Rs. 1200 - 1400 64 items
  6. Rs. 1400 - 1600 32 items
  7. Rs. 1600 - 1800 26 items
  8. Rs. 1800 - 2000 14 items
  9. Rs. 2000 - 2500 10 items
  10. Rs. 2500 - 3000 14 items
  11. Rs. 3000 - 3500 3 items
  12. Rs. 4000 - 4500 1 item
  1. Skater Skirts Remove This Item
  2. Bracelets Remove This Item
  3. Vests And Camis Remove This Item
  4. White Remove This Item
  5. Red Remove This Item
  6. Blue Remove This Item
  7. Black Remove This Item
  8. 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_6606020ba003c4_43322004` 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

101 styles found
  1. 60% Off
    -60%
    Black Retro Contrast Lace Trim Cami
  2. 60% Off
    -60%
    Black Floral Decor Diagonal Neck Top
  3. 60% Off
    -60%
    White Floral Decor Diagonal Neck Top
  4. 80% Off
    -80%
    VINTAGE FEELS BLACKK VEST
  5. 60% Off
    -60%
    Blue Twist-detail Irregular Top
  6. 60% Off
    -60%
    Black Twist-detail Irregular Top
  7. 60% Off
    -60%
    Sheer Lace Blue Halter Neck Top
  8. 58% Off
    -58%
    BLACK HANGING RUFFLES HALTER VEST
  9. 60% Off
    -60%
    Blue Ruched-detail Diagonal Neck Top
  10. 60% Off
    -60%
    Red Slanted Rivet Detail Strap Top
  11. 60% Off
    -60%
    Off-white Strappy Sheer Dotted Top
  12. 58% Off
    -58%
    RUFFLE TRIM Y2K ONE-SHOULDER VEST
  13. 58% Off
    -58%
    POLYESTER BLACK FS DRAPED CAMI
  14. 58% Off
    -58%
    POLYESTER WHITE FS DRAPED CAMI
  15. 60% Off
    -60%
    Blue Lace Edge Short Slit Velour Top
  16. 60% Off
    -60%
    White Halter Scoop Neck Ribbed Vest
  17. 60% Off
    -60%
    Black Halter Scoop Neck Ribbed Vest
  18. 60% Off
    -60%
    Dangling Neck Tie-up Backless Top