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]	STAR BRITE	Star Brite	FISHING	Fishing>Marine>Boat Maintenance	[empty string]	1	10.99	0	10.99	90787-DEFAULT-l.jpg	10.99	90787-DEFAULT-m.jpg	STAR BRITE SILICONE SEALANT CLEAR	N	7 BRYAN	[empty string]	[empty string]	[empty string]	MARINE	[empty string]	[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]	17	10-to-15	0.00	[empty string]	Marine Silicone Sealant Clear	<p>Marine Silicone Sealant is true 100% marine grade silicone to provide a durable, waterproof seal that will not crack, shrink or turn yellow. Retains flexibility for excellent adhesion to fiberglass, wood, glass, metal and some plastics. It is easy to apply and equally easy to remove when desired.</p> <p> </p> <ul> <li>Bonds to fiberglass, wood, glass, metal and some plastics; can be used above and below the waterline.</li> <li>Provides waterproof, airtight bond, but can be easily removed; ideal for mounting deck hardware.</li> <li>Not affected by sunlight, weathering, most chemicals or solvents.</li> <li>Dries tack-free in less than one hour, cures completely in 24 hours.</li> <li>Color: Clear </li> <li>Size: 2.8OZ</li> </ul>	[empty string]	N	10.99	10.99	[empty string]	90787-DEFAULT-s.jpg	[empty string]	1000	74-82102	3985	EMPTY	EMPTY	EMPTY	0	0	0	MARINE	[empty string]	star-brite/marine-silicone-sealant-clear-3985	1
2	[empty string]	STAR BRITE	Star Brite	FISHING	Fishing>Marine>Boat Maintenance	[empty string]	1	14.99	0	14.99	103951-DEFAULT-l.jpg	14.99	103951-DEFAULT-m.jpg	STAR BRITE SILICONE SEALANT CLEAR 300 ML	N	7 BRYAN	[empty string]	[empty string]	[empty string]	MARINE	[empty string]	[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]	10	10-to-15	0.00	[empty string]	Marine Silicone Sealant Clear	<p>Marine Silicone Sealant is true 100% marine grade silicone to provide a durable, waterproof seal that will not crack, shrink or turn yellow. Retains flexibility for excellent adhesion to fiberglass, wood, glass, metal and some plastics. It is easy to apply and equally easy to remove when desired.</p> <p> </p> <ul> <li>Bonds to fiberglass, wood, glass, metal and some plastics; can be used above and below the waterline.</li> <li>Provides waterproof, airtight bond, but can be easily removed; ideal for mounting deck hardware.</li> <li>Not affected by sunlight, weathering, most chemicals or solvents.</li> <li>Dries tack-free in less than one hour, cures completely in 24 hours</li> <li>Color: Clear</li> <li>Size: 10.1 OZ</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	103951-DEFAULT-s.jpg	[empty string]	1000	74-82122	3987	EMPTY	EMPTY	EMPTY	0	0	0	MARINE	[empty string]	star-brite/marine-silicone-sealant-clear-3987	1
3	[empty string]	STAR BRITE	Star Brite	FISHING	Fishing>Marine>Boat Maintenance	[empty string]	1	17.99	0	17.99	91309-DEFAULT-l.jpg	17.99	91309-DEFAULT-m.jpg	STAR BRITE MILDEW/STAIN REMOVER	N	7 BRYAN	[empty string]	[empty string]	[empty string]	MARINE	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]	12	15-to-20	0.00	[empty string]	Mildew Stain Remover	<p>Mildew Stain Remover quickly removes unsightly mildew stains from fiberglass, vinyl, plastic or painted surfaces. It begins working on contact. The special buffered-bleach formula will not harm vinyl upholstery or threads. It is a much better alternative to using regular laundry "bleach-water" solutions, and can also be used around the home or in RVs wherever mildew stains are a problem.</p> <p> </p> <ul> <li>Removes mildew stains on contact without heavy scrubbing.</li> <li>Simple to use; spray on, scrub lightly and rinse off stains.</li> <li>Safe for use on fiberglass, painted surfaces, rubber, plastic and vinyl headliners, bolsters and upholstery.</li> <li>Special buffered formula will not harm vinyl upholstery or thread.</li> <li>Ideal for home or RV use, too.</li> <li>Does not weaken fabric or thread.</li> <li>Formulated specifically for use on marine upholstery; will not harm vinyl or stitching</li> <li>Size: 22 OZ</li> </ul>	[empty string]	N	17.99	17.99	[empty string]	91309-DEFAULT-s.jpg	[empty string]	1000	74-85616	3997	EMPTY	EMPTY	EMPTY	0	0	0	MARINE	[empty string]	star-brite/mildew-stain-remover-3997	1
4	[empty string]	STAR BRITE	Star Brite	FISHING	Fishing>Marine>Boat Maintenance	[empty string]	1	14.99	0	14.99	103954-DEFAULT-l.jpg	14.99	103954-DEFAULT-m.jpg	STARBRITE EZ-ON EZ-OFF HULL CLEANER 32	N	7 BRYAN	[empty string]	[empty string]	[empty string]	MARINE	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]	23	10-to-15	0.00	[empty string]	EZ-ON EZ-OFF Hull & Bottom Cleaner 32oz	<p>EZ-ON EZ-Off Hull & Bottom Cleaner is the best and easiest way to clean dirty bottoms and hulls. Loosens tough marine deposits, and removes stubborn stains quickly and without hard scrubbing.  Ideal for cleaning baitwells, fish boxes or in-deck storage.</p> <p> </p> <ul> <li>Removes deposits on boat bottoms, scum line and rust stains quickly and easily.</li> <li>Loosens the toughest deposits on boat bottoms, removes scum lines and rust stains.</li> <li>Water based, environmentally friendly formula.</li> <li>Size: 32 OZ</li> </ul>	[empty string]	N	14.99	14.99	[empty string]	103954-DEFAULT-s.jpg	[empty string]	1000	74-92832	4001	EMPTY	EMPTY	EMPTY	0	0	0	MARINE	[empty string]	star-brite/ez-on-ez-off-hull-bottom-cleaner-32oz-4001	1
5	[empty string]	STAR BRITE	Star Brite	FISHING	Fishing>Marine>Boat Maintenance	[empty string]	1	6.99	0	6.99	103956-DEFAULT-l.jpg	6.99	103956-DEFAULT-m.jpg	STARBRITE WINTERSAFE RV ANTIFREEZE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	MARINE	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]	33	5-to-10	0.00	[empty string]	Winter Safe -50 RV Anti-Freeze - Non-Toxic PG 1Gallon	<p>Star brite® Wintersafe -50°F (-46°C) Non-Toxic Antifreeze provides excellent cold weather and corrosion protection for drinking water systems and all engines at an attractive price. Its premium additive package prevents corrosion of aluminum, copper, brass and solder, but will not harm rubber, seals or hose materials. The 3X-dyed pink color provides excellent blow-through visibility. Formulated with virgin, non-toxic USP-grade ingredients. It contains no alcohols. This product is ready-to-use; do not dilute it.</p> <p> </p> <ul> <li>Safe for copper, brass and all types of plastic.</li> <li>Non-toxic virgin propylene glycol formula.</li> <li>Protects water systems & engines from freeze ups during storage.</li> <li>Contains corrosion inhibitors to protect all metal engine components and seals.</li> <li>Size: 1 Gallon</li> </ul>	[empty string]	N	6.99	6.99	[empty string]	103956-DEFAULT-s.jpg	[empty string]	1000	74-31200	122185	EMPTY	EMPTY	EMPTY	0	0	0	MARINE	[empty string]	star-brite/winter-safe-50-rv-anti-freeze-non-toxic-pg-1gallon-122185	1
6	[empty string]	STAR BRITE	Star Brite	FISHING	Fishing>Marine>Boat Maintenance	[empty string]	1	6.99	0	6.99	103957-DEFAULT-l.jpg	6.99	103957-DEFAULT-m.jpg	STARBRITE WINTER TECH ANTIFREEZE GALLON	N	7 BRYAN	[empty string]	[empty string]	[empty string]	MARINE	[empty string]	[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]	4	5-to-10	0.00	[empty string]	Winter Tech -50ºF Marine & RV Water System Antifreeze 1 Gallon	<p>Star brite Winter Tech -50°F (-46°C) Marine & RV Water System Antifreeze provides cold weather protection for drinking water tanks and systems and holding tanks at an attractive price. The alcohol and propylene glycol formula will not harm aluminum, copper, brass, or solder, with a bright pink color for excellent blow-through visibility. This product is ready-to-use; do not dilute it.</p> <p> </p> <ul> <li>Safe for copper, brass and all types of plastic</li> <li>Provides burst protection to -50°F</li> <li>Propylene glycol and alcohol formula is safe for all water and holding tank materials</li> <li>Size: 1 Galllon </li> </ul>	[empty string]	N	6.99	6.99	[empty string]	103957-DEFAULT-s.jpg	[empty string]	1000	74-31100	241576	EMPTY	EMPTY	EMPTY	0	0	0	MARINE	[empty string]	star-brite/winter-tech-50-f-marine-rv-water-system-antifreeze-1-gallon-241576	1
7	[empty string]	STAR BRITE	Star Brite	FISHING	Fishing>Marine>Boat Maintenance	[empty string]	1	6.99	0	6.99	104076-DEFAULT-l.jpg	6.99	104076-DEFAULT-m.jpg	BOAT SCUFF ERASER LARGE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	MARINE	[empty string]	[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]	12	5-to-10	0.00	[empty string]	Ultimate Magic Sponge XL	<p>The fastest way to remove stains, scuffs and streaks from fiberglass and vinyl surfaces.</p> <p> </p> <ul> <li>For home, auto, Rv, boat & more</li> <li>Instantly erases dirt, grime, scuff marks and streaks</li> <li>Removes scuffs and stains from vinyl, plastic and fiberglass</li> <li>Ideal for walls, appliances, baseboards, showers, tubs and tiles</li> <li>1 sponge pack</li> </ul>	[empty string]	N	6.99	6.99	[empty string]	104076-DEFAULT-s.jpg	[empty string]	1000	74-41008	317648	EMPTY	EMPTY	EMPTY	0	0	0	MARINE	[empty string]	star-brite/ultimate-magic-sponge-xl-317648	1
8	[empty string]	STAR BRITE	Star Brite	FISHING	Fishing>Marine>Boat Maintenance	[empty string]	1	2.99	0	2.99	104077-DEFAULT-l.jpg	2.99	104077-DEFAULT-m.jpg	BOAT SCUFF ERASER STANDARD SIZE	N	7 BRYAN	[empty string]	[empty string]	[empty string]	MARINE	[empty string]	[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]	19	5-AND-under	0.00	[empty string]	Ultimate Magic Sponge	<p>The fastest way to remove stains, scuffs and streaks from fiberglass and vinyl surfaces.</p> <p> </p> <ul> <li>For home, auto, Rv, boat & more</li> <li>Instantly erases dirt, grime, scuff marks and streaks</li> <li>Removes scuffs and stains from vinyl, plastic and fiberglass</li> <li>Ideal for walls, appliances, baseboards, showers, tubs and tiles</li> </ul>	[empty string]	N	2.99	2.99	[empty string]	104077-DEFAULT-s.jpg	[empty string]	1000	74-41018	317649	EMPTY	EMPTY	EMPTY	0	0	0	MARINE	[empty string]	star-brite/ultimate-magic-sponge-317649	1
9	[empty string]	STAR BRITE	Star Brite	FISHING	Fishing>Marine>Boat Maintenance	[empty string]	1	24.99	0	24.99	103960-DEFAULT-l.jpg	24.99	103960-DEFAULT-m.jpg	WATERPROOF FABRIC TREATMENT 220	N	7 BRYAN	[empty string]	[empty string]	[empty string]	MARINE	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]	7	20-to-25	0.00	[empty string]	Waterproofing 22oz	<p>Star brite Waterproofing restores water repellency to virtually all marine fabrics from boat covers to bimini tops. It is also the easiest, most effective way to waterproof car covers, tents, tarps, foul weather gear, convertible tops and more.<br /> <br /> Star brite Waterproofing is also great for use on new fabrics, greatly extending their service life by providing an additional barrier to moisture and damaging UV rays.<br /> <br /> It’s easy to use; simply spray the fabric to be restored, and allow it to dry for 6 hours before use.  Always apply Waterproofing outdoors, taking care to not breathe the solution.</p> <p> </p> <p><br />  </p>	[empty string]	N	24.99	24.99	[empty string]	103960-DEFAULT-s.jpg	[empty string]	1000	74-81922	317650	EMPTY	EMPTY	EMPTY	0	0	0	MARINE	[empty string]	star-brite/waterproofing-22oz-317650	1

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts ORDER BY sortposition asc

Sort By:

Items per page:

Close

Filter By

Filter