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	DUSKBLU	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	DUSKBLU\|NULL\|NULL	0	329.99	0	329.99	[empty string]	329.99	[empty string]	BALTORO 75L PACK 5LB5OZ 55#CAPACITY	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	BOTH	SELL THRU	ONLINE	[empty string]	[empty string]	1	300-to-350	0.00	[empty string]	Baltoro 75 - Men`s	<p>Spacious yet agile, the Baltoro 75`s Response A3 suspension stays comfortable on any multi-day trip. Carry everything you need for a deluxe basecamp, then set out and explore using the included sidekick daypack.</p> <p> </p> <p>-Response A3 Suspension with Auto Angle Adjust (A3) hipbelts and shoulder harnesses rotate to your unique body geometry for a custom fit<br /> -3D Air hipbelts and harness designed with Gregory`s precurved technology and multi-density LifeSpan EVA foam construction<br /> -Wishbone aluminum frame with anti-barreling cross-stay provide structure for the Response A3 system and deliver weight to the ComfortGrip lumbar pad with removable LumbarTune pad to customize fit<br /> -Matrix breathable backpanel with layered, multi-density foam for the right balance of support, airflow and cushioning<br /> -Full body U-Zip main opening on front of bag for easy unloading when you get to camp<br /> -Custom fitted raincover included - stows in a quick access zippered pocket on underside of the top lid<br /> -Removable hydration sleeve converts into fast and light SideKick Daypack with shoulder harnesses and accessory pocket<br /> -H20 resistant WeatherShield hipbelt pocket with YKK AquaGuard&rgeg; zipper for quick access to your phone or camera<br /> -Sunglass QuickStow system on shoulder harness for quick, secure and scratch-free access to your shades<br /> -SideWinder bottle holster for one-handed on-the-go water bottle access - tucks away when not in use<br /> -Stretch mesh side stash pocket large enough for a second water bottle, trekking poles, sandals, snacks, etc<br /> -Dual front zippered organization pockets with heavy duty stretch mesh stash pocket<br /> -Double barrel top lid design with dual zippered pockets and a flexible center divider for larger items<br /> -Zippered bottom sleeping bag compartment with removable divider<br /> -Dual adjustable attachment loops and upper shock locks for trekking poles or ice axes<br /	[empty string]	N	329.99	329.99	MEDIUM	[empty string]	[empty string]	1000	BALTORO 75	277117	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/baltoro-75l-pack-5lb5oz-55-capacity-277117	1
2	EMPIRE	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	EMPIRE\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	ZULU 55L PACK 3LB11OZ 40#CAPACITY	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	BOTH	ACTIVE	[empty string]	[empty string]	[empty string]	2	150-to-200	0.00	[empty string]	Zulu 55	<p>The Zulu 55 has that ideal balance of space and svelteness that makes it perfect for long summer weekends and winter overnights. With its streamlined shape, low weight, full feature set, and incredible ventilated comfort, this is a pack that can cover serious distance and haul heavy loads without leaving you drained when you hit camp.</p>	[empty string]	N	199.99	199.99	SM/MD,MD/LG	[empty string]	[empty string]	1000	ZULU 55	277122	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/zulu-55l-pack-3lb11oz-40-capacity-277122	1
3	RIVER	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	RIVER\|NULL\|NULL	0	249.99	0	249.99	[empty string]	249.99	[empty string]	WMS MAVEN 65L 3LB7OZ 50#CAPACITY	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	WOMENS	ACTIVE	ONLINE	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Maven 65 - Women`s	<p>A multi-day excursion in the mountains demands a light, nimble pack with plenty of support. The Maven 65 delivers with it`s breathable and adjustable Aerolon suspension.</p> <p> </p> <p>-Aerolon adjustable torso with Matrix breathable backpanel and gription lumbar pad<br /> -Women`s specific quick adjust hipbelts with large zippered pockets<br /> -Women`s specific die-cut dual density shoulder harness with sternum strap with hydration clip<br /> -Wishbone tubular aluminum frame and alloy anti-barreling cross-stay for stable load management and torsional flexibility<br /> -Raincover included with dedicated zippered pocket for added organization<br /> -Sunglass QuickStow system on shoulder harness for quick, secure and scratch-free access to your shades<br /> -Removable hydration sleeve converts into fast and light SideKick Daypack with shoulder harnesses and accessory pocket<br /> -Floating top pocket with two zippered compartments and an underside zippered pocket, reflective attachment points, and key clip<br /> -Dual side stretch mesh pockets, one with side trail access, with pass-through for over or under compression<br /> -Front oversized stretch mesh pocket with multiple webbing attachment points<br /> -Zippered bottom sleeping bag compartment with a removable divider that doubles as a lightweight top flap<br /> -Adjustable attachment loop and upper shock lock for trekking poles or an ice axe<br /> -Removable girth-hitched lower compression MultiStraps double as an accessory strap or hip belt for SideKick daypack<br /> -Custom comfort-grip molded zipper pulls and molded webbing keepers for strap management</p>	[empty string]	N	249.99	249.99	XS/SM	[empty string]	[empty string]	1000	MAVEN 65	277127	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/wms-maven-65l-3lb7oz-50-capacity-277127	1
4	TEAL	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	TEAL\|NULL\|NULL	0	199.99	0	199.99	[empty string]	199.99	[empty string]	WMS JADE 53L 3LB9OZ 40#CAPACITY	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	WOMENS	ACTIVE	ONLINE	[empty string]	[empty string]	4	150-to-200	0.00	[empty string]	Wms Jade 53l 3lb9oz 40#capacity	[empty string]	[empty string]	N	199.99	199.99	XS/SM,SM/MED	[empty string]	[empty string]	1000	JADE 53	277129	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/wms-jade-53l-3lb9oz-40-capacity-277129	1
5	DUSKBLU,ONYX	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	DUSKBLU\|NULL\|NULL,ONYX\|NULL\|NULL	0	299.99	0	299.99	[empty string]	299.99	[empty string]	MNS BALTORO 65 PACK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	MENS	ACTIVE	ONLINE	[empty string]	[empty string]	4	250-to-300	0.00	[empty string]	Baltoro 65 - Men`s	<p>The Baltoro 65 offers plenty of room for a long weekend, and if you`re gear savvy, enough space for an extra day or two. It`s terrain-adaptive Response A3 suspension makes it at home in off-the-beaten-path locales.</p> <p> </p> <p>-Response A3 Suspension with Auto Angle Adjust (A3) hipbelts and shoulder harnesses rotate to your unique body geometry for a custom fit<br /> -3D Air hipbelts and harness designed with Gregory`s precurved technology and multi-density LifeSpan EVA foam construction to eliminate hot spots and relieve pressure in sensitive areas<br /> -Wishbone aluminum frame with anti-barreling cross-stay provide structure for the Response A3 system and deliver weight to the ComfortGrip lumbar pad with removable LumbarTune pad to customize fit<br /> -Matrix breathable backpanel with layered, multi-density foam for the right balance of support, airflow and cushioning<br /> -Full body U-Zip main opening on front of bag for easy unloading when you get to camp<br /> -Custom fitted raincover included - stows in a quick access zippered pocket on underside of the top lid<br /> -Removable hydration sleeve converts into fast and light SideKick Daypack with shoulder harnesses and accessory pocket<br /> -H20 resistant WeatherShield hipbelt pocket with YKK AquaGuard&rgeg; zipper for quick access to your phone or camera<br /> -Sunglass QuickStow system on shoulder harness for quick, secure and scratch-free access to your shades<br /> -SideWinder bottle holster for one-handed on-the-go water bottle access - tucks away when not in use<br /> -Stretch mesh side stash pocket large enough for a second water bottle, trekking poles, sandals, snacks, etc<br /> -Dual front zippered organization pockets with heavy duty stretch mesh stash pocket<br /> -Double barrel top lid design with dual zippered pockets and a flexible center divider for larger items<br /> -Zippered bottom sleeping bag compartment with removable divider<br /> -Dual adjustable attachme	[empty string]	N	299.99	299.99	ONE SZ FITS ALL,MED	[empty string]	[empty string]	1000	BALTORO 65	296215	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/mns-baltoro-65-pack-296215	1
6	PLUMRED	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	PLUMRED\|NULL\|NULL	0	299.99	0	299.99	[empty string]	299.99	[empty string]	WMS DEVA 60 PACK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	WOMENS	ACTIVE	ONLINE	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	Deva 60 - Women'S	<p>For short and long weekends, the Deva 60 is just right. With enough room to sneak some vino for the campfire, the Response A3 suspension will easily haul some luxuries to camp to make all that hiking worth it.</p> <p> </p> <p>-Response A3 Suspension with Auto Angle Adjust (A3) hipbelts and shoulder harnesses rotate to your unique body geometry for a custom fit<br /> -Women's Specific 3D Air hipbelts and harness designed with Gregory's precurved technology and multi-density LifeSpan EVA foam construction to eliminate hot spots and relieve pressure in sensitive areas<br /> -Wishbone aluminum frame with anti-barreling cross-stay provide structure for the Response A3 system and deliver weight to the ComfortGrip lumbar pad with removable LumbarTune pad to customize fit<br /> -Matrix breathable backpanel with layered, multi-density foam for the right balance of support, airflow and cushioning<br /> -Full body U-Zip main opening on front of the bag for easy unloading when you get to camp<br /> -Custom fitted raincover included - stows in a quick access zippered pocket on underside of the top lid<br /> -Removable hydration sleeve converts into fast and light SideKick Daypack with shoulder harnesses and accessory pocket<br /> -H20 resistant WeatherShield hipbelt pocket with YKK AquaGuard® zipper for quick access to you phone or camera<br /> -Sunglass QuickStow system on shoulder harness for quick, secure and scratch-free access to your shades<br /> -SideWinder bottle holster for one-handed on-the-go water bottle access - tucks away when not in use<br /> -Stretch mesh side stash pocket large enough for a second water bottle, trekking poles, sandals, snacks, etc<br /> -Dual front zippered organization pockets with heavy duty stretch mesh stash pocket<br /> -Double barrel top lid design with dual zippered pockets and a flexible center divider for larger items<br /> -Zippered bottom sleeping bag compartment with removable divider<br /> -Dual adjustabl	[empty string]	N	299.99	299.99	SM,MD	[empty string]	[empty string]	1000	DEVA 60	296216	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/wms-deva-60-pack-296216	1
7	FIERY	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	FIERY\|NULL\|NULL	0	149.99	0	149.99	[empty string]	149.99	[empty string]	ZULU 30 DAYPACK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	BOTH	ACTIVE	NOT ONLINE	[empty string]	[empty string]	2	100-to-150	0.00	[empty string]	Zulu 30	<p>The smallest pack in the Zulu series stands tall with technology, making up for any loss in volume with the heat-taming prowess of CrossFlo ventilated suspension. While other packs get heavier as the day goes on, the Zulu 30 runs so cool and light that your post-lunch return route will feel as fast and fun as the first five miles.</p> <p> </p> <p>-Updated CrossFlo Suspension<br /> -Hybrid top loading panel access to main body<br /> -Zippered pockets on exterior and interior of hybrid panel access<br /> -Two external stretch water bottle pockets<br /> -Dual quick-access waist belt pockets<br /> -Trekking pole attachment points double as ice axe loops<br /> -Integrated rain cover<br /> -Interior security pocket with key clip<br /> -Sunglass stash on shoulder harness</p>	[empty string]	N	149.99	149.99	MD/LG	[empty string]	[empty string]	1000	ZULU 30	300954	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/zulu-30-daypack-300954	1
8	EGYPT/BLUE	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	EGYPT/BLUE\|NULL\|NULL	0	299.99	0	299.99	[empty string]	299.99	[empty string]	WMS DEVA 60 EGYPTION BLUE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2020	[empty string]	WOMENS	SO	[empty string]	[empty string]	[empty string]	1	250-to-300	0.00	[empty string]	Wms Deva 60 Egyption Blue	[empty string]	[empty string]	N	299.99	299.99	XS	[empty string]	[empty string]	1000	DEVA 60 XS	312889	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/wms-deva-60-egyption-blue-312889	1
9	BLACK	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	BLACK\|NULL\|NULL	0	219.99	0	219.99	[empty string]	219.99	[empty string]	TETRAD TRAVEL PACK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Tetrad Travel Pack	[empty string]	[empty string]	N	219.99	219.99	ONE SZ FITS ALL	[empty string]	[empty string]	1000	TETRAD 60	324310	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/tetrad-travel-pack-324310	1
10	GREY	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	GREY\|NULL\|NULL	0	219.99	0	219.99	[empty string]	219.99	[empty string]	TRIBUTE 55 TRAVEL PACK	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	BOTH	DISC	[empty string]	[empty string]	[empty string]	3	200-to-250	0.00	[empty string]	Tribute 55 Travel Pack	[empty string]	[empty string]	N	219.99	219.99	ONE SZ FITS ALL	[empty string]	[empty string]	1000	TRIBUTE 55	324311	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/tribute-55-travel-pack-324311	1
11	EMPIRE	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	EMPIRE\|NULL\|NULL	0	279.99	0	279.99	[empty string]	279.99	[empty string]	BACKPACKING PACK 65 LITRE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	3	250-to-300	0.00	[empty string]	Backpacking Pack 65 Litre	[empty string]	[empty string]	N	279.99	279.99	M/L,ONE SZ FITS ALL	[empty string]	[empty string]	1000	KATMAI 65	346077	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/backpacking-pack-65-litre-346077	1
12	RED	GREGORY	Gregory	HUNTING	Hunting>Hunting Packs>Packs	RED\|NULL\|NULL	0	279.99	0	279.99	[empty string]	279.99	[empty string]	BACKPACKING PACK 60 LITRE	N	4 JENNIFER	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	STACCATO	[empty string]	[empty string]	SPRING	[empty string]	2021	[empty string]	MENS	ACTIVE	[empty string]	[empty string]	[empty string]	2	250-to-300	0.00	[empty string]	Backpacking Pack 60 Litre	[empty string]	[empty string]	N	279.99	279.99	XS/SM,SM/MD	[empty string]	[empty string]	1000	KALMIA 60	346078	PACKS	EMPTY	EMPTY	0	0	0	PACKS AND BAGS	[empty string]	gregory/backpacking-pack-60-litre-346078	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter