\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-02-27 12:34:47","push_to_top_date":"2024-02-27 12:34: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":"116236","author_id":"admin","product_sku":"TM-116172","product_hsn":"540710","product_name":"AMOHA DESIGN NO A316 SAREE PURE SATIN FABRICS IN BEAUITFUL MUTICOLORS ","cname":"SAREE PURE SATIN FABRICS IN BEAUITFUL MUTICOLORS ","product_seo_url":"amoha-design-no-a316-saree-pure-satin-fabrics-in-beauitful-muticolors","product_image":"images\/product\/2024\/02\/amoha-design-no-a316-saree-pure-satin-fabrics-in-beauitful-muticolors-2024-02-27_12_29_31.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"2445","product_mrp_price":"2445","product_sale_price":"9780","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":"SAREE PURE SATIN FABRICS IN BEAUITFUL MUTICOLORS ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA DESIGN NO A316 SAREE PURE SATIN FABRICS IN BEAUITFUL MUTICOLORS indian , indianwear , partywear , festivals , functions , occasions .\t\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":" BLOUSE SEQUIN EMBROIDERY WORK WITH DESIGNER PATTERN<\/p>\r\n\r\n SAREE PURE SATIN FABRICS<\/p>\r\n\r\n SIZE (36 READY) \r\n2-2 INCH MARGIN EXTENDED TO 40 \r\nSLEEVES INSIDE<\/p>\r\n\r\n 4 COLOURS AVAIABLE<\/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-02-27 12:29:31","push_to_top_date":"2024-02-27 12:29:31","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"116233","author_id":"admin","product_sku":"TM-116169","product_hsn":"540710","product_name":"AMOHA DESIGN NO A321 SRAG HEAVY SEQUIN EMBROIDERY WORK SAREE ","cname":" SRAG HEAVY SEQUIN EMBROIDERY WORK SAREE ","product_seo_url":"amoha-design-no-a321-srag-heavy-sequin-embroidery-work-saree","product_image":"images\/product\/2024\/02\/amoha-design-no-a321-srag-heavy-sequin-embroidery-work-saree-2024-02-27_12_04_46.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1875","product_mrp_price":"1875","product_sale_price":"7500","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":" SRAG HEAVY SEQUIN EMBROIDERY WORK SAREE ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA DESIGN NO A321 SRAG HEAVY SEQUIN EMBROIDERY WORK SAREE indian , indianwear , partywear , festivals , functions , occasions .\t\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\nBLOUSE SEQUIN EMBROIDERY WORK WITH CHINON FABRIC<\/p>\r\n\r\n
SAREE PURE CHINON FABRIC<\/p>\r\n\r\n SRAG HEAVY SEQUIN EMBROIDERY WORK<\/p>\r\n\r\n SIZE (36 READY) \r\n2-2 INCH MARGIN EXTENDED TO 40 \r\nSLEEVES INSIDE<\/p>\r\n\r\n 4 COLOURS AVAIABLE<\/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-02-27 12:04:46","push_to_top_date":"2024-02-27 12:04:46","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"116232","author_id":"admin","product_sku":"TM-116168","product_hsn":"540710","product_name":"AMOHA DESIGN NO C2040 LEHENGA ORGAZA FABRIC WITH ELEGANT REAL MIRROR WORK WITH COADING WORK LEHENGA","cname":" LEHENGA ORGAZA FABRIC WITH ELEGANT REAL MIRROR WORK WITH COADING WORK LEHENGA","product_seo_url":"amoha-design-no-c2040-lehenga-orgaza-fabric-with-elegant-real-mirror-work-with-coading-work-lehenga","product_image":"images\/product\/2024\/02\/amoha-design-no-c2040-lehenga-orgaza-fabric-with-elegant-real-mirror-work-with-coading-work-lehenga-2024-02-27_11_54_51.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"5995","product_mrp_price":"5995","product_sale_price":"23980","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":"YES","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":" LEHENGA ORGAZA FABRIC WITH ELEGANT REAL MIRROR WORK WITH COADING WORK LEHENGA","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA DESIGN NO C2040 LEHENGA ORGAZA FABRIC WITH ELEGANT REAL MIRROR WORK WITH COADING WORK LEHENGA indian , indianwear , partywear , festivals , functions , occasions .\t\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":" TOP ELEGENT MIRROR WORK BLOUSE<\/p>\r\n\r\n LEHENGA ORGAZA FABRIC WITH ELEGANT REAL MIRROR WORK WITH COADING WORK<\/p>\r\n\r\n DUPPATTA FANCY NET WITH BORDER<\/p>\r\n\r\n FULLY STICHED<\/p>\r\n\r\n SIZE 38 (READ ) \r\n2-2 INCH MARGIN EXTENDED TO 42 \r\nSLEEVES INSIDE<\/p>\r\n\r\n 4 COLOURS AVAILABLE<\/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-02-27 11:54:51","push_to_top_date":"2024-02-27 11:54:51","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"116231","author_id":"admin","product_sku":"TM-116167","product_hsn":"540710","product_name":"AMOHA DESIGN NO 293 SAREE FANCY PURE FABRIC WITH SEQUIN EMBRIDERY BORDER SAREE ","cname":"SAREE FANCY PURE FABRIC WITH SEQUIN EMBRIDERY BORDER SAREE ","product_seo_url":"amoha-design-no-293-saree-fancy-pure-fabric-with-sequin-embridery-border-saree","product_image":"images\/product\/2024\/02\/amoha-design-no-293-saree-fancy-pure-fabric-with-sequin-embridery-border-saree-2024-02-27_11_47_23.jpg","product_qty":"5","catalog_pcs":"3","catelog_set":"","product_price":"1695","product_mrp_price":"1695","product_sale_price":"5085","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"3","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":"SAREE FANCY PURE FABRIC WITH SEQUIN EMBRIDERY BORDER SAREE ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA DESIGN NO 293 SAREE FANCY PURE FABRIC WITH SEQUIN EMBRIDERY BORDER SAREE indian , indianwear , partywear , festivals , functions , occasions .\t\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\nBLOUSE DESIGNER SEQUIN EMBROIDERY WORK WITH NECKLACE SLEEVES<\/p>\r\n\r\n
SAREE FANCY PURE FABRIC WITH SEQUIN EMBRIDERY BORDER<\/p>\r\n\r\n SIZE (36 READY) \r\n2-2 INCH MARGIN EXTENDED TO 40 \r\nSLEEVES INSIDE<\/p>\r\n\r\n 3 COLOURS AVAIABLE<\/p>\r\n\r\n PLEASE CONTACT US IF YOU HAVE ANY QUERIES<\/p>\r\n","single_catalog":"0","product_date":"2024-02-27 11:47:23","push_to_top_date":"2024-02-27 11:47: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":"116210","author_id":"admin","product_sku":"TM-116148","product_hsn":"540710","product_name":"AMOHA DESIGN NO 10209 SAREE SATIN FABRIC WITH EXQUSITE SWAROVSKI WORK ","cname":"SAREE SATIN FABRIC WITH EXQUSITE SWAROVSKI WORK ","product_seo_url":"amoha-design-no-10209-saree-satin-fabric-with-exqusite-swarovski-work","product_image":"images\/product\/2024\/02\/amoha-design-no-10209-saree-satin-fabric-with-exqusite-swarovski-work-2024-02-24_15_57_08.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"3645","product_mrp_price":"3645","product_sale_price":"14580","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":"SAREE SATIN FABRIC WITH EXQUSITE SWAROVSKI WORK ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA DESIGN NO 10209 SAREE SATIN FABRIC WITH EXQUSITE SWAROVSKI WORK indian , indianwear , partywear , festivals , functions , occasions .\t\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":"1y7td_FMnBhDK0e0nO8_ESXo5Fqdytgeo","other_detail":" PLEASE CONTACT US IF YOU HAVE ANY QUERIES<\/p>\r\n","single_catalog":"0","product_date":"2024-02-24 15:57:08","push_to_top_date":"2024-02-24 15:57:08","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"116158","author_id":"admin","product_sku":"TM-116096","product_hsn":"540710","product_name":"AMOHA DESIGN NO 101114 SAREE IMPORTED FABRIC WITH FRILL BORDER ","cname":"SAREE IMPORTED FABRIC WITH FRILL BORDER","product_seo_url":"amoha-design-no-101114-saree-imported-fabric-with-frill-border","product_image":"images\/product\/2024\/02\/amoha-design-no-101114-saree-imported-fabric-with-frill-border-2024-02-21_17_06_43.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1145","product_mrp_price":"1145","product_sale_price":"4580","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":"SAREE IMPORTED FABRIC WITH FRILL BORDER","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA DESIGN NO 101114 SAREE IMPORTED FABRIC WITH FRILL BORDER indian , indianwear , partywear , festivals , functions , occasions .\t\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":" BLOUSE FUR BONDIND WITH STRUCTURE<\/p>\r\n\r\n SAREE IMPORTED FABRIC WITH FRILL BORDER<\/p>\r\n\r\n SIZE 36(READY) \r\n2-2 INCH MARGIN EXTENDED TO 40<\/p>\r\n\r\n 4 COLOURS AVAILABLE<\/p>\r\n\r\n PLEASE CONTAT US IF YOU HAVE ANY QUERIES<\/p>\r\n","single_catalog":"0","product_date":"2024-02-21 17:06:43","push_to_top_date":"2024-02-21 17:06:43","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"116116","author_id":"admin","product_sku":"TM-116054","product_hsn":"540710","product_name":"AMOHA C342 SKIRT CHINON FABRIC WITH COWL AND SHRUG DRESS","cname":" SKIRT CHINON FABRIC WITH COWL AND SHRUG DRESS","product_seo_url":"amoha-c342-skirt-chinon-fabric-with-cowl-and-shrug-dress","product_image":"images\/product\/2024\/02\/amoha-c342-skirt-chinon-fabric-with-cowl-and-shrug-dress-2024-02-20_15_43_04.jpg","product_qty":"15","catalog_pcs":"1","catelog_set":"","product_price":"2425","product_mrp_price":"2425","product_sale_price":"2425","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":" SKIRT CHINON FABRIC WITH COWL AND SHRUG DRESS","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA C342 SKIRT CHINON FABRIC WITH COWL AND SHRUG DRESS indian , indianwear , partywear , festivals , functions , occasions .\t\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":" TOP HAND WORK BLOUSE<\/p>\r\n\r\n SKIRT CHINON FABRIC WITH COWL AND SHRUG<\/p>\r\n\r\n SHRUG CHINON FABRIC WITH DESIGNER PRINT<\/p>\r\n\r\n SIZE L AND XXL<\/p>\r\n\r\n SLEEVES INSIDE<\/p>\r\n\r\n 1 COLOURS AVAILABLE<\/p>\r\n\r\n PLEASE CONTACT US IF YOU HAVE ANY QUERIES<\/p>\r\n","single_catalog":"0","product_date":"2024-02-20 15:43:04","push_to_top_date":"2024-02-20 15:43:04","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"116089","author_id":"admin","product_sku":"TM-116030","product_hsn":"540710","product_name":"AMOHA 101992A TO 101992E lycra saree with belt in beautiful multicolors colors ","cname":"lycra saree with belt in beautiful multicolors colors ","product_seo_url":"amoha-101992a-to-101992e-lycra-saree-with-belt-in-beautiful-multicolors-colors","product_image":"images\/product\/2024\/02\/amoha-101992a-to-101992e-lycra-saree-with-belt-in-beautiful-multicolors-colors-2024-02-19_13_33_41.jpg","product_qty":"5","catalog_pcs":"5","catelog_set":"","product_price":"1225","product_mrp_price":"1225","product_sale_price":"6125","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"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":"lycra saree with belt in beautiful multicolors colors ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA 101992A TO 101992E lycra saree with belt in beautiful multicolors colors indian , indianwear , partywear , festivals , functions , occasions .\t\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-02-19 13:33:41","push_to_top_date":"2024-02-19 13:33:41","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"116074","author_id":"admin","product_sku":"TM-116015","product_hsn":"540710","product_name":"AMOHA KRC325A TO KRC325D CROP TOP DRESS IN BEAUTIFUL COLORS ","cname":"CROP TOP DRESS IN BEAUTIFUL COLORS ","product_seo_url":"amoha-krc325a-to-krc325d-crop-top-dress-in-beautiful-colors","product_image":"images\/product\/2024\/02\/amoha-krc325a-to-krc325d-crop-top-dress-in-beautiful-colors-2024-02-17_16_53_46.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1945","product_mrp_price":"1945","product_sale_price":"7780","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":"YES","saree_fabric":"","blouse_fabric":"","lehenga_fabric":"","inner_for":"","cutfab":"","color":"","bottom":"","length":"","accessories_length":"","product_short_description":"CROP TOP DRESS IN BEAUTIFUL COLORS ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA KRC325A TO KRC325D CROP TOP DRESS IN BEAUTIFUL COLORS indian , indianwear , partywear , festivals , functions , occasions .\t\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-02-17 16:53:46","push_to_top_date":"2024-02-17 16:53:46","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"116043","author_id":"admin","product_sku":"TM-115984","product_hsn":"540710","product_name":"AMOHA A307 SAREE GEOGETTE FABRIC WITH EMBROIDRED BORDER ","cname":"SAREE GEOGETTE FABRIC WITH EMBROIDRED BORDER","product_seo_url":"amoha-a307-saree-geogette-fabric-with-embroidred-border","product_image":"images\/product\/2024\/02\/amoha-a307-saree-geogette-fabric-with-embroidred-border-2024-02-16_13_37_29.jpg","product_qty":"5","catalog_pcs":"5","catelog_set":"","product_price":"2445","product_mrp_price":"2445","product_sale_price":"12225","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"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":"SAREE GEOGETTE FABRIC WITH EMBROIDRED BORDER","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA A307 SAREE GEOGETTE FABRIC WITH EMBROIDRED BORDER indian , indianwear , partywear , festivals , functions , occasions .\t\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":" BLOUSE EXQUSITE EMBROIDERED WORK<\/p>\r\n\r\n SAREE GEOGETTE FABRIC WITH EMBROIDRED BORDER<\/p>\r\n\r\n SIZE 36(READY) \r\n2-2 INCH MARGIN EXTENDED TO 40<\/p>\r\n\r\n 5 COLOURS AVAILABLE<\/p>\r\n\r\n PLEASE CONTACT US IF YOU HAVE ANY QUERIES<\/p>\r\n","single_catalog":"0","product_date":"2024-02-16 13:37:29","push_to_top_date":"2024-02-16 13:37:29","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"115697","author_id":"admin","product_sku":"TM-115638","product_hsn":"540710","product_name":"AMOHA D.NO 262A BLOUSE EXQUISITE MIRROR WORK AND SAREE IMPORTED FABRIC ","cname":"BLOUSE EXQUISITE MIRROR WORK AND SAREE IMPORTED FABRIC ","product_seo_url":"amoha-d-no-262a-blouse-exquisite-mirror-work-and-saree-imported-fabric","product_image":"images\/product\/2024\/02\/amoha-d-no-262a-blouse-exquisite-mirror-work-and-saree-imported-fabric-2024-02-06_15_54_27.jpg","product_qty":"5","catalog_pcs":"1","catelog_set":"","product_price":"2875","product_mrp_price":"2875","product_sale_price":"2875","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":"BLOUSE EXQUISITE MIRROR WORK AND SAREE IMPORTED FABRIC ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA D.NO 262A BLOUSE EXQUISITE MIRROR WORK AND SAREE IMPORTED FABRIC indian , indianwear , partywear , festivals , functions , occasions .\t\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":" SINGLE COLOUR \r\nBLOUSE EXQUISITE MIRROR WORK \r\nSAREE IMPORTED FABRIC \r\nSIZE 36(READY) \r\n2-2 INCH MARGIN EXTENDED TO 40<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-02-06 15:54:27","push_to_top_date":"2024-02-06 15:54:27","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"115685","author_id":"admin","product_sku":"TM-115626","product_hsn":"540710","product_name":"AMOHA C1993 LEHENGA CHINNON FARIC WITH DIGITAL PRINT LEHENGA","cname":" TOP EXQUSITE REAL MIRROR WORK AND LEHENGA CHINNON FARIC WITH DIGITAL PRINT ","product_seo_url":"amoha-c1993-lehenga-chinnon-faric-with-digital-print-lehenga","product_image":"images\/product\/2024\/02\/amoha-c1993-lehenga-chinnon-faric-with-digital-print-lehenga-2024-02-06_11_12_36.jpg","product_qty":"5","catalog_pcs":"3","catelog_set":"","product_price":"2495","product_mrp_price":"2495","product_sale_price":"7485","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"3","product_stitch":"Unstitched","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":" TOP EXQUSITE REAL MIRROR WORK AND LEHENGA CHINNON FARIC WITH DIGITAL PRINT","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA C1993 LEHENGA CHINNON FARIC WITH DIGITAL PRINT LEHENGA indian , indianwear , partywear , festivals , functions , occasions .\t\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":" TOP EXQUSITE REAL MIRROR WORK<\/p>\r\n\r\n LEHENGA CHINNON FARIC WITH DIGITAL PRINT<\/p>\r\n\r\n DUPPATTA FANCY NET WITH LITTLE FRIL<\/p>\r\n\r\n SIZE 36(READY) \r\n2-2 INCH MARGING EXTENDED TO 40 \r\nSLEEVES INSIDE<\/p>\r\n\r\n 3 COLOURS REMOVED<\/p>\r\n\r\n PLEASE CONTACT US IF YOU HAVE ANY QUERIES<\/p>\r\n","single_catalog":"0","product_date":"2024-02-06 11:12:36","push_to_top_date":"2024-02-06 11:12:36","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"115684","author_id":"admin","product_sku":"TM-115625","product_hsn":"540710","product_name":"AMOHA 272 SAREE SILK SATIN FABRIC WITH EMBROIDRED BORDER SAREE","cname":"BLOUSE EXQUSITE EMBROIDERED WORK SAREE SILK SATIN FABRIC WITH EMBROIDRED BORDER SAREE","product_seo_url":"amoha-272-saree-silk-satin-fabric-with-embroidred-border-saree","product_image":"images\/product\/2024\/02\/amoha-272-saree-silk-satin-fabric-with-embroidred-border-saree-2024-02-06_11_04_49.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"3245","product_mrp_price":"3245","product_sale_price":"12980","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":"BLOUSE EXQUSITE EMBROIDERED WORK SAREE SILK SATIN FABRIC WITH EMBROIDRED BORDER SAREE","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA 272 SAREE SILK SATIN FABRIC WITH EMBROIDRED BORDER SAREE","product_meta_description":"","disable_date":"0000-00-00 00:00:00","upcoming":"1","product_type":"Ready to Ship","video_link":"","other_detail":" \r\nBLOUSE EXQUSITE EMBROIDERED WORK<\/p>\r\n\r\n
SAREE SILK SATIN FABRIC WITH EMBROIDRED BORDER <\/p>\r\n\r\n SIZE 36(READY) \r\n2-2 INCH MARGIN EXTENDED TO 40<\/p>\r\n\r\n 4 COLOURS AVAILABLE<\/p>\r\n\r\n PLEASE CONTACT US IF YOU HAVE ANY QUERIES<\/p>\r\n","single_catalog":"0","product_date":"2024-02-06 11:04:49","push_to_top_date":"2024-02-06 11:04:49","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"115532","author_id":"admin","product_sku":"TM-115473","product_hsn":"540710","product_name":"AMOHA Anokhi Pure Viscose Dola Silk With Zari Weaving Designer Pallu \/ Border & Blouse","cname":"Pure Viscose Dola Silk With Zari Weaving Designer Pallu \/ Border & Blouse","product_seo_url":"amoha-anokhi-pure-viscose-dola-silk-with-zari-weaving-designer-pallu-border-blouse","product_image":"images\/product\/2024\/02\/amoha-anokhi-pure-viscose-dola-silk-with-zari-weaving-designer-pallu-border-blouse-2024-02-01_12_55_19.jpg","product_qty":"5","catalog_pcs":"9","catelog_set":"","product_price":"3175","product_mrp_price":"3175","product_sale_price":"28575","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"9","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":"Pure Viscose Dola Silk With Zari Weaving Designer Pallu \/ Border & Blouse","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA Anokhi Pure Viscose Dola Silk With Zari Weaving Designer Pallu \/ Border & Blouse indian , indianwear , partywear , festivals , functions , occasions .\t\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":" \u27a1\ufe0fFabric :- Pure Viscose Dola Silk \r\n With Zari Weaving Designer \r\n Pallu \/ Border & Blouse<\/p>\r\n\r\n 9pc set<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-02-01 12:55:19","push_to_top_date":"2024-02-01 12:55:19","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"115409","author_id":"admin","product_sku":"TM-115351","product_hsn":"540710","product_name":"AMOHA DESIGN NO KAT211 SAREE PRISM PRINTED CHINON SAREE ","cname":"SAREE PRISM PRINTED CHINON SAREE ","product_seo_url":"amoha-design-no-kat211-saree-prism-printed-chinon-saree","product_image":"images\/product\/2024\/01\/amoha-design-no-kat211-saree-prism-printed-chinon-saree-2024-01-29_13_05_18.jpg","product_qty":"5","catalog_pcs":"3","catelog_set":"","product_price":"3475","product_mrp_price":"3475","product_sale_price":"10425","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"3","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":"SAREE PRISM PRINTED CHINON SAREE ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA DESIGN NO KAT211 SAREE PRISM PRINTED CHINON SAREE indian , indianwear , partywear , festivals , functions , occasions .\t\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":" BLOUSE PRISM PRINTED WITH HEAVY EMBROIDERY HANDWORK BLOUSE<\/p>\r\n\r\n SAREE PRISM PRINTED CHINON SAREE<\/p>\r\n\r\n SIZE 36(READY) \r\n2-2 INCH MARGIN EXTENDED TO 40<\/p>\r\n\r\n 3 COLOURS AVAILABLE<\/p>\r\n\r\n PLEASE CONTACT US IF YOU HAVE ANY QUERIES<\/p>\r\n","single_catalog":"0","product_date":"2024-01-29 13:05:18","push_to_top_date":"2024-01-29 13:05: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":"115392","author_id":"admin","product_sku":"TM-115334","product_hsn":"540710","product_name":"AMOHA DESIGN NO 31 SAREE SILK SATIN FABRICE WITH SEQUIN BORDER in beautiful colors ","cname":" SAREE SILK SATIN FABRICE WITH SEQUIN BORDER in beautiful colors ","product_seo_url":"amoha-design-no-31-saree-silk-satin-fabrice-with-sequin-border-in-beautiful-colors","product_image":"images\/product\/2024\/01\/amoha-design-no-31-saree-silk-satin-fabrice-with-sequin-border-in-beautiful-colors-2024-01-27_16_53_43.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1995","product_mrp_price":"1995","product_sale_price":"7980","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":" SAREE SILK SATIN FABRICE WITH SEQUIN BORDER in beautiful colors ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA DESIGN NO 31 SAREE SILK SATIN FABRICE WITH SEQUIN BORDER in beautiful colors indian , indianwear , partywear , festivals , functions , occasions .\t\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":" BLOUSE EXQUSITE SEQUIN WORK WITH FANCY DESIGN<\/p>\r\n\r\n SAREE SILK SATIN FABRICE WITH SEQUIN BORDER<\/p>\r\n\r\n SIZE 36(READY) \r\n2-2 INCH MARGIN EXTENDED TO 40 \r\nSLEEVES INSIDE<\/p>\r\n\r\n 4 COLOURS AVAILABLE<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-01-27 16:53:43","push_to_top_date":"2024-01-27 16:53:43","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"115364","author_id":"admin","product_sku":"TM-115306","product_hsn":"540710","product_name":"AMOHA C1943A TO C1943C VISCOSE GEORGETTE WITH MULTI EMBROIDERY LEHENGA ","cname":"VISCOSE GEORGETTE WITH MULTI EMBROIDERY LEHENGA ","product_seo_url":"amoha-c1943a-to-c1943c-viscose-georgette-with-multi-embroidery-lehenga","product_image":"images\/product\/2024\/01\/amoha-c1943a-to-c1943c-viscose-georgette-with-multi-embroidery-lehenga-2024-01-27_12_27_25.jpg","product_qty":"5","catalog_pcs":"3","catelog_set":"","product_price":"4495","product_mrp_price":"4495","product_sale_price":"13485","product_reseller_price":"","product_reseller_mrp_price":"","product_reseller_sale_price":"0","product_gst":"5","product_weight":"3","product_stitch":"Unstitched","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":"VISCOSE GEORGETTE WITH MULTI EMBROIDERY LEHENGA ","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA C1943A TO C1943C VISCOSE GEORGETTE WITH MULTI EMBROIDERY LEHENGA indian , indianwear , partywear , festivals , functions , occasions .\t\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":" 3 COLORS AVAILABLE \r\nTOP\/BLOUSE - VISCOSE GEORGETTE WITH MULTI EMBROIDERY \r\nLEHENGA - VISCOSE GEORGETTE WITH MULTI EMBROIDERY \r\nDUPATTA- NET WITH MULTI EMBROIDERY \r\nSIZE -40 (READY) \r\n2-2 INCH MARGIN EXTENDED 44<\/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-01-27 12:27:25","push_to_top_date":"2024-01-27 12:27:25","delivery_date":"0000-00-00","fabric":"","availability":"","permalink":"","note":"","shipping_days":"3 to 7","filter":"0","code_userid":"","is_single":"1"}},{"product":{"product_id":"115279","author_id":"admin","product_sku":"TM-115221","product_hsn":"540710","product_name":"AMOHA A313A TO A313D SAREE SILK SATIN FABRIC WITH SEQUIN BORDER sarees ","cname":"SAREE SILK SATIN FABRIC WITH SEQUIN BORDER sarees","product_seo_url":"amoha-a313a-to-a313d-saree-silk-satin-fabric-with-sequin-border-sarees","product_image":"images\/product\/2024\/01\/amoha-a313a-to-a313d-saree-silk-satin-fabric-with-sequin-border-sarees-2024-01-23_13_05_56.jpg","product_qty":"5","catalog_pcs":"4","catelog_set":"","product_price":"1995","product_mrp_price":"1995","product_sale_price":"7980","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":"SAREE SILK SATIN FABRIC WITH SEQUIN BORDER","product_full_description":"","product_status":"Publish","product_meta_title":"","product_meta_keyword":"AMOHA A313A TO A313D SAREE SILK SATIN FABRIC WITH SEQUIN BORDER sarees indian , indianwear , partywear , festivals , functions , occasions .\t\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":" 4 COLOURS AVAILABLE \r\nBLOUSE EXQUISITE SEQUIN WORK WITH FANCY DESIGN \r\nSAREE SILK SATIN FABRIC WITH SEQUIN BORDER \r\nSIZE 36(READY) \r\n2-2 INCH MARGIN EXTENDED TO 40 \r\nSLEEVES INSIDE<\/p>\r\n\r\n please contact us if you have any queries<\/p>\r\n","single_catalog":"0","product_date":"2024-01-23 13:05:56","push_to_top_date":"2024-01-23 13:05:56","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 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='31' order by pm.push_to_top_date desc,pm.product_id desc LIMIT 20, 20"} | | | | | |