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]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	14.99	0	14.99	58288-DEFAULT-l.jpg	14.99	58288-DEFAULT-m.jpg	16GB SD CARD	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]	2012	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	60	10-to-15	0.00	[empty string]	16gb Sd Memory Card	The 16GB SD Memory Card is compatible with most digital cameras and other devices that feature a SD Card Slot.<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	14.99	14.99	16GB	58288-DEFAULT-s.jpg	[empty string]	1000	STC-16GB	149471	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/16gb-sd-card-149471	1
2	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	0	34.99	0	34.99	[empty string]	34.99	[empty string]	BEAR BOX GX SERIES	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]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Security / Bear Box For Gx Series	<p>Sometimes a simple lock bracket is just not enough to stop would be thieves and curious bears. Stealth Cam`s Security Bear Box encases your camera in 16 gauge powder coated steel. Multiple mounting options include direct bolt mount to tree, strap slots as well as Python security cable compatible slots.</p> <p> </p> <p>NOTE: CAMERA AND LOCK ARE NOT INCLUDED</p>	[empty string]	N	34.99	34.99	[empty string]	[empty string]	[empty string]	1000	STC-BBGX	247727	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/bear-box-gx-series-247727	1
3	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	69.99	0	69.99	54901-DEFAULT-l.jpg	69.99	54901-DEFAULT-m.jpg	SD CARD READER 4.3 LCD SCREEN	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	NOT ONLINE	[empty string]	[empty string]	109	50-to-100	0.00	[empty string]	SD CARD READER/VIEWER	<p>Stealth's updated SD Card Reader/Photo viewer features a 4.3" color LCD screen in durable water-resistant housing, and a wrist lanyard for easily viewing your trail camera images in the field.</p> <p> </p> <ul> <li>View images and HD videos with 1080P video playback</li> <li>4.3" Color LCD Screen</li> <li>Manage images with new View & Delete options</li> <li>Headphone jack for audio playback</li> <li>Rugged housing with durable rubberized buttons</li> <li>SD Card slot up to 32 GB</li> <li>Micro USB connection (cable not included)</li> <li>Touchscreen version allows pan and zoom of images</li> <li>Powered by 4 AAA batteries (not included)</li> </ul>	[empty string]	N	69.99	69.99	[empty string]	54901-DEFAULT-s.jpg	[empty string]	1000	STC-CRV43HD	255596	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/sd-card-reader-viewer-255596	1
4	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	14.99	0	14.99	54905-DEFAULT-l.jpg	14.99	54905-DEFAULT-m.jpg	MICRO USB CARD READER FOR ANDROID	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]	2015	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	18	10-to-15	0.00	[empty string]	Memory Card Reader - Android Devices	<p>With the Memory Card Reader you can view images and videos from your trail cam on your Android device.</p>	[empty string]	N	14.99	14.99	[empty string]	54905-DEFAULT-s.jpg	[empty string]	1000	STC-SDCRAND	258851	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/micro-usb-card-reader-for-android-258851	1
5	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	24.99	0	24.99	58289-DEFAULT-l.jpg	24.99	58289-DEFAULT-m.jpg	32GB SD CARD SNGLE PACK	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]	2016	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	10	20-to-25	0.00	[empty string]	32gb Sd Memory Card	The 32GB SD Memory Card is compatible with most digital cameras and other devices that feature a SD Card Slot.<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	24.99	24.99	32GB	58289-DEFAULT-s.jpg	[empty string]	1000	STC-32GB	263414	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/32gb-sd-card-sngle-pack-263414	1
6	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	0	19.99	0	19.99	[empty string]	19.99	[empty string]	8GB SD CARD DOUBLE PACK	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]	2016	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	7	15-to-20	0.00	[empty string]	8gb Sd Memory Card - Double Pack	<p>The 8 GB SD Memory Card is compatible with most digital cameras and other devices that feature a SD Card Slot.</p>	[empty string]	N	19.99	19.99	8GB	[empty string]	[empty string]	1000	STC-2SD8GB	264214	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/8gb-sd-card-double-pack-264214	1
7	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	11.99	0	11.99	100090-DEFAULT-l.jpg	11.99	100090-DEFAULT-m.jpg	TREE SCREW 3PK 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]	2017	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	24	10-to-15	0.00	[empty string]	TREE SCREW 3 PACK	<ul> <li>3 pack</li> <li>Durable powder coated steel</li> <li>1/4″ tripod mount</li> </ul>	[empty string]	N	11.99	11.99	[empty string]	100090-DEFAULT-s.jpg	[empty string]	1000	STC-TS-3PK	285828	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/tree-screw-3-pack-285828	1
8	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	0	9.99	0	9.99	[empty string]	9.99	[empty string]	MEMORY CARD STORAGE 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]	2017	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	8	5-to-10	0.00	[empty string]	Memory Card Storage Case	This Memory Card Storage Case holds and protects up to 24 memory cards.	[empty string]	N	9.99	9.99	[empty string]	[empty string]	[empty string]	1000	STC-MCSC	288776	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/memory-card-storage-case-288776	1
9	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	89.99	0	89.99	100091-DEFAULT-l.jpg	89.99	100091-DEFAULT-m.jpg	TOUCH SCREEN CARD READER/VIEWER	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]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	CRV43X	<p>Swipe left, right, up, down or zoom in or out. Everything of on an SD card is at the tip of your fingers. The new 4.3″ touch screen viewer from Stealth Cam will revolutionize how you look at images in the field.</p>	[empty string]	N	89.99	89.99	[empty string]	100091-DEFAULT-s.jpg	[empty string]	1000	STC-CRV43X	297740	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/crv43x-297740	1
10	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	19.99	0	19.99	98305-DEFAULT-l.jpg	19.99	98305-DEFAULT-m.jpg	4 IN 1 CARD READER FOR ANDROID AND IOS	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]	2018	[empty string]	BOTH	ACTIVE	ONLINE	[empty string]	[empty string]	16	15-to-20	0.00	[empty string]	4-IN-1 CARD READER FOR IOS & ANDROID	<ul> <li>4-in-1 card reader works with both iOS and Android devices with USB-OTG (on-the-go) functionality</li> <li>Connections: Micro USB, USB-C, USB 2.0, Lightning connector</li> <li>iOS uses iBrary Link app to view images</li> <li>Android uses OTG technology</li> </ul>	[empty string]	N	19.99	19.99	[empty string]	98305-DEFAULT-s.jpg	[empty string]	1000	STC-QMCR	310212	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/4-in-1-card-reader-for-ios-android-310212	1
11	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	59.99	0	59.99	91459-DEFAULT-l.jpg	59.99	91459-DEFAULT-m.jpg	SOL-PAK SOLAR BATTERY 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]	2020	HOTSHOW	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	50-to-100	0.00	[empty string]	Sol-pak Solar Battery Pack	[empty string]	[empty string]	N	59.99	59.99	[empty string]	91459-DEFAULT-s.jpg	[empty string]	1000	STC-SOLP	330853	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/sol-pak-solar-battery-pack-330853	1
12	ANDROID	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	ANDROID\|NULL\|NULL	1	14.99	0	14.99	100092-DEFAULT-l.jpg	14.99	100092-DEFAULT-m.jpg	ANDROID USB-C OTG SD CARD READER	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]	2020	HOTSHOW	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	7	10-to-15	0.00	[empty string]	MEMORY CARD READER – ANDROID DEVICES	<p>View images and videos from your trail cam on your Android device.</p>	[empty string]	N	14.99	14.99	[empty string]	100092-DEFAULT-s.jpg	[empty string]	1000	STC-SDCRANDW	330856	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/memory-card-reader-android-devices-330856	1
13	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Accessories	[empty string]	0	4.99	0	4.99	[empty string]	4.99	[empty string]	NO TRESSPASSING METAL SIGN CAMERA SURVEILLANCE	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]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	5-AND-under	0.00	[empty string]	No Tresspassing Metal Sign Camera Surveillance	[empty string]	[empty string]	N	4.99	4.99	[empty string]	[empty string]	[empty string]	1000	STC-SIGN-LWVS	339563	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	stealth-cam/no-tresspassing-metal-sign-camera-surveillance-339563	1
14	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	119.99	0	119.99	98260-DEFAULT-l.jpg	119.99	98260-DEFAULT-m.jpg	GMAX NO GLOW 32MP HD TRAIL CAM	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	100-to-150	0.00	[empty string]	GMAX32	<p>Packed full of features, the GMAX32 trail cam takes picture quality to all new heights at an affordable price point. The GMAX series of trail cameras from Stealth encompass all-new software innovations and a color TFT screen for viewing captured images and videos.</p> <p> </p> <ul> <li>Photo Resolutions: 32MP/16MP/8MP/4MP</li> <li>Video Resolutions: 720P/1080P</li> <li>Detection & IR Range: 80ft</li> <li>LEDs: 34pcs 850nm LEDs</li> <li>LED Flash Type: Infrared</li> <li>Trigger Speed: 0.4 Seconds</li> <li>Burst Mode: 1-9 Photos Per Trigger</li> <li>Recovery time: 2-59 sec/3-59 min</li> <li>PIR and IR Array: “No Glare” Matte finish</li> <li>Image Stamp: Time/Date/Moon Phase/Temperature/Camera</li> <li>SD Card Support: 32GB</li> <li>Batteries Required: 8 AA</li> <li>Lock Latch: Integrated Python Provision</li> <li>External power jack: 12V DC Jack</li> </ul>	[empty string]	N	119.99	119.99	[empty string]	98260-DEFAULT-s.jpg	[empty string]	1000	STC-GMAX32VNG	346013	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/gmax32-346013	1
15	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	59.99	0	59.99	98263-DEFAULT-l.jpg	59.99	98263-DEFAULT-m.jpg	BROWTINE 16MP TRAIL CAM	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]	17	50-to-100	0.00	[empty string]	BROWTINE 16MP	<p>The durable Browtine 16MP trail camera features an 80ft infra-red detection range and burst mode to capture detailed information about your target area.</p> <p> </p> <ul> <li>Photo Resolutions: 16MP/8MP/4MP</li> <li>Video Resolutions: 480P</li> <li>Detection & IR Range: 80ft</li> <li>LEDs: 18pcs 850nm LEDs</li> <li>LED Flash Type: Infrared</li> <li>Trigger Speed: 0.8 Seconds</li> <li>Burst Mode: 1-3 Photos Per Trigger</li> <li>Recovery time: 5s/15s/30s/60s/120s</li> <li>PIR and IR Array: Tinted FX Shield</li> <li>Image Stamp: Time/Date/Moon Phase</li> <li>SD Card Support: 32GB</li> <li>Batteries Required: 8 AA</li> <li>Lock Latch: Integrated Python Provision</li> </ul>	[empty string]	N	59.99	59.99	[empty string]	98263-DEFAULT-s.jpg	[empty string]	1000	STC-BT16	346016	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/browtine-16mp-346016	1
16	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	24.99	0	24.99	98306-DEFAULT-l.jpg	24.99	98306-DEFAULT-m.jpg	TRAIL CAMERA MOUNTING STICK	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]	35	20-to-25	0.00	[empty string]	CAM STICK	<ul> <li>Trail camera mounting stick is idea for mounting cameras in treeless terrain including food plots and open fields.</li> <li>360 degree horizontal rotation plus 270 degree vertical tilt adjustment</li> <li>Durable heavy-gauge steel post mounts cameras up to 34" high</li> </ul>	[empty string]	N	24.99	24.99	[empty string]	98306-DEFAULT-s.jpg	[empty string]	1000	STC-CAMSTICK	367151	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/cam-stick-367151	1
17	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	34.99	0	34.99	98307-DEFAULT-l.jpg	34.99	98307-DEFAULT-m.jpg	UNIVERSAL CAMERA BOX SMALL	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]	32	25-to-50	0.00	[empty string]	SECURITY / BEAR BOX FOR STEALTH CAM - SMALL	<p>Secure your Stealth Cam from theives, bears and other dangers with one of Stealth Cam's heavy-duty metal security boxes.  Each box is made from powder-coated steel and provides an exact fit for your camera model.  These can be lag-bolted, belted, bungeed or cable-locked to the tree to help deter potential theft.</p> <p> </p> <ul> <li>Compatible with the following camera series: Fusion, QS, QV, PXP, FP</li> </ul>	[empty string]	N	34.99	34.99	[empty string]	98307-DEFAULT-s.jpg	[empty string]	1000	STC-BB-SM	367152	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/security-bear-box-for-stealth-cam-small-367152	1
18	[empty string]	STEALTH CAM	Stealth Cam	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	34.99	0	34.99	98308-DEFAULT-l.jpg	34.99	98308-DEFAULT-m.jpg	UNIVERSAL CAMERA BOX LARGE	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]	65	25-to-50	0.00	[empty string]	SECURITY / BEAR BOX FOR STEALTH CAM - LARGE	<p>Secure your Stealth Cam from theives, bears and other dangers with one of Stealth Cam's heavy-duty metal security boxes.  Each box is made from powder-coated steel and provides an exact fit for your camera model.  These can be lag-bolted, belted, bungeed or cable-locked to the tree to help deter potential theft.</p> <p> </p> <ul> <li>Compatible with the following camera series: Reactor, FLX, GMAX, DS4K, WX4G, XV</li> </ul>	[empty string]	N	34.99	34.99	[empty string]	98308-DEFAULT-s.jpg	[empty string]	1000	STC-BB-LG	367153	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	stealth-cam/security-bear-box-for-stealth-cam-large-367153	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter