Item Search

Item Number: Search

Price Filter

$ to $ Go

Search Filters

Neck Wood
Fingerboard Wood
Nut Width
Orientation Back Contour
Scalloping
Frets
Fingerboard Radius
Binding
Inlay
Quartersawn
String Nut
Neck Finish
Search Clear

RSS

Build Your Neck Online

In Stock Guitar Necks

Finished 24 3/4" Conversion Warhead Guitar Necks

  • NO Exact Results
  • We would be happy to create the item you desire: How To Order
Build Your Neck Online

Filters:
Search by Category or use the Search Filters to narrow the results. Save Search


SELECT W_Showcase.ss_Showcase_ID, W_Showcase.ss_Description, W_Showcase.ss_Date_Sold,W_Showcase.ss_Price_Catagory,W_Showcase.ss_Pounds,W_Showcase.ss_Oz, CAST (ss_Price_Catagory as decimal) AS price, W_Showcase.ss_OnHold, W_Showcase.ss_Date_Added, Headstock_Guitar.hg_Name, Construction_Neck.cn_Name, W_Showcase.ss_Spotlight, W_Showcase.ss_Date_Activated FROM W_Showcase INNER JOIN W_OrderItemsDetails AS w_oid1 ON W_Showcase.ss_Showcase_ID = w_oid1.oid_Serial_Number INNER JOIN W_OrderItemsDetails AS w_oid2 ON W_Showcase.ss_Showcase_ID = w_oid2.oid_Serial_Number INNER JOIN W_OrderItemsDetails AS w_oid3 ON W_Showcase.ss_Showcase_ID = w_oid3.oid_Serial_Number INNER JOIN W_OrderItemsDetails AS w_oid4 ON W_Showcase.ss_Showcase_ID = w_oid4.oid_Serial_Number INNER JOIN W_OrderItemsDetails AS w_oid5 ON W_Showcase.ss_Showcase_ID = w_oid5.oid_Serial_Number INNER JOIN W_OrderItemsDetails AS w_oid6 ON W_Showcase.ss_Showcase_ID = w_oid6.oid_Serial_Number INNER JOIN W_OrderItemsDetails AS w_oid7 ON W_Showcase.ss_Showcase_ID = w_oid7.oid_Serial_Number INNER JOIN Headstock_Guitar ON Headstock_Guitar.hg_pkIndex = w_oid7.oid_fk_Option INNER JOIN W_OrderItemsDetails AS w_oid8 ON W_Showcase.ss_Showcase_ID = w_oid8.oid_Serial_Number INNER JOIN Construction_Neck ON Construction_Neck.cn_pkIndex = w_oid8.oid_fk_Option WHERE (w_oid1.oid_Sequnce_ID = 35) AND (w_oid1.oid_fk_Option = 1) AND (w_oid2.oid_Sequnce_ID = 1) AND (w_oid2.oid_fk_Option = 89) AND (w_oid3.oid_Sequnce_ID = 22) AND (w_oid3.oid_fk_Option = 305) AND (w_oid4.oid_Sequnce_ID = 41) AND (w_oid4.oid_fk_Option = 1) AND (w_oid5.oid_Sequnce_ID = 4) AND (w_oid5.oid_fk_Option IN (1,2,3,4,17)) AND (w_oid6.oid_Sequnce_ID = 34) AND (w_oid6.oid_fk_Option = 310) AND (w_oid7.oid_Sequnce_ID = 1) AND (w_oid8.oid_Sequnce_ID = 2) AND (W_Showcase.ss_Date_Sold = 1 / 1 / 1900) ORDER BY ss_Item_Str desc, ss_Item_Num asc