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]	SPYPOINT	Spypoint	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	59.99	0	59.99	100626-DEFAULT-l.jpg	59.99	100626-DEFAULT-m.jpg	LITHIUM BATTERY PACK SPY POINT CAMERAS	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]	2011	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	LITHIUM BATTERY PACK AND CHARGER	<p>This kit includes the 7.4V, 2,000mAh lithium battery and AC charger with charge indicator light. This type of battery is less affected by cold weather, and offers battery life up to three times that of a set of alkaline batteries.<br /> <br /> Not compatible with the Flex, Link-Micro or Force-20 cameras.</p>	[empty string]	N	59.99	59.99	10MP	100626-DEFAULT-s.jpg	[empty string]	1000	05550	128090	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	spypoint/lithium-battery-pack-and-charger-128090	1
2	[empty string]	SPYPOINT	Spypoint	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	49.99	0	49.99	58313-DEFAULT-l.jpg	49.99	58313-DEFAULT-m.jpg	SECRITY BOX FOR SOLAR/EVO AND LINK S	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]	2016	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	11	25-to-50	0.00	[empty string]	Security Box For 42 Led Spypoint Cameras	<p>Fitting all 42 LED Spypoint cameras including the Solar, the SB-200 is an armored shell for your game camera. It keeps your Spypoint camera secured and protected from both damage and theft.</p> <p> </p> <p>NOTE: CAMERA NOT INCLUDED</p>	[empty string]	N	49.99	49.99	[empty string]	58313-DEFAULT-s.jpg	[empty string]	1000	SB-200	283500	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	spypoint/secrity-box-for-solar-evo-and-link-s-283500	1
3	20MP	SPYPOINT	Spypoint	HUNTING	Hunting>Game Cameras and Accessories	20MP\|NULL\|NULL	1	99.99	0	99.99	78117-DEFAULT-l.jpg	99.99	78117-DEFAULT-m.jpg	FORCE-20 GAME CAMERA 20MP	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]	2019	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	FORCE-20	<p>The FORCE-20, as its name suggests, offers 20 megapixels of definition for super-clear images that allow you to examine every detail it captures. When detail in images is important, the FORCE-20 offers the resolution and clarity to do the job. The FORCE-20 also features multi-shot, time-lapse, and video modes. The multi-shot mode can capture up to five images per detection, and the time lapse schedule can be programmed to your specific time preferences.</p> <p> </p> <ul> <li>Definition (MP): 20MP</li> <li>Number of LEDs: 48</li> <li>Flash range: < 80' (24m)</li> <li>Trigger speed: 0.7s</li> <li>Screen: 1.5" configuration</li> <li>Photo type: Color by day, infrared by night</li> <li>Stamp on pictures: Date, time, moon phase and temperature (°C/°F)</li> <li>Time-Lapse Mode: Yes</li> <li>Multi-shot mode: Up to 5 pictures per detection</li> <li>Illumination technologie: Infrared boost</li> <li>Continuous mode: Yes</li> </ul> <p> </p> <ul> <li>Video:</li> <li>Video definition: HD (720p)</li> </ul> <p> </p> <ul> <li>Memory/Power:</li> <li>Memory card: Requires an SD/SDHC card up to 32 GB (SD card 16 GB included)</li> <li>Power: 8 alkaline AA batteries (not included)</li> <li>External power: DC 12V input</li> </ul> <p> </p> <ul> <li>Others:</li> <li>Detection distance: Up to 70 ft (21m)</li> <li>Motion Sensor: 1 sensor covering 3 zones detection</li> <li>Mount: Standard 1/4"-20 tripod</li> <li>Dimensions: 3.8" W x 5.0" H x 2.7"D (9,6 cm L x 12,7 cm H x 5,1 cm P)</li> </ul>	[empty string]	N	99.99	99.99	[empty string]	78117-DEFAULT-s.jpg	[empty string]	1000	01916	313742	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	spypoint/force-20-313742	1
4	CAMO	SPYPOINT	Spypoint	HUNTING	Hunting>Game Cameras and Accessories	CAMO\|NULL\|NULL	1	159.99	0	159.99	98252-DEFAULT-l.jpg	159.99	98252-DEFAULT-m.jpg	FORCE PRO DARK 30MP 4K NO GLOW	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]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	19	150-to-200	0.00	[empty string]	FORCE-PRO ULTRA COMPACT TRAIL CAMERA	<p>The FORCE-PRO from SPYPOINT delivers quality never before thought possible in a trail camera. Still images are delivered in 30MP resolution, so every detail is available for your scrutiny. Similarly, video can be captured in 4K mode, delivering images so clear you would think you were in the woods seeing them in real-time. The FORCE-PRO isn’t just taking pretty pictures. It’s a workhorse trail camera, with all the features you need, like the fast 0.2-second trigger speed. At less than a quarter second, fewer animals will be missed than with other cameras whose trigger speeds are closer to a full second. Not only that, but with a detection range out to 110’, more animals are in range to be captured anyway.</p> <p> </p> <ul> <li>Buck Tracker: Detection Technology (patent pending): Yes</li> </ul> <p> </p> <ul> <li>Photo:</li> <li>Illumination technology: NoInfrared boost</li> <li>Multi-shot mode: Up to 6 pictures per detection</li> <li>Time-Lapse Mode: Yes</li> <li>Stamp on pictures: Date, time, moon phase and temperature (°C/°F)</li> <li>Photo type: Color by day, infrared by night</li> <li>Screen: 1.5" configuration</li> <li>Trigger speed: 0,2s</li> <li>Flash range: < 90' (27m)</li> <li>Number of LEDs: 54</li> <li>Definition (MP): 30MP</li> </ul> <p> </p> <ul> <li>Video:</li> <li>Video definition: HD (4k)</li> <li>Sound recording: Yes</li> <li>Video length: 10, 20, 30, 60sec</li> </ul> <p> </p> <ul> <li>Memory/Power:</li> <li>External power: DC 12V input</li> <li>Power: 8 alkaline AA batteries (not included)</li> <li>Memory card: Requires an SD/SDHC card up to 128 GB (SD card 16 GB included)</li> </ul> <p> </p> <ul> <li>Others:</li> <li>Detection distance: Up to 110 ft (34m)</li> <li>Motion Sensor:1 sensor covering 3 zones detection</li> <li>Mount: Standard 1/4"-20 tripod</li> <li>Dimensions: 3.8" W x 5.0" H x 2.7"D (9,8 cm L x 12,7 cm H x 6,9 cm P)</li> </ul>	[empty string]	N	159.99	159.99	[empty string]	98252-DEFAULT-s.jpg	[empty string]	1000	01889	313743	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	spypoint/force-pro-ultra-compact-trail-camera-313743	1
5	CAMO	SPYPOINT	Spypoint	HUNTING	Hunting>Game Cameras and Accessories	CAMO\|NULL\|NULL	1	119.99	0	119.99	78121-DEFAULT-l.jpg	119.99	78121-DEFAULT-m.jpg	LINK MICRO VERIZON CELLULAR GAME CAMERA	N	9 BILL	[empty string]	[empty string]	[empty string]	C	[empty string]	[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	100-to-150	0.00	[empty string]	LINK-MICRO-LTE CELLULAR TRAIL CAMERA - VERIZON	<p>The LINK-MICRO-LTE from SPYPOINT continues the legacy of the MICRO family, offering an incredible performance and opening the door to the definitive mobile scouting solution, at a price that any hunter can afford. The LINK-MICRO-LTE is a photo-mode only camera, with multi-shot capabilities. All camera settings are managed in the app, where the full compliment of advanced scouting tools like enhanced AI species filters, and mapping and weather integration can be found.</p> <p> </p> <ul> <li>BUCK TRACKER Detection Technology (patent pending): Yes</li> </ul> <p> </p> <ul> <li>Cellular/Wireless:</li> <li>Network: LTE</li> <li>SIM card: Preactivated included</li> <li>Photos transmission: Yes</li> <li>Camera fully configurable: via the SPYPOINT App</li> </ul> <p> </p> <ul> <li>Photo:</li> <li>Continuous mode: Yes</li> <li>Multi-shot mode: Up to 2 pictures per detection</li> <li>Stamp on pictures: Date, time, moon phase and temperature (°C/°F)</li> <li>Photo type: Color by day, infrared by night</li> <li>Trigger speed: 0.5 s</li> <li>Flash range: < 80' (24m)</li> <li>Number of LEDs: 4 Power LEDs</li> <li>Definition (MP): 10MP</li> </ul> <p> </p> <ul> <li>Memory/Power:</li> <li>Memory card: Requires an Micro-SD card (not included) up to 32 GB</li> <li>Power: 8 alkaline AA batteries (not included)</li> <li>Power: LIT-10 battery pack (not included)</li> <li>External power: DC 12V input</li> </ul> <p> </p> <ul> <li>Others:</li> <li>Detection distance: Up to 80 ft (24m)</li> <li>Motion Sensor: 1 sensor covering 5 zones detection</li> <li>Schedule setup: 7 days</li> <li>Mount: Standard 1/4"-20 tripod</li> <li>Dimensions: 3.1" W X 4.4" H X 2.2" D (7,9 cm W X 11,2 cm H X 5,6 cm D)</li> </ul>	[empty string]	N	119.99	119.99	VERIZON	78121-DEFAULT-s.jpg	[empty string]	1000	01905	313746	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	spypoint/link-micro-lte-cellular-trail-camera-verizon-313746	1
6	[empty string]	SPYPOINT	Spypoint	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	0	14.99	0	14.99	[empty string]	14.99	[empty string]	12 V POWER CABLE	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]	2019	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	10-to-15	0.00	[empty string]	12 Volt Rechargeable Battery With Ac Charger	FEATURES:<br/> -12-volt 7.0Ah rechargeable battery and AC charger.	[empty string]	N	14.99	14.99	[empty string]	[empty string]	[empty string]	1000	05678	325520	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	spypoint/12-v-power-cable-325520	1
7	VERIZON	SPYPOINT	Spypoint	HUNTING	Hunting>Game Cameras and Accessories	VERIZON\|NULL\|NULL	1	59.99	0	59.99	88277-DEFAULT-l.jpg	59.99	88277-DEFAULT-m.jpg	UNIVERSAL CELLULAR ADAPTER VERIZON	N	9 BILL	[empty string]	[empty string]	[empty string]	C	[empty string]	[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]	11	50-to-100	0.00	[empty string]	CELL-LINK UNIVERSAL CELLULAR ADAPTER - VERIZON	<p>The CELL-LINK from SPYPOINT can turn virtually any non-cellular trail camera into a cellular device. Reduce trips to your hunting property to pull cards, and save that time and money. Even more exciting is the opportunity to take advantage of the mobile scouting tools that SPYPOINT offers. All the new AI technologies, species filters, advanced weather and mapping functions integrate with your non-cellular camera by connecting it to a CELL-LINK.</p> <p> </p> <ul> <li>Cellular/Wireless:</li> <li>Network: LTE</li> <li>SIM card: Preactivated included</li> <li>Photos transmission: Yes</li> <li>Camera fully configurable: via the SPYPOINT App</li> </ul> <p> </p> <ul> <li>Memory/Power:</li> <li>Memory card: Requires an Micro-SD card (not included) up to 32 GB</li> <li>Power: 8 alkaline AA batteries (not included)</li> <li>Power: LIT-10 battery pack (not included)</li> <li>External power: DC 12V input</li> </ul>	[empty string]	N	59.99	59.99	[empty string]	88277-DEFAULT-s.jpg	[empty string]	1000	CELL-LINK-V	332768	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	spypoint/cell-link-universal-cellular-adapter-verizon-332768	1
8	SPNW	SPYPOINT	Spypoint	HUNTING	Hunting>Game Cameras and Accessories	SPNW\|NULL\|NULL	1	59.99	0	59.99	88276-DEFAULT-l.jpg	59.99	88276-DEFAULT-m.jpg	UNIVERSAL CELLULAR ADAPTER SPNW	N	9 BILL	[empty string]	[empty string]	[empty string]	C	[empty string]	[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]	7	50-to-100	0.00	[empty string]	CELL-LINK UNIVERSAL CELLULAR ADAPTER	<p>The CELL-LINK from SPYPOINT can turn virtually any non-cellular trail camera into a cellular device. Reduce trips to your hunting property to pull cards, and save that time and money. Even more exciting is the opportunity to take advantage of the mobile scouting tools that SPYPOINT offers. All AI technologies, species filters, advanced weather and mapping functions integrate with your non-cellular camera by connecting it to a CELL-LINK.</p> <p> </p> <ul> <li>Network: LTE</li> <li>SIM card: Preactivated included</li> <li>Photos transmission: Yes</li> <li>Camera fully configurable: via the SPYPOINT App</li> </ul> <p> </p> <ul> <li>Memory/Power:</li> <li>Memory card: Requires an Micro-SD card (not included) up to 32 GB</li> <li>Power: 8 alkaline AA batteries (not included)</li> <li>Power: LIT-10 battery pack (not included)</li> <li>External power: DC 12V input</li> </ul>	[empty string]	N	59.99	59.99	[empty string]	88276-DEFAULT-s.jpg	[empty string]	1000	CELL-LINK	332769	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	spypoint/cell-link-universal-cellular-adapter-332769	1
9	GREY	SPYPOINT	Spypoint	HUNTING	Hunting>Game Cameras and Accessories	GREY\|NULL\|NULL	1	179.99	0	179.99	98253-DEFAULT-l.jpg	179.99	98253-DEFAULT-m.jpg	LINK MICRO TWIN PACK SPNW CELL GAME CAMERA	N	9 BILL	[empty string]	[empty string]	[empty string]	C	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	150-to-200	0.00	[empty string]	LINK-MICRO-LTE-TWIN CELLULAR TRAIL CAMERA	<p>Get twice the mobile scouting intelligence and twice the picture-taking power, but without paying twice the price. The Link-Micro-LTE is a photo-mode only camera, with multi-shot capabilities. All camera settings are managed in the app, where the full compliment of advanced scouting tools like enhanced AI species filters, and mapping and weather integration can be found.</p> <p> </p> <p><br /> • 10 megapixels<br /> • .5-second trigger speed<br /> • 80-foot detection and flash range</p>	[empty string]	N	179.99	179.99	TWINPACK	98253-DEFAULT-s.jpg	[empty string]	1000	01890	348833	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	spypoint/link-micro-lte-twin-cellular-trail-camera-348833	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter