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
Sky Yale Blue Fabiana Anarkali Suit
$299.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:
Crinkle chiffon shirt features gorgeous dip dye effects in Deep Sky Blue and Yale Blue colors Lovely embroidery work in different motifs and design made on front and hem. Chinese collar neckline with lovely button detail. Bell sleeves. Fully lined. Concealed back zip closure.
Bottom/Trousers:
Offwhite raw silk flared trousers in full length. Concealed front zip fastening.
Dupatta/Veil:
Crinkle chiffon dupatta having gorgeous dip dye effects in Deep Sky Blue and Yale Blue colors. Heavy sequins embellishments scattered all over. Piping on edges.
Embellishment work:
Sequins and thread work. 100% pure imported fabric. 100% handmade embellishments.
Customers who bought this product also purchased...
