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]	SURELOCK SECURITY	Surelock Security	FIREARMS	Firearms>Storage>Cases	[empty string]	1	79.99	0	79.99	102825-DEFAULT-l.jpg	79.99	102825-DEFAULT-m.jpg	RENEGADE SERIES 16 CASE	N	16 DEVON	[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]	1	50-to-100	0.00	[empty string]	Renegade 16” Waterproof Case	<p>The Renegade Series 16” Waterproof Case by SureLock Security was created to keep your valuables protected in the most rugged conditions. Perfect for larger valuables and firearms, at 1.3ft long, this lightweight reinforced polypropylene case is road ready and can be sealed air tight and locked <em>(via padlocks, sold separately)</em>. Dustproof, shockproof, and you guessed it – waterproof, this 16” Renegade Case has your back in every condition. And with the pressure relief valve, there’s no need to fret about not being able to open your case due to elevation change. No matter where your journey takes you, the 16” Renegade Case will equalize the pressure inside the case - automatically. </p> <p> </p> <ul> <li>Dimensions: 16”L x 13”D x 7”H</li> <li>5.75 lbs.</li> <li>Customizable foam interior, one exterior black handle</li> <li>Lockable <em>(padlocks sold separately)</em></li> </ul>	[empty string]	N	79.99	79.99	[empty string]	102825-DEFAULT-s.jpg	[empty string]	1000	3H20G016	335799	EMPTY	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	surelock-security/renegade-16-waterproof-case-335799	1
2	[empty string]	SURELOCK SECURITY	Surelock Security	FIREARMS	Firearms>Storage>Cases	[empty string]	0	64.99	0	64.99	[empty string]	64.99	[empty string]	RENEGADE SERIES 13 CASE	N	16 DEVON	[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]	1	50-to-100	0.00	[empty string]	Renegade Series 13 Case	[empty string]	[empty string]	N	64.99	64.99	[empty string]	[empty string]	[empty string]	1000	3H20G013	335801	EMPTY	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	surelock-security/renegade-series-13-case-335801	1
3	[empty string]	SURELOCK SECURITY	Surelock Security	FIREARMS	Firearms>Storage>Cases	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	RENEGADE SERIES 53 SINGLE RIFLE CASE	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	9	100-to-150	0.00	[empty string]	Renegade Series 53 Single Rifle Case	[empty string]	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	3H20SG53	347521	EMPTY	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	surelock-security/renegade-series-53-single-rifle-case-347521	1
4	[empty string]	SURELOCK SECURITY	Surelock Security	FIREARMS	Firearms>Storage>Safes	[empty string]	1	99.99	0	99.99	102846-DEFAULT-l.jpg	99.99	102846-DEFAULT-m.jpg	QUICK TOUCH VAULT 100 DIFITAL	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	50-to-100	0.00	[empty string]	Quick Touch Vault 100 Difital	[empty string]	[empty string]	N	99.99	99.99	[empty string]	102846-DEFAULT-s.jpg	[empty string]	1000	3418944	347523	SAFES	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	surelock-security/quick-touch-vault-100-difital-347523	1
5	[empty string]	SURELOCK SECURITY	Surelock Security	FIREARMS	Firearms>Storage>Safes	[empty string]	1	129.99	0	129.99	102848-DEFAULT-l.jpg	129.99	102848-DEFAULT-m.jpg	QUICK TOUCH VAULT 100 DIGITAL AND BIO	N	16 DEVON	[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]	4	100-to-150	0.00	[empty string]	QuickTouch Vault 100 Digital + Bio	<ul> <li><strong>Storage capacity: 1 handgun or documents/jewelry</strong></li> <li><strong>Small, dark, and discreet</strong></li> <li><strong>Digital keypad, 20 biometric fingerprints, and backup key</strong></li> </ul> <p>The SureLock Security Company Quick Touch Vaults are small, discreet safes designed to securely hold a pistol or handgun and/or other small documents, wallets or jewelry. These safes have a front opening door that feature Stealth Opening Technology so you can access your valuables quickly and quietly with the peace of mind that only SureLock can provide.</p> <p>These safes come in three different sizes – 100, 200 and 300 – and all feature predrilled holes in the back, along with a steel lock cable, for safe and secure mounting options. Great for placement in hidden locations, the Quick Touch Vaults are perfect for your closet or dresser, under a desk, or in a garage, cabin or car. In addition to the discreet sizes, these safes come in a Nighthawk Black Matte finish for added discretion, especially in dark settings. Each of the models comes equipped with a USB-C adaptor for if your battery goes dead and you’re not near power, while the 200 and 300 models come with an AC adaptor. The 300-series is also large enough to fit 2 handguns.</p> <p>The Quick Touch Vaults come with both Digital and Digital + Biometric opening options, giving you the flexibility to have options of how accessible you want your belongings to be. With the digital keypad, you can create a 4-6 digit combination code that can be shared with those who need access. The added Biometric feature allows for fingerprint access to your safe and has the ability to store up to 20 prints, so you and your loved ones can have prompt and secure access to your unit. A key lock is also featured on both models so you are covered with a key-entry backup plan.</p>	[empty string]	N	129.99	129.99	[empty string]	102848-DEFAULT-s.jpg	[empty string]	1000	3418945	347524	SAFES	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	surelock-security/quicktouch-vault-100-digital-bio-347524	1
6	[empty string]	SURELOCK SECURITY	Surelock Security	FIREARMS	Firearms>Storage>Safes	[empty string]	1	99.99	0	99.99	102849-DEFAULT-l.jpg	99.99	102849-DEFAULT-m.jpg	QUICK TOUCH VAULT 200 DIGITAL	N	16 DEVON	[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	50-to-100	0.00	[empty string]	QuickTouch Vault 200 Digital	<ul> <li><strong>Storage capacity: 1 handgun or documents/jewelry</strong></li> <li><strong>Small, dark, and discreet</strong></li> <li><strong>Digital keypad + backup key</strong></li> </ul> <p>The Surelock Security Co QuickTouch Vaults are small, discreet safes designed to securely hold a pistol or handgun and/or other small documents, wallets or jewelry. These safes have a front opening door that feature Stealth Opening Technology</p> <p>so you can access your valuables quickly and quietly with the peace of mind that only Surelock can provide.</p> <p>These safes come in three different sizes – 100, 200 and 300 – and all feature predrilled holes in the back, along with a steel lock cable, for safe and secure mounting options. Great for placement in hidden locations, the QuickTouch Vaults are perfect for your closet or dresser, under a desk, or in a garage, cabin or car. In addition to the discreet sizes, these safes come in a Nighthawk Black Matte finish for added discretion, especially in dark settings. Each of the models comes equipped with a USB-C adaptor for if your battery goes dead and you’re not near power, while the 200 and 300 models come with an AC adaptor. The 300-series is also large enough to fit 2 handguns.</p> <p>The Quick Touch Vaults come with both Digital and Digital + Biometric opening options, giving you the flexibility to have options of how accessible you want your belongings to be. With the digital keypad, you can create a 4-6 digit combination code that can be shared with those who need access. A key lock is also featured on both models so you are covered with a key-entry backup plan.</p>	[empty string]	N	99.99	99.99	[empty string]	102849-DEFAULT-s.jpg	[empty string]	1000	3418946	347525	SAFES	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	surelock-security/quicktouch-vault-200-digital-347525	1
7	[empty string]	SURELOCK SECURITY	Surelock Security	FIREARMS	Firearms>Storage>Safes	[empty string]	1	139.99	0	139.99	102852-DEFAULT-l.jpg	139.99	102852-DEFAULT-m.jpg	QUICK TOUCH VAULT 200 DIGITAL AND BIO	N	16 DEVON	[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]	2	100-to-150	0.00	[empty string]	QuickTouch Vault 200 Digital + Bio	<ul> <li><strong>Storage capacity: 1 handgun or documents/jewelry</strong></li> <li><strong>Small, dark, and discreet</strong></li> <li><strong>Digital keypad, 20 biometric fingerprints, and backup key</strong> <p>The SureLock Security Company Quick Touch Vaults are small, discreet safes designed to securely hold a pistol or handgun and/or other small documents, wallets or jewelry. These safes have a front opening door that feature Stealth Opening Technology™, so you can access your valuables quickly and quietly with the peace of mind that only SureLock can provide.</p> <p>These safes come in three different sizes – 100, 200 and 300 – and all feature predrilled holes in the back, along with a steel lock cable, for safe and secure mounting options. Great for placement in hidden locations, the Quick Touch Vaults are perfect for your closet or dresser, under a desk, or in a garage, cabin or car. In addition to the discreet sizes, these safes come in a Nighthawk Black Matte finish for added discretion, especially in dark settings. Each of the models comes equipped with a USB-C adaptor for if your battery goes dead and you’re not near power, while the 200 and 300 models come with an AC adaptor. The 300-series is also large enough to fit 2 handguns.</p> <p>The Quick Touch Vaults come with both Digital and Digital + Biometric opening options, giving you the flexibility to have options of how accessible you want your belongings to be. With the digital keypad, you can create a 4-6 digit combination code that can be shared with those who need access. The added Biometric feature allows for fingerprint access to your safe and has the ability to store up to 20 prints, so you and your loved ones can have prompt and secure access to your unit. A key lock is also featured on both models so you are covered with a key-entry backup plan.</p> </li> </ul>	[empty string]	N	139.99	139.99	[empty string]	102852-DEFAULT-s.jpg	[empty string]	1000	3418947	347526	SAFES	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	surelock-security/quicktouch-vault-200-digital-bio-347526	1
8	[empty string]	SURELOCK SECURITY	Surelock Security	FIREARMS	Firearms>Storage>Safes	[empty string]	1	109.99	0	109.99	102850-DEFAULT-l.jpg	109.99	102850-DEFAULT-m.jpg	QUICK TOUCH VAULT 300 DIGITAL	N	16 DEVON	[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	100-to-150	0.00	[empty string]	QuickTouch Vault 300 Digital	<ul> <li><strong>Storage capacity: 2 handguns or documents/jewelry</strong></li> <li><strong>Small, dark, and discreet</strong></li> <li><strong>Digital keypad + backup key</strong></li> </ul> <p>The Surelock Security Company Quick Touch Vaults are small, discreet safes designed to securely hold a pistol or handgun and/or other small documents, wallets or jewelry. These safes have a front opening door that feature Stealth Opening Technology™, so you can access your valuables quickly and quietly with the peace of mind that only Surelock can provide.</p> <p>These safes come in three different sizes – 100, 200 and 300 – and all feature predrilled holes in the back, along with a steel lock cable, for safe and secure mounting options. Great for placement in hidden locations, the Quick Touch Vaults are perfect for your closet or dresser, under a desk, or in a garage, cabin or car. In addition to the discreet sizes, these safes come in a Nighthawk Black Matte finish for added discretion, especially in dark settings. Each of the models comes equipped with a USB-C adaptor for if your battery goes dead and you’re not near power, while the 200 and 300 models come with an AC adaptor. The 300-series is also large enough to fit 2 handguns.</p> <p>The Quick Touch Vaults come with both Digital and Digital + Biometric opening options, giving you the flexibility to have options of how accessible you want your belongings to be. With the digital keypad, you can create a 4-6 digit combination code that can be shared with those who need access. A key lock is also featured on both models so you are covered with a key-entry backup plan</p>	[empty string]	N	109.99	109.99	[empty string]	102850-DEFAULT-s.jpg	[empty string]	1000	3418948	347528	SAFES	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	surelock-security/quicktouch-vault-300-digital-347528	1
9	[empty string]	SURELOCK SECURITY	Surelock Security	FIREARMS	Firearms>Storage>Safes	[empty string]	1	199.99	0	199.99	101651-DEFAULT-l.jpg	199.99	101651-DEFAULT-m.jpg	QUICK TOUCH VAULT 300 DIGITAL AND BIO	N	16 DEVON	[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]	3	150-to-200	0.00	[empty string]	QUICK TOUCH VAULT 300 DIGITAL + BIOMETRIC	<p>The SureLock Security Company Quick Touch Vaults are small, discreet safes designed to securely hold a pistol or handgun and/or other small documents, wallets or jewelry. These safes have a front opening door that feature Stealth Opening Technology, so you can access your valuables quickly and quietly with the peace of mind that only SureLock can provide.</p> <p> </p> <ul> <li>Exterior dimensions: 7.48'' H x 13.00'' W x 10.04'' D</li> <li>Weight: 14.33 lb.</li> </ul>	[empty string]	N	199.99	199.99	[empty string]	101651-DEFAULT-s.jpg	[empty string]	1000	3418949	347529	SAFES	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	surelock-security/quick-touch-vault-300-digital-biometric-347529	1
10	[empty string]	SURELOCK SECURITY	Surelock Security	FIREARMS	Firearms>Storage>Safes	[empty string]	1	29.99	0	29.99	102851-DEFAULT-l.jpg	29.99	102851-DEFAULT-m.jpg	NIGHTHAWK XL MOBILE LOCK BOX COMBO	N	16 DEVON	[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]	9	25-to-50	0.00	[empty string]	Nighthawk 11.5" Mobile Lock Box Combination Lock	<ul> <li><strong>Gun capacity: 1 handgun, smaller valuables </strong></li> <li><strong>18-gauge steel</strong></li> <li><strong>Latching lock system</strong></li> </ul> <p>The Nighthawk Mobile Vault is a pistol safe designed to hold one pistol/handgun, small documents, wallets, and/or jewelry. The safe opens like a clam shell (top flips backwards) so you can easily access your stored item(s).</p> <p>There is a security cable that mounts to the left side of the unit to easily attach it to a secure surface, and you will also find two pre-drilled holes on the bottom - for additional mounting options. This Mobile Vault is ideal for placement next to a bedside, in a closet or dresser, under a desk, or in a garage, cabin, car + MORE! Easily transportable and securable, you can take the Nighthawk Mobile Vault with you wherever you may roam.</p> <p>The Nighthawk I features a mechanical combination lock. This lock operates with one unique combination that is three single digits: (each) 0-9. The combination code is programmable yourself at any time. The Nighthawk I does not use any batteries, so you never have to worry about changing them out. Perfect if you need to protect a pistol, store a wallet, small purse, cash, jewelry, ammunition, or prescription drugs. Great for small and important documents such as your passports etc. as well.</p>	[empty string]	N	29.99	29.99	[empty string]	102851-DEFAULT-s.jpg	[empty string]	1000	3418942	347533	SAFES	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	surelock-security/nighthawk-11-5-mobile-lock-box-combination-lock-347533	1
11	[empty string]	SURELOCK SECURITY	Surelock Security	FIREARMS	Firearms>Storage>Cases	[empty string]	0	149.99	0	149.99	[empty string]	149.99	[empty string]	RENEGADE BREAKDOWN CASE 44 INCH	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	[empty string]	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	100-to-150	0.00	[empty string]	Renegade Breakdown Case 44 Inch	[empty string]	[empty string]	N	149.99	149.99	[empty string]	[empty string]	[empty string]	1000	3H20G044	347534	EMPTY	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	surelock-security/renegade-breakdown-case-44-inch-347534	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter