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
Black Fiore
$399.00
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:
Black crinkle chiffon anarkali dress Amazing embroidery work in floral and leaf design on front and sleeves. Big sized ornamental motifs embroidered all over. Hemline and slevees cuffs is adorned with beautiful embroidery and bordered with offwhite applique. Button and embroidered detail on a raw silk bodice. Fully lined. Concealed side zip closure.
Bottom/Trousers:
Black crepe silk bottom flared plain trousers. Concealed front zip fastening.
Dupatta/Veil:
Black crinkle chiffon dupatta bordered with offwhite applique. Big sized ornamental motifs embroided all over.
Embellishment work:
Threads and swarovski crystals. 100% pure highest quality imported fabric. 100% handmade embellishments.
Customers who bought this product also purchased...
