› Jovani 64277

Jovani 64277
View large image

Jovani 64277

£630.00

Off White Sweetheart Neckline Embelished Dress 64277
Categories: Prom Dresses , Evening Dresses , Bridal Dresses

Share this product

Product Information

Brands
brands  Jovani

Off-white and nude underlay embellished dress with sweetheart neckline, off-the shoulder fitted bodice and straight back, floor length fitted skirt with lightly flared end.

 

Available Colours: Light-blue, Light-pink, Off-white, Red

SELECT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) AND (prodCat.`catID` = ?)  ORDER BY  parentProd.`pd_featured` DESC, `pd_order` ASC
Array
(
    [0] => 3
)

SELECT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) AND (prodCat.`catID` = '3')  ORDER BY  parentProd.`pd_featured` DESC, `pd_order` ASC
SELECT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) AND (prodCat.`catID` = ?)  ORDER BY  parentProd.`pd_featured` DESC, `pd_order` ASC
Array
(
    [0] => 5
)

SELECT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) AND (prodCat.`catID` = '5')  ORDER BY  parentProd.`pd_featured` DESC, `pd_order` ASC
SELECT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) AND (prodCat.`catID` = ?)  ORDER BY  parentProd.`pd_featured` DESC, `pd_order` ASC
Array
(
    [0] => 6
)

SELECT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) AND (prodCat.`catID` = '6')  ORDER BY  parentProd.`pd_featured` DESC, `pd_order` ASC

Similar Products

Shop
102 Eversley road,
Sketty, Swansea SA2 9DF
+441792208550

Terms & Conditions | Website Policies

Shipping Options