/home/wwwroot/lnmp01/domain/easy_zdata/package/deploy/en07/10_1.kickgame.com0/sessions/3/cart SELECT count(1) as counts,* FROM sqlite_master where sql=:sql /home/wwwroot/lnmp01/domain/easy_zdata/package/deploy/en07/10_1.kickgame.com0/sessions/3/cart SELECT count(1) as counts,* FROM sqlite_master where sql=:sql /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_id/product4 SELECT * FROM mtl_product p,mtl_product_model pm,mtl_product_title pt,mtl_product_quantity pq,mtl_product_to_category ptc,mtl_product_to_product ptp,mtl_product_points ppo where p.show=1 and p.product_id= pm.product_id and p.product_id= pq.product_id and p.product_id= ppo.product_id and p.product_id= ptp.product_id and p.product_id= pt.product_id and p.product_id= ptc.product_id and p.product_id=662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_price SELECT * FROM mtl_product_price pp,mtl_product_special_offer pso where pp.product_id= pso.product_id and pp.product_id=18 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_descpription SELECT * FROM mtl_product_description where product_id=18 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_meta SELECT * FROM mtl_product_meta where product_id=18 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT * FROM mtl_product_link where product_id=18 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/category SELECT * FROM mtl_category c,mtl_category_title ct where c.category_id=ct.category_id and c.category_id= 6 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/category SELECT * FROM mtl_category c,mtl_category_title ct where c.category_id=ct.category_id and c.category_id= 1 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/category_description SELECT * FROM mtl_category_description where category_id= 1 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/category_description SELECT * FROM mtl_category_description where category_id= 6 /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select * from mtl_mainword where name=? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select name from mtl_keyword where id=15844 /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select * from mtl_mainword where name=? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? or name= ? /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select name from mtl_keyword where id=15844 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_attribute SELECT *,pa.option_id as options_id FROM mtl_product_attribute pa, mtl_product_option po, mtl_product_option_value pov where pa.option_id=po.option_id and pa.option_value_id=pov.option_value_id and pa.product_id=18 /home/wwwroot/lnmp01/domain/easy_zdata/package/deploy/en07/10_1.kickgame.com0/sessions/3/cart SELECT sum(quantity)as quantity,SUM(quantity*price) AS total_price FROM mtl_shopping_cart where session_name=:session_name /home/wwwroot/lnmp01/domain/easy_zdata/package/deploy/en07/10_1.kickgame.com0/sessions/3/cart select * FROM mtl_shopping_method where session_name=:session_name /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/category SELECT data_count FROM mtl_category where category_id=6 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/rate/6/rate_id select * from mtl_rate_id where product_id=18 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/rate/6/rate SELECT * from mtl_rate where top_id=0 and product_id=18 order by add_time desc Limit 5 Offset 0 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/ask/6/rate_id select * from mtl_rate_id where product_id=18 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/ask/6/rate SELECT * from mtl_rate where top_id=0 and product_id=18 order by add_time desc Limit 5 Offset 0 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_nature SELECT count(*) as count from mtl_product_nature pa, mtl_product_option po, mtl_product_option_value pov where pa.option_id=po.option_id and pa.option_value_id=pov.option_value_id and pa.product_id =18 and po.types =2 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_nature SELECT * from mtl_product_nature pa, mtl_product_option po, mtl_product_option_value pov where pa.option_id=po.option_id and pa.option_value_id=pov.option_value_id and pa.product_id =18 and po.types =2 order by attribute_id asc /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_nature SELECT count(*) as count from mtl_product_nature pa, mtl_product_option po, mtl_product_option_value pov where pa.option_id=po.option_id and pa.option_value_id=pov.option_value_id and pa.product_id =18 and po.types =1 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_nature SELECT * from mtl_product_nature pa, mtl_product_option po, mtl_product_option_value pov where pa.option_id=po.option_id and pa.option_value_id=pov.option_value_id and pa.product_id =18 and po.types =1 order by attribute_id asc /home/wwwroot/lnmp01/domain/easy_zdata/package/deploy/en07/10_1.kickgame.com0/sessions/3/product_record select page_id from mtl_recent_products where session_name=:session_name order by id desc limit 8 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_id/product4 SELECT p.product_id,name,product_oid,change_time FROM mtl_product p,mtl_product_model pm,mtl_product_title pt,mtl_product_to_product ptp,mtl_product_to_category ptc where p.show=1 and p.product_id= pm.product_id and p.product_id= ptp.product_id and p.product_id= pt.product_id and p.product_id= ptc.product_id and p.product_id in () /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_id/product4 SELECT p.product_id,name,product_oid,change_time FROM mtl_product p,mtl_product_model pm,mtl_product_title pt,mtl_product_to_product ptp,mtl_product_to_category ptc,mtl_product_points ppo,mtl_product_soft_price psp where p.show=1 and p.product_id= pm.product_id and p.product_id= ptp.product_id and p.product_id= psp.product_id and p.product_id= pt.product_id and p.product_id= ptc.product_id and p.product_id= ppo.product_id and p.product_id in (69,163,181,431,510,596,642,793,1042,1072) limit 10 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_price SELECT pp.product_id,price,special_offer FROM mtl_product_price pp,mtl_product_special_offer pso where pp.product_id= pso.product_id and pp.product_id in (846,635,542,458,622,55,321,249,1046,623) /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_descpription SELECT product_id,image FROM mtl_product_description where product_id in (846,635,542,458,622,55,321,249,1046,623) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_id select * from mtl_rate_id /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate SELECT * from mtl_rate where top_id=0 and rate_id in (627,502,377,252,127,2,629,504,379,254) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate SELECT * from mtl_rate where top_id in (2,127,252,254,377,379,502,504,627,629) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_user SELECT * FROM mtl_rate_user where rate_user_id in (2,127,252,254,377,379,502,504,627,629) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_product SELECT * FROM mtl_rate_product where rate_product_id in (2,45,201,202,290,6,376,378,447,449) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_title SELECT * FROM mtl_rate_title where rate_title_id in (2,127,252,254,377,379,502,504,627,629) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_content SELECT * FROM mtl_rate_content where rate_content_id in (2,127,252,254,377,379,502,504,627,629) /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT link_name FROM mtl_product_link where product_id= 662 /home/wwwroot/lnmp01/domain/easy_zdata/word/en07/10_1.kickgame.com0/en_10/10_1.kickgame.com0/en/ad_word select max(ad_word_ip) as maxid FROM mtl_ad_word 123123
Air Jordan 4 Crimson Retro OG PS 'White Cement' 2025 BAC0662
The Air Jordan 4 Retro OG PS 'White Cement' 2025 reintroduces a legendary silhouette tailored for the next generation of sneaker enthusiasts. Dressed in a clean Summit White leather upper, this preschool-sized version features signature Tech Grey speckled detailing on the eyelets, heel tab, and midsole, capturing the timeless appeal of the original 1989 release.
Bold black accents and a Fire Red Jumpman logo on the tongue add contrast, while the iconic Nike Air branding on the heel brings an authentic, heritage-inspired touch. With a cushioned midsole and durable rubber outsole, the 'White Cement' offers both comfort and classic style, making it a standout staple for young sneaker fans.
Thank you for visiting and shopping at airsshoes.shop. Following are the terms and conditions that constitute our Shipping Policy.
Shipment processing time
All orders made before 2:00PM are processed within 2-3 business days. Orders are not shipped or delivered on weekends or holidays.
If we are experiencing a high volume of orders, shipments may be delayed by a few days. Please allow additional days in transit for delivery. If there will be a significant delay in shipment of your order, we will contact you via email or telephone.
Shipping rates ### delivery estimates
Shipping charges for your order will be calculated and displayed at checkout.The shipping time is about 7-10 business days via USPS.Delivery delays can occasionally occur.
Shipment confirmation ### Order tracking
You will receive a Shipment Confirmation email once your order has shipped containing your tracking number(s). The tracking number will be active within 24 hours.
Customs, Duties and Taxes
airsshoes.shop is not responsible for any customs and taxes applied to your order. All fees imposed during or after shipping are the responsibility of the customer (tariffs, taxes, etc.).
Reviewer George Drick
I'm getting old/lazy. I like the ease and quickness of the straps.
Reviewer Samuel H Leff
This is a nice shoe. i always buy a half size bigger from past experience with Skechers shoes. Skechers should warn people of this.
Reviewer Bruce D Saunders
I have lyme disease which results in my feet often being painful, so finding a pair of shoes that is comfortable is essential to me....and rarely found. These shoes definitely meet the requirements!!! They're lightweight and comfy, easily worn all day. I normally wear an 11, but sometimes a 10 1/2. I ordered a 10 1/2 and they fit perfect.
Maybe I'm slow or missing something, but these shoes are slipons. I view the laces as decorative.
Reviewer julio py
Very nice shoe and comfortable.
Reviewer Peter Schimpf
Lite weight, accurate size, not worn a lot yet though.
Reviewer Mike & usan
l Love these shoes, super comfortable, but a bit on the large side
Reviewer Geoffrey D Carter
I bought for my grandson for Christmas he loves them . You would of thought I gave him a 1000 dollars . He wears them everyday . Good product
Reviewer MR KELLEY JOHNSTON
However I never really enjoy them until now. I have difficulty with my legs and feet, and need to pay special attention to them. Walking, with a cane now, is not what it used to be. While I could walk 5 miles and never be concerned, I smashed my left ankle several years ago, and walking isn't that easy anymore. These shoes by Rockport not only fit right out of the box but were so comfortable I am enjoying my walks every day. I think they look great, but Rockport provides many choices. I highly recommend these shoes.
Reviewer Wilson Daniel Pace
Had an older gen of this shoe, it was amazing. This pair is wearing out a little faster than the last gen. The old pair also fit AMAZINGLY, and this one was a bit tight. I changed the lacing style (to horizontal) and it solved the narrow feeling of this pair. Only reason this got 4 starts is because the last pair blew... my... mind! so I might be comparing too much.
Reviewer Lynette Gomez
These fit perfect. I have a pair of the original finger shoes in black, and wanted something neutral in color, and these fit even better than those.