Develop a widget to search the db based on 2 filters (Manufacturer, Model). The filters for the search are to be displayed drop-down boxes. See pic "Used Motorcycles Search 2 filters.jpg" attached. The Manufacturer filter has to be pre-loaded from the db tables (ie Manufacturer gets it's values from the Brand table). The Model filter has to be loaded in real time depending on what is selected by user and what is available in the db, For example if user selects Yamaha, then the Model filter in the drop down (filter) boxes will reflect all the Yamaha models currently in the db.
The query is run by the user pressing the red "Search Bikes" button.
The output of the query are to be shown on a new page as standard product (based on Luma theme), see "Search_Output.png" file attached.
The implementation of the widget (and associated files) should be able to survive a Magento or theme upgrade.