Phone: 972-241-9771
0
items
Home
About Us
Contact Us
Sales Policy
My Account
Log In
WHAT'S NEW
GRAPHIC TEES
WATCH BAND/ GIFT ITEMS
RED,WHITE, AND BLUE
PINK COWGIRL
GAMEDAY
RHINESTONE I CUBIC ZIRCONIA
INITIAL JEWELRY
KIMONO I SCARVES
HANDBAGS
MONTANAWEST BAGS
WESTERN PURSES
CROSSBODY BAGS
TRINITY RANCH BAGS
MENS WALLETS I SMALL ACCESSORIES
NECKLACES
EARRINGS
BRACELETS
RINGS
TURQUOISE JEWELRY
PHONE ACCESSORIES
HATS I HAIR ACC
BELTS
SPORTS THEME
SALE ITEMS
SELECT count(*) FROM product WHERE FIND_IN_SET('232',cats) AND isactive=0 and remove_ready=1
