Categories
Sneakers & Sports Footwear
Plus-size trend mid-top outdoor walking shoes Hiking shoes
- Item No.: JT-S712
- Gender: Men
- MOQ: 300prs
- Product Details
UNBRAND shoes stock lot clear all
Colors: black, brown
Delivery Detail:Within 3-7days after receiving deposit
- Request a Quote
You May Also Like The Following Closeout Shoes
1030 - Got error 28 from storage engine
select distinct p.products_id,p.products_image,pd.products_description,pd.products_name from products p, products_description pd, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.categories_id = '1' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id !='722' order by p.products_date_added desc limit 4
[TEP STOP]
select distinct p.products_id,p.products_image,pd.products_description,pd.products_name from products p, products_description pd, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.categories_id = '1' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id !='722' order by p.products_date_added desc limit 4
[TEP STOP]