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]	CUDDEBACK	Cuddeback	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	29.99	0	29.99	78047-DEFAULT-l.jpg	29.99	78047-DEFAULT-m.jpg	CUDDESAFE FOR J 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]	2018	[empty string]	[empty string]	ACTIVE	ONLINE	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	CUDDESAFE FOR J CAMERA	<ul> <li>Compatible with camera model size J</li> <li>Heavy-duty, bear-proof metal design</li> </ul> <p> </p> <ul> <li>Note- will work with H housing cameras, requires included adapter to be mounted into J CuddeSafe</li> </ul>	[empty string]	N	29.99	29.99	J	78047-DEFAULT-s.jpg	[empty string]	1000	3525	309114	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	cuddeback/cuddesafe-for-j-camera-309114	1
2	[empty string]	CUDDEBACK	Cuddeback	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	29.99	0	29.99	97557-DEFAULT-l.jpg	29.99	97557-DEFAULT-m.jpg	CUDDESAFE FOR G 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]	2018	[empty string]	[empty string]	ACTIVE	NOT ONLINE	[empty string]	[empty string]	19	25-to-50	0.00	[empty string]	CUDDESAFE FOR G CAMERA	<ul> <li>Compatible with camera model size G</li> <li>Note- does not work with model G-5185 & G-5222</li> </ul>	[empty string]	N	29.99	29.99	G	97557-DEFAULT-s.jpg	[empty string]	1000	3419	309230	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	cuddeback/cuddesafe-for-g-camera-309230	1
3	[empty string]	CUDDEBACK	Cuddeback	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	49.99	0	49.99	97560-DEFAULT-l.jpg	49.99	97560-DEFAULT-m.jpg	DUAL BATTERY BANK UNIVERSAL	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]	41	25-to-50	0.00	[empty string]	DUAL POWER BANK	<p>Dual Power Bank Battery Booster extends battery life on your Cuddeback cameras. Comptibile with Cuddeback cameras E Series, C series, J series, K series and G series. Two battery banks serve as primary power and back up power. Bank 1 serves as primary power and will run the camera. When bank 1 fails bank 2 will take over. When Bank 1 is restored it will resume running the camera, preserving bank 2 batteries for future use.</p> <p> </p> <ul> <li>Holds 2 banks of 6D cell batteries each (sold separately)</li> <li>Two power cords included (C1/C2, C2/C2)</li> <li>Includes battery pack, mounting bracket, heavy duty strap and cables</li> <li>12D batteries is power equivalent to 96 AA batteries</li> </ul>	[empty string]	N	49.99	49.99	[empty string]	97560-DEFAULT-s.jpg	[empty string]	1000	PW-3563	316278	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	cuddeback/dual-power-bank-316278	1
4	[empty string]	CUDDEBACK	Cuddeback	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	14.99	0	14.99	86016-DEFAULT-l.jpg	14.99	86016-DEFAULT-m.jpg	GENIUS PTL 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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	18	10-to-15	0.00	[empty string]	GENIUS PAN TILT LOCK MOUNT	<ul> <li>PTL Mount (Pan-Tilt-Lock)</li> <li>3 Axis of adjustment Pan, Tilt, Yaw</li> <li>Includes Universal Camera Adapter</li> <li>Works with Cuddeback and all trail cameras with a tripod socket</li> <li>Will work with T-Post for easy mounting locations (User would need to purchase hose clamp and T-Post)</li> <li>Screw or strap to a tree</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	86016-DEFAULT-s.jpg	[empty string]	1000	3488	325470	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	cuddeback/genius-pan-tilt-lock-mount-325470	1
5	[empty string]	CUDDEBACK	Cuddeback	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	29.99	0	29.99	88627-DEFAULT-l.jpg	29.99	88627-DEFAULT-m.jpg	GENIUS POST 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]	2019	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	GENIUS POST MOUNT	<p>Food plot and fields, logged over areas and even in the thick forest, it seems trees are never where you need them. Genius Post Mount lets you mount any trail camera anywhere you need - no tree required. Simply push the Genius Post Mount into the ground and slide your camera onto the bracket. Post Mount height can be adjusted from 25" to 32".</p> <p> </p> <ul> <li>Works with most trail cameras</li> <li>Cuddeback cameras slide on and off</li> <li>Construction is all metal</li> <li>Height adjusts from 25" to 32"</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	88627-DEFAULT-s.jpg	[empty string]	1000	3556	326664	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	cuddeback/genius-post-mount-326664	1
6	[empty string]	CUDDEBACK	Cuddeback	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	14.99	0	14.99	97556-DEFAULT-l.jpg	14.99	97556-DEFAULT-m.jpg	POWER CORD	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]	3	10-to-15	0.00	[empty string]	POWER CORD	<p>Power cord with built in voltage converter. Metal wrapped cable is 50" long.</p> <p> </p> <ul> <li>Allows CuddeLink J, G & K cameras to operate from user supplied 12 volt battery</li> <li>Compatible with most 12 volt automotive/marine batteries & 12 volt gel cells</li> <li>C2 power plug with C1 adapter included</li> </ul> <p> </p> <ul> <li>User must supply battery and water proof enclosure for battery.</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	97556-DEFAULT-s.jpg	[empty string]	1000	PW-3617	332992	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	cuddeback/power-cord-332992	1
7	[empty string]	CUDDEBACK	Cuddeback	HUNTING	Hunting>Accessories	[empty string]	1	279.99	0	279.99	86846-DEFAULT-l.jpg	279.99	86846-DEFAULT-m.jpg	G-SERIES CUDDELINK POWERHOUSE BLACK	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	250-to-300	0.00	[empty string]	CUDDELINK POWER HOUSE BLACK FLASH 20MP	<p>Cuddeback's most powerful Black Flash CuddeLink camera ever made. X-Change flash system allows you to change flash type. </p> <p> </p> <ul> <li>Compatible with all CuddeLink cameras</li> <li> Instead of checking all your trail cameras, you only check one</li> </ul> <p> </p> <ul> <li>Megapixels: 20</li> <li>Trigger Speed: 1/4 second</li> <li>LEDs: 56 940nm</li> <li>Flash Type: No Glow IR</li> <li>Flash Range: 100 feet</li> <li>Battery Type: 4 x D</li> </ul>	[empty string]	N	279.99	279.99	[empty string]	86846-DEFAULT-s.jpg	[empty string]	1000	G-5079	332996	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	[empty string]	cuddeback/cuddelink-power-house-black-flash-20mp-332996	1
8	[empty string]	CUDDEBACK	Cuddeback	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	199.99	0	199.99	97558-DEFAULT-l.jpg	199.99	97558-DEFAULT-m.jpg	CUDDELINK CELL VZW	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]	20	150-to-200	0.00	[empty string]	CUDDELINK CELL - VERIZON	<p>Note that CuddeLink Cell camera operation requires an active Cuddeback Cell Data Plan. Each cell camera needs their own data plan to operate. </p> <p> </p> <ul> <li>Megapixels: 20</li> <li>Trigger Speed: 1/4 second</li> <li>LEDs: 56 850nm</li> <li>Flash Type: Low Glow IR</li> <li>Flash Range:100 feet</li> <li>Battery Type: 4 x D</li> <li>Cellular Service: Verizon 4G LTE</li> </ul>	[empty string]	N	199.99	199.99	[empty string]	97558-DEFAULT-s.jpg	[empty string]	1000	G-5109	343021	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	cuddeback/cuddelink-cell-verizon-343021	1
9	[empty string]	CUDDEBACK	Cuddeback	HUNTING	Hunting>Game Cameras and Accessories	[empty string]	1	749.99	0	749.99	97812-DEFAULT-l.jpg	749.99	97812-DEFAULT-m.jpg	CUDDELINK BLACK FLASH J-1422 4 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]	2020	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	CuddeLink Black Flash Value Bundle Model 11490	<p>Megapixels: 20<br /> Trigger Speed: 1/4 second<br /> LEDs : 24 940nm<br /> Flash Type: Totally invisible flash<br /> Flash Range: 50 feet<br /> Battery Type: 4 x D</p>	[empty string]	N	749.99	749.99	4PACK	97812-DEFAULT-s.jpg	[empty string]	1000	11490	343131	EMPTY	EMPTY	EMPTY	0	0	0	GAME CAMERAS AND ACCESSORIES	[empty string]	cuddeback/cuddelink-black-flash-value-bundle-model-11490-343131	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Size

Filter