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]	EUREKA	Eureka	CAMPING	Camping>Tents>Backpack Tents	[empty string]	1	219.99	0	219.99	94224-DEFAULT-l.jpg	219.99	94224-DEFAULT-m.jpg	TIMBERLINE 2 TENT	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	PROP 65	[empty string]	[empty string]	7	200-to-250	0.00	[empty string]	Timberline 2 - 2 Person	<p>Meet our legendary A-frame tent, the Timberline 2. As the first double-wall tent, this two person tent combines a breathable inner body with a waterproof rainfly with clips that make set-up a breeze.</p> <p> </p> <ul> <li>5-pole A-frame tent</li> <li>1/2 inch Aluminum frame</li> <li>Twin-track side opening door</li> <li>Shock-corded eaves increase stability and absorb wind stress</li> <li>Hooded fly front and rear allows windows to remain partially open during rain for ventilation</li> <li>Large rear window and areas of uncoated fabric maximize air flow</li> </ul>	[empty string]	N	219.99	219.99	[empty string]	94224-DEFAULT-s.jpg	[empty string]	1000	2627700	34420	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/timberline-2-tent-34420	1
2	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Dome Tents	[empty string]	1	139.99	0	139.99	94232-DEFAULT-l.jpg	139.99	94232-DEFAULT-m.jpg	TETRAGON NX4 DOME TENT	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	100-to-150	0.00	[empty string]	Tetragon Nx4 Dome Tent	<p>A perfect choice for casual car campers, the Tetragon NX offers a durable frame that sets up easily, combined with smart design features – like the hooded rain fly and large door – to keep you dry and comfortable on every camping trip.</p> <p> </p> <ul> <li>Hooded rain fly design and mesh windows provide cooling ventilation.</li> <li>Easy-to-pitch, familiar classic dome design allows for quick setup and pack out.</li> <li>Quality materials, design features and construction ensure years of trouble-free use.</li> <li>Fiberglass poles make set up easy.</li> </ul>	[empty string]	N	139.99	139.99	[empty string]	94232-DEFAULT-s.jpg	[empty string]	1000	2629153	262929	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/tetragon-nx4-dome-tent-262929	1
3	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Dome Tents	[empty string]	1	199.99	0	199.99	94233-DEFAULT-l.jpg	199.99	94233-DEFAULT-m.jpg	TETRAGON NX5 DOME TENT	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]	4	150-to-200	0.00	[empty string]	Tetragon Nx5 Dome Tent	<p>A perfect choice for casual car campers, the Tetragon NX offers a durable frame that sets up easily, combined with smart design features – like the hooded rain fly and large door – to keep you dry and comfortable on every camping trip.</p> <p> </p> <ul> <li>Hooded rain fly design and mesh windows provide cooling ventilation.</li> <li>Easy-to-pitch, familiar classic dome design allows for quick setup and pack out.</li> <li>Quality materials, design features and construction ensure years of trouble-free use.</li> <li>Fiberglass poles make set up easy.</li> </ul>	[empty string]	N	199.99	199.99	[empty string]	94233-DEFAULT-s.jpg	[empty string]	1000	2629163	262930	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/tetragon-nx5-dome-tent-262930	1
4	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Backpack Tents	[empty string]	0	229.99	0	229.99	[empty string]	229.99	[empty string]	MIDORI 3 BACKPACKING TENT	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	NOT ONLINE	[empty string]	[empty string]	1	200-to-250	0.00	[empty string]	Midori 3 Backpacking Tent	[empty string]	[empty string]	N	229.99	229.99	[empty string]	[empty string]	[empty string]	1000	2629086	300402	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/midori-3-backpacking-tent-300402	1
5	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Backpack Tents	[empty string]	1	154.99	0	154.99	94234-DEFAULT-l.jpg	154.99	94234-DEFAULT-m.jpg	SUMA 2	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	150-to-200	0.00	[empty string]	Suma 2	<p>The budget-friendly Suma 2 is Eureka!'s lightest backcountry tent, making it a perfect companion for long backpacking trips. Eureka!'s stripped-down, minimalist, one-door design sets up lightning fast, so you can hit the hay mere minutes after arriving at your campsite.</p> <p> </p> <ul> <li>Gear Loft</li> <li>3 pockets</li> </ul>	[empty string]	N	154.99	154.99	[empty string]	94234-DEFAULT-s.jpg	[empty string]	1000	2629069	300403	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/suma-2-300403	1
6	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Backpack Tents	[empty string]	1	179.99	0	179.99	94235-DEFAULT-l.jpg	179.99	94235-DEFAULT-m.jpg	SUMA 3	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	PROP 65	[empty string]	[empty string]	3	150-to-200	0.00	[empty string]	Suma 3 - 3 Person	<p>The budget-friendly Suma 3 three-person tent is Eureka!'s lightest backcountry tent, making it a perfect companion for long backpacking trips. Eureka!'s stripped-down, minimalist, one-door design sets up lightning fast, so you can hit the hay mere minutes after arriving at your campsite.</p> <p> </p> <ul> <li>Gear Loft</li> <li>3 pockets</li> </ul>	[empty string]	N	179.99	179.99	[empty string]	94235-DEFAULT-s.jpg	[empty string]	1000	2629072	300404	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/suma-3-300404	1
7	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Backpack Tents	[empty string]	0	389.99	0	389.99	[empty string]	389.99	[empty string]	MOUNTAIN PASS 3 PERSON 4 SEASON	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	NOT ONLINE	[empty string]	[empty string]	4	350-to-400	0.00	[empty string]	Mountain Pass 3 Person 4 Season	[empty string]	[empty string]	N	389.99	389.99	[empty string]	[empty string]	[empty string]	1000	2629104	300425	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/mountain-pass-3-person-4-season-300425	1
8	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Dome Tents	[empty string]	1	364.99	0	364.99	94236-DEFAULT-l.jpg	364.99	94236-DEFAULT-m.jpg	SPACE CAMP 4 TENT	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	NOT ONLINE	[empty string]	[empty string]	1	350-to-400	0.00	[empty string]	Jade Canyon 4 - 4 Person	<p>The Space Camp 4 four-person, three-season tent offers out-of-this-world comfort for families through generous height and a large footprint. Eureka!'s Air Exchange System with High/Low Venting is completely adjustable, helping you find the right airflow for all weather conditions.</p> <p> </p> <ul> <li>Generous height and large footprint, this three-season tent offers out-of-this-world comfort for families</li> <li>Eureka!'s Air Exchange System with High/Low Venting is completely adjustable, helping you find the right airflow for all weather conditions</li> <li>Two large doors and vestibules keep the tent entrances dry, while adding extra storage space for gear</li> <li>Outlast any storm with the durable, rugged 7000 Series aluminum frame</li> <li>10 Pockets</li> <li>Comfort</li> </ul>	[empty string]	N	364.99	364.99	[empty string]	94236-DEFAULT-s.jpg	[empty string]	1000	2629112	314649	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/space-camp-4-tent-314649	1
9	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Backpack Tents	[empty string]	1	144.99	0	144.99	94237-DEFAULT-l.jpg	144.99	94237-DEFAULT-m.jpg	MIDORI 1 BACKPACKING TENT	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	PROP 65	[empty string]	[empty string]	3	100-to-150	0.00	[empty string]	Midori 1 Backpacking Tent	<p>Perfect for comfortable trips on the trail, the Midori’s design maximizes space with easy functionality. Whether you’re solo or camping with a partner, comfort and space are the name of the game.</p> <p> </p> <ul> <li>Increased headroom maximizes livable space for comfortable trips on the trail.</li> <li>High/Low Vent - Air Exchange System offers adjustable ventilation options for all weather conditions.</li> <li>A strong aluminum frame and durable fabrics offer miles of dependable performance no matter where you're headed.</li> </ul>	[empty string]	N	144.99	144.99	[empty string]	94237-DEFAULT-s.jpg	[empty string]	1000	2629084	314650	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/midori-1-backpacking-tent-314650	1
10	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Tent Accessories	[empty string]	1	54.99	0	54.99	94238-DEFAULT-l.jpg	54.99	94238-DEFAULT-m.jpg	FOOTPRINT SPACE CAMP 4	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	NOT ONLINE	[empty string]	[empty string]	2	50-to-100	0.00	[empty string]	Jade Canyon 4 - 4 Person	<p>Protect the floor of your Eureka! Space Camp 4 tent against rocks, roots, and dampness with this Space Camp 4 Footprint. Constructed of heavily coated nylon fabric with a custom-cut shape, the footprint fits the Space Camp 4 perfectly.</p> <p> </p> <ul> <li>Constructed of waterproof polyester fabric</li> <li>Adjustable stake out loops</li> <li>Custom-cut shape, guaranteeing a perfect fit every time</li> <li>Fits Space Camp 4 tent model</li> </ul>	[empty string]	N	54.99	54.99	[empty string]	94238-DEFAULT-s.jpg	[empty string]	1000	2660198	314653	TENT ACCESSORIES	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/footprint-space-camp-4-314653	1
11	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Dome Tents	[empty string]	1	259.99	0	259.99	94240-DEFAULT-l.jpg	259.99	94240-DEFAULT-m.jpg	COPPER CANYON LX4	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]	6	250-to-300	0.00	[empty string]	Copper Canyon Lx4	<p>The Copper Canyon’s easy setup, smart features, and full standing height make it Eureka’s most livable family car camping tent.</p> <p> </p> <ul> <li>Durable, steel and fiberglass frame features pole sleeves corner hubs, and quick clips for simple 1 person set up</li> <li>Near-vertical walls create lots of standing room and are ideal when camping with air mattress and cots</li> <li>Large mesh windows with waterproof curtains offer scenic views and plenty of ventilation</li> <li>Extended fly coverage over the door provides extra weather protection and dry entryway</li> <li>The zippered E! Powerport lets you easily run an extension cord inside so you can keep everyone’s gadgets charged</li> <li>There are plenty of stash pockets and a gear loft to help keep things organized</li> </ul>	[empty string]	N	259.99	259.99	[empty string]	94240-DEFAULT-s.jpg	[empty string]	1000	2601298	325970	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/copper-canyon-lx4-325970	1
12	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Dome Tents	[empty string]	1	314.99	0	314.99	94241-DEFAULT-l.jpg	314.99	94241-DEFAULT-m.jpg	COPPER CANYON LX6	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]	2	300-to-350	0.00	[empty string]	Copper Canyon Lx6	<p>The Copper Canyon’s easy setup, smart features, and full standing height make it Eureka’s most livable family car camping tent.</p> <p> </p> <ul> <li>Durable, steel and fiberglass frame features pole sleeves corner hubs, and quick clips for simple 1 person set up</li> <li>Near-vertical walls create lots of standing room and are ideal when camping with air mattress and cots</li> <li>Large mesh windows with waterproof curtains offer scenic views and plenty of ventilation</li> <li>Extended fly coverage over the door provides extra weather protection and dry entryway</li> <li>The zippered E! Powerport lets you easily run an extension cord inside so you can keep everyone’s gadgets charged</li> <li>There are plenty of stash pockets and a gear loft to help keep things organized</li> </ul>	[empty string]	N	314.99	314.99	[empty string]	94241-DEFAULT-s.jpg	[empty string]	1000	2601303	325971	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/copper-canyon-lx6-325971	1
13	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Tent Accessories	[empty string]	1	34.99	0	34.99	94245-DEFAULT-l.jpg	34.99	94245-DEFAULT-m.jpg	FOOTPRINT 1 PERSON	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]	3	25-to-50	0.00	[empty string]	Footprint 1 Person	<p>Shaped to fit one-person tents with non-standard footprints, Eureka!'s footprints are constructed with the same material as the tent's floor—fitted footprints, helping to extend the life of the tent floor and protect it from punctures and wear-and-tear.</p> <p> </p> <ul> <li>Constructed of waterproof polyester fabric</li> <li>Adjustable stake out loops</li> <li>Custom-cut shape, guaranteeing a perfect fit every time</li> <li>Fits Midori 1, Solitaire AL and Solitarire FG tent models</li> </ul>	[empty string]	N	34.99	34.99	[empty string]	94245-DEFAULT-s.jpg	[empty string]	1000	2660205	326006	TENT ACCESSORIES	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/footprint-1-person-326006	1
14	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Tent Accessories	[empty string]	1	39.99	0	39.99	94246-DEFAULT-l.jpg	39.99	94246-DEFAULT-m.jpg	FOOTPRINT 2 PERSON	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]	8	25-to-50	0.00	[empty string]	Footprint 2 Person	<p>Shaped to fit two-person tents with non-standard footprints, Eureka!'s footprints are constructed with the same material as the tent's floor—fitted footprints, helping to extend the life of the tent floor and protect it from punctures and wear-and-tear.</p> <p> </p> <ul> <li>Constructed of waterproof polyester fabric</li> <li>Adjustable stake out loops</li> <li>Custom-cut shape, guaranteeing a perfect fit every time</li> <li>Fits Suma 2 and Midori 2 tent models</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	94246-DEFAULT-s.jpg	[empty string]	1000	2660207	326007	TENT ACCESSORIES	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/footprint-2-person-326007	1
15	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Backpack Tents	[empty string]	1	189.99	0	189.99	94247-DEFAULT-l.jpg	189.99	94247-DEFAULT-m.jpg	MIDORI 2 BACKPACKING TENT	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]	3	150-to-200	0.00	[empty string]	Midori 2 Backpacking Tent	<p>Perfect for comfortable trips on the trail, the Midori’s design maximizes space with easy functionality. Whether you’re solo or camping with a partner, comfort and space are the name of the game.</p> <p> </p> <ul> <li>Increased headroom maximizes livable space for comfortable trips on the trail.</li> <li>High/Low Vent - Air Exchange System offers adjustable ventilation options for all weather conditions.</li> <li>A strong aluminum frame and durable fabrics offer miles of dependable performance no matter where you're headed.</li> </ul>	[empty string]	N	189.99	189.99	[empty string]	94247-DEFAULT-s.jpg	[empty string]	1000	2629085	341283	EMPTY	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/midori-2-backpacking-tent-341283	1
16	[empty string]	EUREKA	Eureka	CAMPING	Camping>Tents>Tent Accessories	[empty string]	1	54.99	0	54.99	94252-DEFAULT-l.jpg	54.99	94252-DEFAULT-m.jpg	FOOTPRINT KOHANA 4 TENT	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]	3	50-to-100	0.00	[empty string]	Footprint Kohana 4 Tent	<p>Shaped to fit Eureka's Kohana tent and made of the same material as the tent’s floor. Protect from punctures from sneaky roots and rocks, or any wear-and-tear over time. Webbing stake-out loops and grommet attachments makes use sturdy and easy.</p> <p> </p> <ul> <li>Constructed of waterproof polyester fabric to stand up to wet or uneven ground</li> <li>Adjustable stake out loops for easy setup</li> <li>Custom-cut shape guarantees a perfect fit every time</li> <li>Fit specifically to Kohana tent model</li> </ul>	[empty string]	N	54.99	54.99	[empty string]	94252-DEFAULT-s.jpg	[empty string]	1000	2660213	350694	TENT ACCESSORIES	EMPTY	EMPTY	0	0	0	TENTS	[empty string]	eureka/footprint-kohana-4-tent-350694	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Filter