Set of 64 BE HOME Stoneware Dinnerware

query

RESULTSET

query
	ADDITIONAL_DESCRIPTION	AGERANGE	ALTIMAGERECORDCOUNT	ATTR1ID	ATTR1LIST	ATTR2ID	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	DESCRIPTION	FAMLIST	GENDER	GOOGLEPRODUCTTAXONOMY	HEXLIST	ID	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	KEYWORDS	LARGEPICTURE	LISTPRICE	LOWESTPRICE	MEDIUMPICTURE	METADESC	METATAGS	NAME	NEW	NON_INVT	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	ORIGBRAND	OVERALLQOH	PAGETITLE	PICTUREID	PICTURE_ID	PRICERANGE	PRODREVIEWSAVERAGE	PRODREVIEWSRECORDCOUNT	QUANTITYONHANDSUM	QUANTITYSOLDSUM	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SCALEID	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	STORE_ID	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TINYPICTURE	TYP	URL	USEPACKAGE	VIDEO	WEBSTYLE	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	[empty string]	[empty string]	[empty string]	[empty string]	DUMMYCOLOR	[empty string]	OTHER	Other	CHINA/DISHES	China/Dishes	[empty string]	DUMMYCOLOR	[empty string]	[empty string]	DUMMYCOLOR	425557	2160	1	695	[empty string]	12050-DEFAULT-l.jpg	2160	[empty string]	12050-DEFAULT-m.jpg	[empty string]	[empty string]	APROX 64 PC BE HOME DINNERWARE	N	[empty string]	BLUE	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	OTHER	1	[empty string]	12050	12050	500-or-more	0.00	0	[empty string]	[empty string]	[empty string]	Set of 64 BE HOME Stoneware Dinnerware	<p><u><strong>Colors:</strong></u> Peacock Blue</p> <p><u><strong>Materials:</strong></u> Stoneware</p> <p><u><strong>Measurements:</strong></u> 12 Large Plates: Diameter 10.75", 1 Pitcher: Height 9", Diameter 4.25", 19 Small Dishes: Diameter 5", Height 3", 16 Bed Bowls: Height 3", Diameter 7.25", 16 Medium Plates: Diameter 8.9"</p> <p><u><strong>Condition:</strong></u> 4.5 Stars, a few of the dishes have minor surface wear<br />  </p> <p> </p> <p> </p> <p> </p>	[empty string]	Y	695	695	[empty string]	[empty string]	12050-DEFAULT-s.jpg	N	1000	9	1090140393	8982350	EMPTY	EMPTY	EMPTY	0	0	0	12050-DEFAULT-xs.jpg	EMPTY	other/set-of-64-be-home-stoneware-dinnerware-8982350	0	[empty string]	1090140393	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * from [dbo].[web_all_products_3] WHERE style_id = ?

SQLPARAMETERS

array
1	8982350

Shop By Category

My Sister's Attic
LUXURY HOME CONSIGNMENT

SEE OUR OTHER STORES

My Sister's Closet
FASHION CONSIGNMENT
Well Suited
MEN'S CONSIGNMENT

Set of 64 BE HOME Stoneware Dinnerware

sku number: 1090140393

description

Colors: Peacock Blue

Materials: Stoneware

Measurements: 12 Large Plates: Diameter 10.75", 1 Pitcher: Height 9", Diameter 4.25", 19 Small Dishes: Diameter 5", Height 3", 16 Bed Bowls: Height 3", Diameter 7.25", 16 Medium Plates: Diameter 8.9"

Condition: 4.5 Stars, a few of the dishes have minor surface wear

Retail Price: ~~$2,160.00~~ Price: $695.00

item location

Desert Village at Pinnacle Peak

23435 N. PIMA RD. #H121
SCOTTSDALE, AZ 85255
480-473-0228

Get a map and directions to this store >>

click thumbnail to view