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]	AMERICAN HUNTER	American Hunter	HUNTING	Hunting>Food Plots and Feeding>Game Feeders	[empty string]	1	9.99	0	9.99	24698-DEFAULT-l.jpg	9.99	24698-DEFAULT-m.jpg	AHF BATTERY CHARGER 6V/12V	N	9 BILL	[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]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	14	5-to-10	0.00	[empty string]	6/12 Volt Battery Charger	<ul> <li>Using a switch, you select 6 volt or 12 Volt charge</li> <li>Plugs into 110 Volt outlet</li> <li>Output is 500 ma DC.</li> <li>This charger will charge most 6 and</li> <li>12 volt rechargeable feeder batteries</li> </ul>	[empty string]	N	9.99	9.99	[empty string]	24698-DEFAULT-s.jpg	[empty string]	1000	BL-C6/12	1634	GAME FEEDERS	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	american-hunter/ahf-battery-charger-6v-12v-1634	1
2	[empty string]	AMERICAN HUNTER	American Hunter	HUNTING	Hunting>Food Plots and Feeding>Game Feeders	[empty string]	1	14.99	0	14.99	94316-DEFAULT-l.jpg	14.99	94316-DEFAULT-m.jpg	RECHARGEABLE BATTERY 6V 5AMP SPRING TOP	N	9 BILL	[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]	[empty string]	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	52	10-to-15	0.00	[empty string]	6 Volt 5 Amp Hr Rechargeable Lantern Battery	<p>Commonly used for game feeders, lantern and flashlights.</p>	[empty string]	N	14.99	14.99	[empty string]	94316-DEFAULT-s.jpg	[empty string]	1000	DE-30045	1642	GAME FEEDERS	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	american-hunter/rechargeable-battery-6v-5amp-spring-top-1642	1
3	[empty string]	AMERICAN HUNTER	American Hunter	HUNTING	Hunting>Food Plots and Feeding>Game Feeders	[empty string]	1	11.99	0	11.99	94317-DEFAULT-l.jpg	11.99	94317-DEFAULT-m.jpg	6V 4.5AMP RECHARGEABLE BATTERY	N	9 BILL	[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]	2014	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	22	10-to-15	0.00	[empty string]	6 Volt 4.5 Amp Hr Rechargeable Battery - Single Packaging	<p>Commonly used for game feeders, motorized ducks, game calls, headlights and spotlights.</p>	[empty string]	N	11.99	11.99	TABTOP	94317-DEFAULT-s.jpg	[empty string]	1000	DE30008	240837	GAME FEEDERS	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	american-hunter/6v-4-5amp-rechargeable-battery-240837	1
4	12VOLT	AMERICAN HUNTER	American Hunter	HUNTING	Hunting>Food Plots and Feeding>Game Feeders	12VOLT\|NULL\|NULL	1	22.99	0	22.99	58065-DEFAULT-l.jpg	22.99	58065-DEFAULT-m.jpg	12V 7AMP RECHARGEABLE BATTERY	N	9 BILL	[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]	2014	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	18	20-to-25	0.00	[empty string]	12 Volt 7 Amp Hr Rechargeable Battery - Single Packaging	<p>Commonly used for game feeders, headlights back-up lighting and household alarms.</p>	[empty string]	N	22.99	22.99	TABTOP	58065-DEFAULT-s.jpg	[empty string]	1000	DE-30020	280971	GAME FEEDERS	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	american-hunter/12v-7amp-rechargeable-battery-280971	1
5	[empty string]	AMERICAN HUNTER	American Hunter	HUNTING	Hunting>Food Plots and Feeding>Game Feeders	[empty string]	1	49.99	0	49.99	94318-DEFAULT-l.jpg	49.99	94318-DEFAULT-m.jpg	12 VOLT SOLAR CHARGER	N	9 BILL	[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]	7	25-to-50	0.00	[empty string]	6 Volt Solar Charger - For R-kit - Rd-kit And Pro Series Kits	<p>Converts sunlight into electric power for charging 12 Volt rechargeable batteries.</p>	[empty string]	N	49.99	49.99	[empty string]	94318-DEFAULT-s.jpg	[empty string]	1000	BL-1260-S	304952	GAME FEEDERS	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	american-hunter/12-volt-solar-charger-304952	1
6	[empty string]	AMERICAN HUNTER	American Hunter	HUNTING	Hunting>Food Plots and Feeding>Game Feeders	[empty string]	1	29.99	0	29.99	94319-DEFAULT-l.jpg	29.99	94319-DEFAULT-m.jpg	VOLT SOLAR CHARGER	N	9 BILL	[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	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Volt Solar Charger	<p>Converts sunlight into electric power for charging a 6V rechargeable battery. Maintenance free, weatherproof, rust proof and corrosive resistant. No exposed wires.</p>	[empty string]	N	29.99	29.99	6VOLT	94319-DEFAULT-s.jpg	[empty string]	1000	BL-660-S	325714	GAME FEEDERS	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	american-hunter/volt-solar-charger-325714	1
7	[empty string]	AMERICAN HUNTER	American Hunter	HUNTING	Hunting>Food Plots and Feeding>Game Feeders	[empty string]	1	69.99	0	69.99	90705-DEFAULT-l.jpg	69.99	90705-DEFAULT-m.jpg	SUN SLINGER 2.0 FEEDER KIT W SOLAR CHARGER	N	9 BILL	[empty string]	[empty string]	[empty string]	F	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	HOTSHOW	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Sun Slinger 2.0 Feeder Kit W Solar Charger	<ul> <li>Fully enclosed varmint cage</li> <li>Rail mount for optional accessories</li> <li>Twist lock OR Flat Mounting</li> <li>Metal spin plate</li> <li>Industrial-grade motor</li> <li>Remote Activator optional add-on accessory</li> </ul> <p>Timer design with large LCD display:</p> <ul> <li>Q-Sets – 2 Preconfigured settings for easy setup</li> <li>1-16 Custom Time Settings</li> <li>0-60 second run-time options</li> <li>Set days of the weeks</li> <li>Reverse Polarity Protection</li> <li>Jam Protection</li> </ul>	[empty string]	N	69.99	69.99	[empty string]	90705-DEFAULT-s.jpg	[empty string]	1000	AH-SSLNG-KIT	330858	GAME FEEDERS	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	american-hunter/sun-slinger-2-0-feeder-kit-w-solar-charger-330858	1
8	[empty string]	AMERICAN HUNTER	American Hunter	HUNTING	Hunting>Food Plots and Feeding>Game Feeders	[empty string]	1	24.99	0	24.99	87667-DEFAULT-l.jpg	24.99	87667-DEFAULT-m.jpg	FEEDER REMOTE ACTIVATOR	N	9 BILL	[empty string]	[empty string]	[empty string]	F	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	HOTSHOW	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	20-to-25	0.00	[empty string]	Feeder Remote Activator	<ul> <li>Activates wildlife feeder remotely up to 300 feet away</li> <li>Perfect for use from treestand, truck or pier</li> <li>For use with XD-PRO and Sunslinger</li> </ul>	[empty string]	N	24.99	24.99	[empty string]	87667-DEFAULT-s.jpg	[empty string]	1000	AH-RMT	330859	GAME FEEDERS	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	american-hunter/feeder-remote-activator-330859	1
9	[empty string]	AMERICAN HUNTER	American Hunter	HUNTING	Hunting>Food Plots and Feeding>Game Feeders	[empty string]	1	44.99	0	44.99	94320-DEFAULT-l.jpg	44.99	94320-DEFAULT-m.jpg	FEEDER METER WITH ANTENNA	N	9 BILL	[empty string]	[empty string]	[empty string]	F	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2020	HOTSHOW	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	12	25-to-50	0.00	[empty string]	Feeder Meter With Antenna	<ul> <li>Connect via Bluetooth 5.0</li> <li>Check how much feed remains in the feeder using the American Hunter APP</li> <li>IP53 rated</li> <li>Antenna version for use with metal hoppers</li> </ul>	[empty string]	N	44.99	44.99	[empty string]	94320-DEFAULT-s.jpg	[empty string]	1000	AH-FMTR-ANT	330860	GAME FEEDERS	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	american-hunter/feeder-meter-with-antenna-330860	1
10	[empty string]	AMERICAN HUNTER	American Hunter	HUNTING	Hunting>Food Plots and Feeding>Game Feeders	[empty string]	1	59.99	0	59.99	88207-DEFAULT-l.jpg	59.99	88207-DEFAULT-m.jpg	POWER SOLAR PANEL FOR FEEDER	N	9 BILL	[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	[empty string]	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Power Solar Panel For Feeder	<ul> <li>Contains an internal rechargeable battery allowing the charger to be used as main power supply for your feeder or as an additional power source to extend battery life</li> <li>Includes both lid and leg adjustable mounting brackets that enable the Solar Panel to face any direction</li> <li>6V Power Solar Panel shown with leg bracket</li> <li>Uses thumb screws for no-tool installation</li> <li>5ft Conduit cable with rubber grommet creates watertight connection with feeders to prevent any unexpected damage</li> </ul>	[empty string]	N	59.99	59.99	[empty string]	88207-DEFAULT-s.jpg	[empty string]	1000	AH-SLR	347966	GAME FEEDERS	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	american-hunter/power-solar-panel-for-feeder-347966	1
11	[empty string]	AMERICAN HUNTER	American Hunter	HUNTING	Hunting>Food Plots and Feeding>Game Feeders	[empty string]	1	19.99	0	19.99	87846-DEFAULT-l.jpg	19.99	87846-DEFAULT-m.jpg	VARMINT ZAPPER MODULE	N	9 BILL	[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	[empty string]	[empty string]	[empty string]	5	15-to-20	0.00	[empty string]	Varmint Buster - For R And Rd Kit	<ul> <li>Keep unwanted varmints away from the feed</li> <li>Mounts inside Varmint Buster compatible feeder kits</li> <li>Peak discharge voltage of 1000 (+/-) 100 volts</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	87846-DEFAULT-s.jpg	[empty string]	1000	AH-VZM	347967	GAME FEEDERS	EMPTY	EMPTY	0	0	0	FOOD PLOTS AND FEEDING	[empty string]	american-hunter/varmint-zapper-module-347967	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter