SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`image`, `e`.`small_image`, `e`.`thumbnail`, `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`.`amstcred_amount`, `e`.`amstcred_allow_open_amount`, `e`.`amstcred_open_amount_min`, `e`.`amstcred_open_amount_max`, `e`.`amstcred_price_type`, `e`.`amstcred_price_type_value`, `e`.`amstcred_price_percent`, `e`.`occasion`, `e`.`style`, `e`.`fabric`, `e`.`size`, `e`.`size_value`, `e`.`time_to_ship`, `e`.`time_to_ship_value`, `e`.`time_to_ship_display`, `e`.`work`, `e`.`customizable_size`, `e`.`blouse_neck_style`, `e`.`blouse_sleeves`, `e`.`readymadesize`, `e`.`amxnotif_hide_alert`, `e`.`productcategory`, `e`.`productcategory_value`, `e`.`tailoringoptions`, `e`.`tailoringoptions_value`, `e`.`swatch_image`, `e`.`aw_arp_override_native`, `e`.`featured`, `e`.`amstore_credit_prices`, `e`.`amstore_credit_open_amount`, `e`.`amstore_credit_open_amount_min`, `e`.`amstore_credit_open_amount_max`, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_flat_1` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (e.entity_id IN (293828, 293823, 293813, 293800, 293797, 293788, 293775, 293765, 293746, 293444, 293442, 293440, 293437, 293426, 293151, 293073, 290562, 290561, 289877, 289876, 288644, 288630, 288608, 288602)) ORDER BY FIELD(e.entity_id,293828,293823,293813,293800,293797,293788,293775,293765,293746,293444,293442,293440,293437,293426,293151,293073,290562,290561,289877,289876,288644,288630,288608,288602)
Page
Sort by
Items 49-72 of 434
FILTER
Now Shopping by
  1. Work
    Zari
  2. Readymade Size
    50
Clear All
Category
Style
  1. Bandhgala Jodhpuri
  2. Kurta Pajama with Nehru Jacket
  3. Kurta Sets
  4. Men's Kurta
  5. Sherwani with Anarkali Kurta
  6. Skirt Set
  7. Anarkali
  8. Abaya Style
  9. Pakistani
  10. Palazzo Suits
  11. Pant Suits
  12. Printed
  13. Punjabi Suits
  14. Sharara Suits
  15. Angrakha Style
  16. Straight Cut
  17. Suits with Slit
  18. A Line
  19. Twin Layered
  20. Kurta Pajama
  21. Jacket Style
  22. Heavy Sleeves
  23. Heavy Yoke
  24. Sherwani
  25. Indo Western Sherwani
  26. Nehru Jacket
  27. Heavy Blouse
  28. Asymmetric
  29. Traditional
  30. Dhoti with Sherwani
  31. Designer
  32. Contemporary
  33. Dhoti with Kurta
  34. Dresses
  35. Kaftan
  36. Kurtis
  37. Long Kurta
  38. Gharara
Occasion
  1. Festive
  2. Groomsmen
  3. Bridesmaid Lehenga
  4. Wedding
  5. Reception
  6. Engagement
  7. Mehendi
  8. Sangeet
  9. Bridal
  10. Party
  11. Cocktail
  12. Casual
  13. Groom
Fabric
  1. Cotton
  2. Art Silk
  3. Banarasi Silk
  4. Brocade
  5. Chanderi
  6. Chiffon
  7. Cotton
  8. Crape
  9. Dupion Silk
  10. Georgette
  11. Jacquard
  12. Jute
  13. Linen
  14. Net
  15. Organza
  16. Rayon
  17. Satin
  18. Silk
  19. Velvet
  20. Viscose
Work
  1. Chikankari Work
  2. Cutbeads
  3. Abstract Print
  4. Applique
  5. Bandhej
  6. Beads Work
  7. Block Print
  8. Crochet Lace
  9. Cut Beads
  10. Cut Work
  11. Digital Print
  12. Dori
  13. Embroidered
  14. Floral Print
  15. Foil Print
  16. Geometric Print
  17. Gota Patti
  18. Hand Work
  19. Kundan Work
  20. Lace
  21. Leheria
  22. Mirror Work
  23. Patch Border
  24. Patch Work
  25. Plain
  26. Polka Dot Print
  27. Print
  28. Printed
  29. Resham Work
  30. Schiffli
  31. Sequins
  32. Stone Work
  33. Stripes Print
  34. Thread
  35. Tie-Dye Print
  36. Woven
  37. Zardosi Work
  38. Zari
Price
Time to ship
  1. Within 1 Day
  2. Within 10 Days
  3. Within 15 Days
  4. Within 21 Days
  5. Within 30 Days
Gender
  1. Female
  2. Male
Readymade Size
  1. 3
  2. 4
  3. 5
  4. 6
  5. 7
  6. 8
  7. 9
  8. 10
  9. 11
  10. 12
  11. 13
  12. 28
  13. 30
  14. 32
  15. 34
  16. 36
  17. 38
  18. 40
  19. 42
  20. 44
  21. 46
  22. 48
  23. 50
  24. 52
  25. 54
  26. 56
  27. 58
  28. 60
  29. 62
  30. 64
  31. 66
  32. 68
  33. 70
Tailoring Options
  1. Readymade
FILTER
Now Shopping by
  1. Work
    Zari
  2. Readymade Size
    50
Category
Style
  1. Bandhgala Jodhpuri
  2. Kurta Pajama with Nehru Jacket
  3. Kurta Sets
  4. Men's Kurta
  5. Sherwani with Anarkali Kurta
  6. Skirt Set
  7. Anarkali
  8. Abaya Style
  9. Pakistani
  10. Palazzo Suits
  11. Pant Suits
  12. Printed
  13. Punjabi Suits
  14. Sharara Suits
  15. Angrakha Style
  16. Straight Cut
  17. Suits with Slit
  18. A Line
  19. Twin Layered
  20. Kurta Pajama
  21. Jacket Style
  22. Heavy Sleeves
  23. Heavy Yoke
  24. Sherwani
  25. Indo Western Sherwani
  26. Nehru Jacket
  27. Heavy Blouse
  28. Asymmetric
  29. Traditional
  30. Dhoti with Sherwani
  31. Designer
  32. Contemporary
  33. Dhoti with Kurta
  34. Dresses
  35. Kaftan
  36. Kurtis
  37. Long Kurta
  38. Gharara
Occasion
  1. Festive
  2. Groomsmen
  3. Bridesmaid Lehenga
  4. Wedding
  5. Reception
  6. Engagement
  7. Mehendi
  8. Sangeet
  9. Bridal
  10. Party
  11. Cocktail
  12. Casual
  13. Groom
Fabric
  1. Cotton
  2. Art Silk
  3. Banarasi Silk
  4. Brocade
  5. Chanderi
  6. Chiffon
  7. Cotton
  8. Crape
  9. Dupion Silk
  10. Georgette
  11. Jacquard
  12. Jute
  13. Linen
  14. Net
  15. Organza
  16. Rayon
  17. Satin
  18. Silk
  19. Velvet
  20. Viscose
Work
  1. Chikankari Work
  2. Cutbeads
  3. Abstract Print
  4. Applique
  5. Bandhej
  6. Beads Work
  7. Block Print
  8. Crochet Lace
  9. Cut Beads
  10. Cut Work
  11. Digital Print
  12. Dori
  13. Embroidered
  14. Floral Print
  15. Foil Print
  16. Geometric Print
  17. Gota Patti
  18. Hand Work
  19. Kundan Work
  20. Lace
  21. Leheria
  22. Mirror Work
  23. Patch Border
  24. Patch Work
  25. Plain
  26. Polka Dot Print
  27. Print
  28. Printed
  29. Resham Work
  30. Schiffli
  31. Sequins
  32. Stone Work
  33. Stripes Print
  34. Thread
  35. Tie-Dye Print
  36. Woven
  37. Zardosi Work
  38. Zari
Price
Time to ship
  1. Within 1 Day
  2. Within 10 Days
  3. Within 15 Days
  4. Within 21 Days
  5. Within 30 Days
Gender
  1. Female
  2. Male
Readymade Size
  1. 3
  2. 4
  3. 5
  4. 6
  5. 7
  6. 8
  7. 9
  8. 10
  9. 11
  10. 12
  11. 13
  12. 28
  13. 30
  14. 32
  15. 34
  16. 36
  17. 38
  18. 40
  19. 42
  20. 44
  21. 46
  22. 48
  23. 50
  24. 52
  25. 54
  26. 56
  27. 58
  28. 60
  29. 62
  30. 64
  31. 66
  32. 68
  33. 70
Tailoring Options
  1. Readymade
SORT
FILTER
© 2025 <span>Panash India</span> A unit of Indian Attires - All rights reserved.