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\r\nIMPORTANT: In case, the actual weight is more so we will contact you for additional charges before shipping.<\/strong><\/p>\r\n","single_catalog":"0","product_date":"2022-07-23 16:55:34","push_to_top_date":"2022-07-23 16:55:34","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"105383","author_id":"admin","product_sku":"TM-105383","product_hsn":"5407","product_name":"ROYAL PRESENTS VRINDAVAN VOL-25 10166 TO 10180 SERIES DESIGNER SILK SAREES COLLECTION AT WHOLESALE PRICE","cname":"BALA2862","product_seo_url":"royal-presents-vrindavan-vol-25-10166-to-10180-series-designer-silk-sarees-collection-at-wholesale-price","product_image":"images\/product\/2022\/07\/royal-presents-vrindavan-vol-25-10166-to-10180-series-designer-silk-sarees-collection-at-wholesale-price-2022-07-20_15_18_08.jpeg","product_qty":"5","catalog_pcs":"15","catelog_set":"","product_price":"2280","product_mrp_price":"2350","product_sale_price":"34200","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"22.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 Sarees 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":"ROYAL PRESENTS VRINDAVAN VOL-25 10166 TO 10180 SERIES DESIGNER SILK SAREES COLLECTION AT WHOLESALE PRICE","product_meta_keyword":"SILK SAREES, WEDDING SAREES, PARTY WEAR SAREES","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> Eye-catching Women Designer Silk Saree comes with Unstitched Blouse Piece in Rich look.<\/li>\r\n\t
- FABRIC:<\/strong> Saree: Silk || Blouse: Silk<\/li>\r\n\t
- LENGTH:<\/strong> The Total Length of the Saree is 6.3 mtr including Blouse Piece || Width: 44″ Inches (approx.) || Unstitched Blouse Length: 1 mtr (Approx.), Width: 44″ (Approx.): Unstitched blouse fabric comes with saree so you can make as you like<\/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. 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\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-07-20 15:18:08","push_to_top_date":"2022-07-20 15:18:08","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"96321","author_id":"","product_sku":"SD-96321","product_hsn":"5407","product_name":"Royal Presents Vrindavan Vol-23 10151 - 10165 Series Designer Silk Saree Royal At Wholesale Price","cname":"2468","product_seo_url":"royal-presents-vrindavan-vol-23-10151-10165-series-designer-silk-saree-royal-at-wholesale-price","product_image":"images\/product\/2022\/07\/royal-presents-vrindavan-vol-23-10151-10165-series-designer-silk-saree-royal-at-wholesale-price-2022-07-18_14_15_48.jpeg","product_qty":"3","catalog_pcs":"15","catelog_set":"Single","product_price":"2280","product_mrp_price":"2350","product_sale_price":"34200","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"22.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 Sarees 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":"Royal Presents Vrindavan Vol-23 10151 - 10165 Series Designer Silk Saree Royal At Wholesale Price","product_meta_keyword":"DESIGNER SAREES, SILK SAREES, PARTY WEAR SAREES, WEDDING SAREES","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> Eye-catching Women Designer Silk Saree comes with Unstitched Blouse Piece in Rich look.<\/li>\r\n\t
- FABRIC:<\/strong> Saree: Silk || Blouse: Silk<\/li>\r\n\t
- LENGTH:<\/strong> The Total Length of the Saree is 6.3 mtr including Blouse Piece || Width: 44″ Inches (approx.) || Unstitched Blouse Length: 1 mtr (Approx.), Width: 44″ (Approx.): Unstitched blouse fabric comes with saree so you can make as you like<\/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. 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\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-04-16 12:05:54","push_to_top_date":"2022-07-18 14:15:00","delivery_date":"2022-04-23","fabric":"","availability":"On Booking","permalink":"https:\/\/textilemela.com\/portfolio\/royal-presents-vrindavan-vol-23-10151-10165-series-designer-silk-saree-royal-at-wholesale-price","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"95797","author_id":"","product_sku":"SD-95797","product_hsn":"6308","product_name":"Royal Presents Vol-23 994 - 1000 Series Designer Lehenga Choli Bridal Wear At Wholesale Price","cname":"BALA2365","product_seo_url":"royal-presents-vol-23-994-1000-series-designer-lehenga-choli-bridal-wear-at-wholesale-price","product_image":"images\/product\/2022\/04\/COVER-2365.jpeg","product_qty":"3","catalog_pcs":"7","catelog_set":"Single","product_price":"12955","product_mrp_price":"13355","product_sale_price":"90685","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"56","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":"Royal Presents Vol-23 994 - 1000 Series Designer Lehenga Choli Bridal Wear At Wholesale Price","product_meta_keyword":"BRIDAL LEHENGA CHOLI, DESIGNER LEHENGA 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: Fancy || Choli: Fancy || Dupatta: Fancy<\/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 +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-04-10 10:34:08","push_to_top_date":"2022-07-16 15:11:00","delivery_date":"2022-04-17","fabric":"","availability":"On Booking","permalink":"https:\/\/textilemela.com\/portfolio\/royal-presents-vol-23-994-1000-series-designer-lehenga-choli-bridal-wear-at-wholesale-price","note":"","shipping_days":"","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"100111","author_id":"","product_sku":"SD-100111","product_hsn":"6208","product_name":"ROYAL PRESENTS VRUNDAVAN VOL-17 DNO 10118 INDIAN WOMEN DESIGNER BANARSI SILK LEHENGA CHOLI GHAGRA PARTY WEDDING WEAR COLLECTION ","cname":"45A","product_seo_url":"royal-presents-vrundavan-vol-17-dno-10118-indian-women-designer-banarsi-silk-lehenga-choli-ghagra-party-wedding-wear-collection","product_image":"images\/product\/2022\/07\/royal-presents-vrundavan-vol-17-dno-10118-indian-women-designer-banarsi-silk-lehenga-choli-ghagra-party-wedding-wear-collection-2022-07-14_16_59_16.jpeg","product_qty":"3","catalog_pcs":"3","catelog_set":"Single","product_price":"6840","product_mrp_price":"7050","product_sale_price":"20520","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"12","product_weight":"0","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":"ROYAL PRESENTS VRUNDAVAN VOL-17 DNO 10118 INDIAN WOMEN DESIGNER BANARSI SILK LEHENGA CHOLI GHAGRA PARTY WEDDING WEAR COLLECTION ","product_meta_keyword":"lehenga choli , ghagra choli , bridal wear , party wear , wedding wear women indian lehenga choli , net lehenga 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: Banarsi silk || Choli: Banarsi silk || Dupatta: Banarsi Silk<\/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-05-17 07:25:48","push_to_top_date":"0000-00-00 00:00:00","delivery_date":"2022-05-24","fabric":"","availability":"On Booking","permalink":"https:\/\/textilemela.com\/portfolio\/royal-presents-vrundavan-vol-17-dno-10118-10124-indian-designer-party-wear-lehenga-choli-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='154' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"}