|SQL||SELECT * from [dbo].[web_all_products_1] WHERE style_id = ?|
Jimmy Choo Size 37 Black Suede Beaded Fringed Boots
sku number: 1020620097
Colors: Black, Red, White, Pink, Blue, Gold
Materials: Suede, Plastic
Measurements: Heel 4.5“, Platform .25“, Shaft 16“
Condition: 4.5 Stars, Casual Wear
Please note, all sales are final. Standard domestic shipping is a flat $15 fee for items priced under $500. Additional fees will be determined at time of purchase for insurance on items over $500.
Price shown on website reflects any discounts that are currently active, if applicable.item location
6204 N. SCOTTSDALE RD.
SCOTTSDALE, AZ 85253