#
+91 9677283427
customercare@hugfab.com

KIDS

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

Pink N Navy Blue Kids Wear -Lehenga Choli

Pink N Navy Blue Kids Wear -Lehenga Choli

DESCRIPTION:Kids Favourite Lehenga Choli Net Fabric With Butta, Lace, Resham Work -UNSTITCHED Size - Upto 42

Rs. 4,308 Rs. 3,016

30% Off

Navy Colour Soft Net Girls Gown Wear

Navy Colour Soft Net Girls Gown Wear

DESCRIPTION:Navy Colour Soft Net Girls Gown Wear

Rs. 3,120 Rs. 2,340

25% Off

Peach N Beige Kids Wear-Gown

Peach N Beige Kids Wear-Gown

DESCRIPTION:Flower HandWork,Sequence Embroderied,Net Fabric Gown-Size upto-32

Rs. 2,880 Rs. 2,160

25% Off

Multi Color Kids Wear-Gown

Multi Color Kids Wear-Gown

DESCRIPTION:Flower HandWork,Sequence Embroderied,Net Fabric Gown-Size upto-32

Rs. 3,120 Rs. 2,340

25% Off

Multi Colour Kids Wear-Lehenga choli

Multi Colour Kids Wear-Lehenga choli

DESCRIPTION:Flower HandWork,Sequence Embroderied,Net Fabric Lehenga choli -Size upto-32

Rs. 2,880 Rs. 2,160

25% Off

Green N Pink Kids Wear -Lehenga Choli

Green N Pink Kids Wear -Lehenga Choli

DESCRIPTION:Kids Favourite Lehenga Choli Net Fabric With Butta, Lace, Resham Work -UNSTITCHED Size - Upto 42

Rs. 4,068 Rs. 2,929

28% Off

Red N Green Kids Wear -Lehenga Choli

Red N Green Kids Wear -Lehenga Choli

DESCRIPTION:Kids Favourite Lehenga Choli Net Fabric With Butta, Lace, Resham Work -UNSTITCHED Size - Upto 42

Rs. 3,552 Rs. 2,664

25% Off

Green N Pink Kids Wear -Lehenga Choli

Green N Pink Kids Wear -Lehenga Choli

DESCRIPTION:Kids Favourite Lehenga Choli Net Fabric With Lace and Embroidery Work -UNSTITCHED Size - Upto 42

Rs. 2,592 Rs. 2,074

20% Off

Navy Blue Kids Wear-Gown

Navy Blue Kids Wear-Gown

DESCRIPTION:Flower HandWork,Sequence Embroderied,Net Fabric Gown-Size upto-32

Rs. 3,120 Rs. 2,340

25% Off

Navy Blue Digital Printed Kids Wear-Gown

Navy Blue Digital Printed Kids Wear-Gown

DESCRIPTION:Flower HandWork,Sequence Embroderied,Net Fabric Gown-Size upto-32

Rs. 3,120 Rs. 2,340

25% Off

Multi Color Kids Wear-Gown

Multi Color Kids Wear-Gown

DESCRIPTION:Flower HandWork,Sequence Embroderied,Net Fabric Gown-Size upto-32

Rs. 3,120 Rs. 2,340

25% Off

Maroon HandWork Kids Wear-Gown

Maroon HandWork Kids Wear-Gown

DESCRIPTION:Flower HandWork,Sequence Embroderied,Net Fabric Gown-Size upto-32

Rs. 3,120 Rs. 2,340

25% Off

Orange Kids Wear -Lehenga Choli

Orange Kids Wear -Lehenga Choli

DESCRIPTION:Kids Favourite Lehenga Choli Net Fabric With Butta, Lace, Resham Work -UNSTITCHED Size - Upto 42

Rs. 4,308 Rs. 3,016

30% Off

Black Colour Banglori Silk Girls Gown Wear

Black Colour Banglori Silk Girls Gown Wear

DESCRIPTION:Black Colour Banglori Silk Girls Gown Wear

Rs. 2,640 Rs. 1,980

25% Off

Navy Blue N Pink Kids Wear -Lehenga Choli

Navy Blue N Pink Kids Wear -Lehenga Choli

DESCRIPTION:Kids Favourite Lehenga Choli Net Fabric With Butta, Lace, Resham Work -UNSTITCHED Size - Upto 42

Rs. 4,068 Rs. 2,929

28% Off

Navy Blue N pink Kids Wear -Lehenga Choli

Navy Blue N pink Kids Wear -Lehenga Choli

DESCRIPTION:Kids Favourite Lehenga Choli Net Fabric With Butta, Lace, Resham Work -UNSTITCHED Size - Upto 42

Rs. 3,552 Rs. 2,664

25% Off

Red N Green Kids Wear -Lehenga Choli

Red N Green Kids Wear -Lehenga Choli

DESCRIPTION:Kids Favourite Lehenga Choli Net Fabric With Lace and Embroidery Work -UNSTITCHED Size - Upto 42

Rs. 2,592 Rs. 2,074

20% Off

Black N Sandal Kids Wear - Gown

Black N Sandal Kids Wear - Gown

DESCRIPTION:Kids Favourite Gown with Silk Fabric Semi Stitched Size -30,36

Rs. 2,878 Rs. 2,159

25% Off

Green Colour Tafetta Silk Girls Gown Wear

Green Colour Tafetta Silk Girls Gown Wear

DESCRIPTION:Green Colour Tafetta Silk Girls Gown Wear

Rs. 3,120 Rs. 2,340

25% Off

Orange N Green Kids Wear -Lehenga Choli

Orange N Green Kids Wear -Lehenga Choli

DESCRIPTION:Kids Favourite Lehenga Choli Net Fabric With Butta, Lace, Resham Work -UNSTITCHED Size - Upto 42

Rs. 4,068 Rs. 3,051

25% Off

Showing 1 to 20 of 73 ( 4 Pages)