|
Add to Cart |
Name |
Size |
Count |
Availability |
Price |
 |
Acid
Cold Infusion Tea |
6 3/4 x 44 |
Single Stick |
Available
|
5.26 |
 |
Acid
Kuba Kuba
Deluxe Tube |
6 x 50 |
Single Stick |
Available
|
5.70 |
 |
Acid
Liquid |
5 x 50 |
Single Stick |
Available
|
4.52 |
 |
Acid
Nasty |
4 x 52 |
Single Stick |
Available
|
3.28 |
 |
Acid
Roam |
7 x 48 |
Single Stick |
Available
|
5.68 |
 |
Ambrosia
Mother Earth |
6 x 50 |
Single Stick |
Available
|
4.54 |
 |
Ambrosia
Nectar |
5 x 42 |
Single Stick |
Available
|
3.64 |
 |
Ambrosia
Spice |
5 x 54 |
Single Stick |
Available
|
4.53 |
 |
Ambrosia
Triple Corona |
7 x 50 |
Single Stick |
Available
|
4.89 |
 |
Ambrosia
Vann Reef |
5 x 50 |
Single Stick |
Available
|
4.42 |
 |
Arturo Fuente
Spanish Lonsdale |
6 1/2 x 42 |
Single Stick |
Available
|
2.65 |
 |
Ashton
8-9-8 |
6 1/2 x 44 |
Single Stick |
Available
|
6.82 |
 |
Astral
Beso |
5 x 52 |
Single Stick |
Available
|
3.18 |
 |
Astral TVS
Toro |
6 x 50 |
Single Stick |
Available
|
3.49 |
 |
Big Butt
Don Gordo
Maduro |
6 x 54 |
Single Stick |
Available
|
2.90 |
 |
Brazilia
Amazon |
6 x 60 |
Single Stick |
Available
|
5.68 |
|
 |
C.A.O
Criollo
Pampa |
4 x 40 |
Single |
Available
|
3.55 |
|

|
C.A.O
Criollo
Mancha |
5 5/8 x 46 |
Single |
Available
|
5.45 |
|
 |
C.A.O
Criollo
Pato |
4 7/8 x 50 |
Single |
Available
|
4.60 |
|
 |
C.A.O
Criollo
Conquistidor |
6 1/8 x 52 |
Single |
Available
|
6.05 |
 |
Cuban Parejo
Epicure
Rosado |
6 x 62 |
Single Stick |
Out Of Stock
|
5.17 |
 |
Cuesta Rey
Aristocrat |
7 1/4 x 48 |
Single Stick |
Available
|
5.56 |
 |
Cuesta Rey
Pyramid |
6 x 52 |
Single Stick |
Available
|
5.43 |
 |
Don Diego
Babies |
5 1/8 x 33 |
Single Stick |
Available
|
.93 |
 |
Don Diego
Reserve Bellicoso |
7 x 52 |
Single Stick |
Out Of Stock
|
4.97 |
 |
Don Sebastian
Toro |
6 x 50 |
Single Stick |
Available
|
1.48 |
 |
Don Tomas
Robusto |
5 1/2 x 50 |
Single Stick |
Available
|
2.13 |
 |
Don Tomas
Cameroon
Perfecto #2 |
5 x 48 |
Single Stick |
Available
|
2.73 |
 |
Esse
Vanilla |
5 1/2 x 40 |
Single Stick |
Available
|
1.42 |
 |
Excalibur
#1 |
7 1/4 x 54 |
Single Stick |
Available
|
4.81 |
 |
Excalibur
#1 Maduro |
7 1/4 x 54 |
Single Stick |
Available
|
4.81 |
 |
Exodus 1959
Robusto |
5 x 52 |
Single Stick |
Available
|
3.18 |
 |
H. Upmann
Churchill |
5 5/8 x 46 |
Single Stick |
Available
|
3.84 |
 |
H. Upmann
Toro |
6 x 50 |
Single Stick |
Available
|
4.54 |
 |
H. Upmann H2000
Corona Larga |
6 3/4 x 44 |
Single Stick |
Out Of Stock
|
4.00 |
 |
Hoyo de Monterey
Dark Sumatra
Ebano |
6 x 45 |
Single Stick |
Available
|
3.56 |
 |
Hoyo de Monterey
Dark Sumatra
Espresso |
4 1/2 x 50 |
Single Stick |
Available
|
3.11 |
 |
Hoyo de Monterey
Dark Sumatra
Media Noche |
5 3/4 x 54 |
Single Stick |
Available
|
3.91 |
 |
Hoyo de Monterey
Dark Sumatra
Noche |
6 1/2 x 52 |
Single Stick |
Available
|
4.22 |
 |
Joya de Nicaragua
Celebracion
Churchill |
6 7/8 x
48 |
Single Stick |
Out Of Stock
|
2.96 |
 |
La Aroma de Cuba
Corona Minor |
4 1/2 x
44 |
Single Stick |
Out Of Stock
|
3.20 |
 |
