Kid Suede Mid Heel Mary Jane

Price £100.00

Be the first to write a review!

Product Code: 16D22NAV

• Gorgeously soft navy kid suede Mary-Janes, with a comfortable mid heel ultra comfy leather lining
• Flexible relaxed insole for added comfort
• Fabric shoe bag also included

Please note, the fit of these shoes is slightly long compared with the fit of other Long Tall Sally shoes, the colour of lining may vary from image.

(SELECT `related`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasgbp`, `nowgbp`, `url`, `img150x223` FROM `merch`, `sku-www-gbp` as sku, `option-www` as opt JOIN `product-www` 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-www` WHERE `url` = '/tall/shoes/mid-heels/kid-suede-mid-heel-mary-jane/navy' LIMIT 1) GROUP BY `related` limit 3) UNION DISTINCT (SELECT opt.`option`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasgbp`, `nowgbp`, `url`, `img150x223` FROM `sku-www-gbp` as sku, `option-status`,`option-www` as opt JOIN `product-www` 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-www` WHERE `url` = '/tall/shoes/mid-heels/kid-suede-mid-heel-mary-jane/navy' LIMIT 1) LIMIT 1) AND `option-status`.`www-gbp-online` = (SELECT `www-gbp-online` FROM `option-status` WHERE `option` = (SELECT `option` FROM `option-www` WHERE `url` = '/tall/shoes/mid-heels/kid-suede-mid-heel-mary-jane/navy' LIMIT 1) LIMIT 1) AND opt.`option` != (SELECT `option` FROM `option-www` WHERE `url` = '/tall/shoes/mid-heels/kid-suede-mid-heel-mary-jane/navy' LIMIT 1) AND sku.stock >= '1' GROUP BY `option` limit 6) UNION DISTINCT (SELECT opt.`option`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasgbp`, `nowgbp`, `url`, `img150x223` FROM `sku-www-gbp` as sku, `option-status`,`option-www` as opt JOIN `product-www` 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-www` WHERE `url` = '/tall/shoes/mid-heels/kid-suede-mid-heel-mary-jane/navy' LIMIT 1) LIMIT 1) AND opt.`option` != (SELECT `option` FROM `option-www` WHERE `url` = '/tall/shoes/mid-heels/kid-suede-mid-heel-mary-jane/navy' LIMIT 1) AND sku.stock >= '1' GROUP BY `option` limit 6) LIMIT 3 Array ( [scheme] => http [host] => www.longtallsally.com [path] => /tall/shoes/mid-heels/kid-suede-mid-heel-mary-jane/navy [query] => category=f-233_made_in_spain )