select * from table_product_search_view where status = 1 and collection = 'Dresses' order by tlid desc
ORDER NOW VIA CALL OR WHATSAPP | +91 9811993458 Worldwide Shipping • Free Shipping in India
Brown Hand Embroidered Pichwai Jacket
$ 324/-
Rust and Beige Hand Embroidered Co-Ord Set
Purple Hand Embroidered Pichwai Jacket
Blue Hand Embroidered Pichwai Jacket
Pink Hand Embroidered Pichwai Jacket
Green Hand Embroidered Pichwai Jacket
Golden Hand Embroidered Pichwai Jacket
$ 361/-
Red Hand Embroidered Pichwai Shirt
$ 161/-
Out of Stock
Olive Green Hand Embroidered Pichwai Top
$ 111/-
Blue Hand Embroidered Pichwai Top
Pink Hand Embroidered Pichwai Top
Green Hand Embroidered Pichwai Top
Mustard Hand Embroidered Pichwai Top
Yellow Hand Embroidered Pichwai Top
Blue Hand Painted Pichwai Top
Pink and Red Paithani & Chanderi Dress with Belt
$ 536/-
Grey and Rust Paithani & Chanderi Dress with Belt
Brown and Beige Hand Embroidered Pichwai Pants
$ 261/-
Rust and Beige Hand Embroidered Pichwai Pants
Purple and Beige Hand Embroidered Pichwai Pants
Blue and Beige Hand Embroidered Pichwai Pants
Pink and Beige Hand Embroidered Pichwai Pants
Green and Beige Hand Embroidered Pichwai Pants
Golden and Blue Hand Embroidered Pichwai Pants
Golden and Grey Hand Embroidered Pichwai Pants
Green Printed Pichwai Pants
Lemon Printed Pichwai Pants
Purple Printed Pichwai Pants
Grey Blue Printed Pichwai Pants
Pink Printed Pichwai Pants
Grey Printed Pichwai Pants
Yellow Printed Pichwai Pants
Peach and Mustard Paithani & Chanderi Dress with Belt
Brown and Beige Hand Embroidered Co-Ord Set
$ 561/-
Purple and Beige Hand Embroidered Co-Ord Set
Blue and Beige Hand Embroidered Co-Ord Set
Pink and Beige Hand Embroidered Co-Ord Set
Green and Beige Hand Embroidered Co-Ord Set
Golden and Blue Hand Embroidered Co-Ord Set
$ 586/-
Golden and Grey Hand Embroidered Co-Ord Set
Green Hand Embroidered Pichwai Shirt
$ 136/-
Black Hand Painted Pichwai Top
Wine Hand Painted Pichwai Top
Red Hand Painted Pichwai Top
Green Hand Painted Pichwai Top
Hand Painted Paithani Pichwai Pants
$ 286/-
Mauve Hand Painted Pichwai Pants
$ 211/-
Green Hand Painted Pichwai Pants
Beige Hand Painted Pichwai Pants
Blue Hand Embroidered Pichwai Pants
Pink Hand Embroidered Co-Ord Set
$ 324
$ 259/-
Grey Hand Embroidered Co-Ord Set
Light Blue Hand Embroidered Co-Ord Set
Sold Out
Dark Grey Hand Embroidered Co-Ord Set
Peach Hand Embroidered Co-Ord Set
Peach Pichwai Lehenga
$ 699/-
Pink Pichwai Lehenga
Olive Green Handpainted Pichwai Lehenga Saree
$ 949/-
Mauve Handpainted Pichwai Lehenga Saree
$ 2,199/-
Green Pichwai Lehenga
Mustard Pichwai Lehenga
Blue Pichwai Lehenga
$ 2,324/-
Yellow Pichwai Lehenga
Grey Raw Silk Gown
$ 949
$ 474/-
Peach Raw Silk Gown
$ 699
$ 349/-
Ice Blue Raw Silk Gown
Yellow Ghicha Silk & Raw Silk Gown
Purple Silk Velvet Gown with Belt
$ 1,574/-
Yellow Raw Silk Gown
Green Ghicha Silk Gown
Black Ghicha Silk Gown with Belt
CALL OR WHATSAPP US ON +91-9811993458
(11AM TO 7PM - 6 DAYS A WEEK - SUNDAY OFF)
EMAIL US ON INFO@LABELPRATHAM.COM
(WE'LL REPLY WITHIN 24 HOURS)
Studio SHOP No 5 & 6, 1-B/83, KATRA PICHWAI, NEXT TO SH. BANKEY BIHARI MANDIR, WEST PUNJABI BAGH, NEW DELHI -110026. INDIA PHONE : +919811993458
Head Office J-1, UDYOG NAGAR INDUSTRIAL AREA, NR. PEERAGARHI METRO STATION, NEW DELHI-110041. INDIA