Item Search

Item Number: Search

Price Filter

$ to $ Go

RSS

Build Your Body Online

In Stock Bodies

Screaming Deals

Same Great Warmoth Quality At Even Lower Prices

Results Per Page:
Compare Selected Items Search by Category or use the Search Filters to narrow the results. Save Search
4 lbs, 4 oz
ps6676
Vintage Replacement Strat® Body
Screamin' Deal


Specs: Alder, Top Rout, Drilled for Vintage Strat® Flat Mount, Strat® Top Jack Rout Jack, Black-Red-Yellow Burst Finish with a Black-Red-Yellow Burst back finish

Regular Price$405.00
Price
$305.00
Buy


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 Body_Model ON Body_Model.bm_pkIndex = w_oid4.oid_fk_Option INNER JOIN W_OrderItemsDetails AS w_oid5 ON W_Showcase.ss_Showcase_ID = w_oid5.oid_Serial_Number INNER JOIN Body_Options_Properties ON Body_Options_Properties.bop_pkIndex = w_oid5.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 = 81) AND (w_oid3.oid_Sequnce_ID = 34) AND (w_oid3.oid_fk_Option = 251) AND (w_oid4.oid_Sequnce_ID = 2) AND (w_oid5.oid_Sequnce_ID = 3) AND W_Showcase.ss_Spotlight IN (3,4) AND (W_Showcase.ss_Date_Sold = 1/1/1900) ORDER BY ss_Date_Activated DESC