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
Coral Pink Amadora
$425.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:
Spice up your style with this crinkle chiffon anarkali shirt in full length and coral pink color .Gorgeous embellishments on neckline, front and bottom Small ornaments embroidered on front. Shutter pleated detail on empire waist Embellished elbow sleeves Stand collar neckline. Fully lined and side zip closure.
Bottom/Trousers:
Coral pink raw silk straight trousers in full lengt h No embellishments. Front zip closure.
Dupatta/Veil:
Coral Pink crinkle chiffon dupatta Heavy sequins spray. Finished with edges on all 4 sides.
Embellishment work:
Beads, Dabka, Sequins, and Swarovski crystals. 100% handmade embellishments. 100% pure imported fabric.
