/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=463 /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=1019 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_descpription SELECT * FROM mtl_product_description where product_id=1019 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_meta SELECT * FROM mtl_product_meta where product_id=1019 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT * FROM mtl_product_link where product_id=1019 /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= ? /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select name from mtl_keyword where id=15645 /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= ? /home/wwwroot/lnmp01/domain/easy_zdata/fake_key/shoe_default select name from mtl_keyword where id=15645 /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= 463 /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=1019 /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/0/rate_id select * from mtl_rate_id where product_id=1019 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/rate/0/rate SELECT * from mtl_rate where top_id=0 and product_id=1019 order by add_time desc Limit 5 Offset 0 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/ask/0/rate_id select * from mtl_rate_id where product_id=1019 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/ask/0/rate SELECT * from mtl_rate where top_id=0 and product_id=1019 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 =1019 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 =1019 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 =1019 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 =1019 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 (1,593,603,649,728,804,810,970,971,1048) 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 (654,560,201,30,479,973,300,364,932,620) /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 (654,560,201,30,479,973,300,364,932,620) /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 (472,391,310,229,148,67,539,458,377,296) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate SELECT * from mtl_rate where top_id in (67,148,229,296,310,377,391,458,472,539) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_user SELECT * FROM mtl_rate_user where rate_user_id in (67,148,229,296,310,377,391,458,472,539) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_product SELECT * FROM mtl_rate_product where rate_product_id in (60,124,62,51,244,290,298,347,357,160) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_title SELECT * FROM mtl_rate_title where rate_title_id in (67,148,229,296,310,377,391,458,472,539) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_content SELECT * FROM mtl_rate_content where rate_content_id in (67,148,229,296,310,377,391,458,472,539) /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= 463 /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= 463 /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= 463 /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= 463 /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= 463 /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= 463 /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= 463 /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= 463 /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= 463 /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= 463 /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= 463 /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 Dunk From Above Golf 'Bred' AAAFC0463
The Air Jordan 4 Golf ‘Bred’ transforms the OG colorway with a retooled build designed for the links. The upper faithfully recreates the 1989 original, highlighted by a black nubuck upper with tonal quarter panel netting, grey TPU eyelets and red Jumpman branding on the woven tongue tag. A second Jumpman logo adorns the molded heel tab. The AJ4’s distinctive midsole comes complete with a visible Air-sole unit in the heel. Underfoot, a translucent outsole plate features seven removable spikes for optimal grip.
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 momof Paige
Love these shoes. Perfect for the office or shorts and a tee. Ordered on whole size smaller than my Nike or Asics. Comfortable for all day wear.
Reviewer K Foote
Having worn 574s for about 15 years I was interested to try the 373. The main difference is in the overall bulk of the shoe. The 373 is much more form fitting with a slightly lower ankle and slightly thinner sole. Comfort is comparable in both shoes, but from a fashion point of view they compliment clothes differently. The 373 I wear with slimmer jeans that have smaller cuffs, which I still prefer the 574 when wearing a boot cut jean or shorts.
Reviewer Sir Richard
Great shoes, my RA prevents ,e from tying my shoes.
Reviewer Phillytomster
real and soft.
Reviewer A Weiss
) Good Value!
Reviewer Peter Schimpf
Lite weight, accurate size, not worn a lot yet though.
Reviewer John M Thorpe
I had to get a size smaller. I am usually in a womens 10 but got these in a 9 and they fit perfect.
Reviewer Karen B Landey
My son is so oddly picky about his shoes and these are classic and perfect.
Reviewer David Wingfield
These are awesome. Fit excellent.
Reviewer JULI
My husband loves these shoes. They are well made and comfortable. However, the fit is about 1/2 size smaller than the chart suggests. They are also a narrow width for a "D". You might want to consider a "E" width.