Warning Warning: I am able to write to the configuration file: /home/herbalf/public_html/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.

PLEASE NOTE:

THIS IS OUR OLD WEBSITE - IT'S NOT POSSIBLE TO PURCHASE FROM THIS SITE.
SOME OF THE PRODUCTS & PLANTS ARE NO LONGER AVAILABLE.

PLEASE CLICK HERE TO REDIRECT
TO OUR NEW STORE AT
HerbalFire.com

Homepage
What's New?
Wholesale
Payment & Shipping
Log In
Contact Us
" A good rest is half the work. "
Shopping Cart (0 items)
Categories
Quick Find
Use keywords to find the product you are looking for.
Advanced Search
Information
TOP 30 - Bestsellers
Affiliate Program
What's New?
Macropiper Excelsum - Kawa Kawa
Macropiper Excelsum - Kawa Kawa
Tell A Friend

Tell someone you know about this product.
Top » Catalog » CACTUS » » Trichocereus Brevispinulosus Cactus


Trichocereus brevispinulosus Cactus

Trichocereus brevispinulosus

Trichocereus brevispinulosus is a beautiful Trichocereus cactus. Not seen very often. We think that most all of the Trichocereus brevisinulosus in the US today are decended from a couple of cacti brought from S.America in 1983 by Karl Knize.

We have heard rumors that these rare cactus are very intelligent. We dont know about that, but Trichocereus brevispinulosus are definately interesting and lovely.

6 inch and 12 inch Trichocereus brevispinulosus cuttings.

Option Price Quantity
8-10" inch Cactus $20.00
Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'herbalf_osc1.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '248' and opa.orders_id = opb.orders_id and opb.products_id != '248' 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]