/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=478 /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=235 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_descpription SELECT * FROM mtl_product_description where product_id=235 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_meta SELECT * FROM mtl_product_meta where product_id=235 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/product_link SELECT * FROM mtl_product_link where product_id=235 /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 SELECT * FROM mtl_category c,mtl_category_title ct where c.category_id=ct.category_id and c.category_id= 0 /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= 1 /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= ? 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=15660 /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= ? 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=15660 /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= 478 /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=235 /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=1 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/rate/5/rate_id select * from mtl_rate_id where product_id=235 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/rate/5/rate SELECT * from mtl_rate where top_id=0 and product_id=235 order by add_time desc Limit 5 Offset 0 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/ask/5/rate_id select * from mtl_rate_id where product_id=235 /home/wwwroot/lnmp01/domain/easy_zdata/data/en_10/10_1.kickgame.com0/en/ask/5/rate SELECT * from mtl_rate where top_id=0 and product_id=235 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 =235 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 =235 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 =235 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 =235 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 (76,117,193,214,321,411,492,633,885,944) 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 (795,25,80,768,350,912,792,520,717,1069) /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 (795,25,80,768,350,912,792,520,717,1069) /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 (427,286,145,4,431,290,149,8,435,294) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate SELECT * from mtl_rate where top_id in (4,8,145,149,286,290,294,427,431,435) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_user SELECT * FROM mtl_rate_user where rate_user_id in (4,8,145,149,286,290,294,427,431,435) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_product SELECT * FROM mtl_rate_product where rate_product_id in (4,8,45,125,227,231,235,328,13,333) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_title SELECT * FROM mtl_rate_title where rate_title_id in (4,8,145,149,286,290,294,427,431,435) /home/wwwroot/lnmp01/domain/easy_zdata/public_rate/Men/Shoes/Fashion_Sneakers/rate_content SELECT * FROM mtl_rate_content where rate_content_id in (4,8,145,149,286,290,294,427,431,435) /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= 478 /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= 478 /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= 478 /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= 478 /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= 478 /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= 478 /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= 478 /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= 478 /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= 478 /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= 478 /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= 478 /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
Travis Scott x Air Jordan 4 Reimagined Bred Houston Oilers Cactus Jack CFDBB0478
Following his popular Nike Air Force 1 collaboration with mix-and-match Swooshes, Travis Scott continued his reign as one of the sneaker world's hottest collaborators in 2018 with the Air Jordan 4 "Cactus Jack". The bright blue nubuck construction with black and red accents takes inspiration from the team colors of the now defunct Houston Oilers football team, a reference to the rapper's Texas roots. Speckled detailing and Scott's "Cactus Jack" logo on the left heel tab add more personal touches to the shoe.
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 Sheryl Crow
Great shoes. True to size and very comfortable. We bought for an 80's costume and now he wears them all the time.
Reviewer S Brainerd
Great deal!! These were 20 plus more at the dance store! Fits as expected!!
Reviewer juanita morris
Just a great walking shoe for this old man. Easy on and off, a cushioned sole, and plenty wide. As reviewers stated, they tend to pick up rocks off our driveway.
Reviewer Robert C Lyons
Look good. A bit stiff at first but they’re broken in now and very comfortable.
Reviewer Stacey Cheatham
This review is based on trying them on once.
I really like this shoe. It's very comfortable for an "old school sneaker", It has a removable insole with surprisingly good arch support and more cushioning then you'll find in a typical canvas sneaker. They're also very soft and won't rub your ankles raw. Unfortunately, I can't justify keeping them, but I find it difficult sending them back, because I like them so much (i.e. only so much closet room for shoes.)
The sizing is very accurate. They may run a little on the large side, but that's what I'd want, so I could wear them with heavy socks in Winter months. So, I disagree with those who suggest sizing up or down, because they're actually quite accurate (they're definitely not too small and I don't think they're even close to being too large, either.) The Teva brand used to run all over the place with sizing, but the last few pair I've owned and have been really consistent and accurate.
I didn't try them on a bike, but I suspect that they're very good bike riding shoes, because the soles are quite firm. In fact, I would have liked them better if the sole wasn't so firm, but I expected them to be firm as bike riding shoes. Overall, I think they're very nice sneakers, but I'm looking for something a little more fashion oriented.
Reviewer trevstonlongworth
I normally only wear 574's from New Balance, but I purchased these because they share the same shoe last and they're similar. I can't say that I like them as well, but they're alright.
I believe the mid-soles are different, and while I think I like the 574 mid-sole better, the 565 doesn't seem bad. One thing I definitely don't like as well is the lack of mesh in the all-suede upper. They probably don't breath as well, but that's not a huge factor for me in a suede shoe. I just like the looks of the mesh/suede combo better then the all-suede shoe.
I saved my final criticism for last, because it applies to both the 565 and 574 models of "Lifestyle and Retro" shoes. These are the ones with model numbers that start with "ml". I don't like them because they appear to be the hipster version of New Balance shoes, with laces that usually match the suede. Like any good hipster shoe, they seem to be more narrow, which is antithetical to the very thing that made the 574, and probably 565, popular shoes in the first place (i.e. spacious.) Even though these are supposedly made on the same shoe last as other models in the line, they definitely don't have the advertised toe depth of the SL-2 shoe last. I've also noticed that many New Balance shoes made on the SL-2 last don't seem to be as wide as they used to be, so that issue probably isn't for the lifestyle and retro shoes alone.
Seems strange that New Balance would ruin a popular line of shoes by changing the very things that made them popular, but that's what they seem to be doing. For customers that want a more narrow 574, it seems like New Balance would just suggest the 363 or one of their models made on narrow shoe lasts. Regardless, I wish they'd leave the SL-2 shoes alone, so that customer who appreciate them can continue to do so. I've worn them for 20 years and the only thing that will stop that is if New Balance changes the shoes so much that they're not the same.
Reviewer Lorien Pratt
My husband's absolute favorite hiking/urban shoe -- he has 4 pairs and if they ever wear out, my guess is he'll buy more.
Reviewer T Brettschneider
This shoes are very comfortable and resistance, i bought a second pair. The only complain is that 1 year after the sole began to felt apart.
Reviewer B Larson
One summer my shoes were my main mode of transportation. In my other shoes I put about 30 - 40 miles of walking per week. Eventually I developed a chronic pain in my left foot. I got these shoes and they helped so much. They really relieved alot of the pain. I'm now convinced that memory foam insoles are best when choosing a shoe on which you want to walk many steps.