Bumper Sale On Fabric | Latest Fashion Dress Material | Charu Creation

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 (167,365,2746,17350)
) 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 168, 12

Bumper Sale On Fabric | Latest Fashion Dress Material | Charu Creation Bumper Sale On Fabric | Latest Fashion Dress Material | Charu Creation

Showing 169–180 of 311 resultsSorted by latest

Showing 169–180 of 311 resultsSorted by latest

“Blue Color Cotton Lurex Dress Material Fabric” has been added to your cart. View cart

Sale!
Lurex
Blue Color Cotton Lurex Dress Material Fabric
MRP Original price was: ₹231.00.Current price is: ₹149.00. / mtr (incl. of all taxes)
74.5 Meter left in stock

Buy
Sale!
Under Rs. 149
Multicolor Check Print on South Cotton Dress Material Fabric
MRP Original price was: ₹288.75.Current price is: ₹149.00. / mtr (incl. of all taxes)
60.5 Meter left in stock

Buy
Sale!
Crepe
Multicolor Printed Design on Rayon Crepe Dress Material Fabric
MRP Original price was: ₹231.00.Current price is: ₹149.00. / mtr (incl. of all taxes)
15.5 Meter left in stock

Buy
Sale!
Under Rs. 149
Red Color Floral Print on Cotton Slub Dress Material Fabric
MRP Original price was: ₹282.19.Current price is: ₹149.00. / mtr (incl. of all taxes)
13 Meter left in stock

Buy
Sale!
Under RS. 99
Multicolor Floral Print on Rayon Crepe Dress Material Fabric
MRP Original price was: ₹173.25.Current price is: ₹99.00. / mtr (incl. of all taxes)
11 Meter left in stock

Buy
Out of stock
Sale!
Rayon
Multicolor Floral Print on Rayon Dress Material Fabric
MRP Original price was: ₹231.00.Current price is: ₹149.00. / mtr (incl. of all taxes)
Out of stock
Under Rs. 149
Off White Floral Print on Cotton Foil Dress Material Fabric
MRP₹99.00 / mtr (incl. of all taxes)
Sale!
Under Rs. 149
Yellow Color Printed Design on Hand Spun Cotton Dress Material Fa...
MRP Original price was: ₹288.75.Current price is: ₹149.00. / mtr (incl. of all taxes)
0.75 Meter left in stock

Buy
Out of stock
Sale!
Net
Peach Color Owl Print on Cotton Nylon Burnout Dress Material Fabr...
MRP Original price was: ₹288.75.Current price is: ₹209.90. / mtr (incl. of all taxes)
Out of stock
Sale!
Under Rs. 149
White Color Floral Print on Cotton Cambric Dress Material Fabric
MRP Original price was: ₹282.19.Current price is: ₹149.00. / mtr (incl. of all taxes)
Out of stock
Sale!
Poplin
Multicolor Eye Print on Cotton Poplin Dress Material Fabric
MRP Original price was: ₹288.75.Current price is: ₹149.00. / mtr (incl. of all taxes)
Out of stock
Sale!
Under Rs. 149
White Color Cotton Slub Dress Material Fabric
MRP Original price was: ₹231.00.Current price is: ₹149.00. / mtr (incl. of all taxes)