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='626' 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='626' 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
Specials

Closeouts

To be notified of sales, and New Products  Like us on Facebook Like us on facebook or Follow us on Google+ google+

All items in this section are being closed out, and are only available while supply lasts.

Products

Sort by: Product Price Default
Western Handbag Mossy Oak and Bling Design by Nocona Mid Size

Offered here is a mid sized Nocona Western handbag. The outside is a man made soft feeling material with a mossy oak print design. Silver colored studs and rhinestones are used to accent the strap. It has a 10-1/2 inch long strap that adjusts to 14 inches long by a buckle at each end and is accented with studs and rhinestones. This mossy oak handbag measures 11-1/2 inches wide and 7-1/2 inches tall, The base of this

WHILE SUPPLIES LAST...


Our price: $51.99
Market price: $65.00 save 20%
Western Handbag Mossy Oak and Bling Design by Nocona Small

Offered here is a small Nocona Western handbag. The outside is a man made soft feeling material with a mossy oak print design. Silver colored studs and rhinestones are used to accent the strap. It has a 19 inch long strap is accented with studs and rhinestones, and is permanently attached to the bag with no adjustment. This mossy oak handbag measures 12-1/4 inches wide and 7-1/2 inches tall, The

WHILE SUPPLIES LAST...


Our price: $47.99
Market price: $60.00 save 20%
Cowgirl Cross and Turquoise Belt by Nocona Size-42-XLg

These cowgirl belts featuring a cross are beautiful. These 1-1/2 inch belts are a dark chocolate brown leather with a stamped and highlighted floral pattern which includes a cross from time to time. These cowgirl belts also have a beautiful buckle featuring a large silver colored cross surrounded  CLOSEOUT Size-42-XLg

WHILE SUPPLIES LAST...


Our price: $30.99
Market price: $39.00 save 21%
Cowgirl Rhinestone Belt Turquoise Cross BLING by Nocona Size-42 inch-XLarge

These cowgirl rhinestone belts made by Nocona are eye catchers! These 1-1/2 inch belts are black in color with an alligator stamped design in the leather. Man made turquoise colored nuggets are featured everywhere on this belt along with some silver colored beads and blue glass beads, and don't forget the crosses that are outlined with rhinestones! Big rhinestones, small rhinestones, and silver
CLOSEOUT Size-42 inch-XLarge ( only 1  left )

WHILE SUPPLIES LAST...


Our price: $67.99
Market price: $85.00 save 20%