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 (1693)
) 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 Cotton Tussar - Charu Creation Plain Cotton Tussar - Charu Creation
+91-9971106200
X

Showing all 12 resultsSorted by latest

Showing all 12 resultsSorted by latest

11
    11
    Your Cart
    Purple Color Cotton Voile Stripe Fabric For Women's Kurta
    Purple Color Cotton Voile Stripe Fabric For Women's Kurta
    Price: MRP₹259.61 / mtr (incl. of all taxes)
    ₹259.61 (incl. GST)
    White Color Polyester Satin Fabric For Women's Gown
    White Color Polyester Satin Fabric For Women's Gown
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    Poly bubble moss crepe dress material fabric
    Poly bubble moss crepe dress material fabric
    Price: MRP Original price was: ₹592.20.Current price is: ₹288.75. / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    Navy Blue base color Floral print on Cotton Cambric fabric for Women's Kurta
    Navy Blue base color Floral print on Cotton Cambric fabric for Women's Kurta
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    COTTON HAKOBA
    Skin Color Cotton Seersucker Embroidery Fabric For Women's Kurta
    Price: MRP₹630.00 / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    Red Color poly textured lycra dress material fabric
    Red Color poly textured lycra dress material fabric
    Price: MRP Original price was: ₹693.00.Current price is: ₹592.20. / mtr (incl. of all taxes)
    ₹592.20 (incl. GST)
    Blue base Paisley Print on Cotton Slub fabric for Women's Top
    Blue base Paisley Print on Cotton Slub fabric for Women's Top
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Yellow Color South cotton fabric for Ladies Saree
    Yellow Color South cotton fabric for Ladies Saree
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Red color Cotton Mangalgiri fabric for Ladies Saree
    Red color Cotton Mangalgiri fabric for Ladies Saree
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Skin Color Cotton Tussar Fabric For Women's Kurta
    Skin Color Cotton Tussar Fabric For Women's Kurta
    Price: MRP₹259.61 / mtr (incl. of all taxes)
    ₹259.61 (incl. GST)
    Black color Cotton Tussar fabric for Men's Shirt
    Black color Cotton Tussar fabric for Men's Shirt
    Price: MRP₹395.06 / mtr (incl. of all taxes)
    ₹395.06 (incl. GST)
    Subtotal ₹3,892.62 (incl. GST)
    To find out your shipping cost , Please proceed to checkout.
    View CartCheckout