|SQL||SELECT * from [dbo].[web_all_products_1] WHERE style_id = ?|
Lucchese Size 9 Harness Boots
sku number: 1050363359
Colors: Black, silver
Materials: Leather, silver tone
Measurements: Heel 1.375“, Shaft 10.125“
Condition: 4.5 stars, casual walk wear on soles and light wear on exteriors
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
23269 N. PIMA RD.
SCOTTSDALE, AZ 85255