select records.id,users.company,records.last,records.first,records.status,records.type,records.make,records.model,records.companyid,SellPrice,[Vehicle Year] from records INNER JOIN users ON records.companyid = users.id where (status='Pick Up' or status='Auction') AutoMarine
Home
About Us
Contact Us
Buyer Information
Browse Inventory
Links
Login
Inventory
We will ship domestical and Internationally.

Search:

Result Pages: 1 |

Make/Model Year Type Price
Chariot / 654 2005 Rv Call
Mercedes Benz / 450 SL 1974 Auto Call
Chevrolet / Classic 2005 Auto Call
Dodge / Magnum 2007 Auto Call
Hi Lo / FunChaser 1994 Rv Call
Dodge / Ram Wagon 2001 Call
Keystone / Raptor 2008 Rv Call
Continental / Cargo 0 Call
Continental / Cargo Trailer 0 Call
Ford / F550 2008 Truck Call
Mitsubishi / Eclipse RS 1998 Auto Call
Hospitality / Hospitality 0 Suv Call
Lancer / 25' Sailboat 1979 Call
Chevrolet / P30 1998 Rv Call

Result Pages: 1 |