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='51' 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='51' 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
Scarf Slides Handmade Hammer Textured
Sanpete Spur & Silver Western Store > Western Scarf Slides > Scarf Slides Handmade Hammer Textured

Scarf Slides Handmade Hammer Textured

One of a Kind by Jepperson For more information about Us click on the "Help Zone" in the brown bar above then go to the “About The Artists” link.

Products

Sort by: Product Price Default
Sterling Silver Cow Skull Cowboy Scarf Slide

Offered here is a handmade, solid sterling silver scarf slide. The background surface of this cowboy scarf slide has been hand hammered by Garth to create a primitive texture. It features a sterling silver cow skull with lasso wrapped


Our price: $65.00
Sterling Silver Cowboy Scarf Slide 1-1/2 Inch
Offered here is a handmade, solid sterling silver scarf slide. The background surface of this cowboy scarf slide has been hand hammered by Garth to create a primitive texture. It features a sterling silver

Our price: $65.00
Sterling Silver Cowboy Scarf Slide 1-1/2 Inch
Offered here is a handmade, solid sterling silver scarf slide. The background surface of this cowboy scarf slide has been hand hammered by Garth to create a primitive texture. It features a brass buffalo head. Measurements

Our price: $65.00