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

Briefs

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Sets 44 items
  2. Hipster 80 items
  3. Bikini 133 items
  4. Boyshort 117 items
  5. Thong 509 items
  6. Cycling Short 1 item
  7. Boyleg 6 items
Colour
Colour
  1. Beige 59 items
  2. Black 141 items
  3. Blue 82 items
  4. Brown 32 items
  5. Green 57 items
  6. Grey 15 items
  7. Maroon 5 items
  8. Multi 155 items
  9. Orange 3 items
  10. Pink 127 items
  11. Purple 41 items
  12. Red 124 items
  13. White 100 items
  14. Yellow 4 items
Less
Size
Size
  1. 1XL 49 items
  2. 2XL 55 items
  3. 3XL 54 items
  4. 4XL 52 items
  5. FS 369 items
  6. L 370 items
  7. M 378 items
  8. S 265 items
  9. XL 213 items
  10. XXL 29 items
  11. 0XL 10 items
Less
Price
Price
  1. Rs. 0 - 200 175 items
  2. Rs. 200 - 400 459 items
  3. Rs. 400 - 600 206 items
  4. Rs. 600 - 800 5 items
  5. Rs. 800 - 1000 13 items
  6. Rs. 1200 - 1400 6 items
  7. Rs. 1400 - 1600 6 items
  8. Rs. 1800 - 2000 10 items
  9. Rs. 2000 - 2500 18 items
  10. Rs. 2500 - 3000 1 item

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=1524 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_672a9c60e621e9_01314474` 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

899 styles found
  1. 65% Off
    -65%
    Satin Lace Brown Thong
  2. 60% Off
    -60%
    LOW-WAISTED BLUE ICE-SILK THONG
  3. 92% Off
    -92%
    LIFELINE LOVE BOYSHORTS SET
  4. 65% Off
    -65%
    PRINTED-STRAP BEIGE FS THONG
  5. 60% Off
    -60%
    LOW-WAISTED CLARET ICE-SILK THONG