Item Search

Item Number: Search

Price Filter

$ to $ Go

Search Filters

Laminate Wood
Core Wood
Control Rout
Orientation
Contoured Heel
Bridge Rout
Binding
Construction Type
F-hole #
Finish
SearchClear

RSS

Build Your Body Online

In Stock Guitar Bodies

Unfinished Split Jazzmaster® Guitar Bodies

  • NO Exact Results
  • We would be happy to create the item you desire: How To Order
Build Your Body 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, Body_Model.bm_Name, Body_Options_Properties.bop_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 Body_Model ON Body_Model.bm_pkIndex = w_oid6.oid_fk_Option INNER JOIN W_OrderItemsDetails AS w_oid7 ON W_Showcase.ss_Showcase_ID = w_oid7.oid_Serial_Number INNER JOIN Body_Options_Properties ON Body_Options_Properties.bop_pkIndex = w_oid7.oid_fk_Option WHERE (w_oid1.oid_Sequnce_ID = 35) AND (w_oid1.oid_fk_Option = 2) AND (w_oid2.oid_Sequnce_ID = 2) AND (w_oid2.oid_fk_Option = 70) AND (w_oid3.oid_Sequnce_ID = 41) AND (w_oid3.oid_fk_Option = 0) AND (w_oid4.oid_Sequnce_ID = 3) AND (w_oid4.oid_fk_Option = 178) AND (w_oid5.oid_Sequnce_ID = 34) AND (w_oid5.oid_fk_Option = 251) AND (w_oid6.oid_Sequnce_ID = 2) AND (w_oid7.oid_Sequnce_ID = 3) AND (W_Showcase.ss_Date_Sold = 1 / 1 / 1900) ORDER BY ss_Item_Str desc, ss_Item_Num asc