Jay's Sporting Goods

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	TAN,WHITE,MILLSTONE	RUFFLAND KENNELS	RUFFLAND KENNELS	PET SUPPLIES	Pet Supplies>Containers>Water	TAN\|NULL\|NULL,WHITE\|NULL\|NULL,MILLSTONE\|NULL\|NULL	1	49.99	0	49.99	105142-DEFAULT-l.jpg	49.99	105142-DEFAULT-m.jpg	WATER HOLE	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	27	25-to-50	0.00	[empty string]	WATER HOLE	<p>It’s a water jug and water dish in one! The Water Hole is a water container that holds up to one gallon of water that is stored in the tower side of the container yet is always available for your dog to drink. It works via a vacuum like an office water cooler. Simply fill it and as your dog drinks the water, that water is automatically replaced from the tower. Will not crack or break if water freezes. Durable roto-molded construction. Handy drain cap also makes it easy to rinse out. </p>	[empty string]	N	49.99	49.99	[empty string]	105142-DEFAULT-s.jpg	[empty string]	1000	WD2009	299572	WATER	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ruffland-kennels/water-hole-299572	1
2	TAN,ORANGE,WHITE	RUFFLAND KENNELS	RUFFLAND KENNELS	PET SUPPLIES	Pet Supplies>Containers	TAN\|NULL\|NULL,ORANGE\|NULL\|NULL,WHITE\|NULL\|NULL	1	24.99	0	24.99	105184-DEFAULT-l.jpg	24.99	105184-DEFAULT-m.jpg	RTK MEDIUM WATER/FOOD DISH	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	26	20-to-25	0.00	[empty string]	FOOD / WATER DISH - MEDIUM	<p>This is not your flimsy water or food dish. This dish is made in the USA of super durable, food-grade polypropylene. It's a perfect tip resistant, dishwasher-safe (top rack) dog bowl.</p> <p> </p> <ul> <li>Diameter of opening: 8”</li> <li>Diameter of base: 11 1/2”</li> <li>Height: 3 1/2”</li> </ul>	[empty string]	N	24.99	24.99	MEDIUM	105184-DEFAULT-s.jpg	[empty string]	1000	DBMED2017	299574	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ruffland-kennels/food-water-dish-medium-299574	1
3	ORANGE,WHITE	RUFFLAND KENNELS	RUFFLAND KENNELS	PET SUPPLIES	Pet Supplies>Containers	ORANGE\|NULL\|NULL,WHITE\|NULL\|NULL	1	19.99	0	19.99	105185-DEFAULT-l.jpg	19.99	105185-DEFAULT-m.jpg	RTK SMALLWATER/FOOD DISH	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	13	15-to-20	0.00	[empty string]	FOOD / WATER DISH - SMALL	<p>This is not your flimsy water or food dish. This dish is made in the USA of super durable, food-grade polypropylene. It's a perfect tip resistant, dishwasher-safe (top rack) dog bowl.</p> <p> </p> <ul> <li>Diameter of opening: 5 5/8”</li> <li>Diameter of base: 8 1/2”</li> <li>Height: 2 3/4”</li> </ul>	[empty string]	N	19.99	19.99	SMALL	105185-DEFAULT-s.jpg	[empty string]	1000	DBSM2017	299575	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ruffland-kennels/food-water-dish-small-299575	1
4	[empty string]	RUFFLAND KENNELS	RUFFLAND KENNELS	PET SUPPLIES	Pet Supplies>Containment Systems>Kennel	[empty string]	1	25.99	0	25.99	104432-DEFAULT-l.jpg	25.99	104432-DEFAULT-m.jpg	RTK D-RING TIE DOWN KIT	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	3	25-to-50	0.00	[empty string]	TIE DOWN KIT D-RING	<p>For added safety and security this is the accessory you need! The RuffLand Performance Kennels Tie Down Kit includes 4 D-rings, 4 washers and 4 bolts. This kit attaches to your RuffLand Performance Kennels dog kennel so you can secure it inside a truck bed, back seat or any other place you might see fit. Attach the tie down brackets to the kennel, and secure your kennel in place with a strap of your choice. Max Load/Working Load, 2,400/800 Allows you to tie down your Ruff Land Kennel when used with Kennel Cover.</p>	[empty string]	N	25.99	25.99	OSFA	104432-DEFAULT-s.jpg	[empty string]	1000	TDD2016	299576	KENNEL	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ruffland-kennels/tie-down-kit-d-ring-299576	1
5	[empty string]	RUFFLAND KENNELS	RUFFLAND KENNELS	PET SUPPLIES	Pet Supplies>Containment Systems>Kennel	[empty string]	1	18.99	0	18.99	105156-DEFAULT-l.jpg	18.99	105156-DEFAULT-m.jpg	SIDE LATCH ROD KIT	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	2	15-to-20	0.00	[empty string]	SIDE LATCH ROD KIT	<p>These two rods with hardware attach horizontally onto the outside of your kennel door adding another level of security for your companion. (Padlock not included.) *Cannot be used in conjunction with the Turtle Plate Fan.</p>	[empty string]	N	18.99	18.99	[empty string]	105156-DEFAULT-s.jpg	[empty string]	1000	SLR-INT/LG2013	357571	KENNEL	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ruffland-kennels/side-latch-rod-kit-357571	1
6	WHITE,MILLSTONE,TAN	RUFFLAND KENNELS	RUFFLAND KENNELS	PET SUPPLIES	Pet Supplies>Containment Systems>Kennel	WHITE\|NULL\|NULL,MILLSTONE\|NULL\|NULL,TAN\|NULL\|NULL	1	267.99	0	267.99	105145-DEFAULT-l.jpg	267.99	105145-DEFAULT-m.jpg	KENNEL SINGLE DOOR BACKSEAT RIDER	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	9	250-to-300	0.00	[empty string]	BACKSEAT RIDER - SINGLE DOOR	<p>The Ruff Land Backseat Rider is a little shorter than Ruffland's best-selling intermediate kennel so it fits better behind your front seat (and two can fit end-to-end in the back seat of most standard vehicles). This is the perfect place for a kennel, as it allows your dog to ride inside when it’s cold outside, when you don’t want your dog subjected to frigid temps and windchills, or when you’re driving on dirt roads or in rainy weather. Like all Ruff Land Kennels, the Backseat Rider is built tough, built safe and built smart.</p> <p> </p> <ul> <li>Exterior:</li> <li>   Length: 27 7/8"</li> <li>   Width: 20" at widest point</li> <li>   Height: 23 1/4"</li> <li>Interior:</li> <li>   Length: 26 1/8"</li> <li>   Width: 17" at narrowest point - 19 3/4" at widest point</li> <li>   Height: 22"</li> <li>Floor:</li> <li>   Length: 24 1/2"</li> <li>   Width: 17 1/2"</li> <li>Weight: Approx. 17 lbs</li> </ul>	[empty string]	N	267.99	267.99	[empty string]	105145-DEFAULT-s.jpg	[empty string]	1000	BSR202022	368804	KENNEL	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ruffland-kennels/backseat-rider-single-door-368804	1
7	WHITE,MILLSTONE,TAN	RUFFLAND KENNELS	RUFFLAND KENNELS	PET SUPPLIES	Pet Supplies>Containment Systems>Kennel	WHITE\|NULL\|NULL,MILLSTONE\|NULL\|NULL,TAN\|NULL\|NULL	1	279.99	0	279.99	105148-DEFAULT-l.jpg	279.99	105148-DEFAULT-m.jpg	KENNEL SINGLE DOOR INTERMEDIATE	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	5	250-to-300	0.00	[empty string]	INTERMEDIATE KENNEL - SINGLE DOOR	<p>The Intermediate Dog kennel was the first dog kennel Ruffland manufactured. Designed by outdoorsmen, endorsed by celebrities, this intermediate dog kennel sets the standard for built-to-last intermediate-sized dog kennels. Ventilation can be customized from the drop-down menu options. The intermediate dog kennel can be stacked and customized with the add-on options.</p> <p> </p> <ul> <li>Exterior:</li> <li>   Length: 30 1/2"</li> <li>   Width: 20" at widest point</li> <li>   Height: 23 1/4"</li> <li>Interior:</li> <li>   Length: 30"</li> <li>   Width: 19 1/2" at widest point</li> <li>   Height: 22"</li> <li>Floor:</li> <li>   Length: 28 1/2"</li> <li>   Width: 17 1/2"</li> <li>   Weight: Approx. 20 lbs</li> </ul>	[empty string]	N	279.99	279.99	INT	105148-DEFAULT-s.jpg	[empty string]	1000	INT200922	368805	KENNEL	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ruffland-kennels/intermediate-kennel-single-door-368805	1
8	WHITE,MILLSTONE,TAN	RUFFLAND KENNELS	RUFFLAND KENNELS	PET SUPPLIES	Pet Supplies>Containment Systems>Kennel	WHITE\|NULL\|NULL,MILLSTONE\|NULL\|NULL,TAN\|NULL\|NULL	1	379.99	0	379.99	105154-DEFAULT-l.jpg	379.99	105154-DEFAULT-m.jpg	KENNEL DOUBLE DOOR FRONT AND BACK LARGE	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	8	350-to-400	0.00	[empty string]	KENNEL - LARGE - DOUBLE DOOR - FRONT AND BACK	<p>This large dog kennel is perfect for your larger breed of dogs or for more space when kenneling at home. It can be stacked or coupled for transport in a boarding or vet clinic setting. (Please note that the double door versions will add 1 1/2" to the dimension.)</p> <p> </p> <ul> <li>Exterior:</li> <li>   Length: 35"</li> <li>   Width: 22" at widest point</li> <li>   Height: 26 3/4"</li> <li>Interior:</li> <li>   Length: 34"</li> <li>   Width: 21 5/8" at widest point</li> <li>   Height: 25"</li> <li>Floor:</li> <li>   Length: 33"</li> <li>   Width: 17 1/2"</li> <li>   Weight: Approx. 30 lbs</li> </ul>	[empty string]	N	379.99	379.99	LG	105154-DEFAULT-s.jpg	[empty string]	1000	LGDD201022	368809	KENNEL	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ruffland-kennels/kennel-large-double-door-front-and-back-368809	1
9	WHITE,TAN,MILLSTONE	RUFFLAND KENNELS	RUFFLAND KENNELS	PET SUPPLIES	Pet Supplies>Containment Systems>Kennel	WHITE\|NULL\|NULL,TAN\|NULL\|NULL,MILLSTONE\|NULL\|NULL	1	414.99	0	414.99	105157-DEFAULT-l.jpg	414.99	105157-DEFAULT-m.jpg	X LARGE SINGLE DOOR KENNEL	N	9.1 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	MAP	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	400-to-450	0.00	[empty string]	KENNEL - X LARGE - SINGLE DOOR	<p>Made in the USA with the same tough material of Ruffland's other kennels, this kennel will accommodate your larger breed of dog. Designed with straighter sides this kennel can fit through narrow doorways such as campers. Vent hole pattern displayed comes standard (1 3/8") with two finger holes in the back. All kennel sizes are outfitted with strong, composite doors that have a tighter grid pattern to prevent biting and chewing.</p> <p> </p> <ul> <li>Exterior:</li> <li>   Length: 40 3/8"</li> <li>   Width: 22" at widest point</li> <li>   Height: 29 7/8"</li> <li>Interior:</li> <li>   Length: 39"</li> <li>   Width: 21 5/8" at widest point</li> <li>   Height: 28"</li> <li>Floor:</li> <li>   Length: 38 1/2"</li> <li>   Width: 19"</li> <li>   Weight: Approx. 42 lbs</li> </ul>	[empty string]	N	414.99	414.99	XL	105157-DEFAULT-s.jpg	[empty string]	1000	XL201122	375356	KENNEL	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	ruffland-kennels/kennel-x-large-single-door-375356	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter