Boone NC Pewter Ornament
mast general store
$899
FLOWER OF THE MONTH BRACELET
$23.99
Choose Color
-
jan for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
feb for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
mar for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
apr for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
may for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
june for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
july for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
aug for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
sept for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
oct for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
nov for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
dec for $23.99
query RESULTSET query ATTR1 ATTR1_ENTRY_ID FAM HEX MAXQC MAXQOH MINQC MINQOH ORIGATTR1 QOH SELL_WEB SKUOF16 SKU_ID SORT_ORDER STYLE_ID 1 JAN 39440 [empty string] [empty string] 0 5 0 0 JAN 33 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 15 0 0 FEB 47 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 5 0 0 MAR 30 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 6 0 0 APR 39 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 8 0 0 MAY 40 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 9 0 0 JUNE 38 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 7 0 0 JULY 37 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 5 0 0 AUG 25 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 1 5 -1 0 SEPT 32 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 6 0 0 OCT 33 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 34 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 38 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 SQL SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=2) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 116144 struct INTERNALLISTPRICE 23.99 INTERNALMARKDOWN false INTERNALPRICE 23.99 REG 23.99 SALE 23.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0
- Description
- Specs
- Reviews
- Live Chat
A special little something
Say it with flowers. A Flower of the Month Bracelet from Salisbury Silver and Pewter is a wonderful way to remember your loved one on any momentous occasion. These uniquely handcrafted 1-inch cuff bracelets are made of lead-free pewter and feature the blossom that corresponds to the recipient's birth month or that symbolizes your dear one's personality and spirit. They also make meaningful personal keepsakes to honor graduates, bridesmaids, and mothers on their special day and are certain to be treasured and worn with great affection.
Why we love it:
"These bracelets are my go-to gift... I like the idea of giving someone a bracelet that celebrates a special time of their life, whether it's a birthday or just an occasion that they would like to remember."
— Lisa, Mast General Store - Valle Crucis, NC
- Made in USA
- 1 inch cuff bracelet
- Lead-free pewter
Flowers of the Month:
- January - Carnation, a symbol of marriage
- February - Violet, a symbol of faithfulness
- March - Jonquil, a symbol of rebirth
- April - Daisy, a symbol of cheer and innocence
- May - Lily of the Valley, a symbol of purity of heart
- June - Rose, a symbol of love and passion
- July - Larkspur, associated with vivacity
- August - Poppy, associated with rest and oblivion
- September - Aster, associated with true love and fidelity
- October - Cosmos, signifies the heart of a girl
- November - Chrysanthemum, a symbol of cheerfulness and optimism
- December - Narcissus, a symbol of good fortune
No Reviews Yet!
-
Description
Say it with flowers. A Flower of the Month Bracelet from Salisbury Silver and Pewter is a wonderful way to remember your loved one on any momentous occasion. These uniquely handcrafted 1-inch cuff bracelets are made of lead-free pewter and feature the blossom that corresponds to the recipient's birth month or that symbolizes your dear one's personality and spirit. They also make meaningful personal keepsakes to honor graduates, bridesmaids, and mothers on their special day and are certain to be treasured and worn with great affection.
Why we love it:
"These bracelets are my go-to gift... I like the idea of giving someone a bracelet that celebrates a special time of their life, whether it's a birthday or just an occasion that they would like to remember."
— Lisa, Mast General Store - Valle Crucis, NC
-
Specs
- Made in USA
- 1 inch cuff bracelet
- Lead-free pewter
Flowers of the Month:
- January - Carnation, a symbol of marriage
- February - Violet, a symbol of faithfulness
- March - Jonquil, a symbol of rebirth
- April - Daisy, a symbol of cheer and innocence
- May - Lily of the Valley, a symbol of purity of heart
- June - Rose, a symbol of love and passion
- July - Larkspur, associated with vivacity
- August - Poppy, associated with rest and oblivion
- September - Aster, associated with true love and fidelity
- October - Cosmos, signifies the heart of a girl
- November - Chrysanthemum, a symbol of cheerfulness and optimism
- December - Narcissus, a symbol of good fortune
-
Reviews
No Reviews Yet!
- Live Chat
- Live Chat
You may also like
