Hi,
Welcome to WixCode.
It sounds as if you just need a column in your database that specifies the region (e.g. New York). When the user selects the region from the dropdown box, you would then filter your database query based on the users selection. The query would then return all row that have the selected region in the region column.
Good luck,
Yisrael