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]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	9.99	0	9.99	100652-DEFAULT-l.jpg	9.99	100652-DEFAULT-m.jpg	CONVERTER 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]	2012	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	6	5-to-10	0.00	[empty string]	2012-2020 UNIVERSAL AUXILIARY/CONVERTOR CABLE	<p>Increase the battery life on your camera by combining the auxiliary cable with a universal 6-12 volt rechargeable battery or solar panel. This will work with all models manufactured from 2012 through 2019. Converts: 9-12 volts to 6 volts. This convertor cable will work with all 12V battery cameras manufactured from 2012-2022. </p>	[empty string]	N	9.99	9.99	[empty string]	100652-DEFAULT-s.jpg	[empty string]	1000	CC2540	150405	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/2012-2020-universal-auxiliary-convertor-cable-150405	1
2	[empty string]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	59.99	0	59.99	100660-DEFAULT-l.jpg	59.99	100660-DEFAULT-m.jpg	SOLAR PANEL WITH LI/ION 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]	2016	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	16	50-to-100	0.00	[empty string]	SOLAR PANEL	<p>Keep your camera's battery life strong with Covert's solar panel. Included in the box is everything you will need except rechargeable AA batteries. Always use rechargeable AA batteries in your camera when the solar panel is plugged in.</p>	[empty string]	N	59.99	59.99	[empty string]	100660-DEFAULT-s.jpg	[empty string]	1000	CC5267	264962	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/solar-panel-264962	1
3	[empty string]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	119.99	0	119.99	98173-DEFAULT-l.jpg	119.99	98173-DEFAULT-m.jpg	MP32 40 LOW GLOW IR TRAIL CAMERA	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	[empty string]	[empty string]	[empty string]	13	100-to-150	0.00	[empty string]	MP32	<ul> <li>32 Megapixels</li> <li>40 IR Low Glow LED’s</li> <li>1080P Video</li> <li>100 foot flash range</li> <li>Detection Range 85’</li> <li>1-5 Shot Photo Burst</li> <li>.35 Second Trigger Speed</li> <li>8-32GB SD card</li> <li>8AA Batteries</li> <li>1.5” Settings Screen</li> <li>Time lapse capability</li> </ul>	[empty string]	N	119.99	119.99	[empty string]	98173-DEFAULT-s.jpg	[empty string]	1000	CC8021	345605	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/mp32-345605	1
4	[empty string]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	69.99	0	69.99	98174-DEFAULT-l.jpg	69.99	98174-DEFAULT-m.jpg	MP9 17 LOW GLOW IR TRAIL CAMERA	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	[empty string]	[empty string]	[empty string]	48	50-to-100	0.00	[empty string]	MP9	<ul> <li>9 Megapixels</li> <li>16 IR Low Glow LED’s</li> <li>60-foot flash range</li> <li>1 Shot, 3 Shot, & Video Mode</li> <li>1 Second Trigger Speed</li> <li>Up to 32GB SD card</li> <li>4 AA Batteries</li> <li>0.9” Settings Screen</li> </ul>	[empty string]	N	69.99	69.99	[empty string]	98174-DEFAULT-s.jpg	[empty string]	1000	CC8038	345606	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/mp9-345606	1
5	[empty string]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	39.99	0	39.99	100653-DEFAULT-l.jpg	39.99	100653-DEFAULT-m.jpg	MP32 TRAIL CAMERA BEAR SAFE	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	[empty string]	[empty string]	[empty string]	8	25-to-50	0.00	[empty string]	MP32 BEARSAFE	<h2><span style="font-size:12px">Covert Scouting Cameras MP32 Bearsafe</span></h2>	[empty string]	N	39.99	39.99	[empty string]	100653-DEFAULT-s.jpg	[empty string]	1000	CC8120	345623	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/mp32-bearsafe-345623	1
6	[empty string]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	39.99	0	39.99	100654-DEFAULT-l.jpg	39.99	100654-DEFAULT-m.jpg	WC30 SERIES TRAIL CAMERA BEAR SAFE	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	[empty string]	[empty string]	[empty string]	14	25-to-50	0.00	[empty string]	WC30 BEARSAFE	<p>Fits: WC30-V and WC30-A</p>	[empty string]	N	39.99	39.99	[empty string]	100654-DEFAULT-s.jpg	[empty string]	1000	CC8090	345624	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/wc30-bearsafe-345624	1
7	ATT	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	ATT\|NULL\|NULL	1	149.99	0	149.99	98175-DEFAULT-l.jpg	149.99	98175-DEFAULT-m.jpg	WC30-A LTE ATT CELL GAME CAM	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	[empty string]	[empty string]	[empty string]	10	100-to-150	0.00	[empty string]	WC30-A	<ul> <li>Dimensions: 5.7”×4.5“×3.2”</li> <li>30 Megapixels (Adjustable 5/16/30)</li> <li>Picture + Video Mode</li> <li>0.2 Second Trigger Speed</li> <li>48 No Glow LED’s</li> <li>100 Foot Flash Range</li> <li>High Resolution</li> <li>1-10 Turbo Shot Burst</li> <li>MaXimum Silence Image Capture</li> <li>Time/Date/Temp/Moon Phase Stamp</li> <li>2.4" Color Viewer</li> <li>12 AA Batteries</li> <li>Exceptional battery life</li> <li>Up to 32GB SD card</li> <li>Reinforced Tripod Mount</li> <li>Available for AT&T</li> </ul>	[empty string]	N	149.99	149.99	[empty string]	98175-DEFAULT-s.jpg	[empty string]	1000	CC2762	345625	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/wc30-a-345625	1
8	VERIZON	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	VERIZON\|NULL\|NULL	1	149.99	0	149.99	98176-DEFAULT-l.jpg	149.99	98176-DEFAULT-m.jpg	WC30-V LTE VERIZON CELL GAME CAM	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	[empty string]	[empty string]	[empty string]	8	100-to-150	0.00	[empty string]	WC30-V	<ul> <li>Dimensions: 5.7”×4.5“×3.2”</li> <li>30 Megapixels (Adjustable 5/16/30)</li> <li>Picture + Video Mode</li> <li>0.2 Second Trigger Speed</li> <li>48 No Glow LED’s</li> <li>100 Foot Flash Range</li> <li>High Resolution</li> <li>1-10 Turbo Shot Burst</li> <li>MaXimum Silence Image Capture</li> <li>Time/Date/Temp/Moon Phase Stamp</li> <li>2.4" Color Viewer</li> <li>12 AA Batteries</li> <li>Exceptional battery life</li> <li>Up to 32GB SD card</li> <li>Reinforced Tripod Mount</li> <li>Available for Verizon LTE</li> </ul>	[empty string]	N	149.99	149.99	[empty string]	98176-DEFAULT-s.jpg	[empty string]	1000	CC8014	345626	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/wc30-v-345626	1
9	[empty string]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	14.99	0	14.99	98283-DEFAULT-l.jpg	14.99	98283-DEFAULT-m.jpg	T60 CAMERA MOUNT 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]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	26	10-to-15	0.00	[empty string]	T60 - 2 PACK	<ul> <li>Threaded Tree Lag</li> <li>Multi-Position Camera Mounting Plate</li> <li>Rotational Ball Mount for 360-degree rotation and adjustability </li> <li>2-Pack</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	98283-DEFAULT-s.jpg	[empty string]	1000	CC2175	345633	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/t60-2-pack-345633	1
10	[empty string]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	14.99	0	14.99	100655-DEFAULT-l.jpg	14.99	100655-DEFAULT-m.jpg	T60 PRO CAMERA MOUNT	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	[empty string]	[empty string]	[empty string]	12	10-to-15	0.00	[empty string]	T60 PRO MOUNT	<ul> <li>Threaded Tree Lag </li> <li>Swing Arm Camera Mount </li> <li>Tool Free Positioning</li> <li>Rotational Ball Mount for 360-degree rotation and adjustability</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	100655-DEFAULT-s.jpg	[empty string]	1000	CC2373	345634	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/t60-pro-mount-345634	1
11	[empty string]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	12.99	0	12.99	100656-DEFAULT-l.jpg	12.99	100656-DEFAULT-m.jpg	T60 T-POST CAMERA MOUNT	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	[empty string]	[empty string]	[empty string]	5	10-to-15	0.00	[empty string]	T60 POST MOUNT	<ul> <li>Mounts to any post less than 1.5" in diameter</li> <li>Clamp with Threaded Tightener for TPost Mounting </li> <li>Multi-Position Camera Mounting Plate</li> <li>Rotational Ball Mount for 360-degree rotation and adjustability</li> </ul>	[empty string]	N	12.99	12.99	[empty string]	100656-DEFAULT-s.jpg	[empty string]	1000	CC2410	345635	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/t60-post-mount-345635	1
12	[empty string]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	29.99	0	29.99	100657-DEFAULT-l.jpg	29.99	100657-DEFAULT-m.jpg	T60 FIELD CAMERA MOUNT	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	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	T60 FIELD MOUNT	<ul> <li>Extendable Aluminum Shaft</li> <li>Collapses to 23”</li> <li>Extends to 48" </li> <li>Removeable 6” Foot Plate and Removeable 6" Ground Stakes </li> <li>Rotational Ball Mount for 360-degree rotation and adjustability</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	100657-DEFAULT-s.jpg	[empty string]	1000	CC2564	345636	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/t60-field-mount-345636	1
13	[empty string]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	14.99	0	14.99	100658-DEFAULT-l.jpg	14.99	100658-DEFAULT-m.jpg	SD CARD CASE	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	[empty string]	[empty string]	[empty string]	7	10-to-15	0.00	[empty string]	COVERT SD CARD CASE	<ul> <li>Zippered EVA Molded Case with Embossed Logo</li> <li>Fits 20 SD Cards</li> <li>Measures: 6” W x 4” H x 1.5” D</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	100658-DEFAULT-s.jpg	[empty string]	1000	CC5960	345637	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/covert-sd-card-case-345637	1
14	[empty string]	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	249.99	0	249.99	98177-DEFAULT-l.jpg	249.99	98177-DEFAULT-m.jpg	CODE BLACK SELECT DUAL CARRIER CELLL CAMERA	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	200-to-250	0.00	[empty string]	CODE BLACK SELECT	<ul> <li>30 Megapixels</li> <li>4K HD Video</li> <li>.2 second Trigger Speed</li> <li>4G LTE Universal Module</li> <li>GPS function</li> <li>2" Viewing Screen</li> <li>100 foot Flash Range</li> <li>60 foot Detection Range</li> <li>12 AA Battereies</li> <li>QR Code Set-up</li> <li>HQ Image Downloads</li> <li>Real Time Photos</li> <li>Settings Changes via the App</li> <li>Invisible flash technology</li> <li>1-10 turbo shot burst</li> <li>Maximum Silence image capture</li> <li>Time/date/temp/moon phase stamp</li> <li>Up to 32GB SD card</li> </ul>	[empty string]	N	249.99	249.99	[empty string]	98177-DEFAULT-s.jpg	[empty string]	1000	CC0029	365945	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/code-black-select-365945	1
15	ATT	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	ATT\|NULL\|NULL	1	119.99	0	119.99	98178-DEFAULT-l.jpg	119.99	98178-DEFAULT-m.jpg	WC20-A ATT CELL GAME CAMERA	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	88	100-to-150	0.00	[empty string]	WC20-A	<ul> <li>4G LTE</li> <li>No Glow Flash</li> <li>12 AA Batteries</li> <li>QR Code Set-up</li> <li>HQ Image Downloads</li> <li>Settings Changes via the App</li> <li>1-3 turbo shot burst</li> <li>Maximum Silence image capture</li> <li>Time/date/temp/moon phase stamp</li> </ul> <p> </p> <ul> <li>20 Megapixels</li> <li>1080p Video</li> <li>.3 second Trigger Speed</li> <li>100 foot Flash Range</li> <li>1.5" Setting Screen</li> <li>80 foot Detection Range</li> <li>Up to 32GB SD card</li> </ul>	[empty string]	Y	119.99	119.99	[empty string]	98178-DEFAULT-s.jpg	[empty string]	1000	CC0005	365947	EMPTY	EMPTY	EMPTY	1	119.99	79.99	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/wc20-a-365947	1
16	VERIZON	COVERT CAMERAS	Covert Cameras	HUNTING	Hunting>Game Cameras and Accessories	VERIZON\|NULL\|NULL	1	119.99	0	119.99	98180-DEFAULT-l.jpg	119.99	98180-DEFAULT-m.jpg	WC20-V VERIZON CELL GAME CAMERA	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]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	123	100-to-150	0.00	[empty string]	WC20-V	<ul> <li>4G LTE</li> <li>No Glow Flash</li> <li>12 AA Batteries</li> <li>QR Code Set-up</li> <li>HQ Image Downloads</li> <li>Settings Changes via the App</li> <li>1-3 turbo shot burst</li> <li>Maximum Silence image capture</li> <li>Time/date/temp/moon phase stamp</li> </ul> <p> </p> <ul> <li>20 Megapixels</li> <li>1080p Video</li> <li>.3 second Trigger Speed</li> <li>100 foot Flash Range</li> <li>1.5" Setting Screen</li> <li>80 foot Detection Range</li> <li>Up to 32GB SD card</li> </ul>	[empty string]	Y	119.99	119.99	[empty string]	98180-DEFAULT-s.jpg	[empty string]	1000	CC0012	365949	EMPTY	EMPTY	EMPTY	1	119.99	79.99	GAME CAMERAS AND ACCESSORIES	[empty string]	covert-cameras/wc20-v-365949	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter