SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_products_lng_en.product, xcart_products_lng_en.descr, xcart_products_lng_en.fulldescr, IFNULL(xcart_variants.avail, xcart_products.avail) as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode FROM xcart_products INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_products.forsale = 'Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.avail = 'Y' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid WHERE xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL AND xcart_products_categories.categoryid='101' GROUP BY xcart_products.productid ORDER BY xcart_products_categories.orderby ASC, xcart_products_lng_en.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC
SELECT xcart_products.*, xcart_quick_flags.*, xcart_quick_prices.variantid, xcart_pricing.price, xcart_products_lng_en.product, xcart_products_lng_en.descr, xcart_products_lng_en.fulldescr, IFNULL(xcart_variants.avail, xcart_products.avail) as avail, IFNULL(xcart_variants.weight, xcart_products.weight) as weight, IFNULL(xcart_variants.productcode, xcart_products.productcode) as productcode FROM xcart_products INNER JOIN xcart_featured_products ON xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='101' INNER JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid AND xcart_products.forsale = 'Y' AND xcart_products.product_type <> 'C' INNER JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid INNER JOIN xcart_quick_prices ON xcart_quick_prices.productid = xcart_products.productid AND xcart_quick_prices.membershipid = '0' AND xcart_quick_prices.priceid = xcart_pricing.priceid INNER JOIN xcart_products_lng_en ON xcart_products_lng_en.productid = xcart_products.productid INNER JOIN xcart_products_categories ON xcart_products_categories.productid = xcart_products.productid INNER JOIN xcart_categories ON xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.avail = 'Y' LEFT JOIN xcart_category_memberships ON xcart_category_memberships.categoryid = xcart_categories.categoryid LEFT JOIN xcart_product_memberships ON xcart_product_memberships.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid AND xcart_quick_prices.variantid = xcart_variants.variantid WHERE xcart_category_memberships.membershipid IS NULL AND xcart_product_memberships.membershipid IS NULL GROUP BY xcart_products.productid ORDER BY xcart_featured_products.product_order, xcart_products_lng_en.product ASC, xcart_products.productcode ASC, xcart_products.productid ASC
Western Cowboy Wallets
Sanpete Spur & Silver Western Store > Western Cowboy Wallets

Western Cowboy Wallets

We have one of the best selections of Justin, Tony Lama, Nocona and Ariat wallets that you will find anywhere, in the money clip wallet, rodeo, bifold and trifold styles.

Justin Cowboy  Wallets

Justin Cowboy Wallets

We have one of the best selections of Justin wallets that you will find anywhere, in the money...

Tony Lama Wallets

Tony Lama Wallets

We have one of the best selections of Tony Lama wallets that you will find anywhere, in the...

Nocona Cowboy  Wallets

Nocona Cowboy Wallets

We have one of the best selections of Nocona wallets that you will find anywhere, in the rodeo,...

Ariat Western Wallets

Ariat Western Wallets

We have a one of the best selections of Ariat western wallets that you will find anywhere. We...

PBR Western Wallets

PBR Western Wallets

PBR Western Wallets in the Rodeo, Bi-fold, and Trifold styles just for you.

USA Made Coronado Leather Western Wallets

USA Made Coronado Leather Western Wallets

We have a great selection of Coronado Leather Wallets in the Rodeo, Bi-fold credit card, and...

Rodeo  Wallets Only

Rodeo Wallets Only

We have one of the best selections of Justin, Tony Lama, Nocona and Ariat rodeo wallets/checkbook...

Leather Money Clip  Wallets Only

Leather Money Clip Wallets Only

These are great leather wallets for the cowboy who likes a money clip and a credit card holder in...

Tri-fold  Wallets Only

Tri-fold Wallets Only

We have one of the best selections of Justin, Tony Lama, Nocona and Ariat tri-fold wallets that...

Bi-fold  Wallets Only

Bi-fold Wallets Only

We have one of the best selections of Justin, Tony Lama, Nocona and Ariat bi-fold wallets that...