You have received a lot of really good advice here, including;
@millercarbon
If the location is that good, and you are looking for a hobby, then open a coffee shop (serving something better than S'bucks), or a sandwich shop, where you can play good music for your customers and operate a B&M pick-up point for a vinyl web business. Otherwise, in the wise words of: @millercarbon
@millercarbon
No one knows the current worthlessness of the business like the current owner.@noromance
By keeping the name, inventory, and fixtures, he’s not really selling you anything other than an empty store that used to be a record store.@jdane
Minimally, you should ask to see his books in detail and study them carefully.@uncledemp
I think putting together a business plan would be time well spent.All you are getting from this "deal" is the storefront with "ridiculously cheap rent in a good area of town" and a "steady customer base." This guy is doing you no favors if he "will be taking all of his inventory and record storage bins." Without the inventory and bins, all you are doing is renting a storefront and the "business" is worth zero. The customers are already in the area. Sheesh.....he has even become your instant web competitor who is selling his existing inventory from a website he is already advertising from your (future) shop! Duh!
If the location is that good, and you are looking for a hobby, then open a coffee shop (serving something better than S'bucks), or a sandwich shop, where you can play good music for your customers and operate a B&M pick-up point for a vinyl web business. Otherwise, in the wise words of: @millercarbon
Its a rocks in your head thing to do if your goal is income.