app-download-header
Everything under Rs.999
20% Cashback* on Buy 4 items. , Use Code: CB20
20% Cashback* on Buy 4 items.
Use Code: CB20
HR
:
MN
:
SC
ENDS IN

Bottom

Filter
Shopping Options
Category
Category
Colour
Colour
  1. Beige 17 items
  2. Black 74 items
  3. Blue 60 items
  4. Brown 48 items
  5. Green 48 items
  6. Grey 39 items
  7. Maroon 2 items
  8. Multi 10 items
  9. Orange 13 items
  10. Pink 41 items
  11. Purple 21 items
  12. Red 10 items
  13. White 17 items
  14. Yellow 5 items
Less
Size
Size
  1. 2XL 34 items
  2. 3XL 5 items
  3. FS 1 item
  4. L 372 items
  5. L/XL 2 items
  6. M 374 items
  7. S 371 items
  8. S/M 2 items
  9. XL 259 items
  10. XS 24 items
  11. XXL 2 items
Less
Price
Price
  1. Rs. 200 - 400 1 item
  2. Rs. 600 - 800 11 items
  3. Rs. 800 - 1000 22 items
  4. Rs. 1000 - 1200 6 items
  5. Rs. 1200 - 1400 40 items
  6. Rs. 1400 - 1600 58 items
  7. Rs. 1600 - 1800 49 items
  8. Rs. 1800 - 2000 36 items
  9. Rs. 2000 - 2500 124 items
  10. Rs. 2500 - 3000 47 items
  11. Rs. 3000 - 3500 5 items
  12. Rs. 3500 - 4000 1 item
  13. Rs. 4000 - 4500 5 items
Brand
Brand
  1. LULUANDSKY 394 items
  2. KOSHA YOGA 11 items

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `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_entity` 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=1537 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_672ade68c6ade6_09845388` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` ASC, `e`.`entity_id` DESC LIMIT 24

405 styles found
  1. 60% Off
    -60%
    CRIMSON HIGH-WAIST YOGA LEGGINGS
  2. 75% Off
    -75%
    Apricot Tiered Tie-up Sports Skirt
  3. 60% Off
    -60%
    ULTRA HIGH WAIST GREY YOGA PANTS
  4. 65% Off
    -65%
    FREE SPIRIT PURPLE SHORTS
  5. 64% Off
    -64%
    Green High-waisted Sports Shorts
  6. 60% Off
    -60%
    SO CONVENIENT WINE YOGA PANTS
  7. 63% Off
    -63%
    Black Slit Activewear Flare Pants
  8. 85% Off
    -85%
    STARK AND SWEET ORANGE YOGA PANTS
  9. 60% Off
    -60%
    SO CONVENIENT GREY YOGA PANTS
  10. 60% Off
    -60%
    YELLOW HIGH-WAIST YOGA LEGGINGS
  11. 60% Off
    -60%
    PRINTED PINK TIE-DYE GREY GYM SHORTS
  12. 60% Off
    -60%
    ULTRA HIGH WAIST BLUE YOGA PANTS
  13. 63% Off
    -63%
    Grey Blue Ombre Sports Tights