SELECT SQL_CALC_FOUND_ROWS  ujw_posts.*
					 FROM ujw_posts  LEFT JOIN ujw_term_relationships ON (ujw_posts.ID = ujw_term_relationships.object_id)
					 WHERE 1=1  AND ( 
  ujw_posts.ID NOT IN (
				SELECT object_id
				FROM ujw_term_relationships
				WHERE term_taxonomy_id IN (11)
			) 
  AND 
  ujw_term_relationships.term_taxonomy_id IN (2931,2932,2933,2934,2935,2936,2937)
) AND ((ujw_posts.post_type = 'product' AND (ujw_posts.post_status = 'publish' OR ujw_posts.post_status = 'acf-disabled')))
					 GROUP BY ujw_posts.ID
					 ORDER BY ujw_posts.post_date DESC, ujw_posts.ID DESC
					 LIMIT 0, 12
Chemical Lace Fabric | Charu Creation | Affordable Dress Materials Chemical Lace Fabric | Charu Creation | Affordable Dress Materials
X

Showing 1–12 of 19 resultsSorted by latest

Showing 1–12 of 19 resultsSorted by latest

15
    15
    Your Cart
    Wine Color Textured Poly Crepe Lining Dress Material Fabric
    Wine Color Textured Poly Crepe Lining Dress Material Fabric
    Price: MRP Original price was: ₹635.25.Current price is: ₹367.50. / mtr (incl. of all taxes)
    ₹367.50 (incl. GST)
    White Color Printed Design on Cotton Poplin Dress Material Fabric
    White Color Printed Design on Cotton Poplin Dress Material Fabric
    Price: MRP₹404.25 / mtr (incl. of all taxes)
    ₹1,212.75 (incl. GST)
    cotton hakoba
    Black base White Embroidery Cotton Poplin Border Boota fabric for Women's Dress
    Price: MRP Original price was: ₹564.38.Current price is: ₹525.00. / mtr (incl. of all taxes)
    ₹525.00 (incl. GST)
    Off White color Chemical lace fabric for Women's Top
    Off White color Chemical lace fabric for Women's Top
    Price: MRP₹1,128.75 / mtr (incl. of all taxes)
    ₹1,128.75 (incl. GST)
    Pink Color Olivia Georgette fabric for Women's Kurti
    Pink Color Olivia Georgette fabric for Women's Kurti
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    Pink Color Handloom Mangalagiri fabric for Women's Saree
    Pink Color Handloom Mangalagiri fabric for Women's Saree
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Navy Blue color Olivia Georgette fabric for Women's Western Dresses
    Navy Blue color Olivia Georgette fabric for Women's Western Dresses
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    White color Cotton Dobby fabric for Men's Kurta
    White color Cotton Dobby fabric for Men's Kurta
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Dark Grey color Poly Viscose slub imported fabric for Women's Kurta
    Dark Grey color Poly Viscose slub imported fabric for Women's Kurta
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    Multicolor Cotton Voile Print fabric for Women's Top
    Multicolor Cotton Voile Print fabric for Women's Top
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    White Color RFD Cotton Hakoba Fabric for Women's Kurta
    White Color RFD Cotton Hakoba Fabric for Women's Kurta
    Price: MRP Original price was: ₹903.00.Current price is: ₹840.00. / mtr (incl. of all taxes)
    ₹840.00 (incl. GST)
    Traditional Chemical Lace Fabric
    Traditional Chemical Lace Fabric
    Price: MRP Original price was: ₹1,501.50.Current price is: ₹1,155.00. / mtr (incl. of all taxes)
    ₹1,155.00 (incl. GST)
    White color Chemical lace fabric for Women's Top
    White color Chemical lace fabric for Women's Top
    Price: MRP₹1,128.75 / mtr (incl. of all taxes)
    ₹1,128.75 (incl. GST)