|SQL||SELECT * from [dbo].[web_all_products_3] WHERE style_id = ?|
Pair of Amber Glass Lamps
sku number: 1090167565
Colors: amber, white, yellow
Materials: glass, fabric
Measurements: height 29", diameter 15"
Condition: 4.5 stars, light wear
Please note, all sales are final. Shipping fees will be determined based on weight and distance. A store representative will contact you.item location
23435 N. PIMA RD.
SCOTTSDALE, AZ 85255