#
+91 9677283427
info@hugfab.com

Tussar Silk Sarees

  • 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' 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='82' and option_value_id='22'
  • Prices

Navy Colour Net Tussar Silk Saree

Navy Colour Net Tussar Silk Saree

DESCRIPTION:Navy Colour Net Tussar Silk Saree

Rs. 2,520 Rs. 1,966

22% Off

Aqua Blue Colour Net Tussar Silk Saree

Aqua Blue Colour Net Tussar Silk Saree

DESCRIPTION:Aqua Blue Colour Net Tushar Silk Saree

Rs. 2,640 Rs. 2,059

22% Off

Blue Colour Net Tussar Silk Saree

Blue Colour Net Tussar Silk Saree

DESCRIPTION:Blue Colour Net Tushar Silk Saree

Rs. 2,520 Rs. 1,966

22% Off

Pink Colour Net Tussar Silk Saree

Pink Colour Net Tussar Silk Saree

DESCRIPTION:Pink Colour Net Tushar Silk Saree

Rs. 2,520 Rs. 1,966

22% Off

Yellow Colour Net Tussar Silk Saree

Yellow Colour Net Tussar Silk Saree

DESCRIPTION:Navy Colour Net Tushar Silk Saree

Rs. 2,640 Rs. 2,059

22% Off

Brown Colour Net Tussar Silk Saree

Brown Colour Net Tussar Silk Saree

DESCRIPTION:Brown Colour Net Tushar Silk Saree

Rs. 2,520 Rs. 1,966

22% Off

Yellow Colour Net Tussar Silk Saree

Yellow Colour Net Tussar Silk Saree

DESCRIPTION:Yellow Colour Net Tushar Silk Saree

Rs. 2,520 Rs. 1,966

22% Off

Magenta Colour Net Tussar Silk Saree

Magenta Colour Net Tussar Silk Saree

DESCRIPTION:Magenta Colour Net Tushar Silk Saree

Rs. 2,520 Rs. 1,966

22% Off

Orange Colour Net Tussar Silk Saree

Orange Colour Net Tussar Silk Saree

DESCRIPTION:Orange Colour Net Tushar Silk Saree

Rs. 2,520 Rs. 1,966

22% Off

Red Colour Net Tussar Silk Saree

Red Colour Net Tussar Silk Saree

DESCRIPTION:Red Colour Net Tushar Silk Saree

Rs. 2,520 Rs. 1,966

22% Off

Prussian Blue Net Tussar Silk Saree

Prussian Blue Net Tussar Silk Saree

DESCRIPTION:Prussian Blue Colour Net Tushar Silk Saree

Rs. 2,520 Rs. 1,966

22% Off

Green Colour Net Tussar Silk Saree

Green Colour Net Tussar Silk Saree

DESCRIPTION:Green Colour Net Tushar Silk Saree

Rs. 2,640 Rs. 2,059

22% Off

Old Rose Pink Colour Net Tussar Silk Saree

Old Rose Pink Colour Net Tussar Silk Saree

DESCRIPTION:Old Rose Pink Colour Net Tushar Silk Saree

Rs. 2,520 Rs. 1,966

22% Off

Rama Green Colour Net Tussar Silk Saree

Rama Green Colour Net Tussar Silk Saree

DESCRIPTION:Rama Green Colour Net Tushar Silk Saree

Rs. 2,520 Rs. 1,966

22% Off

Showing 1 to 14 of 14 ( 1 Pages)