#
+91 9677283427
info@hugfab.com

Celebrity Wear

  • Colors
      SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='162'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='92'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='91'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='90'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='89'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='88'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='87'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='86'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='85'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='84'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='83'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='82'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='81'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='80'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='79'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='78'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='77'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='93'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='94'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='160'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='159'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='152'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='138'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='137'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='135'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='109'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='108'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='107'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='103'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='100'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='99'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='98'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='97'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='96'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='95'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='76'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='75'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='74'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='53'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='52'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='51'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='50'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='49'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='48'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='47'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='46'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='45'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='44'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='43'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='42'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='41'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='54'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='55'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='73'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='72'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='71'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='70'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='69'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='68'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='67'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='66'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='21'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='56'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='57'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='58'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='59'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='65'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='26'SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='23'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='27'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='24'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='25'
    • SELECT count(pov.product_id) as color_total FROM product p INNER JOIN `product_option_value` pov ON p.product_id = pov.product_id INNER JOIN product_to_category p2c ON p.product_id = p2c.product_id where p2c.category_id='168' and option_value_id='22'
  • Prices

Mint Green Georgette Celebrity-Wear Anarkali Suit

Mint Green Georgette Celebrity-Wear Anarkali Suit

DESCRIPTION : Celebrate This Festive Season With This Pretty Mint Green Colored Floor Length Suit Paired With Mint Green Colored Bottom And Dupatta. Its Fabricated On Georgette Paired With Santoon Bottom And Chiffon Dupatta. It Is Beautified With Elegant Embroidery All Over. Grab This Lovely Suit Now.

Top Color : Mint Green
Bottom Color : Mint Green
Dupatta Color : Mint Green
Top Fabric : Georgette
Bottom Fabric : Santoon
Dupatta Fabric : Chiffon
Inner Fabric : Santoon
Work : Jari & Thread Embroidery With Stone Work
Customised Upto : 42"
Wash : Dry Clean

Rs. 6,223 Rs. 4,356

30% Off

Cream Georgette Salwar Suit

Cream Georgette Salwar Suit

DESCRIPTION: Your Beautiful Smile Will Enhance Manifolds With The Look Of This Dress On You. This Cream Colored Fancy GeorgetteSuit Is What Makes The Daily Wear More Exciting. Wear It To Your Trips To The Market Or A Tea Party And Look Fabulous. Get This Now.

Top Color : Cream
Bottom Color : Cream
Dupatta Color : Cream
Top Fabric : Georgette
Bottom Fabric : Santoon
Dupatta Fabric : Chiffon
Inner Fabric : Santoon
Work : Zari, resham embroidery with stone work and Lace border
Top Length : 48
Customised Upto : 40"
Wash: Dry Clean

Rs. 5,062 Rs. 3,644

28% Off

Pastel Green Georgette Salwar Suit

Pastel Green Georgette Salwar Suit

DESCRIPTION: This Summer Is All About Sorbet Shades Pastel Play. Grab This Pastel Green Colored Suit Paired With Pastel Green Colored Bottom And Dupatta. This Suit Is Fabricated On Georgette Paired With Santoon Bottom And Chiffon Dupatta. Buy This Lovely Suit Now.

Top Color : Pastel Green
Bottom Color : Pastel Green
Dupatta Color : Pastel Green
Top Fabric : Georgette
Bottom Fabric : Santoon
Dupatta Fabric : Chiffon
Inner : Santoon
Work : Jari & Resham Embroidery With Stone Work
Customised Upto : 40"
Top Length : 48"
Wash: Dry Clean

Rs. 6,223 Rs. 4,356

30% Off

Pastel Peach Georgette Celebrity-Wear Anarkali Suit

Pastel Peach Georgette Celebrity-Wear Anarkali Suit

DESCRIPTION : Flanut Your Rich Taste With This Sophisticated Pastel Peach Colored Floor Length Suit Paired With Contrasting Red Colored Dupatta. Its Top Is Fabricated On Georgette Beautified With Floral Colorful Thread Embroidery Paired With Santoon Bottom And Chiffon Dupatta. All Three Fabrics Ensures Great Comfort All Day Long. Buy It Now.

Top Color : Pastel Peach
Bottom Color : Pastel Peach
Dupatta Color : Red
Top Fabric : Georgette
Bottom Fabric : Santoon
Dupatta Fabric : Chiffon
Inner Fabric : Santoon
Work : Jari & Thread Embroidery With Stone Work
Customised Upto : 42"
Wash : Dry Clean

Rs. 6,223 Rs. 4,356

30% Off

Beige Georgette Salwar Suit

Beige Georgette Salwar Suit

DESCRIPTION: Elegant And Beautiful Color Is Here In This Beige Colored Semi-Stitched Suit. Its Is Paired With Beige Colored Bottom And Dupatta. Its Top Is Fabricated On Georgette Paired With Santoon Bottom And Chiffon Dupatta. Buy This Suit Now.

Top Color : Beige
Bottom Color : Beige
Dupatta Color : Beige
Top Fabric : Georgette
Bottom Fabric : Santoon
Dupatta Fabric : Chiffon
Inner : Santoon
Work : Jari & Resham Embroidery With Stone Work
Customised Upto : 40"
Top Length : 48"
Wash: Dry Clean

Rs. 5,791 Rs. 4,053

30% Off

Dark Pink Georgette Celebrity-Wear Anarkali Suit

Dark Pink Georgette Celebrity-Wear Anarkali Suit

DESCRIPTION : Another indo-Western Patternend Suit Is Here In This Dark Pink Colored Suit. This Suit Is Paired With Dark Pink Colored Bottom And Dupatta. Its Top Is Fabricated On Georgette Paired With Santoon Bottom And Chiffon Dupatta. This Semi-Stitched Dress Is Beautified With Detailed Jari And Thread Embroidery Making The Suit Attractive. Buy It Now.

Top Color : Dark Pink
Bottom Color : Dark Pink
Dupatta Color : Dark Pink
Top Fabric : Georgette
Bottom Fabric : Santoon
Dupatta Fabric : Chiffon
Inner Fabric : Santoon
Work : Jari & Thread Embroidery With Stone Work
Customised Upto : 42"
Wash : Dry Clean

Rs. 6,223 Rs. 4,356

30% Off

Showing 21 to 26 of 26 ( 2 Pages)