Men's Nike Zoom Fly 4 Road Running Shoes

Style: CT2392

Brand: nike

$160.00 $120.00

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	NON_INVT	ORIGATTR1	QOH	SKU_ID	SORT_ORDER
1	BLACK/WHT/ANTHRACITE	71885	[empty string]	[empty string]	N	BLACK/WHT/ANTHRACITE	1	571682	[empty string]
2	BARELY_VOLT/BLACK	71886	[empty string]	[empty string]	N	BARELY_VOLT/BLACK	-1	571697	[empty string]
3	WOLF_GREY/WHITE/BLUE	71887	[empty string]	[empty string]	N	WOLF_GREY/WHITE/BLUE	0	578979	[empty string]
4	ACAI/BLACK/WHT_BLUE	71888	[empty string]	[empty string]	N	ACAI/BLACK/WHT_BLUE	0	593523	[empty string]
5	BLACK/WHT_BLUE	71889	[empty string]	[empty string]	N	BLACK/WHT_BLUE	0	593538	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(z.non_invt) as non_invt FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) LEFT JOIN tb_styles z on (z.style_id = a.style_id) WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id=? AND e.store_id in(1,2,3,4) GROUP BY b.attr1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	41564

Colors:

Size: 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 12.5 13 14 15

Width REGULAR

description
shipping & returns

Nike Zoom Fly 4
Men's Road Running Shoes
DURABLE SPEED MADE FOR PROPULSIVE TRAINING.
Train hard and find your rhythm on the road. From the moment you lace up, the webbing on the upper and lacing system wrap around your foot for a secure feel from start to finish. The added flex feels highly responsive and secure with every step. A soft, breathable upper combines with a stretchy collar for a sock-like fit for a secure, stable sensation. You've got goals to hit, lace up and fly towards a new best.

Snug Fit
Nike Flyknit material is placed around the collar, providing extra stretch for easy on and off. It has a sock-like feel that helps contain your foot and feels secure.
Cooler Comfort
The upper is made with lightweight mesh for a softer, more breathable feel that conforms to your foot.
Secure Feel
Midfoot support arrives courtesy of 4 individual pieces of webbing that intertwine with the laces. When you lace up, the shoe gets tighter, giving you stability. Also, an internal heel pod delivers a more secure fit than the Zoom Fly 3.
Propulsive Miles
Nike React technology is a lightweight, durable foam that delivers a smooth, responsive ride. It combines with an internal carbon fiber plate for flexibility in your stride.

Shipping

We offer free standard shipping on all orders $50+ and a flat rate on all orders under that amount. Expedited shipping is available in checkout for a shipping premium.

Returns

Any unworn product can be returned for a full refund within 90 days. We do not offer free return shipping except in cases of defective items. These can be returned for a full refund within 90 days at no expense to you. Please contact us with any inquiries.

Returns can be mailed to:
Runners Plus
8970 Kingsridge Dr.
Dayton, OH 45458