La Aroma de Cuba
Double Corona |
7 1/2 x
52 |
Single Stick |
Available
|
4.33 |
 |
La Aroma de Cuba
Monarch |
6 x 50 |
Single Stick |
Available
|
3.88 |
 |
La Aroma de Cuba
Robusto |
5 x 54 |
Single Stick |
Available
|
3.67 |
 |
La Unica Cameroon
Churchill #2 |
6 1/2 x 50 |
Single Stick |
Out Of Stock
|
5.06 |
 |
La Unica Cameroon
Robusto #4 |
4 1/2 x 52 |
Single Stick |
Out Of Stock
|
4.32 |
 |
La Unica Cameroon
Torpedo #1 |
5 5/8 x 55 |
Single Stick |
Out Of Stock
|
5.63 |
 |
Macanudo Cafe
Hampton Court |
5 3/4 x 43 |
Single Stick |
Available
|
4.22 |
 |
Macanudo Cafe
Portofino |
7 x 36 |
Single Stick |
Available
|
4.22 |
 |
Macanudo Cafe
Rothchild |
6 1/2 x 42 |
Single Stick |
Available
|
4.22 |
 |
Macanudo Gold
Duke of York |
5 1/4 x 54 |
Single Stick |
Out Of Stock
|
4.96 |
 |
Macanudo Gold
Lord Nelson |
7 x 49 |
Single Stick |
Out Of Stock
|
5.33 |
 |
Macanudo Gold
Shakespeare |
6 1/2 x 45 |
Single Stick |
Out Of Stock
|
4.52 |
 |
Macanudo Robust
Hampton Court |
5 3/4 x 43 |
Single Stick |
Available
|
4.22 |
 |
Macanudo Robust
Prince Philip |
7 1/2 x 49 |
Single Stick |
Available
|
5.49 |
 |
Macanudo Robust
Rothchild |
6 1/2 x 42 |
Single Stick |
Available
|
4.22 |
SQL = "SELECT * FROM Inventory WHERE Field2 = 'MC6050'"
oRs.Open SQL, oConn, adOpenDynamic, adLockReadOnly
%>
 |
Montecristo #2 (Torpedo) |
6 x 50 |
Single Stick |
Available
|
9.75 |
 |
Montecristo
Double Corona |
6 1/4 x 50 |
Single Stick |
Available
|
7.131 |
 |
Montecristo
Robusto |
4 3/4 x 50 |
Single Stick |
Out Of Stock
|
6.75 |
 |
Montesino
Napoleon Grande
|
7 1/2 x 46 |
Single Stick |
Available
|
1.72 |
 |
Montesino
Gran Corona
Maduro
|
6 3/4 x
48 |
Single Stick |
Available
|
3.40 |
 |
Natural
Dirt |
4 x 43 |
Single Stick |
Available
|
2.88 |
 |
Natural
Green Hero |
6 1/2 x 54 |
Single Stick |
Out Of Stock
|
4.67 |
 |
Natural
Root |
5 x 55 |
Single Stick |
Available
|
4.53 |
 |
CAO Odyssey
Limited Edition |
6 3/4 x 55 |
Single Coffin |
Call For Availability |
15.00 |
 |
Partagas #1 |
6 3/4 x 43 |
Single Stick |
Out Of Stock
|
4.84 |
 |
Partagas
Sabroso |
5 1/8 x 44 |
Single Stick |
Available
|
4.76 |
 |
Punch
Rothchild |
4 1/2 x 50 |
Single Stick |
Available
|
2.83 |
 |
Romeo y Julietta
Cedro Deluxe #1 |
6 1/2 x 44 |
Single Stick |
Available
|
3.84 |
 |
Romeo y Julieta
Clemenceau en Tubo |
6 x 50 |
Single Stick |
Available
|
4.48 |
 |
Romeo y Julieta
Habano #2 |
7 x 52 |
Single Stick |
Out Of Stock
|
4.26 |
 |
Romeo y Julieta
Numero Dos
Tubes |
6 1/4 x 52 |
Single Stick |
Available
|
5.55 |
 |
Romeo y Julieta
Petite Numero Dos
Tubes |
5 x 52 |
Single Stick |
Available
|
4.69 |
 |
Romeo y Julieta
Romeos Court
Tubes |
5 x 44 |
Single Stick |
Available
|
4.26 |
 |
Romeo y Julieta
Rothchilde en Tubo |
5 x 50 |
Single Stick |
Available
|
4.26 |
 |
Romeo y Julieta
Toro |
6 x 50 |
Single Stick |
Out Of Stock
|
3.69 |
 |
Sancho Panza
Dulcinea |
6 1/4 x 54 |
Single Stick |
Available
|
3.50 |
 |
Sancho Panza
Valiente |
5 1/4 x 50 |
Single Stick |
Available
|
2.60 |
 |
Sancho Panza
Caballero |
6 1/4 x
45 |
Single Stick |
Available
|
2.47 |
 |
Sancho Panza
Primoroso |
6 3/4 x
47 |
Single Stick |
Available
|
3.03 |
|