Simmons' 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	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEBSTYLE	WEIGHTED_SEARCH
1	[empty string]	BOWTECH	Bowtech	ARCHERY	Archery	[empty string]	1	49.99	0	49.99	5772-DEFAULT-l.jpg	49.99	5772-DEFAULT-m.jpg	BOWTECH 90731TSN OCTANE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	842	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	25-to-50	0.00	[empty string]	Bowtech 90731tsn Octane Balance X Stabilizer	<p>Octane Balance-X Stabilizer 7-11" Treestand Most advanced and adjustable stabilizer with it's dampening material will neutralize vibration for a noticeably smoother shot. A fully customizable length of 7"-11" you can choose the length and weight that is right for your bow set-up. Quick adjustability extends or retracts with just a twist to lock or unlock. Adjustable weights give you the ability to add or subtract the weights to customize your stabilizer to fit your bow performance. Advanced dampening material neutralizes any vibration in your shot. Weights included with stabilizer. Mass Weight: .4 lbs. ,Size: 7-11", Color: Treestand, Size: 7-11", Manufacturer: DIAMOND BY BOWTECH, Model: 60151</p>	[empty string]	N	49.99	49.99	[empty string]	5772-DEFAULT-s.jpg	[empty string]	1000	1000	90731TSN	91570	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bowtech/bowtech-90731tsn-octane-balance-x-stabilizer-91570	90731TSN	0
2	BLACK	BOWTECH	Bowtech	ARCHERY	Archery	BLACK\|NULL\|NULL	1	599.99	0	599.99	7517-DEFAULT-l.jpg	599.99	7517-DEFAULT-m.jpg	BOWTECH AMPLIFY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	842	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	5	500-or-more	0.00	[empty string]	Bowtech Amplify	<p><strong>ADJUSTS TO ANYONE, DOMINATES EVERYTHING IN ITS CLASS</strong></p><p> </p><ul><li>Versatility and performance at a price that doesn't break the bank.</li><li>Forgiving enough for the beginner archer and deadly enough to fill the freezer.</li><li>Highly adjustable to fit virtually any archer.</li></ul><p>MASS WEIGHT<br />4.0 LBS<br />Lighter bows can be great for mobility while adding weight or dampeners can virtually eliminate vibration. <br />DRAW LENGTH<br />21" - 30"<br />Compound bows have an adjustable draw length range and should be set to fit your unique body size and shape. <br />DRAW WEIGHT<br />8 - 70 LBS<br />Max draw weights can typically be reduced by 10lbs. This provides comfortable draw cycles for everyone while maximizing energy. <br />SPEED<br />335 FPS<br />Today's average bow speeds offer more forgiveness on the shot than ever. Faster bows can deliver more downrange energy. <br />AXLE TO AXLE<br />31.5"<br />Longer bows can increase stability while shorter bows can be better suited for maneuverability and tight spaces.<br />BRACE HEIGHT<br />6"<br />A longer brace height can offer more forgiveness on the shot while a shorter brace height can make a fast bow even faster.</p>	[empty string]	N	599.99	599.99	[empty string]	7517-DEFAULT-s.jpg	[empty string]	1000	1000	A10800	91585	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bowtech/bowtech-amplify-91585	A10800	0
3	BREAKUP_COUNTRY	BOWTECH	Bowtech	ARCHERY	Archery	BREAKUP_COUNTRY\|NULL\|NULL	1	599.99	0	599.99	30334-DEFAULT-l.jpg	599.99	30334-DEFAULT-m.jpg	BOWTECH AMPLIFY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	842	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	6	500-or-more	0.00	[empty string]	Bowtech Amplify	<p><strong>ADJUSTS TO ANYONE, DOMINATES EVERYTHING IN ITS CLASS</strong></p><p> </p><ul><li>Versatility and performance at a price that doesn't break the bank.</li><li>Forgiving enough for the beginner archer and deadly enough to fill the freezer.</li><li>Highly adjustable to fit virtually any archer.</li></ul><p>MASS WEIGHT<br />4.0 LBS<br />Lighter bows can be great for mobility while adding weight or dampeners can virtually eliminate vibration. <br />DRAW LENGTH<br />21" - 30"<br />Compound bows have an adjustable draw length range and should be set to fit your unique body size and shape. <br />DRAW WEIGHT<br />8 - 70 LBS<br />Max draw weights can typically be reduced by 10lbs. This provides comfortable draw cycles for everyone while maximizing energy. <br />SPEED<br />335 FPS<br />Today's average bow speeds offer more forgiveness on the shot than ever. Faster bows can deliver more downrange energy. <br />AXLE TO AXLE<br />31.5"<br />Longer bows can increase stability while shorter bows can be better suited for maneuverability and tight spaces.<br />BRACE HEIGHT<br />6"<br />A longer brace height can offer more forgiveness on the shot while a shorter brace height can make a fast bow even faster.</p>	[empty string]	N	599.99	599.99	[empty string]	30334-DEFAULT-s.jpg	[empty string]	1000	1000	A10802	91587	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bowtech/bowtech-amplify-91587	A10802	0
4	OD_GREEN	BOWTECH	Bowtech	ARCHERY	Archery	OD_GREEN\|NULL\|NULL	1	599.99	0	649.99	7298-DEFAULT-l.jpg	599.99	7298-DEFAULT-m.jpg	BOWTECH AMPLIFY	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	842	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	3	500-or-more	0.00	[empty string]	Bowtech Amplify	<p><strong>ADJUSTS TO ANYONE, DOMINATES EVERYTHING IN ITS CLASS</strong></p><p> </p><ul><li>Versatility and performance at a price that doesn't break the bank.</li><li>Forgiving enough for the beginner archer and deadly enough to fill the freezer.</li><li>Highly adjustable to fit virtually any archer.</li></ul><p>MASS WEIGHT<br />4.0 LBS<br />Lighter bows can be great for mobility while adding weight or dampeners can virtually eliminate vibration. <br />DRAW LENGTH<br />21" - 30"<br />Compound bows have an adjustable draw length range and should be set to fit your unique body size and shape. <br />DRAW WEIGHT<br />8 - 70 LBS<br />Max draw weights can typically be reduced by 10lbs. This provides comfortable draw cycles for everyone while maximizing energy. <br />SPEED<br />335 FPS<br />Today's average bow speeds offer more forgiveness on the shot than ever. Faster bows can deliver more downrange energy. <br />AXLE TO AXLE<br />31.5"<br />Longer bows can increase stability while shorter bows can be better suited for maneuverability and tight spaces.<br />BRACE HEIGHT<br />6"<br />A longer brace height can offer more forgiveness on the shot while a shorter brace height can make a fast bow even faster.</p>	[empty string]	N	649.99	649.99	[empty string]	7298-DEFAULT-s.jpg	[empty string]	1000	1000	A10804	91589	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bowtech/bowtech-amplify-91589	A10804	0
5	OD_GREEN	BOWTECH	Bowtech	ARCHERY	Archery	OD_GREEN\|NULL\|NULL	1	1699.99	1	1449.99	18050-DEFAULT-l.jpg	1699.99	18050-DEFAULT-m.jpg	BOWTECH CARBON ONE	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	842	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Bowtech Carbon One	<ul><li>A whole new look in Carbon bows. Flowing, sexy lines that stand far above the competitors.</li><li>The only carbon bow featuring the smoothest experience before, during, and after the shot.</li><li>Equipped with the DeadLock Cam System: the quickest and simplest way to achieve perfect arrow flight and repeatable accuracy.</li><li>The strategically engineered carbon riser, coupled with the Orbit Dampeners virtually eliminates all felt vibration on the shot.</li><li>Features the Integrate Mounting System dovetail for use with arrow rests equipped with IMS.</li><li>The strategically positioned Orbit Dampeners virtually eliminate vibration and noise on the shot.</li></ul><p> </p>	[empty string]	Y	1449.99	1449.99	[empty string]	18050-DEFAULT-s.jpg	[empty string]	1000	1000	A11289	91597	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bowtech/bowtech-carbon-one-91597	A11289	0
6	COUNTRY_DNA	BOWTECH	Bowtech	ARCHERY	Archery	COUNTRY_DNA\|NULL\|NULL	1	1099.99	0	1099.99	18051-DEFAULT-l.jpg	1099.99	18051-DEFAULT-m.jpg	BOWTECH CP30	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	842	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	1	500-or-more	0.00	[empty string]	Bowtech CP30	<p><strong>MASS WEIGHT</strong><br />4.5 LBS<br />Lighter bows can be great for mobility while adding weight or dampeners can virtually eliminate vibration. Video Popup Link<br /><strong>DRAW LENGTH</strong><br />25" - 30.5"<br />Compound bows have an adjustable draw length range and should be set to fit your unique body size and shape. Video Popup Link<br /><strong>DRAW WEIGHT</strong><br />50, 60, 70 LBS<br />Max draw weights can typically be reduced by 10lbs. This provides comfortable draw cycles for everyone while maximizing energy. Video Popup Link<br /><strong>SPEED</strong><br />331 FPS<br />Today's average bow speeds offer more forgiveness on the shot than ever. Faster bows can deliver more downrange energy. Video Popup Link<br /><strong>AXLE TO AXLE</strong><br />30"<br />Longer bows can increase stability while shorter bows can be better suited for maneuverability and tight spaces. Video Popup Link<br /><strong>BRACE HEIGHT</strong><br />6.75"<br />A longer brace height can offer more forgiveness on the shot while a shorter brace height can make a fast bow even faster. </p>	[empty string]	N	1099.99	1099.99	[empty string]	18051-DEFAULT-s.jpg	[empty string]	1000	1000	A13919	91607	EMPTY	EMPTY	EMPTY	0	0	0	EMPTY	bowtech/bowtech-cp30-91607	A13919	0

CACHED

false

EXECUTIONTIME

0

SQL

SELECT * FROM GetALLProducts89 ORDER BY sortposition asc

Filter By

Sort By

Items Per Page

Bowtech 90731tsn Octane Balance X Stabilizer

details

Bowtech 90731tsn Octane Balance X Stabilizer

Item # 90731TSN $49.99

Bowtech Amplify

details

Bowtech Amplify

Item # A10800 $599.99

Bowtech Amplify

details

Bowtech Amplify

Item # A10802 $599.99

Bowtech Amplify

details

Bowtech Amplify

Item # A10804 $649.99

Bowtech Carbon One

details

Bowtech Carbon One

Item # A11289 $1,699.99 $1,449.99

Bowtech CP30

details

Bowtech Cp30

Item # A13919 $1,099.99