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]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	19.99	0	19.99	104272-DEFAULT-l.jpg	19.99	104272-DEFAULT-m.jpg	LIGHT `N SOUND LANTERN	N	10 MALLORY	[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]	8	15-to-20	0.00	[empty string]	Light & Sound Lantern	<table style="width:371px"> <tbody> <tr> <td> <p><strong>This durable lantern is perfect for indoor and outdoor play.</strong> Turn the knob and listen to wildlife sounds and light up the room or tent. Handy carrying handle means the perfect toy for kids on the go. Great for all ages and arrives in a color box. Great for gift giving. Batteries included.</p> </td> </tr> </tbody> </table> <table style="width:371px"> <tbody> <tr> <td> <ul> <li>Features on/off switch</li> </ul> </td> </tr> <tr> <td> <ul> <li>Includes nature sound effects</li> </ul> </td> </tr> <tr> <td> <ul> <li>Soft glow light for indoors and outside</li> </ul> </td> </tr> <tr> <td> <ul> <li>Handy carrying handle</li> </ul> </td> </tr> <tr> <td> <ul> <li>Color box, batteries included, box is 8"w x 7.5" h x 4.5" d</li> </ul> </td> </tr> </tbody> </table>	[empty string]	N	19.99	19.99	[empty string]	104272-DEFAULT-s.jpg	[empty string]	1000	NB523	337697	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/light-sound-lantern-337697	1
2	[empty string]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	29.99	0	29.99	104253-DEFAULT-l.jpg	29.99	104253-DEFAULT-m.jpg	METAL DETECTOR	N	10 MALLORY	[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]	5	25-to-50	0.00	[empty string]	Metal Detector for Kids	<ul> <li>KIDS CAN FIND BURIED TREASURE - Detects metal objects such as coins, jewelry, or other types of hidden treasure</li> <li>LIGHTS AND SOUNDS - LED flashing lights and beeping tones when objects are found</li> <li>ADJUSTABLE HANDLE - Use as a handheld device or extend to 29” long. Great for beach, lake, or backyard treasure hunting. Breaks down into three pieces for easy travel</li> <li>ADJUSTABLE SENSITIVITY - Turn up the sensitivity for small treasure. Turn down the sensitivity for larger treasure. Helps eliminate false detection</li> <li>LIGHTWEIGHT - Great for boys or girls as a gift or school project.</li> </ul>	[empty string]	N	29.99	29.99	[empty string]	104253-DEFAULT-s.jpg	[empty string]	1000	NB532	337701	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/metal-detector-for-kids-337701	1
3	[empty string]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	12.99	0	12.99	104255-DEFAULT-l.jpg	12.99	104255-DEFAULT-m.jpg	CRITTER CAGE	N	10 MALLORY	[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]	Critter Cage	<p>Kids will get outside and explore nature with this fun insect activity kit. It's easy to open the swinging door and insert leaves, sticks, food, and water while studying insects or small reptiles. Gentle enough for small bugs, tough enough for active kids. We have even included an activity booklet to make learning fun and easy. A perfect gift idea or use it in the classroom. A favorite of kids and teachers alike this habitat has a sturdy base to prevent tipping over. No batteries required.</p> <ul> <li>SAFE OBSERVATION OF INSECTS: Sturdy construction with fabric mesh and carrying handle.</li> <li>INCLUDES BONUS BOOKLET: Our exclusive field guide means kids learn while they have fun.</li> <li>EASY OPEN HATCH: Hinged door makes it easy to insert insects, leaves, water, and food.</li> <li>PORTABLE SIZE: 8.5 x 5.75 x 8 inches means it's great for home or classroom use. A STEM toy!</li> <li>GREAT GIFT: A perfect gift or for classroom use. Ages 4 </li> </ul>	[empty string]	N	12.99	12.99	[empty string]	104255-DEFAULT-s.jpg	[empty string]	1000	NB537	337704	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/critter-cage-337704	1
4	[empty string]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	19.99	0	19.99	104245-DEFAULT-l.jpg	19.99	104245-DEFAULT-m.jpg	ROCK AND GEM DIG SET	N	10 MALLORY	[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	15-to-20	0.00	[empty string]	Discovery Rock & Gem Dig Set	<p> </p> <ul> <li>A complete rock dig that makes exploring and collecting fun.</li> <li>Dig using the included tools to find the buried gemstones, minerals and rocks.</li> <li>Includes Clipboard, write & wipe checklist, activity booklets and tray.</li> <li>Packaged in a color box so it's great for gift giving,</li> </ul> <p>Explore the fascinating world of geology and collect rare gemstones! This kit has everything you need to dig, explore, study, and collect. Each digging block includes 10 collectible stones. Learn about the stones as you see how many You can collect. Includes digging block with tray, digging tools, brush, collector box with labels, activity booklets, and write & wipe chart. Perfect for any home or classroom. </p>	[empty string]	N	19.99	19.99	[empty string]	104245-DEFAULT-s.jpg	[empty string]	1000	BF578	340443	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/discovery-rock-gem-dig-set-340443	1
5	[empty string]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	29.99	0	29.99	104247-DEFAULT-l.jpg	29.99	104247-DEFAULT-m.jpg	WALKIE TALKIES SET	N	10 MALLORY	[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]	4	25-to-50	0.00	[empty string]	Walkie Talkies for Kids	<ul> <li>GREAT FIRST WALKIE TALKIES FOR KIDS: Durable and easy to use</li> <li>LOTS OF GREAT FEATURES: Each walkie talkie includes 9 channel function, an LED flashlight, and a belt clip</li> <li>LONG DISTANCE: Up to 2 miles in an open area, more than .5 miles in urban areas.</li> <li>BEST TOY FOR GIRLS AND BOYS ALIKE: Kids love to play inside and outside. 462 mhz with 8 channels</li> </ul> <p>One of the most wished for gifts for kids are walkie talkies. These Nature Bound Walkie Talkies are loaded with must have features. Plus, we back them up with an unconditional warranty. Get kids up, outside, and off the couch with our best selling walkie talkie set!</p> <p><br /> -462 mhz and over 2 mile range in an open field (less in crowded neighborhood or buildings)<br /> -8 channels means kids can safely play anywhere without interference<br /> -Handy belt clip is great for kids while they explore on the go<br /> -Packaged in a nice color box so they are perfect for gift giving<br /> -Built in LED flashlight for exploring at night<br /> -6 x "AAA" batteries required, not included<br /> -Recommended for boys and girls ages 5</p>	[empty string]	N	29.99	29.99	[empty string]	104247-DEFAULT-s.jpg	[empty string]	1000	NB596	342032	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/walkie-talkies-for-kids-342032	1
6	[empty string]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	35.99	0	35.99	104271-DEFAULT-l.jpg	35.99	104271-DEFAULT-m.jpg	HUNTING BLIND TENT	N	10 MALLORY	[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]	6	25-to-50	0.00	[empty string]	Hunting Blind Pop Up Tent	<ul> <li>Big Tent: opens to 32" L x 32" W x 33. 5" H</li> <li>Easy set up: Simply pop it open, no tools necessary</li> <li>Includes: Army Tent/ pop up hunting Tent includes carry bag with zipper</li> <li>Indoor/outdoor: Made of high quality 190T water resistant polyester</li> <li>Playhouse: easy pop-up hunting blind is the newest innovation in kid tents. Great gift idea for kids 5 +</li> </ul> <p>The perfect tent for indoor or outdoor play. Kids of all a Ages will have fun camping in the backyard, camping in the living room, or taking the tent on a real campout or hunt. Instant assembly. Simply pop open the tent – no tools required. This 32 inch by 32 inch by 35. 5 inch Hunting blind (army style) tent features door, and spy window for ventilation. It is made of tough 190T polyester for years of fun. Cool Camouflage design with be-safe orange trim. Packaged in colourful storage zipper bag. Great for boys and girls ages 5 </p>	[empty string]	N	35.99	35.99	[empty string]	104271-DEFAULT-s.jpg	[empty string]	1000	NB541	357878	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/hunting-blind-pop-up-tent-357878	1
7	[empty string]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	39.99	0	39.99	104248-DEFAULT-l.jpg	39.99	104248-DEFAULT-m.jpg	DOME TENT	N	10 MALLORY	[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]	6	25-to-50	0.00	[empty string]	2-Person Kids Tent	<ul> <li>Indoor/outdoor tent: large 2 person kids Tent 47 inches long x 47 inches wide x 35 inches high</li> <li>Quick and easy set up: simple assembly makes set up a snap</li> <li>Durable: made of tough 190T polyester and fiberglass poles</li> <li>Features: open/close door, air vents, window, durable, and draw string storage bag</li> <li>Many uses: a great gift for kids who want to have a backyard adventure inside or outside. Packaged in colorful box. Ages 6 +</li> </ul> <p>The perfect tent for indoor or outdoor play. Kids of all a ages will have fun camping in the backyard, camping in the living room, or taking the tent on a real campout. Super easy assembly. Simply insert the fiberglass rods into the tent and it’s up in a snap. This 47 inch by 47 inch by 35 inch dome tent feature ventilated dome, rear window, door, and spy holes. It is made of tough 190T polyester for years of fun. Cool camouflage design with be-safe orange trim. Great for boys and girls ages 6 +<br /> -Nature Bound makes great kid tents<br /> -This is a great indoor kids tent or outdoor kids tent</p>	[empty string]	N	39.99	39.99	[empty string]	104248-DEFAULT-s.jpg	[empty string]	1000	NB540	357879	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/2-person-kids-tent-357879	1
8	[empty string]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	14.99	0	14.99	104270-DEFAULT-l.jpg	14.99	104270-DEFAULT-m.jpg	BUG CATCHER AND VIEWER	N	10 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2022	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	10-to-15	0.00	[empty string]	Bug Catcher & Viewer	<p>Kids will enjoy hours of play with the Nature Bound Bug Catcher & Viewer. Simply pull the trigger and the spring loaded capture core opens wide. Place over a bug or small critter and release the trigger to close the habitat. Now kids can study the insect and learn about the wonders of nature. When done, simply squeeze the trigger to release the bug back into nature. A safe way for kids to catch, study, and release insects or other little critters. Encourages learning while they play. Recommended for ages 3+, no batteries required. Packaged in a colorful window box so it is a great gift idea.</p> <ul> <li>NATURE EXPLORATION TOY - The bug catcher will encourage kids to explore the world around them</li> <li>EASY TO USE - Perfectly designed for kids ages 3+. Simply squeeze the trigger to open and close</li> <li>SAFE CATCH AND RELEASE - Kids don't have to touch the bugs. Simply catch, study, and release</li> <li>STEM TOY - A great way to get kids interested in science and nature. No batteries required.</li> <li>SAFE - Made of durable plastic, not glass</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	104270-DEFAULT-s.jpg	[empty string]	1000	NB520	373563	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/bug-catcher-viewer-373563	1
9	[empty string]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	59.99	0	59.99	104240-DEFAULT-l.jpg	59.99	104240-DEFAULT-m.jpg	ROCK TUMBLER KIT FOR KIDS	N	10 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	50-to-100	0.00	[empty string]	Rock Tumbler Kit for Kids	<p>- <strong>FAST</strong> – Our unique design means a faster gemstone polishing experience. Polish beautiful stones in half the time </p> <p>- <strong>COMPLETE KIT</strong> – Everything the young rock hound needs including rock tumbler, power chord, 3 types of unpolished gemstones, polishing powder, and jewelry settings.</p> <p>- <strong>NO LEAK</strong> – Our rock tumbler securely fastens and does not leak like so many others</p> <p>- <strong>EASY TO USE</strong> – All ages and skill levels can get started quickly and easily.</p> <p>- <strong>100% SATISFACTION GUARANTEE</strong> – We stand behind all of our rock tumblers with a manufacturer’s warranty</p> <p><strong>BEST ROCK TUMBLER FOR KIDS</strong></p> <p>Our advanced design means rock tumbling doesn’t take weeks anymore. Now you can turn rough stones into beautifully polished gemstones. Simply open the container, add your rocks, and press a button. The high quality rock tumbler does the rest. Great gift idea or use as a classroom teachers project. </p> <p><strong>COMPLETE GEOLOGY SCIENCE KIT INCLUDES</strong></p> <p>-High-quality state of the art rock tumbler with built in timers and sound cover</p> <p>-Leak proof tumbler barrel with our exclusive polishing liner</p> <p>-Over ½ pound of beautiful collector stones, 3 bags of rough stones including amethyst, jasper, and agates</p> <p>-2 ring fasteners. Polish your gemstones and glue them on a ring for fashion jewelry</p> <p>-Simple instruction</p>	[empty string]	N	59.99	59.99	[empty string]	104240-DEFAULT-s.jpg	[empty string]	1000	NB527	382542	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/rock-tumbler-kit-for-kids-382542	1
10	[empty string]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	14.99	0	14.99	104242-DEFAULT-l.jpg	14.99	104242-DEFAULT-m.jpg	PARROT BINOCULARS	N	10 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	10-to-15	0.00	[empty string]	Binoculars for Kids - Parrot Shap	<ul> <li><strong>SPECIAL BINOCULARS DESIGNED FOR CHILDREN</strong>: Kid-sized binoculars are easy focus and feature comfy eyepieces. Built kid tough and designed to last for years. The perfect 7x35 power lenses designed for little kids ages 3+</li> <li><strong>EDUCATIONAL & FUN</strong>: An innovative STEM toy introduces toddlers and preschoolers to the joys of exploring nature. View and explore</li> <li><strong>BEST GIFT FOR TODDLERS & PRESCHOOLERS</strong>: The perfect birthday present, holiday gift, Christmas, Hanukkah, or as a party favor. These fine binoculars will get kids excited. Packaged in a colorful gift box so you'll be proud of your gift</li> <li><strong>OUTDOOR & INDOOR PLAY</strong>: Get kids off the couch and into nature. Explore the world, the park, or the backyard. Great for bird watching or pretend play</li> <li><strong>KIDS BINOCULARS MADE FOR CHILDREN</strong>: Fun airplane design - kid binoculars with breakaway neck strap are great for toddlers or young children. Great for camping, hiking, the beach, or anywhere kids play</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	104242-DEFAULT-s.jpg	[empty string]	1000	NB598	382543	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/binoculars-for-kids-parrot-shap-382543	1
11	[empty string]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	34.99	0	34.99	104249-DEFAULT-l.jpg	34.99	104249-DEFAULT-m.jpg	TODDLER 12 PC TOOL SET	N	10 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	6	25-to-50	0.00	[empty string]	Toddler 12 PC Tool Set	<ul> <li><strong>TODDLER-SAFE TOOLS</strong>: Encourages little kids to have fun while they learn. Action motorized drill is safe for little ones</li> <li><strong>DURABLE:</strong> This little kids tool set is Made of high quality plastic materials to last years</li> <li><strong>COMPLETE PLAY TOOL SET:</strong> Includes safe motorized drill, wrench, 2 drill attachments, screwdriver, hammer, saw, 4 sets of nuts and bolts, and it packs into the handy toolbox</li> <li><strong>SO REAL, SO FUN:</strong> The safe motorized drill runs forward and reverse. The wrench, drill, and screwdriver match the included nuts and bolts. Kids will love the pretend play of fixing things around the house while learning</li> </ul>	[empty string]	N	34.99	34.99	[empty string]	104249-DEFAULT-s.jpg	[empty string]	1000	P550	382545	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/toddler-12-pc-tool-set-382545	1
12	[empty string]	THIN AIR	Thin Air	HOME AND CABIN	Home and Cabin>Toys	[empty string]	1	39.99	0	39.99	104251-DEFAULT-l.jpg	39.99	104251-DEFAULT-m.jpg	MINI PLAY GOLF GAME	N	10 MALLORY	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	2023	[empty string]	[empty string]	ACTIVE	[empty string]	[empty string]	[empty string]	4	25-to-50	0.00	[empty string]	Mini Play Golf Game	<ul> <li>Kids Have a Blast as They Learn: Ready to introduce your little duffer to the great game of golf? Check out this toddler golf set, designed to turn kid-pleasing fun into a genuine learning experience.</li> <li>Even Tee-Up Is Extra Fun: You’ll love the cool way this mini golf set sets up the ball for tee-off. Your child simply presses down the lever & the mechanical arm feeds the balls right to the tee.</li> <li>Ideal for Righties: Why bother with toddler golf clubs that won’t accommodate all boys & girls? Our adjustable golf club comes with 3 different clubheads for righthand play.</li> <li>20 Golf Balls Just for Tots: Golf for kids should be carefully customized to children’s skills & abilities. That’s why this set provides child-size golf balls, perfect for toddlers & preschoolers.</li> <li>Safe for Ages 3 & Up</li> </ul>	[empty string]	N	39.99	39.99	[empty string]	104251-DEFAULT-s.jpg	[empty string]	1000	P553	382546	EMPTY	EMPTY	EMPTY	0	0	0	TOYS	[empty string]	thin-air/mini-play-golf-game-382546	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter