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

New

Filter
Shopping Options
Category
Category
  • Clothing 11 items
Styles
Styles
  1. Asymmetrical Dresses 9 items
  2. Blouses 13 items
  3. Body Suits 30 items
  4. Bodycon 38 items
  5. Cateye Sunglasses 0 items
  6. Cover Ups 7 items
  7. Crop Tops 23 items
  8. Jumpsuits 10 items
  9. Maxi Dresses 28 items
  10. Maxi Skirts 6 items
  11. Midi Dresses 13 items
  12. Midi Skirts 1 item
  13. Nightdresses 4 items
  14. Nightwear Set 9 items
  15. Off Shoulder Tops 7 items
  16. Off-shoulder And Bandeau Dresses 16 items
  17. Pencil Dresses 4 items
  18. Pencil Skirts 1 item
  19. Playsuits And Rompers 8 items
  20. Retro Sunglasses 0 items
  21. Sets 65 items
  22. Shift Dresses 2 items
  23. Shirt Dresses 4 items
  24. Shirts 10 items
  25. Short And Mini Skirts 5 items
  26. Skater Dresses 13 items
  27. Skater Skirts 4 items
  28. Straight Jeans 1 item
  29. Swimsuit 17 items
  30. T-shirts 57 items
  31. Tunic Tops 1 item
  32. Vests And Camis 29 items
  33. Hipster 1 item
  34. Bikini 2 items
  35. Thong 12 items
  36. Sports 2 items
  37. T-Shirt Bra 1 item
  38. Bralette 2 items
  39. Padded 1 item
  40. Non Padded 1 item
  41. Collars 4 items
  42. Mom Jeans 1 item
  43. Vests 1 item
  44. Neck Warmer 1 item
  45. Shawl 1 item
  46. Corsets & Tube Tops 25 items
  47. Sarong 1 item
  48. Corset Dresses 8 items
  49. Dressing Gowns & Robes 2 items
Colour
Colour
  1. Beige 4 items
  2. Black 29 items
  3. Blue 14 items
  4. Brown 5 items
  5. Gold 2 items
  6. Green 8 items
  7. Grey 1 item
  8. Multi 3 items
  9. Orange 2 items
  10. Pink 10 items
  11. Purple 3 items
  12. Red 10 items
  13. Silver 1 item
  14. White 11 items
  15. Yellow 2 items
Less
Size
Size
  1. FS 4 items
  2. L 5 items
  3. M 6 items
  4. S 6 items
  5. XL 5 items
Less
Price
Price
  1. Rs. 1000 - 1200 1 item
  2. Rs. 1400 - 1600 1 item
  3. Rs. 2000 - 2500 2 items
  4. Rs. 2500 - 3000 2 items
  1. Pencil Dresses Remove This Item
  2. Retro Sunglasses Remove This Item
  3. Cateye Sunglasses Remove This Item
  4. Cover Ups Remove This Item
  5. White 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=385 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_6606013b5b1267_97060611` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`created_at` ASC, `e`.`entity_id` DESC LIMIT 24

6 styles found