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]	SPORTS AFIELD	Sports Afield	FIREARMS	Firearms>Storage>Safes	[empty string]	1	3999.99	0	3999.99	101752-DEFAULT-l.jpg	3999.99	101752-DEFAULT-m.jpg	REMINGTON STS 40 FLEX GUN - FIRE AND WATERPROOF SAFE	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	REMINGTON STS 40 FLEX GUN - FIRE AND WATERPROOF SAFE	<p>Built from 10-gauge steel this heavy-duty safe keeps you prepared for anything. This waterproof and fireproof safe can withstand 120 minutes at 1800° and water resistance for 2 feet for up to 7-days. The UL-rated SecuRam lock is backlit and the interior is fully lit for easy access in low light conditions.  The Remington STS gun safe represents the premier level of everything; security, performance, durability, and luxury.</p> <p> </p> <ul> <li>Triple Seal Protection against fire, smoke, and theft</li> <li>Unique brass wheel handle</li> <li>Bolt limiting pins protect the exterior of the safe from cosmetic damage</li> <li>40 long guns + 6 handguns + 1 long gun on the door</li> <li>Interior is entirely quilted in premium vinyl</li> <li>Fully adjustable shelves and barrel rests plus 2 glass shelves</li> <li>Zero-Sag steel reinforced top shelf</li> <li>UL-listed dual outlet and USB ports</li> <li>Factory-installed motion sensor LED lights</li> <li>Upholstered interior door panel embroidered with Remington logo</li> <li>Door panel with pouches for small gear and gun organization</li> <li>Approved by the California DOJ for secure gun storage</li> </ul>	[empty string]	N	3999.99	3999.99	[empty string]	101752-DEFAULT-s.jpg	[empty string]	1000	SAR6540S	383564	SAFES	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	sports-afield/remington-sts-40-flex-gun-fire-and-waterproof-safe-383564	1
2	[empty string]	SPORTS AFIELD	Sports Afield	FIREARMS	Firearms>Storage>Safes	[empty string]	1	2699.99	0	2699.99	101914-DEFAULT-l.jpg	2699.99	101914-DEFAULT-m.jpg	REMINGTON NITRO 36+6 GUN - FIRE AND WATERPROOF SAFE	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	REMINGTON NITRO 36+6 GUN - FIRE AND WATERPROOF SAFE	<p>The Remington Nitro gun safe provides top-level security for your firearms and valuables. It is fire-rated for 90 minutes at 1800 degrees and waterproof for up to 7-days in 2 feet of water. The SecuRam digital lock is backlit for easy access in low light. The body is forged from 11-gauge steel, weighs 910.5 lbs, and is painted a glossy Seltzer Gray Metallic. Entry to the safe is intuitive with the 5-spoke chrome handle with carbon fiber accents. The fully lit interior features quilted vinyl on the sidewalls and door. There is plenty of storage for guns and hunting accessories on the door storage and adjustable shelving. Stay powered up with dual outlets and two USB ports. The sophisticated design of the Remington Nitro safe is both practical and inspiring.</p> <p> </p> <ul> <li>Gun Capacity - 36 + 6</li> <li>External Dimensions - (HxWxD) - 65'' x 34'' x 26''</li> <li>Internal Volume - 18.66 cu. ft.</li> <li>Water Protection - 2' for 7 days</li> <li>Weight - 910.5 lb.</li> <li>Finish - Seltzer Gray Gloss Metallic Powder Coat</li> <li>Lock Type - SecuRam backlit UL-rated digital lock & 5 spoke handle</li> <li>Bolts - 14 Total - 1.75'' dia. Bolts, 10 Live Bolts 4'' length</li> <li>Steel Guage - 11 ga.</li> <li>Triple Seal Protection against fire, smoke, and theft</li> <li>Black chrome hub and 5-spoke handle with carbon fiber accents</li> <li>Bolt limiting pins protect exterior of safe from cosmetic damage</li> <li>36 + 6 gun storage</li> <li>Quilted vinyl sidewalls and door</li> <li>Fully adjustable carpeted shelves and barrel rests with stitched vinyl trim</li> <li>Zero-Sag steel-reinforced top shelf</li> <li>UL-listed dual outlet and USB ports</li> <li>Factory-installed LED lights</li> <li>Upholstered interior door panel embroidered with Remington logo</li> <li>Door panel with pouches for small gear and gun organization</li> <li>Approved by the California DOJ for secure gun storage</li> </ul>	[empty string]	N	2699.99	2699.99	[empty string]	101914-DEFAULT-s.jpg	[empty string]	1000	SAR6536N	383566	SAFES	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	sports-afield/remington-nitro-36-6-gun-fire-and-waterproof-safe-383566	1
3	[empty string]	SPORTS AFIELD	Sports Afield	FIREARMS	Firearms>Storage>Safes	[empty string]	1	1899.99	0	1899.99	102052-DEFAULT-l.jpg	1899.99	102052-DEFAULT-m.jpg	24+4 GUN - FIRE AND WATERPROOF SAFE	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	2	500-or-more	0.00	[empty string]	REMINGTON 24+4 GUN - FIRE AND WATERPROOF SAFE	<p>Admiring the harmony of innovation and time-proven excellence is what the Remington Express 24-Gun Safe is all about. Prepared for the elements with a 12-gauge industrial steel body and Triple Seal technology, this fireproof and waterproof safe is one you can depend on to keep your firearms and valuables protected. Backed by a high-performance SecuRam UL Rated electronic lock, ten robust steel locking bolts, and a relocker device for maximum in-home security. Motion-activated LED lights come installed inside your safe for easy access in low light conditions. The fully carpeted interior features ample storage with the deluxe pocket door organizer, barrel rests, Zero-Sag top shelf, and adjustable side shelves. Keep your favorite gun safe accessories charged with the integrated UL Rated dual power outlets and two USB ports. Includes a waterproof bolt-down kit for use with the pre-drilled holes and a Lifetime Warranty that covers your entire Remington safe against theft, fire, natural flood, locks, parts, and paint.</p> <p> </p> <ul> <li>Gun Capacity - 24 + 4</li> <li>External Dimensions (HxWxD) - 59'' x 28'' x 22''</li> <li>Internal Volume - 11.57 cu. ft.</li> <li>Water Protection - 2' for 7 days</li> <li>Weight - 590.4 lbs.</li> <li>Finish - Express Graphite Satin Metallic Powder Coat</li> <li>Lock Type - SecuRam UL Rated Electronic Lock</li> <li>Bolts - 10 Total - 1.5'' dia. Bolts, 7 Live Bolts 3'' length</li> <li>Steel Guage - 12 ga.</li> <li>Fireproof for 60 minutes reaching temperatures up to 1650°F</li> <li>Waterproof for 7-days in up to 2 ft. of standing water</li> <li>Accommodates up to 24 long guns and four handguns</li> <li>Fully programmable UL Rated SecuRam Electronic Lock</li> <li>Two Fail Safe override keys for emergency use</li> <li>12-gauge steel body with a full seam Uni-Weld construction</li> <li>Ten solid steel locking bolts- seven 1.5'' active locking bolts and three 1.5'' deadbolts</li> <li>Drill-resistant hard plate and a relocker device</li> <li>Bright motion-detected interior lighting</li> <li>UL Rated dual power outlet with two USB ports</li> <li>Fully carpeted interior, shelving, and barrel rests with a stylish embroidered vinyl trim</li> <li>Three height-adjustable side shelves</li> <li>Premium quilted vinyl pocket door organizer with holsters and zipper pockets</li> <li>Bolt-limiting pins protect the exterior of the safe from cosmetic damage caused by open bolts</li> <li>Durable Express Graphite Satin Metallic powder coat finish</li> <li>Stylish 5-spoke chrome handle</li> <li>California DOJ Approved gun safe</li> <li>Includes a waterproof safe bolt-down kit for use with the four pre-drilled bottom holes, two Fail Safe™ override keys, 9V battery, Quick-Start Guide and Owner’s Manual</li> <li>Backed by a Lifetime Warranty that covers the entire safe against theft, fire, natural flood, locks, parts, and paint with free freight shipping on replacement safes</li> <li>Exterior Dimensions: 59''H x 28''W x 22''D</li> <li>Interior Dimensions: 55.51''H x 24.41''W x 14.76''D</li> <li>Weight: 590.4 lbs.</li> </ul>	[empty string]	N	1899.99	1899.99	[empty string]	102052-DEFAULT-s.jpg	[empty string]	1000	SAR5924E	383567	SAFES	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	sports-afield/remington-24-4-gun-fire-and-waterproof-safe-383567	1
4	[empty string]	SPORTS AFIELD	Sports Afield	FIREARMS	Firearms>Storage>Safes	[empty string]	1	999.99	0	999.99	101995-DEFAULT-l.jpg	999.99	101995-DEFAULT-m.jpg	PRESERVE 24 + 4-GUN, ELECTRONIC LOCK	N	16 DEVON	[empty string]	[empty string]	[empty string]	[empty string]	INSTORE PICK UP ONLY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	PRESERVE 24 + 4-GUN, ELECTRONIC LOCK	<p>The Sports Afield Preserve 10.42 cu. ft. Fireproof and Waterproof 24-Gun Safe provides all the essentials to secure your firearms, giving you total peace of mind. Our proprietary Triple Seal technology creates a seal that is smoke and fire resistant for 45 minutes in temperatures up to 1400°F with water protection for up to 7-days in 2 ft. of standing water. This long gun safe is constructed out of industrial-grade steel with a heavy-duty Uni-Weld body and six 1.5 in. steel locking bolts. It features a fully programmable electronic lock, Anti-Theft Alarm, and comes with two Fail Safe override keys. The interior of the safe is fully carpeted and includes a barrel rack with 24 gun positions, a Zero-Sag steel reinforced top shelf that supports heavier items, and three height-adjustable side shelves. The exterior has a sleek Black Textured Gloss powder coat finish and chrome hardware. The large external hinges allow the door to open 180° for easy access while loading your safe. </p> <p> </p> <p> </p> <ul> <li>Gun Capacity - 24 + 4</li> <li>External Dimensions (HxWxD) - 59'' x 24'' x 20''</li> <li>Internal Volume - 10.42 cu. ft.</li> <li>Water Protection - Waterproof in 2' for 7 Days</li> <li>Weight - 348 lb.</li> <li>Finish - Black Textured Gloss Powder Coat</li> <li>Lock Type - Electronic Lock Face</li> <li>Bolts - 6–1.5'' steel bolts</li> <li>Steel Guage - 14 ga.</li> <li>Independently fire-rated for 45 minutes in temperatures up to 1400 degrees Fahrenheit</li> <li>Independently water-rated for 7 days in up to 2 ft of standing water </li> <li>24 long gun barrel rests and 4 handgun holsters</li> <li>Fully programmable electronic lock with two Fail Safe override keys for emergency use</li> <li>Rugged full-seam Uni-Weld steel construction with three 1.5 in. active steel bolts and three 1.5 in. deadbolts creates a fortified barrier against theft</li> <li>Anti-Theft Alert triggers the alarm if unauthorized entry attempts are detected</li> <li>Fully carpeted interior with a Zero-Sag top shelf, height-adjustable side shelves, and a single UL Rated power outlet</li> <li>Deluxe pocket door organization with zipper pockets and four handgun holsters for quick access to commonly used items</li> <li>Stylish and durable Black Textured Gloss powder coat finish with a 3-spoke chrome handle</li> </ul>	[empty string]	N	999.99	999.99	[empty string]	101995-DEFAULT-s.jpg	[empty string]	1000	SA5924P	383569	SAFES	EMPTY	EMPTY	0	0	0	STORAGE	[empty string]	sports-afield/preserve-24-4-gun-electronic-lock-383569	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter

Sports Afield
Remington Sts 40 Flex Gun - Fire And Waterproof Safe
Item # SAR6540S $3,999.99
Sports Afield
Remington Nitro 36 + 6 Gun - Fire And Waterproof Safe
Item # SAR6536N $2,699.99
Sports Afield
Remington 24 + 4 Gun - Fire And Waterproof Safe
Item # SAR5924E $1,899.99
Sports Afield
Preserve 24 + 4- Gun, Electronic Lock
Item # SA5924P $999.99