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 (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
X

Showing 1–12 of 17 resultsSorted by latest

Showing 1–12 of 17 resultsSorted by latest

16
    16
    Your Cart
    Beige Color Eye Print on Cotton Poplin Dress Material Fabric
    Beige Color Eye Print on Cotton Poplin Dress Material Fabric
    Price: MRP₹288.75 / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    Off White Color Floral Print on Net Embroidered Dress Material Fabric
    Off White Color Floral Print on Net Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹677.25.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    Pink Color Plain Cotton Cambric Dress Material Fabric
    Pink Color Plain Cotton Cambric Dress Material Fabric
    Price: MRP₹141.10 / mtr (incl. of all taxes)
    ₹141.10 (incl. GST)
    Multicolor Cotton Poplin Dress Material Fabric
    Multicolor Cotton Poplin Dress Material Fabric
    Price: MRP₹288.75 / mtr (incl. of all taxes)
    ₹288.75 (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)
    Multicolor tropical design on multicolor poly organza dress material fabric
    ₹346.50 (incl. GST)
    Multicolor Printed Design on Cotton Poplin Dress Material Fabric
    Multicolor Printed Design on Cotton Poplin Dress Material Fabric
    Price: MRP₹288.75 / mtr (incl. of all taxes)
    ₹577.50 (incl. GST)
    Yellow color Wool fabric for Ladies Coat
    Yellow color Wool fabric for Ladies Coat
    Price: MRP₹677.25 / mtr (incl. of all taxes)
    ₹677.25 (incl. GST)
    Pink color Wool fabric for Ladies Shrugs
    Pink color Wool fabric for Ladies Shrugs
    Price: MRP₹677.25 / mtr (incl. of all taxes)
    ₹677.25 (incl. GST)
    Black color Cotton Crepe fabric for Lining Garments
    Black color Cotton Crepe fabric for Lining Garments
    Price: MRP₹169.31 / mtr (incl. of all taxes)
    ₹169.31 (incl. GST)
    Bottle Green color Poly Georgette textured imported fabric for Women's Trousers
    ₹507.94 (incl. GST)
    All Over Design Yarn Dyed Check , Off White Color Thread Embroidery Fabric (Eyelet Fabric)
    All Over Design Yarn Dyed Check , Off White Color Thread Embroidery Fabric (Eyelet Fabric)
    Price: MRP Original price was: ₹1,270.50.Current price is: ₹1,050.00. / mtr (incl. of all taxes)
    ₹1,050.00 (incl. GST)
    Double Side Textured Poly Dress Material Fabric
    Double Side Textured Poly Dress Material Fabric
    Price: MRP Original price was: ₹693.00.Current price is: ₹218.89. / mtr (incl. of all taxes)
    ₹218.89 (incl. GST)
    Green color Wool fabric for Men's Coat
    Green color Wool fabric for Men's Coat
    Price: MRP₹677.25 / mtr (incl. of all taxes)
    ₹677.25 (incl. GST)
    Yellow color Polyester Bubble Textured Seersucker fabric for Women's Top
    Yellow color Polyester Bubble Textured Seersucker fabric for Women's Top
    Price: MRP₹395.06 / mtr (incl. of all taxes)
    ₹395.06 (incl. GST)