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='731' 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='731' 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 Key Chains & Such
Sanpete Spur & Silver Western Store > Western Key Chains & Such

Western Key Chains & Such

Key Chins & Such

Products

Sort by: Product Price Default
Western Leather Card Holder Basket Weave
Offered here is a very nice genuine leather card holder made by 3D Company. The front has a basket weave design stamped and then the chevron shaped top corners are over laid tooled leather. Measurements are 4 inches wide, 2

Our price: $22.00
Western Leather Card Holder Gator
Offered here is a very nice genuine leather covered card holder made by 3D Company. The front has a gator design stamped and then the chevron shaped top corners are over laid tooled leather. Measurements are 4

Our price: $26.00
Western Braided Horsehair Key Chain Black
This braided horsehair key chain is hand braided. Because our supplier has 14 braiders creating these key chains, the colors will be the same...but you may see some variation in each design. This braided horsehair key chain has a variety of bright colors including maroon, orange, blue, white and black. The tassels main

Our price: $17.00
Western Silver Spur Key Chain Large
Offered here is a sterling silver plated miniature spur with a moving spur rowel. The 1/2 inch wide band has been hand engraved, along with the shank, then they have added chain and a threaded key ring to finish this spur off nicely. The spur measures 2-1/2 inches long by 1-1/2 inches wide. The total

Our price: $15.00
Western Sterling Silver Spur Key Chain Small

Offered here is a sterling silver plated miniature spur with a moving spur rowel. The 1/2 inch wide band has been hand engraved, along with the shank, then they have added chain and a threaded key ring to finish this spur off nicely. The spur measures 1-3/4 inches long by 7/8 inch wide. The total


Our price: $14.00
Western Braided Horsehair Key Chain Black with Silver
This braided horsehair key chain is hand braided. Because our supplier has 14 braiders creating these key chains, the colors will be the same...but you may see some variation in each design. This braided horsehair key chain features a 1 inch long silver colored

Our price: $12.00
Western Braided Horsehair Key Chain Black with Turquoise
This braided horsehair key chain is hand braided. Because our supplier has 14 braiders creating these key chains, the colors will be the same...but you may see some variation in each design. This braided horsehair key chain features a 1 inch long turquoise colored bead with a black design carved in it and finished with a round silver colored

Our price: $12.00
Western Braided Horsehair Key Chain Brown with Silver
This braided horsehair key chain is hand braided. Because our supplier has 14 braiders creating these key chains, the colors will be the same...but you may see some variation in each design. This braided horsehair key chain features a 1 inch long silver colored bead with a black design carved in it and finished with a round gold colored

Our price: $12.00
Western Braided Horsehair Key Chain Brown/Cream with Silver
This braided horsehair key chain is hand braided. Because our supplier has 14 braiders creating these key chains, the colors will be the same...but you may see some variation in each design. This braided horsehair key chain features a 1 inch long silver colored bead with a black design carved in it and finished with a round gold colored

Our price: $12.00
Western Braided Horsehair Key Chain Cream
This braided horsehair key chain is hand braided. Because our supplier has 14 braiders creating these key chains, the colors will be the same...but you may see some variation in each design. This braided horsehair key chain has a variety of bright

Our price: $17.00