IMPORTANT: In case, the actual weight is more so we will contact you for additional charges before shipping.<\/strong><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-29 13:58:18","push_to_top_date":"2023-08-29 13:58:18","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"111408","author_id":"admin","product_sku":"TM-111369","product_hsn":"5407","product_name":"Zeel D.no-7811 Hit Designer Ethnic Wedding Wear Lehenga Choli ","cname":"Full Catalog Available At Wholesale Rate","product_seo_url":"zeel-d-no-7811-hit-designer-ethnic-wedding-wear-lehenga-choli","product_image":"images\/product\/2023\/08\/zeel-d-no-7811-hit-designer-ethnic-wedding-wear-lehenga-choli-2023-08-28_14_22_45.jpeg","product_qty":"12","catalog_pcs":"6","catelog_set":"","product_price":"2999","product_mrp_price":"3399","product_sale_price":"17994","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"24","product_stitch":"Semi Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Indian Latest Designer Lehenga Choli Collection. Exclusive with Embroidery Work gives a Fashionable Look, High sensed style and luxury makes you ready for envious glazes and very rich & Royal in the Party, Function, Event etc.","product_full_description":"","product_status":"Publish","product_meta_title":"Zeel D.no-7811 Hit Designer Ethnic Wedding Wear Lehenga Choli ","product_meta_keyword":"INDIAN DESIGNER LEHENGA CHOLI, FESTIVAL LEHENGA CHOLI, PARTYWEAR LEHENGA CHOLI, WHOLESALE LEHENGA CHOLI, WEDDING LEHENGA, NAVRATRI LEHENGA CHOLI, ZEEL LEHENGA CHOLI,","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"Attract compliments with this enticing yellow color lehenga made of slub silk material embellished with dori work, zari sequin work, and embroidery work. <\/p>\r\n\r\n
Lehenga (Semi-Stitched)
\r\nFabric: Slub Silk
\r\nWork: Zari, Sequins and Dori Embroidery Work
\r\nInner: Satin with can-can layered net.
\r\nFlair : 3.50 mtr
\r\nSize : waist-43" Length-43"<\/p>\r\n\r\n
Blouse (Unstitched)
\r\nFabric: Slub Silk
\r\nColor: Matching
\r\nWork: Zari, Sequins and Dori Embroidery Work
\r\nFront Neck: V-Neck
\r\nBack Neck: Round Neck
\r\nSleeves: Elbow Sleeves
\r\nSize: up to 43"<\/p>\r\n\r\n
Dupatta
\r\nFabric: Soft Net
\r\nColor: Matching
\r\nWork: Zari, Sequins and Dori Embroidery Work
\r\nLength: 2.30 meter<\/p>\r\n\r\n
\r\n\t- DO NOTE:<\/strong> Accessories shown in the image are for presentation purposes only. Difference in Image colour v\/s Actual colour is possible because of photography lights. If any query, do WhatsApp us on +918154943468.<\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-28 14:22:45","push_to_top_date":"2023-08-28 14:22:45","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"111406","author_id":"admin","product_sku":"TM-111367","product_hsn":"5407","product_name":"Zeel Mandakani Vol-2 Traditional Style Festival & Partywear Lehenga Choli Collection ","cname":"Full Catalog Available At Wholesale Rate","product_seo_url":"zeel-mandakani-vol-2-traditional-style-festival-partywear-lehenga-choli-collection","product_image":"images\/product\/2023\/08\/zeel-mandakani-vol-2-traditional-style-festival-partywear-lehenga-choli-collection-2023-08-28_13_11_32.jpeg","product_qty":"15","catalog_pcs":"11","catelog_set":"","product_price":"3300","product_mrp_price":"3600","product_sale_price":"36300","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"33","product_stitch":"Semi Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Indian Latest Designer Lehenga Choli Collection. Exclusive with Embroidery Work gives a Fashionable Look, High sensed style and luxury makes you ready for envious glazes and very rich & Royal in the Party, Function, Event etc.","product_full_description":"","product_status":"Publish","product_meta_title":"Zeel Mandakani Vol-2 Traditional Style Festival & Partywear Lehenga Choli Collection ","product_meta_keyword":"INDIAN DESIGNER LEHENGA CHOLI, FESTIVAL LEHENGA CHOLI, PARTYWEAR LEHENGA CHOLI, WHOLESALE LEHENGA CHOLI, WEDDING LEHENGA, NAVRATRI LEHENGA CHOLI, ZEEL LEHENGA CHOLI, GHAGHAR CHOLI","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
BLOUSE FABRIC: SLUB SILK || LEHENGA FABRIC: ORGANZA\/CHINNON<\/p>\r\n\r\n
DUPATTA: SOFT NET<\/p>\r\n\r\n
WORK DETAILS: REAL MIRROR WITH THREAD, ZARI & SEQUIN EMBROIDERY AND DIGITAL PRINT WORK<\/p>\r\n","single_catalog":"0","product_date":"2023-08-28 13:11:32","push_to_top_date":"2023-08-28 13:11:32","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"110761","author_id":"admin","product_sku":"TM-110725","product_hsn":"5407","product_name":"Zeel Expression Vol-1Georgette Partywear Lehenga","cname":"Full Catalog Available At Wholesale Rate","product_seo_url":"zeel-expression-vol-1georgette-partywear-lehenga","product_image":"images\/product\/2023\/08\/zeel-expression-vol-1georgette-partywear-lehenga-1-2023-08-03_16_25_37.jpeg","product_qty":"5","catalog_pcs":"11","catelog_set":"","product_price":"3000","product_mrp_price":"4200","product_sale_price":"33000","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"44","product_stitch":"Semi Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Indian Latest Designer Lehenga Collection. Exclusive with Embroidery Work gives a Fashionable Look, High sensed style and luxury makes you ready for envious glazes and very rich & Royal in the Party, Function, Event etc.","product_full_description":"","product_status":"Publish","product_meta_title":"Zeel Expression Vol-1Georgette Partywear Lehenga","product_meta_keyword":"INDIAN DESIGNER LEHENGA, FESTIVAL LEHENGA, PARTYWEAR LEHENGA, WHOLESALE LEHENGA, FESTIVE-WEAR LEHENGA","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
\r\n\t- STYLE<\/strong>: This is Semi Stitched Lehenga with Unstitched Choli and Dupatta in Stylish Pattern.<\/li>\r\n\t
- FABRIC<\/strong>: Lehenga: Georgette || Choli: Georgette || Dupatta: Soft Net<\/li>\r\n\t
- WORK<\/strong>: A stunning Lehenga with Sequin And Zari Embroidery, Mirror Work<\/li>\r\n\t
- FEATURE<\/strong>: Flair: 4 mtr approx. | Lehenga length: 42 inches approx. || Dupatta Length: 2.40 Mtr approx. || Choli Length – 1 Meter approx. || Sleeve length :10″ approx.<\/li>\r\n\t
- WHY BUY FROM US<\/strong> – All our collections are 100% original & as shown in the picture.<\/li>\r\n\t
- DO NOTE<\/strong>: Accessories shown in the image are for presentation purposes only. (Slight variation in actual colour vs. image is possible.) If any query, do WhatsApp us on +918154943468 & mail us on info@textilemela.com<\/a><\/li>\r\n\t
- IMPORTANT: In case, the actual weight is more so we will contact you for additional charges before shipping.<\/strong><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-08-03 16:25:37","push_to_top_date":"2023-08-03 16:25:37","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"110169","author_id":"admin","product_sku":"TM-110140","product_hsn":"6208","product_name":"Zeel The Shimmers Vol-1 Dno Indian Women Traditional Soft Net Lehenga Choli Wedding Party Wear Ghagra Choli At Wholesale Price ","cname":"Bala8974","product_seo_url":"zeel-the-shimmers-vol-1-dno-indian-women-traditional-soft-net-lehenga-choli-wedding-party-wear-ghagra-choli-at-wholesale-price","product_image":"images\/product\/2023\/05\/zeel-the-shimmers-vol-1-dno-indian-women-traditional-soft-net-lehenga-choli-wedding-party-wear-ghagra-choli-at-wholesale-price-2023-05-24_16_02_01.jpeg","product_qty":"5","catalog_pcs":"9","catelog_set":"","product_price":"3999","product_mrp_price":"3999","product_sale_price":"35991","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"15","product_stitch":"Unstitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Indian Latest Designer Lehenga Choli Collection. Exclusive with Embroidery Work gives a Fashionable Look, High sensed style and luxury makes you ready for envious glazes and very rich & Royal in the Party, Function, Event etc.","product_full_description":"","product_status":"Publish","product_meta_title":"Zeel The Shimmers Vol-1 Dno Indian Women Traditional Soft Net Lehenga Choli Wedding Party Wear Ghagra Choli At Wholesale Price ","product_meta_keyword":"lehenga choli ,wedding wear , cocktail wear lehenga choli , bollywood style lehnga choli , party wear ghagraa choli , chaniya choli","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
\r\n\t- STYLE<\/strong>: This is Semi Stitched Lehenga with Unstitched Choli and Dupatta in Stylish Pattern.<\/li>\r\n\t
- FABRIC<\/strong>: Lehenga: Soft Net || Choli: Soft Net || Dupatta: Soft Net<\/li>\r\n\t
- WORK<\/strong>: A stunning Lehenga with Zarkan, Thread Work.<\/li>\r\n\t
- FEATURE<\/strong>: Flair: 4 mtr approx. | Lehenga length: 42 inches approx. || Dupatta Length: 2.40 Mtr approx. || Choli Length – 1 Meter approx. || Sleeve length :10″ approx.<\/li>\r\n\t
- WHY BUY FROM US<\/strong> – All our collections are 100% original & as shown in the picture.<\/li>\r\n\t
- DO NOTE<\/strong>: Accessories shown in the image are for presentation purposes only. (Slight variation in actual colour vs. image is possible.) If any query, do WhatsApp us on +918178839036 & mail us on info@textilemela.com<\/a><\/li>\r\n\t
- IMPORTANT: In case, the actual weight is more so we will contact you for additional charges before shipping.<\/strong><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2023-05-24 16:02:01","push_to_top_date":"2023-05-24 16:02:01","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3-7 Days","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"105760","author_id":"admin","product_sku":"TM-105760","product_hsn":"6208","product_name":"BALAJI EMPORIUM PRESENTS MANDAKINI VOL-1 101 - 110 SERIES INDIAN WOMEN DESIGNER FANCY SILK LEHENGA GHAGRA CHOLI PARTY WEDDING FESTIVE WEAR COLLECTION 2959","cname":"BALA2959","product_seo_url":"balaji-emporium-presents-mandakini-vol-1-101-110-series-indian-women-designer-fancy-silk-lehenga-ghagra-choli-party-wedding-festive-wear-collection-2959","product_image":"images\/product\/2022\/08\/balaji-emporium-presents-mandakini-vol-1-101-110-series-indian-women-designer-fancy-silk-lehenga-ghagra-choli-party-wedding-festive-wear-collection-2959-2022-08-04_12_57_14.jpeg","product_qty":"5","catalog_pcs":"10","catelog_set":"","product_price":"3200","product_mrp_price":"3300","product_sale_price":"32000","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"10","product_stitch":"Unstitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Indian Latest Designer Bridal Lehenga Choli Collection. Exclusive with Embroidery Work gives a Fashionable Look, High sensed style and luxury makes you ready for envious glazes and very rich & Royal in the Party, Function, Event etc.","product_full_description":"","product_status":"Publish","product_meta_title":"BALAJI EMPORIUM PRESENTS MANDAKINI VOL-1 101 - 110 SERIES INDIAN WOMEN DESIGNER FANCY SILK LEHENGA GHAGRA CHOLI PARTY WEDDING FESTIVE WEAR COLLECTION 2959","product_meta_keyword":"bridal lehenga choli , party wear lehenga choli , lehenga choli , ghagra choli , party , wedding wear women , indian designer , net , velvet lehenga choli , bridal women ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
\r\n\t- STYLE<\/strong>: This is Semi Stitched Lehenga with Unstitched Choli and Dupatta in Stylish Pattern.<\/li>\r\n\t
- FABRIC<\/strong>: Lehenga: Fancy silk || Choli: Fancy silk || Dupatta: Net<\/li>\r\n\t
- WORK<\/strong>: A stunning Lehenga with Zarkan, Thread Work.<\/li>\r\n\t
- FEATURE<\/strong>: Flair: 4 mtr approx. | Lehenga length: 42 inches approx. || Dupatta Length: 2.40 Mtr approx. || Choli Length – 1 Meter approx. || Sleeve length :10″ approx.<\/li>\r\n\t
- WHY BUY FROM US<\/strong> – All our collections are 100% original & as shown in the picture.<\/li>\r\n\t
- DO NOTE<\/strong>: Accessories shown in the image are for presentation purposes only. (Slight variation in actual colour vs. image is possible.) If any query, do WhatsApp us on +918076953198 & mail us on info@textilemela.com<\/a><\/li>\r\n\t
- IMPORTANT: In case, the actual weight is more so we will contact you for additional charges before shipping.<\/strong><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2022-08-04 12:57:14","push_to_top_date":"2022-08-04 12:57:14","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"93922","author_id":"","product_sku":"SD-93922","product_hsn":"6208","product_name":"Balaji Emporium Presents Carnations Dno 7507 Designer Party Cocktail Wear Lehenga At Wholesale Price","cname":"BALAM13","product_seo_url":"balaji-emporium-presents-carnations-dno-7507-designer-party-cocktail-wear-lehenga-at-wholesale-price","product_image":"images\/product\/2022\/03\/COVER-13-1.jpeg","product_qty":"3","catalog_pcs":"1","catelog_set":"Single","product_price":"2500","product_mrp_price":"2995","product_sale_price":"2500","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"2.5","product_stitch":"Unstitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"Indian Latest Designer Lehenga Choli Collection. Exclusive with Embroidery Work gives a Fashionable Look, High sensed style and luxury makes you ready for envious glazes and very rich & Royal in the Party, Function, Event etc","product_full_description":"","product_status":"publish","product_meta_title":"Balaji Emporium Presents Carnations Dno 7507 Designer Party Cocktail Wear Lehenga At Wholesale Price","product_meta_keyword":"DESIGNER LEHENGA, PARTY WEAR LEHENGA CHOLI, FESTIVAL LEHENGA","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":"
\r\n\t- STYLE<\/strong>: This is Semi Stitched Lehenga with Unstitched Choli and Dupatta in Stylish Pattern.<\/li>\r\n\t
- FABRIC<\/strong>: Lehenga: Art silk || Choli: Art silk || Dupatta: Net<\/li>\r\n\t
- WORK<\/strong>: A stunning Lehenga with Zarkan, Thread Work, Sequence Work.<\/li>\r\n\t
- FEATURE<\/strong>: Flair: 4 mtr approx. | Lehenga length: 42 inches approx. || Dupatta Length: 2.40 Mtr approx. || Choli Length – 1 Meter approx. || Sleeve length :10″ approx.<\/li>\r\n\t
- WHY BUY FROM US<\/strong> – All our collections are 100% original & as shown in the picture.<\/li>\r\n\t
- DO NOTE<\/strong>: Accessories shown in the image are for presentation purposes only. (Slight variation in actual colour vs. image is possible.) If any query, do WhatsApp us on +91 8154943468 & mail us on info@textilemela.com<\/a><\/li>\r\n\t
- IMPORTANT: In case, the actual weight is more so we will contact you for additional charges before shipping.<\/strong><\/li>\r\n<\/ul>\r\n","single_catalog":"0","product_date":"2022-03-29 11:29:21","push_to_top_date":"2022-07-19 15:10:00","delivery_date":"2022-04-05","fabric":"","availability":"On Booking","permalink":"https:\/\/textilemela.com\/portfolio\/balaji-emporium-presents-carnations-dno-7507-designer-party-cocktail-wear-lehenga-at-wholesale-price","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"1"}}],"ggg":"select pm.* from brand_relation_master as brm left join product_master as pm on pm.product_id=brm.product_id where 1=1 and pm.product_price!=0 and brm.brand_id='258' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}