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 (1477)
) 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
Multicolor Cotton Dobby For Men And Women Kurtas | Charu Creation Multicolor Cotton Dobby For Men And Women Kurtas | Charu Creation
+91-9971106200
X

Showing all 12 resultsSorted by latest

Showing all 12 resultsSorted by latest

11
    11
    Your Cart
    Navy Blue color Olivia Georgette fabric for Women's Western Dresses
    Navy Blue color Olivia Georgette fabric for Women's Western Dresses
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    White color Cotton Dobby fabric for Men's Kurta
    White color Cotton Dobby fabric for Men's Kurta
    Price: MRP₹282.19 / mtr (incl. of all taxes)
    ₹282.19 (incl. GST)
    Magenta color Olivia Georgette fabric for Women's Western Dresses
    Magenta color Olivia Georgette fabric for Women's Western Dresses
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    Mehendi Green base color Floral Print on Polyester Georgette fabric for Women's Maxi Dress
    Mehendi Green base color Floral Print on Polyester Georgette fabric for Women's Maxi Dress
    Price: MRP₹141.10 / mtr (incl. of all taxes)
    ₹141.10 (incl. GST)
    Grey Color Cotton Cambric Lining Dress Material Fabric
    Grey Color Cotton Cambric 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)
    Baby Pink color Olivia Georgette fabric for Girls Partywear Dresses
    Baby Pink color Olivia Georgette fabric for Girls Partywear Dresses
    Price: MRP₹338.63 / mtr (incl. of all taxes)
    ₹338.63 (incl. GST)
    Off White Plain Cotton Twill Dress Material Fabric
    Off White Plain Cotton Twill Dress Material Fabric
    Price: MRP₹288.75 / mtr (incl. of all taxes)
    ₹288.75 (incl. GST)
    Multicolor Viscose Linen Fabric For Women's Top
    Multicolor Viscose Linen Fabric For Women's Top
    Price: MRP₹451.50 / mtr (incl. of all taxes)
    ₹451.50 (incl. GST)
    Peach Color Plain Cotton Cambric Lining Dress Material fabric
    Peach Color Plain Cotton Cambric 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)
    Off White Color Cotton Lurex Dobby Fabric For Women's Kurta
    Off White Color Cotton Lurex Dobby Fabric For Women's Kurta
    Price: MRP₹203.18 / mtr (incl. of all taxes)
    ₹203.18 (incl. GST)
    Red color Cotton Dobby fabric for Men's Stylish Shirts
    Red color Cotton Dobby fabric for Men's Stylish Shirts
    Price: MRP₹225.75 / mtr (incl. of all taxes)
    ₹225.75 (incl. GST)
    Subtotal ₹3,003.44 (incl. GST)
    To find out your shipping cost , Please proceed to checkout.
    View CartCheckout