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	[empty string]	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Collars and Harnesses>Training Collars	[empty string]	1	139.99	0	139.99	24862-DEFAULT-l.jpg	139.99	24862-DEFAULT-m.jpg	INSTANT FENCE EXTRA COLLAR	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]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	8	100-to-150	0.00	[empty string]	Wireless Fence Collar	<p>This extra receiver collar can be used to add another dog or as a replacement collar to the Wireless Pet Containment System (PIF-300). Add an unlimited number of pets to your system. This collar features 5 adjustable levels of static correction.</p>	[empty string]	N	139.99	139.99	[empty string]	24862-DEFAULT-s.jpg	[empty string]	1000	PIF-275-19	66300	TRAINING COLLARS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/instant-fence-extra-collar-66300	1
2	[empty string]	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Collars and Harnesses>Training Collars	[empty string]	1	0	0	279.99	48601-DEFAULT-l.jpg	0	48601-DEFAULT-m.jpg	WIRELESS DOG FENCE	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]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	6	250-to-300	0.00	[empty string]	Wireless Pet Containment System	<p>Trusted and true, Pet Safe's original Wireless Pet Containment System keeps pets happier while you breathe easier. A simple signal from a small unit in your home to your dog’s collar is all it takes. They learn their new yard boundaries quickly and comfortably, and the collar will remind them with a tone or static correction if they forget. Before you know it, it’s all happy playing and no random straying. Covering an area up to 1/2 acre, it’s portable, requires no buried wires, and sets up in 1-2 hours.</p>	[empty string]	N	279.99	279.99	[empty string]	48601-DEFAULT-s.jpg	[empty string]	1000	PIF-300	66301	TRAINING COLLARS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/wireless-dog-fence-66301	1
3	[empty string]	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Collars and Harnesses>Training Collars	[empty string]	0	0	0	4.99	[empty string]	0	[empty string]	COLLAR REPLACEMENT BATTERY CR2032 2 PACK	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]	2012	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	65	5-AND-under	0.00	[empty string]	Cr2032 Lithium Replacement Batteries For Sd-105 And Sd-105s	Compatible with:<br/> -Two replacement lithium batteries for SportDOG Brand YardTrainer remote training collars.<br/> -For use with SD-105 and SD-105S<br/> -2 Lithium Replacement Batteries<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	RFA-35-11	66311	TRAINING COLLARS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/collar-replacement-battery-cr2032-2-pack-66311	1
4	[empty string]	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Collars and Harnesses>Training Collars	[empty string]	1	0	0	7.99	24868-DEFAULT-l.jpg	0	24868-DEFAULT-m.jpg	COLLAR REPLACEMENT BATTERY	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]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	5	5-to-10	0.00	[empty string]	Nobark 6/18 Replacement Lithium Batteries - Pkg Of 2	FEATURES:<BR/> -6-Volt<BR/> -Each lasts 1-3 months<BR/> -2 Lithium Replacement Batteries<br/> -Compatible with: NoBark 6 (SBC-6) and NoBark 18 (SBC-18)<br/> <br> <br> <br> <i><font size=1> Note: While every effort is made to include accurate and correct images, descriptions, specifications and pricing for each product, they are shown for example only and do not necessarily represent the product in its entirety. Inadvertent errors may occur. Jay`s Sporting Goods reserves the right to modify or change product information and pricing without notice. If you have a question about an item, please call or email us for more information before ordering.</font></i>	[empty string]	N	7.99	7.99	[empty string]	24868-DEFAULT-s.jpg	[empty string]	1000	RFA-67D-11	66312	TRAINING COLLARS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/collar-replacement-battery-66312	1
5	WIRELESS	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Collars and Harnesses>Training Collars	WIRELESS\|NULL\|NULL	1	329.99	0	329.99	24960-DEFAULT-l.jpg	329.99	24960-DEFAULT-m.jpg	STAY AND PLAY WIRELESS RECHARGEABLE FENC	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]	2012	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	300-to-350	0.00	[empty string]	Stay + Play Wireless Fence - 3/4 Acre Range	<p>A pet-perfect yard is now perfectly easy without expensive fences or buried wires. Keep pets playing happily and secure in your yard and off the street. The sleek in-home unit is tiny and portable; it just needs an outlet! The waterproof, rechargeable collars are our smallest yet. With easy training, custom collar settings, and protection up to 3/4 of an acre, the Stay + Play Wireless Fence gives your pet the best in yard freedom.</p>	[empty string]	N	329.99	329.99	RECHARGE	24960-DEFAULT-s.jpg	[empty string]	1000	PIF00-12917	147731	TRAINING COLLARS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/stay-and-play-wireless-rechargeable-fenc-147731	1
6	[empty string]	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Collars and Harnesses>Training Collars	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	STAY AND PLAY WIRELESS WALL CHARGER	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]	2014	[empty string]	BOTH	DISC	NOT ONLINE	[empty string]	[empty string]	10	15-to-20	0.00	[empty string]	Stay + Play Wireless Fence Collar Charger	<p>This a an additional or replacement charger for the Stay + Play Wireless Fence Rechargeable Collar.</p>	[empty string]	N	19.99	19.99	[empty string]	[empty string]	[empty string]	1000	RFA-463	219358	TRAINING COLLARS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/stay-and-play-wireless-wall-charger-219358	1
7	[empty string]	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Collars and Harnesses>Training Collars	[empty string]	1	149.99	0	149.99	64301-DEFAULT-l.jpg	149.99	64301-DEFAULT-m.jpg	STAY AND PLAY ADD-A-DOG-COLLAR	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]	2012	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	6	100-to-150	0.00	[empty string]	Stay+play Wireless Fence Rechargeable Collar	<p>The PetSafe Stay and Play Wireless Fence has been proven safe, comfortable, and effective for pets over 5 pounds. The system works by transmitting a radio signal up to 105 feet in all directions.</p>	[empty string]	N	149.99	149.99	RECHARGE	64301-DEFAULT-s.jpg	[empty string]	1000	PIF00-14288	240573	TRAINING COLLARS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/stay-and-play-add-a-dog-collar-240573	1
8	[empty string]	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Collars and Harnesses>Training Collars	[empty string]	0	229.99	0	229.99	[empty string]	229.99	[empty string]	RECHARGEABLE IN-GROUND FENCE SYSTEM	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]	2014	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Rechargeable In-ground Fence	<p>The Rechargeable In Ground Fence sends a radio signal travels through a buried wire, marking the boundaries you wish to set for your dog. Your dog wears a Receiver Collar that detects the signal at the boundary. As your dog approaches the boundary, the receiver issues a warning tone. If he proceeds further, he receives a safe but startling Static Correction. While harmless, the correction will persuade him to stay in the containment area you`ve established, The Rechargeable In-Ground Fence Receiver Collar offers 4 levels of correction plus tone-only, adjustable to your dog`s temperament.</p>	[empty string]	N	229.99	229.99	[empty string]	[empty string]	[empty string]	1000	PIG00-14673	242403	TRAINING COLLARS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/rechargeable-in-ground-fence-system-242403	1
9	[empty string]	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Collars and Harnesses>Training Collars	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	ACCESSORY KIT FOR CONTAINMENT COLLARS	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]	2014	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	16	5-to-10	0.00	[empty string]	Fence Collars Accessory Pack	<p>Refresh your pet's fencing collar with components from this universal kit. Includes long and short/standard contact points plus replacement pieces for your pet's fence receiver collar. The washers are used to keep the receiver attached to the strap. The protective clear caps help to keep water and debris out of the switch port on receivers with correction level adjustment buttons. The 4 screws can be used to replace the receiver screws on Stubborn Dog receivers.</p>	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	RFA-529	245911	TRAINING COLLARS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/accessory-kit-for-containment-collars-245911	1
10	[empty string]	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Collars and Harnesses>Training Collars	[empty string]	0	129.99	0	129.99	[empty string]	129.99	[empty string]	RECHARGEABLE IN GROUND FENCE RECEIVER	N	9 BILL	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Rechargeable In-ground Fence Collar	<p>The Rechargeable In-Ground Fence Collar waterproof receiver collar has 4 levels of static correction to match the sensitivity of your pet plus tone-only mode for training.</p>	[empty string]	N	129.99	129.99	[empty string]	[empty string]	[empty string]	1000	PIG00-13737	252392	TRAINING COLLARS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/rechargeable-in-ground-fence-receiver-252392	1
11	GREY	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies	GREY\|NULL\|NULL	0	89.99	0	89.99	[empty string]	89.99	[empty string]	PREMIUM BENCH SEAT COVER GREY EXTRA WIDE	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	50-to-100	0.00	[empty string]	Bench Seat Cover	<p>Keep your dog comfortable and your car clean! Solvit Deluxe Seat Covers combine comfort, warmth and protection. Featuring the SmartFit system, which provides improved fit on all vehicles.</p>	[empty string]	N	89.99	89.99	EXTRAWIDE	[empty string]	[empty string]	1000	62446	298611	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/premium-bench-seat-cover-grey-extra-wide-298611	1
12	[empty string]	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Containment Systems>Carriers and Crates	[empty string]	0	49.99	0	49.99	[empty string]	49.99	[empty string]	TUBULAR VEHICLE PET BARRIER 3-PIECE	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]	DISC	ONLINE	[empty string]	[empty string]	2	25-to-50	0.00	[empty string]	Tubular Barrier - 3 Piece	<p>The QuickCONNECT Tubular Car Barrier improves safety by reducing distractions when you travel with your dog. Special features eliminate the annoying rattling sound that comes with other designs, so you can enjoy a truly peaceful trip. Many barriers have a hard time staying in place, but the Tubular Car Barrier design includes rubberized top and bottom caps to firmly grip the floor and headliner and prevent slipping.</p>	[empty string]	N	49.99	49.99	[empty string]	[empty string]	[empty string]	1000	62409	298612	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/tubular-vehicle-pet-barrier-3-piece-298612	1
13	[empty string]	PETSAFE	Petsafe	PET SUPPLIES	Pet Supplies>Collars and Harnesses>Training Collars	[empty string]	0	39.99	0	39.99	[empty string]	39.99	[empty string]	WIRE ANDFLAGS KIT	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]	[empty string]	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Wire Andflags Kit	[empty string]	[empty string]	N	39.99	39.99	[empty string]	[empty string]	[empty string]	1000	PIG00-13769	345574	TRAINING COLLARS	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	petsafe/wire-andflags-kit-345574	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter