Gazhel by Vaneli

Price US $149.00US $80.00

Clearance

Be the first to write a review!

Product Code: 16C175RED

• Ladies kitten heel pump with ruffle trim. Available in larger sizes.

Style note
Ruffles and bows create the most feminine look. Matching patent leather accents soft nappa and the sole is designed in flexible rubber.

(SELECT `related`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasusd`, `nowusd`, `url`, `img150x223` FROM `merch`, `sku-us-usd` as sku, `option-us` as opt JOIN `product-us` as pdt ON opt.product = pdt.product WHERE opt.`option` = `merch`.`related` AND sku.option = merch.related AND sku.stock >= '1' AND `merch`.`option` = (SELECT `option` FROM `option-us` WHERE `url` = '/tall-women-large-shoes/upto-size13/shoes-boots/vaneli/gazhel-by-vaneli/red' LIMIT 1) GROUP BY `related` limit 3) UNION DISTINCT (SELECT opt.`option`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasusd`, `nowusd`, `url`, `img150x223` FROM `sku-us-usd` as sku, `option-status`,`option-us` as opt JOIN `product-us` as pdt ON opt.product = pdt.product LEFT JOIN `option-department` on `option-department`.`option` = opt.`option` WHERE sku.`option` = opt.`option` AND `option-status`.`option` = opt.`option` AND `option-department`.`departmentID` = (SELECT `departmentID` FROM `option-department` WHERE `option` = (SELECT `option` FROM `option-us` WHERE `url` = '/tall-women-large-shoes/upto-size13/shoes-boots/vaneli/gazhel-by-vaneli/red' LIMIT 1) LIMIT 1) AND `option-status`.`us-usd-online` = (SELECT `us-usd-online` FROM `option-status` WHERE `option` = (SELECT `option` FROM `option-us` WHERE `url` = '/tall-women-large-shoes/upto-size13/shoes-boots/vaneli/gazhel-by-vaneli/red' LIMIT 1) LIMIT 1) AND opt.`option` != (SELECT `option` FROM `option-us` WHERE `url` = '/tall-women-large-shoes/upto-size13/shoes-boots/vaneli/gazhel-by-vaneli/red' LIMIT 1) AND sku.stock >= '1' GROUP BY `option` limit 6) UNION DISTINCT (SELECT opt.`option`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasusd`, `nowusd`, `url`, `img150x223` FROM `sku-us-usd` as sku, `option-status`,`option-us` as opt JOIN `product-us` as pdt ON opt.product = pdt.product LEFT JOIN `option-department` on `option-department`.`option` = opt.`option` WHERE sku.`option` = opt.`option` AND `option-status`.`option` = opt.`option` AND `option-department`.`departmentID` = (SELECT `departmentID` FROM `option-department` WHERE `option` = (SELECT `option` FROM `option-us` WHERE `url` = '/tall-women-large-shoes/upto-size13/shoes-boots/vaneli/gazhel-by-vaneli/red' LIMIT 1) LIMIT 1) AND opt.`option` != (SELECT `option` FROM `option-us` WHERE `url` = '/tall-women-large-shoes/upto-size13/shoes-boots/vaneli/gazhel-by-vaneli/red' LIMIT 1) AND sku.stock >= '1' GROUP BY `option` limit 6) LIMIT 3 Array ( [scheme] => http [host] => us.longtallsally.com [path] => /tall-women-large-shoes/upto-size13/shoes-boots/vaneli/gazhel-by-vaneli/red [query] => category=f-154_vaneli )