app-download-header
24 Hours Sale - 95% Off on Everything
20% OFF on Buy 4 any items, Use Code: MERRY
20% OFF on Buy 4 any items
Use Code: MERRY
HR
:
MN
:
SC
ENDS IN

Clothing

Filter
Shopping Options
Styles
Styles
  1. Asymmetrical Dresses 4 items
  2. Blouses 6 items
  3. Body Suits 24 items
  4. Bodycon 43 items
  5. Cover Ups 4 items
  6. Crop Tops 22 items
  7. Flare Jeans 1 item
  8. Jumpsuits 10 items
  9. Maxi Dresses 33 items
  10. Maxi Skirts 6 items
  11. Midi Dresses 8 items
  12. Midi Skirts 4 items
  13. Nightdresses 3 items
  14. Nightwear Set 9 items
  15. Off Shoulder Tops 4 items
  16. Off-shoulder And Bandeau Dresses 17 items
  17. Pencil Dresses 3 items
  18. Pencil Skirts 1 item
  19. Playsuits And Rompers 3 items
  20. Ripped Jeans 0 items
  21. Sets 78 items
  22. Shift Dresses 7 items
  23. Shirt Dresses 1 item
  24. Shirts 5 items
  25. Short And Mini Skirts 8 items
  26. Skater Dresses 6 items
  27. Skater Skirts 2 items
  28. Straight Jeans 2 items
  29. Swimsuit 12 items
  30. T-shirts 37 items
  31. Tunic Dresses 2 items
  32. Vests And Camis 18 items
  33. Thong 3 items
  34. Bralette 2 items
  35. Collars 1 item
  36. Corsets & Tube Tops 15 items
  37. Cold Shoulder Tops 1 item
  38. Corset Dresses 3 items
Colour
Colour
  1. Beige 2 items
  2. Black 9 items
  3. Blue 1 item
  4. Brown 4 items
  5. Green 4 items
  6. Multi 3 items
  7. Orange 2 items
  8. Pink 7 items
  9. Red 3 items
  10. White 12 items
  11. Yellow 2 items
Less
Size
Size
  1. 2XL 2 items
  2. 35 0 items
  3. 3XL 1 item
  4. 4XL 1 item
  5. FS 2 items
  6. L 5 items
  7. M 5 items
  8. S 5 items
  9. XL 5 items
Less
Price
Price
  1. Rs. 1400 - 1600 2 items
  2. Rs. 1800 - 2000 2 items
  3. Rs. 2000 - 2500 1 item
  1. Blouses Remove This Item
  2. Ripped Jeans Remove This Item
  3. Beige Remove This Item
  4. Brown Remove This Item
  5. XL Remove This Item
  6. 35 Remove This Item
  7. L Remove This Item
  8. M 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=389 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_6605b36fe84bd2_49369442` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24

6 styles found
  1. 60% Off
    -60%
    Cotton Brown Full Sleeved Wrap-top
  2. 60% Off
    -60%
    KHAKI TWIST-STRAP TEXTURED BLOUSE
  3. 60% Off
    -60%
    SURPLICE NECK BEIGE SHORT BLOUSE
  4. 60% Off
    -60%
    BROWN CRIMPED DRAWSTRING BLOUSE
  5. 58% Off
    -58%
    SATIN BROWN PLEATED BUTTONED BLOUSE