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 (1691,1692,1693,1694)
) 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
Plain Archives - Charu Creation Plain Archives - Charu Creation
+91-9971106200
X

Showing 1–12 of 36 resultsSorted by latest

Showing 1–12 of 36 resultsSorted by latest

In stock only
10
    10
    Your Cart
    Black Base Zig Zag Print on Net Sequence Dress Material Fabric
    Black Base Zig Zag Print on Net Sequence Dress Material Fabric
    Price: MRP₹1,617.00 / mtr (incl. of all taxes)
    ₹1,617.00 (incl. GST)
    Brown Color Georgette Lycra Dress Material Fabric
    Brown Color Georgette Lycra Dress Material Fabric
    Price: MRP₹351.75 / mtr (incl. of all taxes)
    ₹351.75 (incl. GST)
    Black color Poly Dupion Fabric for Men's ethnic Kurta Pyjama
    Black color Poly Dupion Fabric for Men's ethnic Kurta Pyjama
    Price: MRP₹169.31 / mtr (incl. of all taxes)
    ₹169.31 (incl. GST)
    Blue Color Cotton Voile Fabric For Women's Top
    Blue Color Cotton Voile Fabric For Women's Top
    Price: MRP₹124.16 / mtr (incl. of all taxes)
    ₹124.16 (incl. GST)
    Off White Cotton Lurex Dress Material Fabric
    Off White Cotton Lurex Dress Material Fabric
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    Off White Color Cotton Cambric Fabric For Summer Dress
    Off White Color Cotton Cambric Fabric For Summer Dress
    Price: MRP₹169.31 / mtr (incl. of all taxes)
    ₹169.31 (incl. GST)
    Blue Color Georgette Lycra Dress Material Fabric
    Blue Color Georgette Lycra Dress Material Fabric
    Price: MRP₹288.75 / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    Black color Polyester Textured fabric for Men's Blazer
    Black color Polyester Textured fabric for Men's Blazer
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Brown Color Hand Spun Cotton Dress Material Fabric
    Brown Color Hand Spun Cotton Dress Material Fabric
    Price: MRP Original price was: ₹288.75.Current price is: ₹249.00. / mtr (incl. of all taxes)
    ₹249.00 (incl. GST)
    Peach Color Plain Cotton Cambric Dress Material Fabric
    Peach Color Plain Cotton Cambric Dress Material Fabric
    Price: MRP₹197.54 / mtr (incl. of all taxes)
    ₹197.54 (incl. GST)
    Subtotal ₹3,956.95 (incl. GST)
    To find out your shipping cost , Please proceed to checkout.
    View CartCheckout