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
" Winners never quit and quitters never win. "
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?
Sassafras albidum - Sassafras
Sassafras albidum - Sassafras
Tell A Friend

Tell someone you know about this product.
Top » Catalog » CACTUS » » San Pedro Cactus - Rooted Specimen Cacti


San Pedro Cactus - Rooted Specimen Cacti: We have a limited number of San Pedro Cactus with multiple branches available. They are all rooted with several branches. They are approximately 18 to 24 inches tall with about 4 total feet of cactus (total length from all branches).

For the time being, we are not selling San Pedro Cactus (Trichocereus Pachanoi).
We are proud to have partnered with MrBotanicals.com, You can purchase San Pedro Cactus (Trichocereus Pachanoi) by Clicking Here.
Option Price Quantity
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 = '257' and opa.orders_id = opb.orders_id and opb.products_id != '257' 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]