query

RESULTSET

query
	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	FAMLIST	HASIMAGE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	LARGEPICTURE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SOLD	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	UPC	URL	VENDOR_INTEGRATE_ID
1	[empty string]	PRECISION PET	Precision Pet	PET SUPPLIES	Pet Supplies>Containment Systems	[empty string]	0	74.99	0	74.99	[empty string]	74.99	[empty string]	PRECISION PET GREAT CRATE 4000	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DISC	ONLINE	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Great Crate - 4000	<p>Precision Pet`s 2 Door Great Crate is the ideal heavy-duty wire crate for your pet. Composed of durable heavy-gauge wire with rounded corners and closer wire spacing makes this crate safer and stronger. Designed with your pet`s safety in mind, the Great Crate utilizes a patented 5-Point Locking mechanism to secure the door at five locations. Each Great Crate comes equipped with a durable, easy to clean polypropylene plastic pan and a divider panel that allows puppy owners to adjust the crate size as your puppy grows. For storage or travel, the 2 Door Great Crate easily folds flat and features an easy carry handle for added convenience.</p>	[empty string]	N	74.99	74.99	[empty string]	[empty string]	[empty string]	1000	21203	33959	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	precision-pet/precision-pet-great-crate-4000-33959	1
2	[empty string]	PRECISION PET	Precision Pet	PET SUPPLIES	Pet Supplies>Containment Systems	[empty string]	0	119.99	0	119.99	[empty string]	119.99	[empty string]	PRECISION PET GREAT CRATE 6000	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	DISC	ONLINE	[empty string]	[empty string]	1	100-to-150	0.00	[empty string]	Great Crate - 6000	<p>Precision Pet`s 2 Door Great Crate is the ideal heavy-duty wire crate for your pet. Composed of durable heavy-gauge wire with rounded corners and closer wire spacing makes this crate safer and stronger. Designed with your pet`s safety in mind, the Great Crate utilizes a patented 5-Point Locking mechanism to secure the door at five locations. Each Great Crate comes equipped with a durable, easy to clean polypropylene plastic pan and a divider panel that allows puppy owners to adjust the crate size as your puppy grows. For storage or travel, the 2 Door Great Crate easily folds flat and features an easy carry handle for added convenience.</p>	[empty string]	N	119.99	119.99	[empty string]	[empty string]	[empty string]	1000	21205	33961	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	precision-pet/precision-pet-great-crate-6000-33961	1
3	[empty string]	PETMATE	Petmate	PET SUPPLIES	Pet Supplies>Containment Systems	[empty string]	0	0	0	17.99	[empty string]	0	[empty string]	SNOOZY BLACK QUILTED CRATE MAT 35X21.5	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Snoozy Black Quilted Crate Mat 35x21.5	[empty string]	[empty string]	N	17.99	17.99	[empty string]	[empty string]	[empty string]	1000	225765	33984	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	petmate/snoozy-black-quilted-crate-mat-35x21-5-33984	1
4	[empty string]	PETMATE	Petmate	PET SUPPLIES	Pet Supplies>Containment Systems	[empty string]	0	17.99	0	17.99	[empty string]	17.99	[empty string]	SNOOZY SLEEPER NATURAL QUILTED CRATE MAT 35X21.5	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	Petmate Quilted Kennel Mat - Natural	<p>Petmate Quilted Kennel Mats are specifically designed for use in the car, at home, or inside crates. Comes in a variety of sizes and designed to fit standard wire dog kennels from sizes 19" to 48". Petmate Quilted Kennel Mats bring comfort to your pet while being in their kennel when you`re away.</p> <p> </p>	[empty string]	N	17.99	17.99	[empty string]	[empty string]	[empty string]	1000	225771	33988	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	petmate/snoozy-sleeper-natural-quilted-crate-mat-35x21-5-33988	1
5	PAN	PRECISION PET	Precision Pet	PET SUPPLIES	Pet Supplies>Containment Systems	PAN\|NULL\|NULL	0	22.99	0	22.99	[empty string]	22.99	[empty string]	PRECISION PET GREAT CRATE 5000 REPL PAN	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2011	[empty string]	BOTH	DISC	NOT ONLINE	[empty string]	[empty string]	2	20-to-25	0.00	[empty string]	Precision Pet Great Crate 5000 Repl Pan	[empty string]	[empty string]	N	22.99	22.99	5000	[empty string]	[empty string]	1000	21758	125953	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	precision-pet/precision-pet-great-crate-5000-repl-pan-125953	1
6	[empty string]	PRECISION PET	Precision Pet	PET SUPPLIES	Pet Supplies>Containment Systems	[empty string]	0	52.99	0	52.99	[empty string]	52.99	[empty string]	PRECISION PRO VALUE CRATE 2000	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Precision Pro Value Crate 2000	[empty string]	[empty string]	N	52.99	52.99	24X18X19	[empty string]	[empty string]	1000	21721	154680	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	precision-pet/precision-pro-value-crate-2000-154680	1
7	2DOOR	PRECISION PET	Precision Pet	PET SUPPLIES	Pet Supplies>Containment Systems	2DOOR\|NULL\|NULL	0	67.99	0	67.99	[empty string]	67.99	[empty string]	PRECISION PRO VALUE CRATE2 3000	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	8	50-to-100	0.00	[empty string]	Precision Pro Value Crate2 3000	[empty string]	[empty string]	N	67.99	67.99	30X19X21	[empty string]	[empty string]	1000	21722	154681	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	precision-pet/precision-pro-value-crate2-3000-154681	1
8	2DOOR	PRECISION PET	Precision Pet	PET SUPPLIES	Pet Supplies>Containment Systems	2DOOR\|NULL\|NULL	0	91.99	0	91.99	[empty string]	91.99	[empty string]	PRECISION PRO VALUE CRATE2 4000	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Precision Pro Value Crate2 4000	[empty string]	[empty string]	N	91.99	91.99	36X23X25	[empty string]	[empty string]	1000	21723	154682	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	precision-pet/precision-pro-value-crate2-4000-154682	1
9	2DOOR	PRECISION PET	Precision Pet	PET SUPPLIES	Pet Supplies>Containment Systems	2DOOR\|NULL\|NULL	0	129.99	0	129.99	[empty string]	129.99	[empty string]	PRECISION PRO VALUE CRATE2 5000	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Precision Pro Value Crate2 5000	[empty string]	[empty string]	N	129.99	129.99	42X28X30	[empty string]	[empty string]	1000	21724	154684	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	precision-pet/precision-pro-value-crate2-5000-154684	1
10	2DOOR	PRECISION PET	Precision Pet	PET SUPPLIES	Pet Supplies>Containment Systems	2DOOR\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	PRECISION PRO VALUE CRATE2 6000	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Precision Pro Value Crate2 6000	[empty string]	[empty string]	N	149.99	149.99	48X30X32	[empty string]	[empty string]	1000	21725	154685	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	precision-pet/precision-pro-value-crate2-6000-154685	1
11	PAN	PRECISION PET	Precision Pet	PET SUPPLIES	Pet Supplies>Containment Systems	PAN\|NULL\|NULL	0	13.99	0	13.99	[empty string]	13.99	[empty string]	PRECISION PET GREAT CRATE 3000 REPL PAN	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2011	[empty string]	BOTH	DISC	NOT ONLINE	[empty string]	[empty string]	1	10-to-15	0.00	[empty string]	Precision Pet Great Crate 3000 Repl Pan	[empty string]	[empty string]	N	13.99	13.99	3000	[empty string]	[empty string]	1000	21756	167357	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	precision-pet/precision-pet-great-crate-3000-repl-pan-167357	1
12	BLADES	AVERY	Avery	PET SUPPLIES	Pet Supplies>Containment Systems	BLADES\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.99	[empty string]	KENNEL PAD LRG BLADES	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2016	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Kennel Pads - Lg - Kw-1	These reversible kennel pads are designed to keep your dog comfortable traveling to and from the field.	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	01961	272852	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	avery/kennel-pad-lrg-blades-272852	1
13	MAX5	AVERY	Avery	PET SUPPLIES	Pet Supplies>Containment Systems	MAX5\|NULL\|NULL	0	34.99	0	34.99	[empty string]	34.99	[empty string]	KENNEL PAD XL MAX5	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	FALL	[empty string]	2016	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Kennel Pad Xl Max5	These reversible kennel pads are designed to keep your dog comfortable traveling to and from the field.	[empty string]	N	34.99	34.99	XL	[empty string]	[empty string]	1000	01971	272854	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	avery/kennel-pad-xl-max5-272854	1
14	[empty string]	DOG GONE SMART	Dog Gone Smart	PET SUPPLIES	Pet Supplies>Containment Systems	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	DIRTY DOG LARGE GREY DOORMAT	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2017	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	15	25-to-50	0.00	[empty string]	Dirty Dog Large Grey Doormat	[empty string]	[empty string]	N	39.99	39.99	LARGE	[empty string]	[empty string]	1000	226615	286416	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	dog-gone-smart/dirty-dog-large-grey-doormat-286416	1
15	WHITE,TAN,ORANGE	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	WHITE\|NULL\|NULL,TAN\|NULL\|NULL,ORANGE\|NULL\|NULL	0	309.99	0	309.99	[empty string]	309.99	[empty string]	LARGE DOUBLE DOOR LEFT SIDE ENTRY KENNEL	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	4	300-to-350	0.00	[empty string]	Large Double-door Dog Kennel - Left Side Entry	<p>The Large Double Door Left Side Entry Kennel is the perfect companion to the right side entry! Couple them together and you have multiple access points, and more options for configurations!  Vent hole pattern displayed comes standard (1 3/8"). The large dog crate can be stacked and customized with add-ons.</p> <p> </p> <p>NOTE: NOT AS ALL IMAGES SHOWN. ALL COLORS ARE LEFT SIDE ENTRY.</p>	[empty string]	N	309.99	309.99	LARGE	[empty string]	[empty string]	1000	LGDDLSE2017	299564	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/large-double-door-left-side-entry-kennel-299564	1
16	ORANGE	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	ORANGE\|NULL\|NULL	0	229.99	0	229.99	[empty string]	229.99	[empty string]	INTERMEDIATE DOUBLE DOOR LEFT SIDE ENTRY KENNEL	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Intermediate Double-doordog Kennel - Left Side Entry	<p>The Intermediate Double Door Left Side Entry Kennel is the perfect companion to the right side entry! Couple them together and you have multiple access points, and more options for configurations!  Vent hole pattern displayed comes standard (1 3/8"). The intermediate dog crate can be stacked and customized with add-ons.</p> <p> </p> <p>NOTE: NOT AS ALL IMAGES SHOWN. ALL COLORS ARE LEFT SIDE ENTRY.</p>	[empty string]	N	229.99	229.99	INTERMED	[empty string]	[empty string]	1000	INTDDLSE2017	299565	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/intermediate-double-door-left-side-entry-kennel-299565	1
17	ORANGE	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	ORANGE\|NULL\|NULL	0	209.99	0	209.99	[empty string]	209.99	[empty string]	INTERMEDIATE SINGLE DOOR KENNEL	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Intermediate Single Door Kennel	[empty string]	[empty string]	N	209.99	209.99	INTERMED	[empty string]	[empty string]	1000	INT2009	299568	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/intermediate-single-door-kennel-299568	1
18	TAN,ORANGE	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	TAN\|NULL\|NULL,ORANGE\|NULL\|NULL	0	209.99	0	209.99	[empty string]	209.99	[empty string]	INTERMEDIATE SUV SINGLE DOOR KENNEL	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	200-to-250	0.00	[empty string]	Intermediate Suv Dog Kennel	<p>The kennel that so many have been asking and waiting for! With a change in vehicle styles and dimensions comes a change in Ruff Tough`s kennels! With only the top back edge "cut-out"  in order to be set back on a majority of SUV`s and crossovers, the RTK Intermediate SUV does not compromise on floor space.  Vent hole pattern displayed comes standard (1 3/8" hole size), with two finger holes in the back.</p> <p> </p> <p>NOTE: NOT AS ALL IMAGES SHOWN. ALL COLORS ARE IN THE SUV KENNEL STYLE.</p>	[empty string]	N	209.99	209.99	INTERMED	[empty string]	[empty string]	1000	INTSUV2017	299569	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/intermediate-suv-single-door-kennel-299569	1
19	[empty string]	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	[empty string]	0	34.99	0	34.99	[empty string]	34.99	[empty string]	RTK COUPLER KIT FOR LARGE KENNELS	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	5	25-to-50	0.00	[empty string]	Coupler Kit - Large	<p>The Ruff Tough Kennel coupler kits are perfect for securing your crates together in your vehicle, home, or business. The large coupler kit is compatible with the large single and double door kennels.</p>	[empty string]	N	34.99	34.99	LARGE	[empty string]	[empty string]	1000	CK-LG	299578	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/rtk-coupler-kit-for-large-kennels-299578	1
20	[empty string]	MOMARSH	Momarsh	PET SUPPLIES	Pet Supplies>Containment Systems	[empty string]	0	54.99	1	49.99	[empty string]	54.99	[empty string]	KENNEL COT	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	37	25-to-50	0.00	[empty string]	Kennel Cot	<p>Designed to fit inside standard medium and large kennels the MOmarsh kennel cot is a new twist on canine kennel comfort. Unlike kennel pads, the Duramesh fabric and slightly elevated platform allow liquids to drain and keep your partner high and dry while still providing comfort from the the kennel floor. It can be used double duty as a climb and training tool and with its sleek look and high thread count embroider it easily lends itself to use on the living room floor. Easy to clean and extremely durable make this a must have for any dog enthusiast.</p>	[empty string]	N	49.99	54.99	MED,LARGE	[empty string]	[empty string]	1000	COT	300418	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	momarsh/kennel-cot-300418	1
21	[empty string]	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	[empty string]	0	29.99	0	29.99	[empty string]	29.99	[empty string]	RTK HANDLE KIT	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Kennel Handles	<p>Add handles to your X-Large, Large and Intermediate Ruff Land Kennel to make transport even easier! Handles come standard on Medium, Mid-Size and Small kennels Easily attach into pre-molded inserts on top of kennel</p>	[empty string]	N	29.99	29.99	[empty string]	[empty string]	[empty string]	1000	HK2009	309506	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/rtk-handle-kit-309506	1
22	BROWN	DOG GONE SMART	Dog Gone Smart	PET SUPPLIES	Pet Supplies>Containment Systems	BROWN\|NULL\|NULL	0	79.99	0	79.99	[empty string]	79.99	[empty string]	DOG GONE SMART DIRTY DOG RUNNER BROWN	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	18	50-to-100	0.00	[empty string]	Dog Gone Smart Dirty Dog Runner Brown	[empty string]	[empty string]	N	79.99	79.99	60X30	[empty string]	[empty string]	1000	226621	313290	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	dog-gone-smart/dog-gone-smart-dirty-dog-runner-brown-313290	1
23	GREY	DOG GONE SMART	Dog Gone Smart	PET SUPPLIES	Pet Supplies>Containment Systems	GREY\|NULL\|NULL	0	79.99	0	79.99	[empty string]	79.99	[empty string]	DOG GONE SMART DIRTY DOG RUNNER GREY	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	5	50-to-100	0.00	[empty string]	Dog Gone Smart Dirty Dog Runner Grey	[empty string]	[empty string]	N	79.99	79.99	60X30	[empty string]	[empty string]	1000	226620	313292	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	dog-gone-smart/dog-gone-smart-dirty-dog-runner-grey-313292	1
24	BROWN,CAMO	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	BROWN\|NULL\|NULL,CAMO\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	KENNEL COVER FOR DOUBLE DOOR INTERMEDIATE	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	8	100-to-150	0.00	[empty string]	Kennel Cover For Double Door Intermediate	[empty string]	[empty string]	N	149.99	149.99	INTERMED	[empty string]	[empty string]	1000	KCINTDD	318285	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/kennel-cover-for-double-door-intermediate-318285	1
25	BROWN	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	BROWN\|NULL\|NULL	0	309.99	0	309.99	[empty string]	309.99	[empty string]	KENNEL COVER FOR DOUBLE DOOR LARGE	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	300-to-350	0.00	[empty string]	Kennel Cover For Double Door Large	[empty string]	[empty string]	N	309.99	309.99	LARGE	[empty string]	[empty string]	1000	KCLGDD	318286	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/kennel-cover-for-double-door-large-318286	1
26	WHITE,ORANGE	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	WHITE\|NULL\|NULL,ORANGE\|NULL\|NULL	0	139.99	0	139.99	[empty string]	139.99	[empty string]	SMALL SINGLE DOOR KENNEL 100	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Small Kennel	<p>The Ruff Land Performance Kennels small kennel is affordable, durable and is of the same quality as Ruffland`s other size dog kennels. This size still carries the wire door. This unit comes with a handle already attached for dog or cat kennel portability. Vent hole pattern displayed is standard (3/4" Holes) with one finger hole on the back.</p>	[empty string]	N	139.99	139.99	SMALL	[empty string]	[empty string]	1000	SM2011	320085	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/small-single-door-kennel-100-320085	1
27	WHITE	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	WHITE\|NULL\|NULL	0	162.99	0	162.99	[empty string]	162.99	[empty string]	MIDSIZE SINGLE DOOR KENNEL	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Mid-size Kennel	<p>When the Medium Kennel is more than you need but the small is not roomy enough; meet the Mid-Size! The newest in Ruffland`s line of kennels comes in response to dog owners and show go-ers requests. The Mid comes standard with a handle and 1" vent holes.</p> <p> </p> <p>NOTE: Not stackable or able to couple with smalls or medium</p>	[empty string]	N	162.99	162.99	MIDSIZE	[empty string]	[empty string]	1000	MID2017	320086	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/midsize-single-door-kennel-320086	1
28	ORANGE	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	ORANGE\|NULL\|NULL	0	191.99	0	191.99	[empty string]	191.99	[empty string]	MEDIUM SINGLE DOOR KENNEL 200	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	Medium Single Door Kennel 200	[empty string]	[empty string]	N	191.99	191.99	MEDIUM	[empty string]	[empty string]	1000	MED2010	320087	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/medium-single-door-kennel-200-320087	1
29	HTHRGREY	BERGAN	Bergan	PET SUPPLIES	Pet Supplies>Containment Systems	HTHRGREY\|NULL\|NULL	0	59.99	0	59.99	[empty string]	59.99	[empty string]	BRGN CMFT CARRIEROTAP HTRGREY LARGE	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Brgn Cmft Carrierotap Htrgrey Large	[empty string]	[empty string]	N	59.99	59.99	LARGE	[empty string]	[empty string]	1000	88919	322154	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	bergan/brgn-cmft-carrierotap-htrgrey-large-322154	1
30	BLACK	PETMATE	Petmate	PET SUPPLIES	Pet Supplies>Containment Systems	BLACK\|NULL\|NULL	0	24.99	0	24.99	[empty string]	24.99	[empty string]	SNOOZY BLACK QUILTED CRATE MAT 47X28	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	DISC	[empty string]	[empty string]	[empty string]	1	20-to-25	0.00	[empty string]	Snoozy Black Quilted Crate Mat 47x28	[empty string]	[empty string]	N	24.99	24.99	47X28	[empty string]	[empty string]	1000	225767	322968	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	petmate/snoozy-black-quilted-crate-mat-47x28-322968	1
31	WINTERMOSS	ARCTIC SHIELD	Arctic Shield	PET SUPPLIES	Pet Supplies>Containment Systems	WINTERMOSS\|NULL\|NULL	0	19.99	0	19.99	[empty string]	19.99	[empty string]	KENNEL PAD WINTER MOSS MEDIUM	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	15-to-20	0.00	[empty string]	Kennel Pad Winter Moss Medium	[empty string]	[empty string]	N	19.99	19.99	MEDIUM	[empty string]	[empty string]	1000	560500-400-030-16	324047	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	arctic-shield/kennel-pad-winter-moss-medium-324047	1
32	BROWN	DOG GONE SMART	Dog Gone Smart	PET SUPPLIES	Pet Supplies>Containment Systems	BROWN\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	DIRTY DOG LARGE BROWN DOORMAT	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Dirty Dog Large Brown Doormat	[empty string]	[empty string]	N	39.99	39.99	LARGE	[empty string]	[empty string]	1000	226616	324386	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	dog-gone-smart/dirty-dog-large-brown-doormat-324386	1
33	BLUE	DOG GONE SMART	Dog Gone Smart	PET SUPPLIES	Pet Supplies>Containment Systems	BLUE\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	DIRTY DOG LARGE BLUE DOORMAT	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	Dirty Dog Large Blue Doormat	[empty string]	[empty string]	N	39.99	39.99	LARGE	[empty string]	[empty string]	1000	226614	327623	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	dog-gone-smart/dirty-dog-large-blue-doormat-327623	1
34	BLACK	DOG GONE SMART	Dog Gone Smart	PET SUPPLIES	Pet Supplies>Containment Systems	BLACK\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	DIRTY DOG LARGE BLACK DOORMAT	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	7	25-to-50	0.00	[empty string]	Dirty Dog Large Black Doormat	[empty string]	[empty string]	N	39.99	39.99	LARGE	[empty string]	[empty string]	1000	226618	327624	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	dog-gone-smart/dirty-dog-large-black-doormat-327624	1
35	[empty string]	ZONE DEFENSE	Zone Defense	PET SUPPLIES	Pet Supplies>Containment Systems	[empty string]	0	16.99	0	16.99	[empty string]	16.99	[empty string]	ZONE NO HOLES DIGGING DOG PREVENT RUT	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	15	15-to-20	0.00	[empty string]	Zone No Holes Digging Dog Prevent Rut	[empty string]	[empty string]	N	16.99	16.99	32.OZ	[empty string]	[empty string]	1000	102-32S	336858	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	zone-defense/zone-no-holes-digging-dog-prevent-rut-336858	1
36	COY,DAR,OLI	DAKOTA 283	Dakota 283	PET SUPPLIES	Pet Supplies>Containment Systems	COY\|NULL\|NULL,DAR\|NULL\|NULL,OLI\|NULL\|NULL	0	499.99	0	499.99	[empty string]	499.99	[empty string]	LARGE KENNEL	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	450-to-500	0.00	[empty string]	Large Kennel	[empty string]	[empty string]	N	499.99	499.99	LARGE	[empty string]	[empty string]	1000	D2-G3LRG-FRM	336977	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	dakota-283/large-kennel-336977	1
37	OLI,COY	DAKOTA 283	Dakota 283	PET SUPPLIES	Pet Supplies>Containment Systems	OLI\|NULL\|NULL,COY\|NULL\|NULL	0	559.99	0	559.99	[empty string]	559.99	[empty string]	EXTRA LARGE KENNEL	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	Extra Large Kennel	[empty string]	[empty string]	N	559.99	559.99	XL	[empty string]	[empty string]	1000	D2-G3XLG-FRM	336978	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	dakota-283/extra-large-kennel-336978	1
38	OPTIFADE	MOMARSH	Momarsh	PET SUPPLIES	Pet Supplies>Containment Systems	OPTIFADE\|NULL\|NULL	0	189.99	0	189.99	[empty string]	189.99	[empty string]	FIELD HOUSE ORTHOPEDIC CRATE/BLIND	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	FALL	[empty string]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Field House Orthopedic Crate/blind	[empty string]	[empty string]	N	189.99	189.99	[empty string]	[empty string]	[empty string]	1000	34048	338682	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	momarsh/field-house-orthopedic-crate-blind-338682	1
39	TAN,ORANGE,WHITE	RUFF LAND KENNELS	Ruff Land Kennels	PET SUPPLIES	Pet Supplies>Containment Systems	TAN\|NULL\|NULL,ORANGE\|NULL\|NULL,WHITE\|NULL\|NULL	0	389.99	0	389.99	[empty string]	389.99	[empty string]	X LARGE DOUIBLE DOOR RIGHT SIDE ENTRY	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	4	350-to-400	0.00	[empty string]	X Large Douible Door Right Side Entry	[empty string]	[empty string]	N	389.99	389.99	XL	[empty string]	[empty string]	1000	DB2017XLRSE	346945	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	ruff-land-kennels/x-large-douible-door-right-side-entry-346945	1
40	TURQUOISE	DOG GONE SMART	Dog Gone Smart	PET SUPPLIES	Pet Supplies>Containment Systems	TURQUOISE\|NULL\|NULL	0	79.99	0	79.99	[empty string]	79.99	[empty string]	DOG GONE SMART DIRTY DOG RUNNER TURQUOISE	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Dog Gone Smart Dirty Dog Runner Turquoise	[empty string]	[empty string]	N	79.99	79.99	60X30	[empty string]	[empty string]	1000	226622	352408	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	dog-gone-smart/dog-gone-smart-dirty-dog-runner-turquoise-352408	1
41	TURQUOISE	DOG GONE SMART	Dog Gone Smart	PET SUPPLIES	Pet Supplies>Containment Systems	TURQUOISE\|NULL\|NULL	0	39.99	0	39.99	[empty string]	39.99	[empty string]	DIRTY DOG LARGE TURQUOISE DOORMAT	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Dirty Dog Large Turquoise Doormat	[empty string]	[empty string]	N	39.99	39.99	35X29	[empty string]	[empty string]	1000	226617	352410	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	dog-gone-smart/dirty-dog-large-turquoise-doormat-352410	1
42	BROWN	PETMATE	Petmate	PET SUPPLIES	Pet Supplies>Containment Systems	BROWN\|NULL\|NULL	0	24.99	0	24.99	[empty string]	24.99	[empty string]	SNOOZZY BROWN CRATE MAT 41X26	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	DISC	[empty string]	[empty string]	[empty string]	2	20-to-25	0.00	[empty string]	Snoozzy Brown Crate Mat 41x26	[empty string]	[empty string]	N	24.99	24.99	41X26	[empty string]	[empty string]	1000	225778	354870	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	petmate/snoozzy-brown-crate-mat-41x26-354870	1
43	BROWN	PETMATE	Petmate	PET SUPPLIES	Pet Supplies>Containment Systems	BROWN\|NULL\|NULL	0	29.99	0	29.99	[empty string]	29.99	[empty string]	SNOOZZY BROWN CRATE MAT 47X28	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	V	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	DISC	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Snoozzy Brown Crate Mat 47x28	[empty string]	[empty string]	N	29.99	29.99	47X28	[empty string]	[empty string]	1000	225779	354871	EMPTY	EMPTY	EMPTY	0	0	0	CONTAINMENT SYSTEMS	[empty string]	petmate/snoozzy-brown-crate-mat-47x28-354871	1

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM GetALLProducts29 ORDER BY sortposition asc

Pet Supplies

Sort By:

Items per page:

2 1

Filter

2 1

Filter By

Price

Containment Systems

Brand

Size

Great Crate - 4000

Great Crate - 6000

Snoozy Black Quilted Crate Mat 35x21.5

Petmate Quilted Kennel Mat - Natural

Precision Pet Great Crate 5000 Repl Pan

Precision Pro Value Crate 2000

Precision Pro Value Crate2 3000

Precision Pro Value Crate2 4000

Precision Pro Value Crate2 5000

Precision Pro Value Crate2 6000

Precision Pet Great Crate 3000 Repl Pan

Kennel Pads - Lg - Kw- 1

Kennel Pad Xl Max5

Dirty Dog Large Grey Doormat

Large Double- Door Dog Kennel - Left Side Entry

Intermediate Double- Doordog Kennel - Left Side Entry

Intermediate Single Door Kennel

Intermediate Suv Dog Kennel

Coupler Kit - Large

Kennel Cot

Kennel Handles

Dog Gone Smart Dirty Dog Runner Brown

Dog Gone Smart Dirty Dog Runner Grey

Kennel Cover For Double Door Intermediate