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 (1288)
) 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
Online Best Boota Fabric Material | Charu Creation Online Best Boota Fabric Material | Charu Creation
+91-9971106200
X

Showing 1–12 of 22 resultsSorted by latest

Showing 1–12 of 22 resultsSorted by latest

SELECT   ujw_posts.*
					 FROM ujw_posts 
					 WHERE 1=1  AND ujw_posts.post_name = 'e2f5f1626c938bee1f84fa3186db0198' AND ujw_posts.post_type = 'oembed_cache' AND ((ujw_posts.post_status = 'publish'))
					 
					 ORDER BY ujw_posts.post_date DESC
In stock only
20
    20
    Your Cart
    Green color Plain Cotton Cambric Fabric for Men's Kurta Salwar Dress
    Green color Plain Cotton Cambric Fabric for Men's Kurta Salwar Dress
    Price: MRP₹197.54 / mtr (incl. of all taxes)
    ₹197.54 (incl. GST)
    Mustard Color Taffeta Fabric for Women's Gown
    Mustard Color Taffeta Fabric for Women's Gown
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (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)
    Black Color Plain Cotton Voile Dress Material Fabric
    Black Color Plain Cotton Voile Dress Material Fabric
    Price: MRP₹141.10 / mtr (incl. of all taxes)
    ₹141.10 (incl. GST)
    Charu Dual Shade Blue Poly Satin Crushed Dress Fabric for Clothing
    Charu Dual Shade Blue Poly Satin Crushed Dress Fabric for Clothing
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Grey Color Plain Taffeta Fabric for Men's Jacket
    Grey Color Plain Taffeta Fabric for Men's Jacket
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    Multicolor Viscose Linen fabric for Women's Blazer
    Multicolor Viscose Linen fabric for Women's Blazer
    Price: MRP₹451.50 / mtr (incl. of all taxes)
    ₹451.50 (incl. GST)
    Orange Color Plain Cotton Cambric Choodidaar Lining Dress Material Fabric
    Orange Color Plain Cotton Cambric Choodidaar Lining Dress Material Fabric
    Price: MRP Original price was: ₹346.50.Current price is: ₹197.54. / mtr (incl. of all taxes)
    ₹197.54 (incl. GST)
    White Color Floral Print on Cotton Embroidered Dress Material Fabric
    White Color Floral Print on Cotton Embroidered Dress Material Fabric
    Price: MRP₹577.50 / mtr (incl. of all taxes)
    ₹577.50 (incl. GST)
    Black color Polyester frenzies Textured fabric for Women's Top
    Black color Polyester frenzies Textured fabric for Women's Top
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Black color Polyester texture fabric for Women's Office Wear Shirts
    Black color Polyester texture fabric for Women's Office Wear Shirts
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Pink Color Polyester Seersucker Fabric For Women's Kurta
    Pink Color Polyester Seersucker Fabric For Women's Kurta
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Charu Multi Color Plain Poly Dupion Dress Fabric for Women's Shirt
    Charu Multi Color Plain Poly Dupion Dress Fabric for Women's Shirt
    Price: MRP₹141.10 / mtr (incl. of all taxes)
    ₹141.10 (incl. GST)
    Multicolor Print on Net Print Fabric for Women's Traditional Wear
    Multicolor Print on Net Print Fabric for Women's Traditional Wear
    Price: MRP₹99.00 / mtr (incl. of all taxes)
    ₹99.00 (incl. GST)
    Dusty color Polyester frenzies Textured fabric for Women's Western Top
    Dusty color Polyester frenzies Textured fabric for Women's Western Top
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Pink color poly textured lycra dress material fabric
    Pink color poly textured lycra dress material fabric
    Price: MRP Original price was: ₹693.00.Current price is: ₹288.75. / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    Charu Pink Color Plain Cotton Gauze Fabric for Women's Blouse
    Charu Pink Color Plain Cotton Gauze Fabric for Women's Blouse
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    Blue color Futki Lurex Fabric for Women's Western Dress
    Blue color Futki Lurex Fabric for Women's Western Dress
    Price: MRP Original price was: ₹472.50.Current price is: ₹451.50. / mtr (incl. of all taxes)
    ₹451.50 (incl. GST)
    White Color Floral Print on Nylon Net Embroidered Dress Material Fabric
    White Color Floral Print on Nylon Net Embroidered Dress Material Fabric
    Price: MRP₹577.50 / mtr (incl. of all taxes)
    ₹577.50 (incl. GST)
    Multicolor Floral print on Cotton Cambric Boota fabric for Women's Dress
    Multicolor Floral print on Cotton Cambric Boota fabric for Women's Dress
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Subtotal ₹6,645.43 (incl. GST)
    To find out your shipping cost , Please proceed to checkout.
    View CartCheckout