Look-up Field and Database-Like Display

Does anybody know if it's possible, and if so which add on products you need, to create a front facing user site that has a place to basically input or select a value, and then view data dynamically being pulled from a source sheet for just that value? The use case is that we have a lot of properties, so wanting to create a drop-down with our properties, then when you select one the page shows you values related to that property from a source sheet (address, property manager, phone number, property type, etc). Ideally we'd like to have flexibility to place the values on a page to look like a webpage, where we can group certain fields together and maybe embed a report that is filtered to show only values for that select. Not sure if that is possible, or which products you need to do that.