Item Search

Item Number: Search

Price Filter

$ to $ Go

Search Filters

Laminate Wood
Core Wood
Control Rout
Contoured Heel
Bridge Rout
Construction Type
F-hole #


In Stock Bass Bodies

Spotlight Bodies

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

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 Body_Model ON Body_Model.bm_pkIndex = w_oid5.oid_fk_Option INNER JOIN W_OrderItemsDetails AS w_oid6 ON W_Showcase.ss_Showcase_ID = w_oid6.oid_Serial_Number INNER JOIN Body_Options_Properties ON Body_Options_Properties.bop_pkIndex = w_oid6.oid_fk_Option WHERE (w_oid1.oid_Sequnce_ID = 35) AND (w_oid1.oid_fk_Option = 2) AND (w_oid2.oid_Sequnce_ID = 41) AND (w_oid2.oid_fk_Option = 0) AND (w_oid3.oid_Sequnce_ID = 8) AND (w_oid3.oid_fk_Option = 33) AND (w_oid4.oid_Sequnce_ID = 34) AND (w_oid4.oid_fk_Option = 252) AND (w_oid5.oid_Sequnce_ID = 2) AND (w_oid6.oid_Sequnce_ID = 3) AND W_Showcase.ss_Spotlight IN (2,4) AND (W_Showcase.ss_Date_Sold = 1/1/1900) ORDER BY ss_Item_Str desc, ss_Item_Num asc