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 (288667, 288659, 288657, 288656, 288632, 288631, 288626, 288620, 288612, 288611, 252516, 252484, 250766, 250756, 250751, 250743, 250702, 250701, 246129, 246071, 240149, 240141, 240132, 240122)) ORDER BY FIELD(e.entity_id,288667,288659,288657,288656,288632,288631,288626,288620,288612,288611,252516,252484,250766,250756,250751,250743,250702,250701,246129,246071,240149,240141,240132,240122)
Page
Sort by
Items 25-48 of 263
FILTER
Now Shopping by
  1. Work
    Resham Work
  2. Readymade Size
    50
Clear All
Category
Style
  1. Kurta Pajama with Nehru Jacket
  2. Kurta Sets
  3. Men's Kurta
  4. Skirt Set
  5. Anarkali
  6. Pakistani
  7. Palazzo Suits
  8. Pant Suits
  9. Printed
  10. Sharara Suits
  11. Angrakha Style
  12. Straight Cut
  13. Suits with Slit
  14. A Line
  15. Twin Layered
  16. Kurta Pajama
  17. Jacket Style
  18. Heavy Sleeves
  19. Heavy Yoke
  20. Sherwani
  21. Indo Western Sherwani
  22. Nehru Jacket
  23. Heavy Blouse
  24. Asymmetric
  25. Traditional
  26. Dhoti with Sherwani
  27. Designer
  28. Contemporary
  29. Dresses
  30. Gowns
  31. Kaftan
  32. Kurtis
  33. Long Kurta
  34. Gharara
Occasion
  1. Festive
  2. Bridesmaid Lehenga
  3. Wedding
  4. Reception
  5. Engagement
  6. Mehendi
  7. Party
  8. Cocktail
  9. Casual
  10. Groom
Fabric
  1. Art Silk
  2. Brocade
  3. Chiffon
  4. Cotton
  5. Crape
  6. Dupion Silk
  7. Georgette
  8. Jacquard
  9. Rayon
  10. Satin
  11. Silk
  12. Velvet
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
Customizable Size
  1. 34
  2. 36
  3. 38
  4. 40
  5. 42
  6. 44
Tailoring Options
  1. Readymade
FILTER
Now Shopping by
  1. Work
    Resham Work
  2. Readymade Size
    50
Category
Style
  1. Kurta Pajama with Nehru Jacket
  2. Kurta Sets
  3. Men's Kurta
  4. Skirt Set
  5. Anarkali
  6. Pakistani
  7. Palazzo Suits
  8. Pant Suits
  9. Printed
  10. Sharara Suits
  11. Angrakha Style
  12. Straight Cut
  13. Suits with Slit
  14. A Line
  15. Twin Layered
  16. Kurta Pajama
  17. Jacket Style
  18. Heavy Sleeves
  19. Heavy Yoke
  20. Sherwani
  21. Indo Western Sherwani
  22. Nehru Jacket
  23. Heavy Blouse
  24. Asymmetric
  25. Traditional
  26. Dhoti with Sherwani
  27. Designer
  28. Contemporary
  29. Dresses
  30. Gowns
  31. Kaftan
  32. Kurtis
  33. Long Kurta
  34. Gharara
Occasion
  1. Festive
  2. Bridesmaid Lehenga
  3. Wedding
  4. Reception
  5. Engagement
  6. Mehendi
  7. Party
  8. Cocktail
  9. Casual
  10. Groom
Fabric
  1. Art Silk
  2. Brocade
  3. Chiffon
  4. Cotton
  5. Crape
  6. Dupion Silk
  7. Georgette
  8. Jacquard
  9. Rayon
  10. Satin
  11. Silk
  12. Velvet
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
Customizable Size
  1. 34
  2. 36
  3. 38
  4. 40
  5. 42
  6. 44
Tailoring Options
  1. Readymade
SORT
FILTER
© 2025 <span>Panash India</span> A unit of Indian Attires - All rights reserved.