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 (23)
			) 
  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 (17667)
) 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
Seersucker Archives - Charu Creation Seersucker Archives - Charu Creation
+91-9971106200
X

Showing 1–12 of 13 resultsSorted by latest

Showing 1–12 of 13 resultsSorted by latest

In stock only
14
    14
    Your Cart
    Green color Poly Dupion fabric for Men's Traditional Kurta
    Green color Poly Dupion fabric for Men's Traditional Kurta
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    Multicolor Polyester Jacquard fabric for Women's Top
    Multicolor Polyester Jacquard fabric for Women's Top
    Price: MRP₹677.25 / mtr (incl. of all taxes)
    ₹677.25 (incl. GST)
    White Base Color Beige Linene Embroidery Fabric For Women's Top
    White Base Color Beige Linene Embroidery Fabric For Women's Top
    Price: MRP Original price was: ₹1,155.00.Current price is: ₹1,050.00. / mtr (incl. of all taxes)
    ₹1,050.00 (incl. GST)
    White Color Cotton Hakoba Embroidery Fabric For Women's Kurta
    White Color Cotton Hakoba Embroidery Fabric For Women's Kurta
    Price: MRP₹420.00 / mtr (incl. of all taxes)
    ₹420.00 (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)
    Cream Color Polyester Textured Fabric For Women's Dress
    Cream Color Polyester Textured Fabric For Women's Dress
    Price: MRP₹395.06 / mtr (incl. of all taxes)
    ₹395.06 (incl. GST)
    Brown Color Poly Viscose Slub Dress Material Fabric
    Brown Color Poly Viscose Slub Dress Material Fabric
    Price: MRP Original price was: ₹577.50.Current price is: ₹367.50. / mtr (incl. of all taxes)
    ₹367.50 (incl. GST)
    Multicolor Cotton Matka fabric for Home Furnishing
    Multicolor Cotton Matka fabric for Home Furnishing
    Price: MRP₹507.94 / mtr (incl. of all taxes)
    ₹507.94 (incl. GST)
    Peach color Plain Poly Georgette Lurex fabric for Saree
    Peach color Plain Poly Georgette Lurex fabric for Saree
    Price: MRP Original price was: ₹190.31.Current price is: ₹169.31. / mtr (incl. of all taxes)
    ₹169.31 (incl. GST)
    Multicolor Polyester Jacquard fabric for Women's Partydress
    Multicolor Polyester Jacquard fabric for Women's Partydress
    Price: MRP₹677.25 / mtr (incl. of all taxes)
    ₹677.25 (incl. GST)
    MultiColor Pasley Design on Rayon Fabric for Women's Top
    MultiColor Pasley Design on Rayon Fabric for Women's Top
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    White color Polyester Textured fabric for Women's Blazer
    White color Polyester Textured fabric for Women's Blazer
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    White Base Color Blue Embroidery on Cotton Hakoba Fabric For Women's Kurti
    White Base Color Blue Embroidery on Cotton Hakoba Fabric For Women's Kurti
    Price: MRP₹1,050.00 / mtr (incl. of all taxes)
    ₹1,050.00 (incl. GST)
    Pista Green color Polyester Bubble Textured Seersucker fabric for Women's Midi Dress
    Pista Green color Polyester Bubble Textured Seersucker fabric for Women's Midi Dress
    Price: MRP₹564.38 / mtr (incl. of all taxes)
    ₹564.38 (incl. GST)
    Subtotal ₹7,515.39 (incl. GST)
    To find out your shipping cost , Please proceed to checkout.
    View CartCheckout