Is there a way to find out where the nearest one is?
You are probably going to want the least flashy of the results, as all that flash comes at an expense ;)
I know that there are at least 2 good ones in Chicago and another that sells used hotel furniture (which I am not sure that I would willingly go into, but apparently there is a market for such things...).
These places are very much business-focused; it's not like walking into an IKEA. You'll probably have to get buzzed in through many doors and then sign in, where you'll be asked for both your name and business. If you don't have a business they aren't going to throw you out or anything, but probably ask you to write something like "<First Name><Last Name> LLC" so they can put you in their system. You probably have to get escorted to the sales floor but are free to wander around. You have to pay in full for what you want, up front, but will get issued an invoice and bill of sale as if you are a business (from their point of view, they aren't selling anything to you, they are selling to the business you are representing).
My best finds for second hand goods were found by intentionally searching obscure marketplaces. Telling a few ppl on HN probably wouldn’t make much of a difference, making a viral TikTok video about it might.
You can pick up beverage glasses and cups, plates, silverware.
This is the place I generally use, but simply because it is most convenient for where I live (it's about 3 blocks south of I-290 at the Cicero Ave exit)