app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 5 items
  2. Body Suits 8 items
  3. Bodycon 20 items
  4. Crop Tops 6 items
  5. Cropped Jeans 1 item
  6. Culottes 1 item
  7. Denim Dresses 3 items
  8. Denim Tops 1 item
  9. Earrings 0 items
  10. Flare Jeans 19 items
  11. Jumpsuits 1 item
  12. Maxi Dresses 8 items
  13. Midi Dresses 2 items
  14. Midi Skirts 2 items
  15. Off-shoulder And Bandeau Dresses 6 items
  16. Pencil Dresses 1 item
  17. Pencil Skirts 1 item
  18. Ripped Jeans 2 items
  19. Sets 11 items
  20. Shirts 1 item
  21. Short And Mini Skirts 1 item
  22. Skater Dresses 5 items
  23. Skater Skirts 2 items
  24. Skinny Jeans 3 items
  25. Straight Jeans 42 items
  26. T-shirts 6 items
  27. Vests And Camis 1 item
  28. Bralette 2 items
  29. Baggy Jeans 1 item
  30. Wide Leg Jeans 22 items
  31. Corsets & Tube Tops 26 items
  32. Corset Dresses 4 items
Colour
Colour
  1. Beige 1 item
  2. Black 3 items
  3. Blue 5 items
  4. Green 3 items
  5. Multi 1 item
  6. Pink 1 item
  7. Red 3 items
  8. Silver 1 item
  9. White 3 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 6 items
  3. 3XL 6 items
  4. L 29 items
  5. M 30 items
  6. S 30 items
  7. XL 13 items
  8. XS 6 items
Less
Price
Price
  1. Rs. 1000 - 1200 1 item
  2. Rs. 1200 - 1400 1 item
  3. Rs. 1600 - 1800 1 item
  4. Rs. 2000 - 2500 2 items
  5. Rs. 2500 - 3000 1 item
  6. Rs. 3000 - 3500 2 items
  1. Asymmetrical Dresses Remove This Item
  2. Earrings Remove This Item
  3. Skinny Jeans Remove This Item
  4. Red Remove This Item
  5. Blue Remove This Item
  6. XS 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_6605badf400d53_30360268` 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

8 styles found
  1. 58% Off
    -58%
    DARK-BLUE SKINNY SLIT JEANS
  2. 58% Off
    -58%
    LIGHT-BLUE SKINNY SLIT JEANS
  3. 58% Off
    -58%
    ROSE-RED HOLLOW ASYMMETRICAL DRESS
  4. 80% Off
    -80%
    FULL OF CHARM BLUE JEANS