Limited-Time Promotion

Puffco 4/20 Wholesale Sale

Save 10% on select Puffco devices & 20% on select accessories

Applies to eligible Puffco products only. Not all Puffco items are included. Eligible Puffco items only.

Shop Puffco Sale

11" Colored Neon Marble Sherlock Pipe – P2795

MSRP: $43.99
Was: $10.95
Wholesale: $9.95
You save $34.04
Sale 77%
SKU:
P2795
In Stock & Ready To Ship!
Current Stock:Only left: 45

Frequently Bought Together:

Total: Inc. Tax
Total: Ex. Tax

Description

Why Retailers Stock It

Extra-long hand pipes—especially ones that pop with neon color—draw a crowd in any showcase. At 11.5 inches, this Gandalf-style Sherlock gives customers the cooling draw of a water pipe without the cleaning commitment, while its bright solid-glass body and dotted marble accents shout “artisan” from across the counter. Because SPS offers single units or a low-risk bundle of two, stores can top up a lonely peg hook or reload an entire grab-jar before the weekend rush—no cash trapped in slow movers.

MSRP $39.99 – $43.99 per unit

Key Features & Specs

  • Purchase options: single 1 countbundle of 2
  • Length: approx. 11.5″ • Weight: approx. 125 g
  • Material: durable colored borosilicate glass with neon marble bowl studs
  • Design: long, gently curved Sherlock stem for cooler smoke and eye-level display impact
  • Stabilizing glass ring accents double as grip points and natural heat sinks
  • Ships in assorted solid hues—royal blue, lavender, jade green, ruby red and more
  • SKU P2795 • Style: dry-herb Sherlock hand pipe

Wholesale Perks

  • Shelf-ready packaging—no re-bagging or labelling needed on arrival
  • Fast California shipping plus $100 minimum keeps re-stocks cash-flow friendly
  • No import tariffs—100 % of landed cost stays in your margin column

Display & Upsell Ideas

  • Lean one pipe on a small riser so shoppers see the marble accents acting as anti-roll feet—instant durability demo.
  • Merchandise pipe screens, silicone stem caps, and Formula 420 cleaner nearby to build effortless add-on bundles.

Care

  • Rinse after demos; for deeper cleans, recommend Formula 420 as a quicker, odor-free alternative to isopropyl alcohol.
  • Avoid abrasive pads that could scratch the colored finish or knock off marble accents.

Stock up today and keep your shelves ready for demand.

Extra Information

Size:
11.5"
Weight:
125g
Style:
Sherlock

Shipping & Delivery

Shipping & Delivery

ETA: Most orders arrive in 3–8 business days (business days only)
Processing: Ships in 2 business days or less from CA
Free Ship: $750+ on eligible items (AK/HI, COD, expedited & excluded items/brands excluded)
UPS Ground time-in-transit map from California origin
Guide only. Transit times are business days and not guaranteed; holidays and weather can add time.
Where & how we ship

UPS Ground to the 50 U.S. states. Orders typically leave our CA warehouse within 2 business days or less.

Rates & thresholds
  • Orders $750+ qualify for free UPS Ground on eligible items within the contiguous U.S. (AK/HI, COD, expedited services, and excluded items/brands are not eligible).
  • Mixed carts: If your order contains excluded items/brands, free shipping may still apply to eligible items, but shipping charges will apply to excluded items as shown in cart/checkout.
  • Under $750: weight-based rates shown in cart/checkout.
  • Expedited options (when available) are offered at checkout but are not eligible for free shipping.
  • UPS rounds up to the next full pound.
  • See full Free Shipping & Sale Info for exclusions and any limited-time sale details.
Returns & claims
  • 30-Day Returns: New/unused. We cover return freight if it was our mistake; restocking may apply over $500 or for careless repack.
  • Damages: Report within 14 days of delivery with photos, your invoice #, and the product code to claims@spswholesale.com.
  • Missing/Pack errors: Tell us within 2 days of delivery; we record pack-out video to resolve quickly.
Peak-season planning

See our current Holiday Order-By Dates & UPS Transit Map.

Quick Answers

Do I have to be a business to order?

Yes. We sell wholesale to businesses. A tax ID / reseller permit may be required in certain states.

Do you offer drop-shipping?

Yes. We support drop-ship fulfillment through our dropshipping program (powered by Crowdship), so orders can ship directly from our warehouse to your customers. Learn how our dropshipping program works.

Do you ship internationally?

Not directly. We currently ship UPS Ground within the 50 U.S. states.

Why am I seeing shipping charges on a $750+ order?

Some items/brands are excluded from free shipping due to carrier and handling costs. If your order contains excluded items, free shipping may still apply to eligible items, but shipping charges will apply to excluded items as shown at checkout.

Estimates are based on typical handling times and UPS Ground guidance. Transit is measured in business days and is not guaranteed. Check carrier holiday schedules for non-operational days.