HOOPIE COLLAR

No 25203

Description
Specs
Reviews
Live Chat

Enjoy Your Walk A Little More

Need an everyday collar for your four-legged buddy that's easy to use? Ruffwear has you covered with the Hoopie Collar. Featuring a side-release buckle, strong and comfortable webbing, and an aluminum v-ring, this fun collar is a stylish and practical dog-walking accessory.

Why we love it:

I purchased this collar for my 50 pound rescue pup. It is attractive, durable and holds up well to our active lifestyle. I especially like the unique mountain pattern that is woven into the collar webbing, as well as, the aluminum v-ring that makes attaching the leash quick and easy.

Tami S., Mast General Store - Roanoke, VA

Ruffwear-designed Tubelok™ webbing
Easily add or remove tags with Quick Ring™
Separate ID attachment point
Silicone tag silencer
Care instructions: Hand wash; mild detergent; air dry
Imported

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

Need an everyday collar for your four-legged buddy that's easy to use? Ruffwear has you covered with the Hoopie Collar. Featuring a side-release buckle, strong and comfortable webbing, and an aluminum v-ring, this fun collar is a stylish and practical dog-walking accessory.

Why we love it:

I purchased this collar for my 50 pound rescue pup. It is attractive, durable and holds up well to our active lifestyle. I especially like the unique mountain pattern that is woven into the collar webbing, as well as, the aluminum v-ring that makes attaching the leash quick and easy.

Tami S., Mast General Store - Roanoke, VA
Specs
- Ruffwear-designed Tubelok™ webbing
- Easily add or remove tags with Quick Ring™
- Separate ID attachment point
- Silicone tag silencer
- Care instructions: Hand wash; mild detergent; air dry
- Imported
Reviews

No Reviews Yet!
Live Chat

$19.95

Choose Color

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	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	27	Y	[empty string]	758881	[empty string]	155039
2	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	4	Y	[empty string]	758866	[empty string]	155039
3	RED_BUTTE	85318	[empty string]	[empty string]	0	1	0	0	RED_BUTTE	4	Y	[empty string]	758877	[empty string]	155039
4	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	5	Y	[empty string]	758870	[empty string]	155039

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,14,6,5,9,8,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,14,6,5,9,8,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	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

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	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	27	Y	[empty string]	758881	[empty string]	155039
2	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	4	Y	[empty string]	758866	[empty string]	155039
3	RED_BUTTE	85318	[empty string]	[empty string]	0	1	0	0	RED_BUTTE	4	Y	[empty string]	758877	[empty string]	155039
4	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	5	Y	[empty string]	758870	[empty string]	155039

array
1	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

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	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	27	Y	[empty string]	758881	[empty string]	155039
2	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	4	Y	[empty string]	758866	[empty string]	155039
3	RED_BUTTE	85318	[empty string]	[empty string]	0	1	0	0	RED_BUTTE	4	Y	[empty string]	758877	[empty string]	155039
4	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	5	Y	[empty string]	758870	[empty string]	155039

array
1	155039

struct
INTERNALLISTPRICE	19.95
INTERNALMARKDOWN	false
INTERNALPRICE	19.95
REG	19.95
SALE	19.95
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

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	OBSIDIAN_BLACK	85313	[empty string]	[empty string]	0	5	0	0	OBSIDIAN_BLACK	27	Y	[empty string]	758881	[empty string]	155039
2	ORANGE_SUNSET	85316	[empty string]	[empty string]	0	2	0	0	ORANGE_SUNSET	4	Y	[empty string]	758866	[empty string]	155039
3	RED_BUTTE	85318	[empty string]	[empty string]	0	1	0	0	RED_BUTTE	4	Y	[empty string]	758877	[empty string]	155039
4	MONUMENT_VALLEY	85320	[empty string]	[empty string]	0	3	0	0	MONUMENT_VALLEY	5	Y	[empty string]	758870	[empty string]	155039