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 (1047)
) 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 24, 12
Party Wear Fabric Collection | Charu Creation | Page 3 Party Wear Fabric Collection | Charu Creation | Page 3
+91-9971106200
X

Showing 25–30 of 30 resultsSorted by latest

Showing 25–30 of 30 resultsSorted by latest

In stock only
10
    10
    Your Cart
    White color Cotton Hakoba fabric for Women's Top
    White color Cotton Hakoba fabric for Women's Top
    Price: MRP Original price was: ₹451.50.Current price is: ₹420.00. / mtr (incl. of all taxes)
    ₹420.00 (incl. GST)
    White Base Color Orange Embroidery on Cotton Hakoba Fabric For Women's Kurti
    White Base Color Orange Embroidery on Cotton Hakoba Fabric For Women's Kurti
    Price: MRP₹630.00 / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    White Color Star Print on Cotton Embroidered Dress Material Fabric
    White Color Star Print on Cotton Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹282.19.Current price is: ₹262.50. / mtr (incl. of all taxes)
    ₹262.50 (incl. GST)
    White Color Star Print on Cotton Embroidered Dress Material Fabric
    White Color Star Print on Cotton Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹564.38.Current price is: ₹525.00. / mtr (incl. of all taxes)
    ₹525.00 (incl. GST)
    White color Cotton Cambric Embroidery Dyeable fabric for Women's Western Top
    White color Cotton Cambric Embroidery Dyeable fabric for Women's Western Top
    Price: MRP Original price was: ₹677.25.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    White Base Color Blue Embroidery on Cotton Hakoba Fabric For Women's Kurta
    White Base Color Blue Embroidery on Cotton Hakoba Fabric For Women's Kurta
    Price: MRP₹1,050.00 / mtr (incl. of all taxes)
    ₹1,050.00 (incl. GST)
    White Color Floral Print on Cotton Embroidered Dress Material Fabric
    White Color Floral Print on Cotton Embroidered Dress Material Fabric
    Price: MRP Original price was: ₹564.38.Current price is: ₹525.00. / mtr (incl. of all taxes)
    ₹525.00 (incl. GST)
    Multicolor Net Sequin Dress Material Fabric
    Multicolor Net Sequin Dress Material Fabric
    Price: MRP₹1,386.00 / mtr (incl. of all taxes)
    ₹1,386.00 (incl. GST)
    Black Georgette Fabric With Double Side Embroidered Fabric Dress Material (Eyelet Fabric)
    Black Georgette Fabric With Double Side Embroidered Fabric Dress Material (Eyelet Fabric)
    Price: MRP Original price was: ₹750.75.Current price is: ₹630.00. / mtr (incl. of all taxes)
    ₹630.00 (incl. GST)
    Pink Silver Baby Sequin On Mesh Glittery Dress Material
    Pink Silver Baby Sequin On Mesh Glittery Dress Material
    Price: MRP₹1,260.00 / mtr (incl. of all taxes)
    ₹1,260.00 (incl. GST)
    Subtotal ₹7,318.50 (incl. GST)
    To find out your shipping cost , Please proceed to checkout.
    View CartCheckout