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)
The Fresh Foam X More v4 offers the pinnacle of plush underfoot cushioning. This experience starts with a midsole containing the most Fresh Foam X in a shoe to date, but doesn’t end there. A wider platform allows for a balance between cushioning and support, by applying the cushioning across the entire foot.
Combined with the smoother transitions provided by the largest rocker in the Fresh Foam range, the Fresh Foam X More v4 offers a complete experience, 360 degrees of comfort that retains a natural feel.
Meets New Balance’s green leaf standard: upper is made of 50% or more recycled content, and at least one midsole/outsole material contains a minimum of 3% bio-based or 5% recycled content.
Fresh Foam X midsole foam with approximately 3% bio-based content delivers our most cushioned Fresh Foam experience for incredible comfort. Bio-based content is made from renewable resources to help reduce our carbon footprint.
Wider platform applies underfoot cushioning to more areas of the foot, balancing comfort, support, and protection
Increased rocker for smoother heel/toe strike transitions
Engineered mesh upper with zonal support and breathability
Data informed outsole placement
Screen printed 3D N logo
Heel Drop: 4 mm
We offer free standard shipping on all orders $50+ and a flat rate on all orders under that amount. Expedited shippingis available in checkout for a shipping premium.
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:
8970 Kingsridge Dr.
Dayton, OH 45458