\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-07 13:38:02","push_to_top_date":"2024-05-07 13:38:02","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118297","author_id":"admin","product_sku":"TM-118219","product_hsn":"540710 ","product_name":"Shri Balahi Emporium 6205 KUSUM VOL-07 Classic Indian women Casual Wear Silk Sarees ","cname":" Classic Indian women silk sarees party wear , casual wear ","product_seo_url":"shri-balahi-emporium-6205-kusum-vol-07-classic-indian-women-casual-wear-silk-sarees","product_image":"images\/product\/2024\/05\/shri-balahi-emporium-6205-kusum-vol-07-classic-indian-women-casual-wear-silk-sarees-2024-05-07_13_31_47.jpg","product_qty":"5","catalog_pcs":"6","catelog_set":"","product_price":"725","product_mrp_price":"725","product_sale_price":"4350","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"6","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":" Classic Indian women silk sarees party wear , casual wear ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balahi Emporium 6205 KUSUM VOL-07 Classic Indian women Casual Wear Silk Sareesindian indianwear partywear festivals functions occasions .\t\t\t\t\t ","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\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-07 13:31:47","push_to_top_date":"2024-05-07 13:31:47","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118296","author_id":"admin","product_sku":"TM-118218","product_hsn":"540710","product_name":"LT Fabrics 5481 RUBY festival wear designer fancy border saree","cname":"part wear wedding wear designer fancy saree ","product_seo_url":"lt-fabrics-5481-ruby-festival-wear-designer-fancy-border-saree","product_image":"images\/product\/2024\/05\/lt-fabrics-5481-ruby-festival-wear-designer-fancy-border-saree-2024-05-07_13_27_32.png","product_qty":"5","catalog_pcs":"8","catelog_set":"","product_price":"680","product_mrp_price":"680","product_sale_price":"5440","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"8","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":"part wear wedding wear designer fancy saree ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"LT Fabrics 5481 RUBY festival wear designer fancy border saree","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" New Cataloge Launch<\/p>\r\n\r\n Brand- LT Fabrics<\/p>\r\n\r\n CATLOGUE - RUBY<\/p>\r\n\r\n Fabric - PC Moss With Diamond Work & Fancy Border & Fancy Chiffli Blouse<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n\r\n <\/p>\r\n","single_catalog":"0","product_date":"2024-05-07 13:27:32","push_to_top_date":"2024-05-07 13:27: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":"118295","author_id":"admin","product_sku":"TM-118217","product_hsn":"540710 ","product_name":"BUNAWAT 6207 VANTARA VOL-05 Classic Indian women Pashmina sarees ","cname":" Classic Indian women Pashmina sarees party wear , casual wear ","product_seo_url":"bunawat-6207-vantara-vol-05-classic-indian-women-pashmina-sarees","product_image":"images\/product\/2024\/05\/bunawat-6207-vantara-vol-05-classic-indian-women-pashmina-sarees-2024-05-07_13_25_23.jpg","product_qty":"5","catalog_pcs":"8","catelog_set":"","product_price":"1199","product_mrp_price":"1199","product_sale_price":"9592","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"8","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":" Classic Indian women Pashmina sarees ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"BUNAWAT 6207 VANTARA VOL-05 Classic Indian women Pashmina sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Product Type: Saree \r\nFabric: Pashmina \r\nTotal Pcs: 8 \r\nOther Specifications: Pashmina Saree \r\nSaree Mtr: 5.5 Mtr \r\nBlouse: 0.8 Mtr<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-07 13:25:23","push_to_top_date":"2024-05-07 13:25:23","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118294","author_id":"admin","product_sku":"TM-118216","product_hsn":"540710 ","product_name":"Shri Balahi Emporium 6206 D.NO. JR614 New Exclusive Indian women party wear sarees ","cname":"Georgette Embroidery & Sequence work With Tassels Saree","product_seo_url":"shri-balahi-emporium-6206-d-no-jr614-new-exclusive-indian-women-party-wear-sarees","product_image":"images\/product\/2024\/05\/shri-balahi-emporium-6206-d-no-jr614-new-exclusive-indian-women-party-wear-sarees-2024-05-07_13_20_16.jpg","product_qty":"5","catalog_pcs":"1","catelog_set":"","product_price":"839","product_mrp_price":"839","product_sale_price":"839","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"1","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":"Georgette Embroidery & Sequence work With Tassels Saree ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balahi Emporium 6206 D.NO. JR614 New Exclusive Indian women party wear sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Fabric details \r\nSAREE FABRIC- Georgette \r\nSAREE LENGTH- 5.50 Mtr \r\nSAREE WORK- Embroidery & Sequence work With Tassels \r\nBLOUSE FABRIC- Heavy Mono Silk With Embroidery Work \r\nClassic and elegant, this saree will be a perfect addition to your ethnic wardrobe, offering a soothing and pretty wibe the adornment of sequence work makes it impeccable<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n\r\n <\/p>\r\n","single_catalog":"0","product_date":"2024-05-07 13:20:16","push_to_top_date":"2024-05-07 13:20:16","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118293","author_id":"admin","product_sku":"TM-118215","product_hsn":"540710","product_name":"zeel 5480 Code: 7907 indian women designer festival wear lehenga choli","cname":"party wear festival wear wedding wear designer net lehenga choli","product_seo_url":"zeel-5480-code-7907-indian-women-designer-festival-wear-lehenga-choli","product_image":"images\/product\/2024\/05\/zeel-5480-code-7907-indian-women-designer-festival-wear-lehenga-choli-2024-05-07_13_13_59.png","product_qty":"5","catalog_pcs":"1","catelog_set":"","product_price":"4149","product_mrp_price":"4149","product_sale_price":"4149","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"2.5","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":"party wear festival wear wedding wear designer net lehenga choli","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"zeel 5480 Code: 7907 indian women designer festival wear lehenga choli","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Style and design and trend would be at the peak of your splendor as soon as you dress in this Dusky Orchid color soft net lehenga.<\/p>\r\n\r\n Lehenga (Semi-Stitched) \r\nFabric: Net \r\nWork: Thread, Badla, Glitter Dori & Zari 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: Net \r\nColor: Matching \r\nWork: Thread, Badla, Glitter Dori & Zari Embroidery Work. \r\nFront Neck: Round Neck \r\nBack Neck: Round Neck \r\nSleeves: Long Sleeves \r\nSize: up to 43"<\/p>\r\n\r\n Dupatta \r\nFabric: Net \r\nColor: Matching \r\nWork: Thread, Badla, Glitter Dori & Zari Embroidery Work. \r\nLength: 2.25 meter<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-05-07 13:13:59","push_to_top_date":"2024-05-07 13:13:59","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118292","author_id":"admin","product_sku":"TM-118214","product_hsn":"540710 ","product_name":"Shri Balahi Emporium 6202 STORY New Exclusive Indian women party wear sarees ","cname":"Soft banarasi fabric New Exclusive Indian women party wear sarees ","product_seo_url":"shri-balahi-emporium-6202-story-new-exclusive-indian-women-party-wear-sarees","product_image":"images\/product\/2024\/05\/shri-balahi-emporium-6202-story-new-exclusive-indian-women-party-wear-sarees-2024-05-07_13_13_24.jpg","product_qty":"5","catalog_pcs":"10","catelog_set":"","product_price":"1595","product_mrp_price":"1595","product_sale_price":"15950","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","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":"Soft banarasi fabric New Exclusive Indian women party wear sarees ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balahi Emporium 6202 STORY New Exclusive Indian women party wear sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t ","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\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-07 13:13:24","push_to_top_date":"2024-05-07 13:13:24","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118291","author_id":"admin","product_sku":"TM-118213","product_hsn":"540710 ","product_name":"RUCHI 6203 VIVANTA SILK 28TH EDITION Indian Women Printed Silk Crepe Sarees ","cname":" Indian Women Printed Silk Crepe Sarees Casual wear Sarees ","product_seo_url":"ruchi-6203-vivanta-silk-28th-edition-indian-women-printed-silk-crepe-sarees","product_image":"images\/product\/2024\/05\/ruchi-6203-vivanta-silk-28th-edition-indian-women-printed-silk-crepe-sarees-2024-05-07_13_03_35.jpeg","product_qty":"5","catalog_pcs":"12","catelog_set":"","product_price":"606","product_mrp_price":"606","product_sale_price":"7272","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"12","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 Women Printed Silk Crepe Sarees Casual wear Sarees ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"RUCHI 6203 VIVANTA SILK 28TH EDITION Indian Women Printed Silk Crepe Sarees sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Pcs. - 12. \r\nFabric - Silk Crepe<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-07 13:03:35","push_to_top_date":"2024-05-07 13:03:35","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118290","author_id":"admin","product_sku":"TM-118212","product_hsn":"540710","product_name":"shri balaji emporium 5478 AADHIRA Vol-9 designer alia cut sharara shuit","cname":" wedding wear Designer Embroidered Sleeves paired with Designer Plazo And Dupatta alia cut sharara shuit","product_seo_url":"shri-balaji-emporium-5478-aadhira-vol-9-designer-alia-cut-sharara-shuit","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-5478-aadhira-vol-9-designer-alia-cut-sharara-shuit-2024-05-07_13_01_48.png","product_qty":"30","catalog_pcs":"5","catelog_set":"","product_price":"1375","product_mrp_price":"1375","product_sale_price":"6875","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"5","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":" wedding wear Designer Embroidered Sleeves paired with Designer Plazo And Dupatta alia cut sharara shuit","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"shri balaji emporium 5478 AADHIRA Vol-9 designer alia cut sharara shuit","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" We are Introducing our NAYRA STYLE WEAR COLLECTION To Make You Unique and Classy..<\/p>\r\n\r\n With Supirier Quality and Affordable Price<\/p>\r\n\r\n Catalogue:- AADHIRA Vol-9 \r\nDescription \r\n Designer Embroidered Sleeves paired with Designer Plazo And Dupatta<\/p>\r\n\r\n Details \r\nTop:- PURE REYON VISCOS FABRIC WITH HEAVY LAKHNAWI EMBROIDERY<\/p>\r\n\r\n Bottom :- Pure Reyon Viscos fabrics With Hevy Lakhnavi Work<\/p>\r\n\r\n DUPTTA Nazmin 4side border GPU less \r\n Size Chart \r\n Top:- S-36,M-38,L-40,XL-42,XXL-44,3XL-46<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-05-07 13:01:48","push_to_top_date":"2024-05-07 13:01:48","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118289","author_id":"admin","product_sku":"TM-118211","product_hsn":"540710","product_name":"TRIRATH 6201 SWASTIK Indian Traditional Party Wear Paithani Silk Sarees ","cname":"Super Pv Silk With Paithani Design With Epoxy Finish","product_seo_url":"trirath-6201-swastik-indian-traditional-party-wear-paithani-silk-sarees","product_image":"images\/product\/2024\/05\/trirath-6201-swastik-indian-traditional-party-wear-paithani-silk-sarees-2024-05-07_12_47_12.jpg","product_qty":"5","catalog_pcs":"8","catelog_set":"","product_price":"1495","product_mrp_price":"1495","product_sale_price":"11960","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"8","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":"Super Pv Silk With Paithani Design With Epoxy Finish","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"TRIRATH 6201 SWASTIK Indian Traditional Party Wear Paithani Silk sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Saree : Super Pv Silk With Paithani Design With Epoxy Finish \r\nBlouse : Super Pv Silk \r\nOccasion : Festival Wear<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-07 12:47:12","push_to_top_date":"2024-05-07 12:47:12","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118288","author_id":"admin","product_sku":"TM-118210","product_hsn":"540710","product_name":"shri balaji emporium 5477 Aarzoo Ladies Flavour Aarzoo Heavy Chanderi Silk Readymade Suits ","cname":"daily wear casual wear designer chanderi silk ready to wear shuit","product_seo_url":"shri-balaji-emporium-5477-aarzoo-ladies-flavour-aarzoo-heavy-chanderi-silk-readymade-suits","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-5477-aarzoo-ladies-flavour-aarzoo-heavy-chanderi-silk-readymade-suits-2024-05-07_12_36_23.png","product_qty":"20","catalog_pcs":"4","catelog_set":"","product_price":"1225","product_mrp_price":"1225","product_sale_price":"4900","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","product_stitch":"Full Stitched","catalog_type":"","moq":"0","top_fabric":"","bottom_fabric":"","dupatta_fabric":"yes","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"daily wear casual wear designer chanderi silk ready to wear shuit","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"shri balaji emporium 5477 Aarzoo Ladies Flavour Aarzoo Heavy Chanderi Silk Readymade Suits","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Premium Festival Collection + Dupptta Catlouge<\/p>\r\n\r\n Catalog: Aarzoo<\/p>\r\n\r\n Design: 4<\/p>\r\n\r\n Fabric:- \r\nTop:- Heavy Chanderi Silk With Embroidery With Hand Work With inner<\/p>\r\n\r\n Note :- Top with Cup & Zip Finishing<\/p>\r\n\r\n Bottom:- Heavy Chanderi Silk<\/p>\r\n\r\n Dupptta :Chinon Chiffon With Gota Lace (2.30 cut & 36 Panna)<\/p>\r\n\r\n Size : M(38),L(40),XL(42), 2XL(44)<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-05-07 12:36:23","push_to_top_date":"2024-05-07 12:36:23","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118287","author_id":"admin","product_sku":"TM-118209","product_hsn":"540710","product_name":"Shri Balaji Emporium 6200 JR615 COLOUR\u2019S Indian Traditional Party Wear sequence Sarees ","cname":"Georgette Embroidery & Sequence work lace with piping ","product_seo_url":"shri-balaji-emporium-6200-jr615-colour-s-indian-traditional-party-wear-sequence-sarees","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6200-jr615-colour-s-indian-traditional-party-wear-sequence-sarees-2024-05-07_12_36_02.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"959","product_mrp_price":"959","product_sale_price":"3836","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"4","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":"Embroidery & Sequence work lace with piping ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balaji Emporium 6200 JR615 COLOUR\u2019S Indian Traditional Party Wear sequence Sarees sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Fabric details \r\nSAREE FABRIC- Georgette \r\nSAREE LENGTH- 5.50 Mtr \r\nSAREE WORK- Embroidery & Sequence work lace with piping \r\nBLOUSE FABRIC- Heavy Mono Silk \r\nClassic and elegant, this saree will be a perfect addition to your ethnic wardrobe, offering a soothing and pretty wibe the adornment of sequence work makes it impeccable <\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-07 12:36:02","push_to_top_date":"2024-05-07 12:36:02","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118284","author_id":"admin","product_sku":"TM-118206","product_hsn":"540710","product_name":"Shri Balahi Emporium 6199 KUSUM VOL-06 Design Freshness Dola Jacquard Silk Sarees ","cname":" Design Freshness Dola jacquard silk Sarees ","product_seo_url":"shri-balahi-emporium-6199-kusum-vol-06-design-freshness-dola-jacquard-silk-sarees","product_image":"images\/product\/2024\/05\/shri-balahi-emporium-6199-kusum-vol-06-design-freshness-dola-jacquard-silk-sarees-2024-05-07_12_24_35.jpg","product_qty":"5","catalog_pcs":"8","catelog_set":"","product_price":"725","product_mrp_price":"725","product_sale_price":"5800","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"8","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":" Design Freshness Dola jacquard silk sarees ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balahi Emporium 6199 KUSUM VOL-06 Design Freshness Dola Jacquard Silk Sarees indian indianwear partywear festivals functions occasions .\t\t\t\t\t ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Dola jacquard silk Sarees inlatest designs<\/p>\r\n\r\n \r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-07 12:24:35","push_to_top_date":"2024-05-07 12:24:35","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118283","author_id":"admin","product_sku":"TM-118205","product_hsn":"540710","product_name":"Shri Balaji Emporium 6226 Pure Cotton Hand Block Printed Readymade 3pcs stitch suits","cname":"New Summer Collection Designer Pure Cotton Hand Block Printed Readymade 3pcs stitch suits","product_seo_url":"shri-balaji-emporium-6226-pure-cotton-hand-block-printed-readymade-3pcs-stitch-suits","product_image":"images\/product\/2024\/05\/shri-balaji-emporium-6226-pure-cotton-hand-block-printed-readymade-3pcs-stitch-suits-2024-05-07_12_23_32.jpg","product_qty":"25","catalog_pcs":"17","catelog_set":"","product_price":"1199","product_mrp_price":"1199","product_sale_price":"20383","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"17","product_stitch":"Full 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":"New Summer Collection Designer Pure Cotton Hand Block Printed Readymade 3pcs stitch suits","product_full_description":"","product_status":"Publish","product_meta_title":"Shri Balaji Emporium 6226 Pure Cotton Hand Block Printed Readymade 3pcs stitch suits","product_meta_keyword":"Shri Balaji Emporium 6226 Pure Cotton Hand Block Printed Readymade 3pcs stitch suits pink red yellow purple wine green blue black white indianfashion, fashion, indianwear, indianwedding, ethnicwear, india, onlineshopping instafashion, indianbride, fashionblogger, style, indian, ","product_meta_description":"New Summer Collection Designer Pure Cotton Hand Block Printed Readymade 3pcs stitch suits","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" Designer Pure Hand Block Printed Readymade 3pcs stitch suits \r\nPure Hand block printed cotton kurti \r\n Pure Hand block printed Pant \r\n Pure Hand block printed Dupatta \r\nSizes available 36,38,40,42,44 \r\nFabric Quality:- Kurti & Pant Cotton 60x60 ( Super dying) \r\nDupatta Mull mull 100x100 (Super Dying) \r\nPlease contact us if you have any questions.<\/p>\r\n","single_catalog":"0","product_date":"2024-05-07 12:23:32","push_to_top_date":"2024-05-07 12:23:32","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7 days","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118282","author_id":"admin","product_sku":"TM-118204","product_hsn":"540710","product_name":"KASHVI CREATION 5476 MALIKA Pure Line Fancy designer saree","cname":"party wear wedding wear fancy designer saree","product_seo_url":"kashvi-creation-5476-malika-pure-line-fancy-designer-saree","product_image":"images\/product\/2024\/05\/kashvi-creation-5476-malika-pure-line-fancy-designer-saree-2024-05-07_12_16_00.png","product_qty":"5","catalog_pcs":"8","catelog_set":"","product_price":"695","product_mrp_price":"695","product_sale_price":"5560","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"8","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":"party wear wedding wear fancy designer saree","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"KASHVI CREATION 5476 MALIKA Pure Line Fancy designer saree","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" MALIKA<\/p>\r\n\r\n FABRIC - PURE LINEN WITH EMBROIDERY WORK AND CONTRAST BLOUSE<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-05-07 12:16:00","push_to_top_date":"2024-05-07 12:16:00","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 TO 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"118281","author_id":"admin","product_sku":"TM-118203","product_hsn":"540710","product_name":"Shri Balahi Emporium 6198 Design Freshness Fabric Digital Print Silk ","cname":"Design With Freshness Bembers Fabric in Digital Print with different type of exclusive fancy Border Sarees ","product_seo_url":"shri-balahi-emporium-6198-design-freshness-fabric-digital-print-silk","product_image":"images\/product\/2024\/05\/shri-balahi-emporium-6198-design-freshness-fabric-digital-print-silk-2024-05-07_12_14_22.jpg","product_qty":"5","catalog_pcs":"8","catelog_set":"","product_price":"975","product_mrp_price":"975","product_sale_price":"7800","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"8","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":"Design With Freshness Bembers Fabric in Digital Print with different type of exclusive fancy Border ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"Shri Balahi Emporium 6198 Design Freshness Fabric Digital Print Silk indian indianwear partywear festivals functions occasions .\t\t\t\t\t ","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"0","product_type":"Ready to Ship","video_link":"","other_detail":" \r\nDesign With Freshness Bembers Fabric in Digital Print with different type of exclusive fancy Border \r\nFABRIC – BAMBER SILK <\/p>\r\n\r\n
\r\n\t\r\n\t\t\r\n\t\t\tplease contact us if you have any queries<\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t\t | <\/td>\r\n\t\t<\/tr>\r\n\t<\/tbody>\r\n<\/table>\r\n","single_catalog":"0","product_date":"2024-05-07 12:14:22","push_to_top_date":"2024-05-07 12:14:22","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}}],"ggg":"select pm.* from relation_master as rm left join product_master as pm on pm.product_id=rm.product_id where 1=1 and pm.product_price!=0 and rm.type_id='2' and rm.type='cat' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 24, 20"} | | | | | | | | | |