<%@ LANGUAGE="VBScript.Encode" %> <% order = Session("orderid") 'READ STUFF From Database Dim objSimpleAdo, rstRS, SQLStmt SQLStmt = "SELECT * From item " SQLStmt = SQLStmt & "WHERE [Orderid] =" & Order & "; " Set SimpleAdo = New CSimpleAdo SimpleAdo.setConnectionString = Session("ConnectionString") Set RS = SimpleAdo.getRecordSet(SQLStmt) 'Do stuff with the record set 'Initialize variables for this application thedate = Cstr(Date) 'get the date thetime = Cstr(Time) 'get the time subtotal = 0 'the subtotal for a row of items subweight = 0 'the subweight for a row of items subsize = 0 'the subsize for a row of items subquantity = 0 'the subquantity for a row of items CurrentRecord = 0 Do While CheckRS(RS) 'Calculate the individual totals for a row subweight = subweight + (RS("Quantity") * RS("Weight")) subsize = subsize + (RS("Quantity") * RS("Size")) subtotal = (RS("Quantity") * RS("Price")) subquantity = subquantity + RS("Quantity") total = FormatCurrency (CCur(subtotal)) grandtotal = grandtotal + subtotal RS.MoveNext Loop Set SimpleAdo = Nothing Set RS = Nothing %> Add Ons Clearance

Click On Arrow To Enter

 

[photogallery/photo00003942/real.htm]

Visit our newest Salon & Spa at

 https://id415.van.ca.siteprotect.com/studiohair.com/merchantmanager/index.php?mmsid=fe74c528db756d39c104e8c5e756ce62

 

 

 

The On-Line Salon

Studio Hair®

Wigs * Hair Pieces* Hair Extensions*The Intra-Weave Hair System

Visit Our New Salon At

 
Click On Arrow To Enter

 

 

 

Items on this page are one of a kind over stock, available only while supplies last!

Please note that the items on this page are selling so quickly it is difficult keeping up with sold out items on an hourly basis.
Place your orders now, when you return to this page the item may be sold out!

Please Note: All sales are final on all closeout and clearance items, no returns or exchanges

Ten Piece Clip-In Extensions Raquel Welch Clip-In Extensions are offered in two different hair lengths-14"

Widths in Set:
Four pieces - 1 1/2" wide
Two pieces - 6" wide
One piece - 7" wide
One piece - 8" wide Two 1" wide strips for testing perm and color

These extensions have been specially processed so that they can be colored and/or permed and cut to match any client's needs

14" Their Retail Price $229.00 clearance Price $94.66 color
14" Their Retail Price $229.00 clearance Price $94.66 color

Look of Love Hairpieces - 101 Braided Headband - Price: $32.00Braided Headband
Summary: Features a special fiber blend for a natural look.
Description: A beautiful way to hold your hair back away from your face. Features a 4-section weave to create this hand-made headband.
Width: Approx 1" 1¼"
Sizes: One Size

Retail: $42.00  Clearance Price $15.00

A PULL THROUGH PIECE THAT PROVIDES FULLER, HEALTHIER LOOKING HAIR,  AN INSTANT FROST- OR BOTH!
33-Dark Auburn  Closeout Price $8.33
27-light Auburn  Closeout Price $8.33

 Length: 7 1/2"to 8"
The hair illusion is a strip of hair with Velcro along the edge. It attaches to your hats to simulating a long straight bob.
Style: # 616    Hair Illusion   clearance $6.66 color 33-Dark Auburn 

Domed Based Braided Chignon
Style:
116
 Our Price: $97 clearance $36.33 color#25BMed. Golden Blonde

Made by hand by sewing a long braided switch onto a concave base that attaches with a series of flex combs. Quick and simple: pull own hair to back area of head into a couple of pin curls. Place dome base over own hair and slide in combs. This piece can be worn horizontal or vertical.

Hair-B-Tweenz 100% Human Hair Integration Hairpiece

 HBT-Elite-6H 

The Hair-B-Tweenz Elite Human Hair Integration hairpiece is new to the collection offering greater styling versitility. Because it is made from 100% human hair, you can curl using hot irons or rollers.
The unique hand crocheted multi-directional technology allows for greater versatility in styling, including "closer to the head" styles. The root direction can actually turn to now flow in with your own hair style.
bulletIntegration Pull-thru Base Design
bullet100% Human Hair @ 6" FHL
bullet100% hand ventilation technology
bulletHand tied interval strips with spaces to incorporate own hair. Approx. ¼" x 4½" ea.
bulletTotal base size approx. 2" front-to-back and 4½" side-to-side.
bulletHuman hair can be styled with curling irons, rollers, etc.
Red Tag Price: $36.66 color #8
Red Tag Price: $36.66 color #10

   Style:   Pony Switch
Hair Length:   27"   Weight: 4. oz.
Pony Switch has an elastic attachment. 
( Can Be Braided)

Original Price: $60.00
Red Tag $22.33

color # 27 light red
color # 12 pecan
color # 1R Midnight
color # 1R Midnight
color # 1R Midnight
color # 1R Midnight
color # 1R Midnight
color # 1R Midnight

     (Click on photo to view full size image)  Style: 618      Playmate Soft fiber  $75.oo
 Hair Length 3 3/4" - 4 1/2"  Base Size  10" x 10 1/2" Base is optional pull thru
clearance price $37.66 color #38

Style:  #159  Our extra coverage HoneyComb hairpiece extends a little deeper and wider than our Basic Wiglet/Filler piece. It features handtied edges so the hair flows in naturally with your own. Features a flexible soft base design.
bulletHair length: 4" (10.2cm) to 4½" (11.4cm)
bulletBase size: 6" (15.2cm) across, 6" (15.2cm) front to back
bulletAttachment: 2 snap comb clips and 2 wire flex combs
bulletWeight: ¾ oz
bulletCurl pattern: pre-curled, with basic roller set
bulletMade of Kanekalon Fiber Blends

