osCommerce My Account  Cart Contents  Checkout  
  Top » Catalog » Hardware » Stretch Headbands » My Account  |  Cart Contents  |  Checkout   
Categories
COLOR MATCHES
SHIPPING SCHEDULE
Solid Grosgrain
Cheer & Sports
Grosgrain Dots
Grosgrain Stripes
Holiday Ribbon
Novelty Prints
Sheer Organza
Stitched Ribbon
Hardware
  Alligator Clips
  French Barrettes
  Plastic Hair Clips
  D-Rings
  Snap Clips
  Bow Display Cards
  Pony O's
  Stretch Headbands
FULL ROLLS
Korker Bow Tips
What's New? more
3/8" Hot Pink Peace Sign Print Grosgrain Ribbon
3/8" Hot Pink Peace Sign Print Grosgrain Ribbon
$1.75
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
2.5" Yellow Stretchy Nylon Headband $0.85

***Very Limited Quantities***

These lightweight Yellow headbands are perfect for babies through older girls! They are incredibly stretchy, made from a thick nylon. 2.5" Wide, 100% Nylon, not made from pantyhose. Price is for one headband.
This product was added to our catalog on Tuesday 03 July, 2007.
Reviews
1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '1243' and opa.orders_id = opb.orders_id and opb.products_id != '1243' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]