/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=1103 /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=1025 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_descpription SELECT * FROM mtl_product_description where product_id=1025 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_meta SELECT * FROM mtl_product_meta where product_id=1025 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT * FROM mtl_product_link where product_id=1025 /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= ? /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select name from mtl_keyword where id=16285 /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= ? /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select name from mtl_keyword where id=16285 /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= 1103 /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=1025 /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/8/rate_id select * from mtl_rate_id where product_id=1025 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/rate/8/rate SELECT * from mtl_rate where top_id=0 and product_id=1025 order by add_time desc Limit 5 Offset 0 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/ask/8/rate_id select * from mtl_rate_id where product_id=1025 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/ask/8/rate SELECT * from mtl_rate where top_id=0 and product_id=1025 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 =1025 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 =1025 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 =1025 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 =1025 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 (11,13,66,72,97,120,787,861,869,1052) 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 (569,764,791,518,484,195,646,733,84,879) /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 (569,764,791,518,484,195,646,733,84,879) /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 (938,683,428,173,1111,856,601,346,91,1029) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate SELECT * from mtl_rate where top_id in (91,173,346,428,601,683,856,938,1029,1111) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_user SELECT * FROM mtl_rate_user where rate_user_id in (91,173,346,428,601,683,856,938,1029,1111) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_product SELECT * FROM mtl_rate_product where rate_product_id in (80,145,270,329,428,282,28,278,677,733) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_title SELECT * FROM mtl_rate_title where rate_title_id in (91,173,346,428,601,683,856,938,1029,1111) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_content SELECT * FROM mtl_rate_content where rate_content_id in (91,173,346,428,601,683,856,938,1029,1111) /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= 1103 /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= 1103 /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= 1103 /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= 1103 /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= 1103 /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= 1103 /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= 1103 /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= 1103 /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= 1103 /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= 1103 /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= 1103 /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
Light Blue Air Jordan 4 Flyknit 'Hyper Royal' DCDCA1103
Popularized by Spike Lee’s iconic Air Jordan commercials and his cult classic film, Do the Right Thing, the Nike Air Jordan 4 was transformed from on-court performance style into a pop icon. To honor the thirty year anniversary of the Air Jordan 4, Jordan Brand released the monochromatic Air Jordan 4 Flyknit pack in June 2019. This style is decked out in a Game Royal colorway equipped with a flexible Flyknit upper, translucent lacing wings and a Nike Air cushioned sole for modern basketball-inspired style. Now available at Kick Game
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 MoonChyld DewDrop
awesome sneakers...great fit and very comfortable to wear
Reviewer Stacey Mancuso
Bought these for my little brother. Nice shoes. I buy polo women's shoes and figured I'd give the men's a try for gifts. Good product.
Reviewer P L Stahler
Nice looking shoe! Lightweight and fit well!! Good purchase!
Reviewer PTcasserlyPD4
These shoes are very good looking, only that are a lil bit tight, i use them with thin socks
Reviewer Ms Do
My husband and I bought a pair of these each and we enjoy wearing them around. We are old kids, I suppose, because we are not kids. The shoes change colors, blink, and do all sorts of things - so much fun especially outside at night. And they are so comfortable to wear!!!!!
Reviewer marjorie
He doesn't use them for working out, but his normal everyday use of them works freat.
Reviewer kathy hancock
My husband Love's them says they are comfortable
Reviewer Adam Floro
I live in boat shoes, both ashore (mostly) an on my boat. This is my second pair of Sea Kites. I also have a pair in another color. The Sea Kites hold up well with my day to day use and a bit of abuse. I've been through Timberland, Bass, and Clarks over the years. They have gone through up and down cycles of quality. Right now Sperry is on top and I find the others disappointing in terms of fit and quality.
Reviewer Da L Luo
These shoes look very similar to a Nike pair that I own. They are cushy inside and fit as expected. The overall workmanship and materials feel about like the quality I would expect from a target or Walmart shoe. These will make great work shoes, though I don’t expect them to last very long.
Reviewer J Line
Great product I will continue buy great service and product