select distinct p.products_id, pd.products_name, p.products_ordered, p.products_price, p.products_image
from nl_products p, nl_products_description pd
where p.products_status = '1'
and p.products_ordered > 0
and p.products_id = pd.products_id
and pd.language_id = '1'
order by p.products_ordered desc, pd.products_name
limit 3
Colorant Rous
$799.99
Please Choose:
Select Size
Custom Made-to-Measure
Size (2XL)
Size (2XL-2)
Size (L)
Size (L-2)
Size (M)
Size (M-2)
Size (S)
Size (S-2)
Size (XL)
Size (XL-2)
Size (XS)
Select Sleeve
Sleeve: As shown/described
Sleeve: Bell
Sleeve: Full
Sleeve: Half
Sleeve: Three Quarter
Select Bottom
Bottom: As shown/described
Pyjama: Churidar
Pyjama: Slim Straight
Shalwar: Baggy
Shalwar: Patiala
Shalwar: Regular
Shalwar: Slim
Trouser: Slim Straight
Trouser: Bell Bottom
Trouser: Capris
Trouser: Flappers
Trouser: Straight
Description
Top:
Amber gold to aqua, antique blue and blue willow ombre dye chiffon long gown
Heavy embellishments on neckline, armhole and hemline.
Beautiful floral cord work under bust.
Ornamental motifs getting gradually bigger from top to bottom.
Front split with longer inside.
Stand collar neck with U front.
Straight tab inside.
Front split. Piping edges.
Beige applique border with soft-ball edges dangling on hems.
Bottom:
Beige crinkle chiffon jamawar flared lehenga with woven cord design lined with blue willow.
Fully lined.
Hidden waistband.
Piping edges finish.
Shawl/Dupatta:
Amber gold to blue willow Ombre dye chiffon dupatta
Heavy sequins spread all over.
Beige applique border with soft-ball dangling finish.
Embellishments Work:
Beads, Sequins, cut-glass, kora, dabka, Swarovski crystals,
diamantes, kamdani, badla, danglings, pearls, and kasab.
100% natural pure fabrics.
All handmade embellishments.
Customers who bought this product also purchased...