clearance price $27.66 color #30med. red

Add beautiful curls with charm and elegance to the back crown area of your coiffure. The base design is contoured to fit from the crown to the nape areas with a beautiful sculptured curl pattern as shown. Features a light weight skin base construction for impeccable naturalness. Hair Length: 10 1/2"  Weight:  2 1/2  oz. Made of Kanekalon Fiber Blends

  Style:   216  (Suggested Retail   $ 89.oo)

Color # 30/130Med.and Flame Red Red Tag $23.33

HBT-TTS (Temple - To - Temple Shag)   (Suggested Retail   $ 150.oo)
*100% Kanekalon fiber blend    *Pre-curled  in soft  smooth wave  Pattern  * 5  Elastic wefts stretch completely around head, from temple to temple.
*Attachment: Series of snap comb clips (placement of clips may vary) Hair length is layered with 3 different lengths (from top) 8", 12" & 16"
color 22N Red Tag $23.66

Style   BFM - 303          (Suggested Retail   $ 115.oo)
Pinch - On Pony Tail Hair length: 15"       Medium size butterfly clip;         Soft natural curl;          Made of Kanekalon Fiber Blends

Red Tag $27.33 Color # 27B Strawberry Blonde

The Layered Pinch- On Shag
A beautifully layered, softly waved pony tail that gracefully flows around the head when attached at the crown, instantly offering a younger appearance. Style   BFM - 280 9"-15"        (Suggested Retail   $ 125.oo)
Hair length: 9" to 15"  Soft wave as shown;      Medium size butterfly clip .       Made of Kanekalon Fiber Blends
Red Tag $33.33 color # 32
Red Tag $33.33 color # 14/24Lt.Blonde/med. sandy blonde

The Barretted Chignon
Tortoise shell barrette in Brown.
 
Hair Length 7"  Weight: 1-1 3/4 oz
style:
# 235     (Suggested Retail   $ 105.oo)

Red Tag $28.33 color #4 Med. Dark Brown

Pageboy Pony Butterfly Style   BFM - 235 (Suggested Retail   $ 95.oo)
Our elegant shorter pony tail chignon can glamorize even the most basic heads of hair in just minutes. Pinches on the same way you would use a regular butterfly clip! Hair length:5" to 10"       Medium size butterfly clip;      Comes pre-curled as shown;    Made of Kanekalon Fiber Blends

Red Tag $13.33(Color # 30 Med. Natural Red)
Red Tag $13.33 color #59 light blonde grey with 5% grey

 

Pinch - On Pony Tail

Style   BFM - 310 Our Price  $72.00
Clearance Price:
$23.33 color # 14/24f
Light Gold / Sandy Med. blondes

This unique Look of Love instant hair extension adds length to your own hair in just minutes. But this hairpiece is different...it's two styles in one!
We created this style for the woman who likes versatility. This gorgeous hairpiece can be clipped on to your own hair to create a long all-one-length ponytail or turn it upside down to get a longer layered look. Now, with just one piece, you can have two totally different styles to choose from!
Reversible Long Ponytail and Shag

bulletHair length: 17" (43.2cm) to 22" (55.9cm)
bulletCurl pattern: soft and straight with slightly curled under ends, as shown
bulletMedium butterfly clip 3¾" (9.5cm)
bulletMade of Kanekalon fiber

Medium Size Chignon Style: BFM - 301 (Suggested Retail   $ 98.oo)
5 - 5 1/2" Hair length Pre-curled as shown; Medium size butterfly clip inside hairpiece. Made of Kanekalon Fiber Blends

Red Tag $12.05 (Color # 30 Med. Natural Red)

Please Note: All sales are final on all closeout and clearance items, no returns or exchanges

Style: Touch
Their Retail Price $29.00Hair wrap on an elastic band that can be styled casually around a ponytail or exquisitely around a bun.

Red Tag $4.33Color R22 (Swedish Blonde)

style: UpDo (Magic Comb)
Our On-Line Price
$34.oo
A beautiful burst of barely waved hair on a patent pending Magic Comb.

Red Tag $8.33 color 8/25

 

Style:  Feather Wrap by Put On Pieces  HairpiecesFeather Wrap Hair Length: over all 5 1/2"
Their Retail Price $14.00 Red Tag $3.33
A short, feathery hair wrap on an elastic band that turns a plain ponytail or bun into fanciful style.

Color R22 (Swedish Blonde)

Please Note: All sales are final on all closeout and clearance items, no returns or exchanges

VoilaStyle:  Voila Retail Price $52.00
Subtly layered waves on a claw clip attachment.
Made of Kanekalon Fiber

Color R29S (Glazed Strawberry) Red Tag $3.33

 (after)  Style: Hair Match
 
Enhance the look of your own hair with these wiglets for added height and volume.
 Attaches with 4 wirer combs.

Original Price: $59.oo
Made of Kanekalon Fiber Blends
Base Size:  8 x 5 3/4'    Weight: 1.3 oz. Hair Length: 3 1/2"

Hair Match  color# 101 (platinum blonde) Red Tag $3.33

Please Note: All sales are final on all closeout and clearance items, no returns or exchanges

 

For Questions E-Mail:  TheStylist@StudioHair.net

To order by phone, you can speak to one of our stylists at 415-642-9447 Tues - Sat 10 AM-5PM.

 

Our On-Line Salon is staffed by licensed stylists, not telemarketers or sales people. 

Enjoy your visit !

 

Designed by
Studio Hair ®

Studio Hair©