INVALID SQL: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND xcart_products_categories.productid = xprod.productid AND xcar' at line 3
SQL QUERY FAILURE:SELECT xprod.productid FROM xcart_products as xprod LEFT JOIN xcart_quick_prices as xp ON xprod.productid = xp.productid, xcart_products_categories WHERE AND xcart_products_categories.productid = xprod.productid AND xcart_products_categories.productid = xprod.productid AND forsale = 'Y' AND xp.membershipid = 0 ORDER BY orderby, xprod.product ASC
No. 6 Clothing ankle buckle boots at Bird : ShopBird.com
Free ground shipping on all orders over $250!    

more offers
 

ROLLOVER TO ZOOM

No. 6 Clothing

ankle buckle boots

$380.00

SKU: 24396

Vintage collector Morgan Yakus and stylist Karin Bereson pooled their talents to create No. 6, the in-house clothing line for their store in Little Italy. Known for their clogs, the No. 6 line features print heavy and vintage inspired clothes.


OUT OF STOCK FIT GUIDE

YOU MAY ALSO LIKE