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 (265354, 265348, 265331, 265330, 265324, 265317, 265316, 265314, 265310, 265308, 265296, 265291, 265289, 265280, 265278, 265267, 265257, 265256, 265238, 264610, 264609, 263725, 263719, 263716)) ORDER BY FIELD(e.entity_id,265354,265348,265331,265330,265324,265317,265316,265314,265310,265308,265296,265291,265289,265280,265278,265267,265257,265256,265238,264610,264609,263725,263719,263716)
Page
Sort by
Items 145-168 of 272
FILTER
Now Shopping by
  1. Style
    Kurta Pajama
  2. Work
    Sequins
  3. Readymade Size
    52
Clear All
Category
Style
  1. Bandhgala Jodhpuri
  2. Co-ord Sets
  3. Kurta Pajama with Nehru Jacket
  4. Kurta Sets
  5. Plunge Neck
  6. Sherwani with Anarkali Kurta
  7. Skirt Set
  8. Anarkali
  9. Abaya Style
  10. Pakistani
  11. Palazzo Suits
  12. Pant Suits
  13. Printed
  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. Kurti Style Lehenga
  28. Heavy Blouse
  29. Asymmetric
  30. Classic Style
  31. Dhoti with Sherwani
  32. Designer
  33. Contemporary
  34. Dhoti with Kurta
  35. Dresses
  36. Gowns
  37. Jumpsuit
  38. Kaftan
  39. Kurtis
  40. Long Kurta
  41. Gharara
Occasion
  1. Festive
  2. Groomsmen
  3. Wedding
  4. Reception
  5. Engagement
  6. Haldi
  7. Sangeet
  8. Party
  9. Casual
  10. Groom
Fabric
  1. Cotton
  2. Art Silk
  3. Banarasi Silk
  4. Brocade
  5. Chanderi
  6. Cotton
  7. Georgette
  8. Jacquard
  9. Linen
  10. Rayon
  11. Satin
  12. Silk
  13. Velvet
  14. Viscose
Work
  1. Chikankari Work
  2. Abstract Print
  3. Applique
  4. Bandhej
  5. Beads Work
  6. Cut Beads
  7. Digital Print
  8. Dori
  9. Embroidered
  10. Floral Print
  11. Foil Print
  12. Geometric Print
  13. Gota Patti
  14. Hand Work
  15. Lace
  16. Mirror Work
  17. Patch Border
  18. Patch Work
  19. Plain
  20. Print
  21. Printed
  22. Resham Work
  23. Sequins
  24. Stone Work
  25. Stripes Print
  26. Thread
  27. Tie-Dye Print
  28. Woven
  29. Zari
Price
Time to ship
  1. Within 10 Days
  2. Within 15 Days
  3. Within 21 Days
  4. Within 30 Days
Readymade Size
  1. 32
  2. 34
  3. 36
  4. 38
  5. 40
  6. 42
  7. 44
  8. 46
  9. 48
  10. 50
  11. 52
  12. 54
  13. 56
  14. 58
  15. 60
  16. 62
  17. 64
  18. 66
  19. 68
  20. 70
FILTER
Now Shopping by
  1. Style
    Kurta Pajama
  2. Work
    Sequins
  3. Readymade Size
    52
Category
Style
  1. Bandhgala Jodhpuri
  2. Co-ord Sets
  3. Kurta Pajama with Nehru Jacket
  4. Kurta Sets
  5. Plunge Neck
  6. Sherwani with Anarkali Kurta
  7. Skirt Set
  8. Anarkali
  9. Abaya Style
  10. Pakistani
  11. Palazzo Suits
  12. Pant Suits
  13. Printed
  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. Kurti Style Lehenga
  28. Heavy Blouse
  29. Asymmetric
  30. Classic Style
  31. Dhoti with Sherwani
  32. Designer
  33. Contemporary
  34. Dhoti with Kurta
  35. Dresses
  36. Gowns
  37. Jumpsuit
  38. Kaftan
  39. Kurtis
  40. Long Kurta
  41. Gharara
Occasion
  1. Festive
  2. Groomsmen
  3. Wedding
  4. Reception
  5. Engagement
  6. Haldi
  7. Sangeet
  8. Party
  9. Casual
  10. Groom
Fabric
  1. Cotton
  2. Art Silk
  3. Banarasi Silk
  4. Brocade
  5. Chanderi
  6. Cotton
  7. Georgette
  8. Jacquard
  9. Linen
  10. Rayon
  11. Satin
  12. Silk
  13. Velvet
  14. Viscose
Work
  1. Chikankari Work
  2. Abstract Print
  3. Applique
  4. Bandhej
  5. Beads Work
  6. Cut Beads
  7. Digital Print
  8. Dori
  9. Embroidered
  10. Floral Print
  11. Foil Print
  12. Geometric Print
  13. Gota Patti
  14. Hand Work
  15. Lace
  16. Mirror Work
  17. Patch Border
  18. Patch Work
  19. Plain
  20. Print
  21. Printed
  22. Resham Work
  23. Sequins
  24. Stone Work
  25. Stripes Print
  26. Thread
  27. Tie-Dye Print
  28. Woven
  29. Zari
Price
Time to ship
  1. Within 10 Days
  2. Within 15 Days
  3. Within 21 Days
  4. Within 30 Days
Readymade Size
  1. 32
  2. 34
  3. 36
  4. 38
  5. 40
  6. 42
  7. 44
  8. 46
  9. 48
  10. 50
  11. 52
  12. 54
  13. 56
  14. 58
  15. 60
  16. 62
  17. 64
  18. 66
  19. 68
  20. 70
SORT
FILTER
© 2025 <span>Panash India</span> A unit of Indian Attires - All rights reserved.