Vicky by Blondo

Price US $249.00US $209.00

Clearance

Be the first to write a review!

Product Code: 31B105BLA

Ladies tall dressy boot with non-functional strap and buckle detail at ankle, slight ruching along shaft, full inside zip with goring at top of shaft, stitching and overlay details.

Style note:
Blondo has the ultimate goal of creating footwear that will bring pleasure to walk and move to its customers. For the winter collection, only the most beautiful waterproof leathers are selected. All boots and shoes from this collection are labeled AquaProtect®, which provides superior overall efficiency factor against water infiltration and the harmful effects of salt.

(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` LIKE '%/women-large-shoes-size/shoes-boots/blondo/vicky-by-blondo/blondo/black%' 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` LIKE '%/women-large-shoes-size/shoes-boots/blondo/vicky-by-blondo/blondo/black%' 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` LIKE '%/women-large-shoes-size/shoes-boots/blondo/vicky-by-blondo/blondo/black%' LIMIT 1) LIMIT 1) AND opt.`option` != (SELECT `option` FROM `option-us` WHERE `url` LIKE '%/women-large-shoes-size/shoes-boots/blondo/vicky-by-blondo/blondo/black%' 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` LIKE '%/women-large-shoes-size/shoes-boots/blondo/vicky-by-blondo/blondo/black%' LIMIT 1) LIMIT 1) AND opt.`option` != (SELECT `option` FROM `option-us` WHERE `url` LIKE '%/women-large-shoes-size/shoes-boots/blondo/vicky-by-blondo/blondo/black%' LIMIT 1) AND sku.stock >= '1' GROUP BY `option` limit 6) LIMIT 3 Array ( [scheme] => http [host] => us.longtallsally.com [path] => /women-large-shoes-size/shoes-boots/blondo/vicky-by-blondo/blondo/black [query] => category=f-314_blondo )