Extract and present data - Laravel4

We are using Laravel 4 framework, and have an existing site that routes 5 views, and connects to 1 mysql table. The site and routes are already set up, and mysql connection to table and raw data dump from the table is already working. The table data is property addresses with fields such as postcode, street, street number etc. We are looking to run simple queries for each view (number of distinct records, numrows etc) on the table and present it to the user view. The route structure is already working, we only need the property data to be retrieved and presented to the view. To give a feel of the data to be extracted and presented: - View 1 /: list all the distinct postcodes, and number of suburbs in each postcode - View 2 /{postcode}: list all the distinct suburbs, and number of properties in each suburb - View 3 /{postcode}/{suburb}: list all the streets, and number of properties on each street - View 4 /{postcode}/{suburb}/{street}: list all the properties on the street - View 5 /{postcode}/{suburb}/{street}/{street_no}: if an apartment (this is specified in the table), print all apartments in the table 2. implement twitter bootstrap, so the view and formatting look presentable 3. link each recored so the user can click through and drill down through the address Needs to use laravel 4, blade and eloquent. Please mention your experience in Laravel4, you will be ignored otherwise.