|SQL||SELECT * from [dbo].[web_all_products_1] WHERE style_id = ?|
Johnny Was Size Large Lavender Floral Blouse
sku number: 1050188118
Colors: lavender, burgundy, blue, teal, green, orange, pink, off white, gold, beige
Materials: 100% cupra rayon, trims: 100% polyester
Measurements: Length 31", Chest 38", Shoulders 16", Sleeves 21"
Condition: 5 Stars, no visible 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.item location
23269 N. PIMA RD.
SCOTTSDALE, AZ 85255