Urban Western Wear

My Account | International Shipping | Tel: 832-369-6715     

  

cart


buy an UrbanWesternClothing.com gift card Gift Cards Available

Invitations

You have five friend invitations remaning.

Click here

 

Category: Men > Cowboy Boots


Menís Cowboy Boots
Tony Lama Bay Apache

$178.95

brand: tony lama


Note: This product is in high demand, please allow extra time for delivery.

Add to Cart

Need it fast? Some sizes are shipped next business day. Click here for availability.


Tony Lama AMERICANA
BAY APACHE Style #: 7902
Upper: 12"
Vamp: BAY APACHE FOOT
Toe: R
Welt: ANTIQUE WELT WITH BROWN WELT STITCH,HANDCRAFTED IN THE USA
Heel: 4 - 1 5/8" Height
Insole: CUSHION
Outsole: LEATHER
Sizes: B(9-12, 13) D(6-12, 13, 14, 15) EE(6-12, 13)


Style #7902    Product #7250




update product_parents set vendorinventorywhen = now() where parentid = '7250'checking inventory...

Opening connection to Tony Lama...


Automatically checking vendor inventory...

1: 9 - b = 3

1: 9.5 - b = 3

1: 10 - b = 6

1: 10.5 - b = 6

1: 11 - b = 1

1: 11.5 - b = 8

1: 12 - b = 6

1: 13 - b = 5

1: 6 - d = 4

1: 6.5 - d = 7

1: 7 - d = 6

1: 7.5 - d = 14

1: 8 - d = 40

1: 8.5 - d = 67

1: 9 - d = 99

1: 9.5 - d = 99

1: 10 - d = 99

1: 10.5 - d = 99

1: 11 - d = 99

1: 11.5 - d = 82

1: 12 - d = 99

1: 13 - d = 81

1: 14 - d = 11

1: 15 - d = 10

1: 6 - ee = 8

1: 6.5 - ee = 10

1: 7 - ee = 2

1: 7.5 - ee = 10

1: 8 - ee = 17

1: 8.5 - ee = 25

1: 9 - ee = 43

1: 9.5 - ee = 59

1: 10 - ee = 78

1: 10.5 - ee = 85

1: 11 - ee = 68

1: 11.5 - ee = 44

1: 12 - ee = 69

1: 13 - ee = 29

Importing...

0 out: update products set vendorinventory = '0' where parentid = '7250'

2: 9 - b = 3

update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '82034'

2: 9 - d = 99

update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55118'

2: 9 - ee = 43

update products set vendorinventory = '43', vendorinventorywhen=now() where prodid = '56511'

2: 9.5 - b = 3

update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '82894'

2: 9.5 - d = 99

update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55119'

2: 9.5 - ee = 59

update products set vendorinventory = '59', vendorinventorywhen=now() where prodid = '57109'

2: 10 - b = 6

update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '77698'

2: 10 - d = 99

update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '56942'

2: 10 - ee = 78

update products set vendorinventory = '78', vendorinventorywhen=now() where prodid = '55120'

2: 10.5 - b = 6

update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '77254'

2: 10.5 - d = 99

update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '56512'

2: 10.5 - ee = 85

update products set vendorinventory = '85', vendorinventorywhen=now() where prodid = '56513'

2: 11 - b = 1

update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '82035'

2: 11 - d = 99

update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '56514'

2: 11 - ee = 68

update products set vendorinventory = '68', vendorinventorywhen=now() where prodid = '60851'

2: 11.5 - b = 8

update products set vendorinventory = '8', vendorinventorywhen=now() where prodid = '55121'

2: 11.5 - d = 82

update products set vendorinventory = '82', vendorinventorywhen=now() where prodid = '60107'

2: 11.5 - ee = 44

update products set vendorinventory = '44', vendorinventorywhen=now() where prodid = '56515'

2: 12 - b = 6

update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '55122'

2: 12 - d = 99

update products set vendorinventory = '99', vendorinventorywhen=now() where prodid = '55123'

2: 12 - ee = 69

update products set vendorinventory = '69', vendorinventorywhen=now() where prodid = '55124'

2: 13 - b = 5

not inserting to prevent dup key 13 = 13

2: 13 - d = 81

not inserting to prevent dup key 13 = 13

2: 13 - ee = 29

not inserting to prevent dup key 13 = 13

2: 6 - d = 4

update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '81950'

2: 6 - ee = 8

update products set vendorinventory = '8', vendorinventorywhen=now() where prodid = '86063'

2: 6.5 - d = 7

update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '92938'

2: 6.5 - ee = 10

update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '55125'

2: 7 - d = 6

update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '55126'

2: 7 - ee = 2

update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '86329'

2: 7.5 - d = 14

update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '60380'

2: 7.5 - ee = 10

update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '85207'

2: 8 - d = 40

update products set vendorinventory = '40', vendorinventorywhen=now() where prodid = '55127'

2: 8 - ee = 17

update products set vendorinventory = '17', vendorinventorywhen=now() where prodid = '56235'

2: 8.5 - d = 67

update products set vendorinventory = '67', vendorinventorywhen=now() where prodid = '55128'

2: 8.5 - ee = 25

update products set vendorinventory = '25', vendorinventorywhen=now() where prodid = '56236'

2: 14 - d = 11

update products set vendorinventory = '11', vendorinventorywhen=now() where prodid = '88347'

2: 15 - d = 10

update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '56516'

TIQ 1386

update product_parents set vendorinventorywhen = now() where parentid = '7250'

 

We are currently gathering reviews for this product.

Category: Menís Cowboy Boots

Style #: 7902
Product #: 7250
Short URL:


brand: tony lama   View more from Tony Lama brand.


Item Added to Cart

You successfully added an item to your cart.

Enter Your Email:




Payment Processing

Customer Service: 832-369-6715
Contact Us | Blogs | Facebook | Search | Sizing Charts
Coupons | Group Discounts | Site Maps
Resources | Privacy Policy | Return Policy | Gift Cards

International
Shipping

 
Join Our Email List
Email:  


updated Wednesday, April 23, 2014
© Copyright 2010-2014, Urban Western Wear. All rights reserved.
Photos, imagery and any other information from this site may not be used without prior written consent.

 

   THANK YOU FOR VISITING OUR SITE!