How to think about structuring a site with dynamic content

First of all my apologies for not getting all of the terminology correct to perhaps pinpoint with more accuracy what it is i’m trying to say.

So hopefully this graphic will help anyone who reads this post and takes the time to answer it clearly see what i’m trying to accomplish.

Link to PDF of sitemap

re: sitemap – imagine 27 more neighborhood pages each with their respective child links and you start to see the repetitive pattern of how the site needs to work.

I’m sure it’s been done a thousand times over but without the correct terminology i’ll never be able to ask the right questions.

Even after reading hundreds of articles, posts, and forums i still haven’t found anyone that has had this particular question and it makes me think that i’m either over-thinking the solution am really dumb that i need someone else to dumb it down for me:)

The site is an online magazine for a real estate company that has the following parent links on the navigation menu “HOME | NEIGHBORHOODS | BLOG | ABOUT US”.
Here’s the static HTML homepage : Homepage click here

I understand the blog part because that lends itself to the very thing that WP does so well so i don’t have a problem with that or with ABOUT US (i realized that’s a single static page), HOME is just a custom homepage (no blog posts on the home page).

It’s NEIGHBORHOODS that i’m stumbling on understanding and here’s the 2 main reasons why:

1) There are sub pages that stem from this parent menu item (Neighborhoods leads to a list of neighborhoods> user clicks on a neighborhood and is taken to that neighborhood page which will then have sub-navigation menu items to explore the contents of that neighborhood including places within that neighborhood)

2) – How to structure this so that an admin user could navigate to a specific page and update it’s content in several block widgets on each page without the standard WYSIWYG editor that is so common for blog posts (and easy for that use but won’t cut it alone in this case)

I’m approaching each Neighborhood page as a custom post type so therefore i’m creating a template that will be re-usable for every Neighborhood (there are 27 neighborhoods) so naturally the admin user would need to be able to update things like the neighborhood name, background color, main image of neighborhood, content in all widgets (some are just link lists others will import RSS feed titles), and insert images for a jquery slider. Here’s a Neighborhood page example

Every neighborhood will also drill down to have a sub-navigation (all sub navs will be identical for each neighborhood but naturally need to have it’s own unique content in each widget area and editable elements that i mentioned in the paragraph above)
notice the sub navigation links on the “Georgetown” page

So part of my question is:

Do all these pages need to just be static pages with custom post and field types so that they can be edited from the admin panel?

Since they are not posts i can’t think of what else they would be.

And since they are all so repetitive in layout the only exception being content, how should i think about structuring the pages.

I don’t mind manually linking all the pages together is that will make it easier since i can’t wrap my head around how the client would create a new page and apply it to the correct neighborhood’s place?

e.g (home>neighborhood>place>content on “Places” page)

And obviously this will equate to many pages since there are 27 neighborhoods and each neighborhood has a sub-nav with 4 menu items leading to Places, Gallery, History, and Points of Interest. All these sub-nav pages will have different content although laid out exactly the same for every neighborhood. That number of static pages could range from 108+ pages that will need content updated.

Needless to say that if these repetitive pages are made each into their own template then making new pages with a specific theme for each page could accomplish this but the question would be how does the client create these pages on their own and allow them to be able to edit the CONTENT ONLY (that should be controlled in its placement by the CSS) and make it systematic for the client to do so.

Otherwise i see myself having to create all the Neighborhood pages, all the Places pages within those neighborhoods and all the other neighborhood and place specific versions of the gallery, history, points of interest and then just have the client go in and alter the text and images for those pages but as you can imagine that will increase the time that i have to spend on the project and it becomes a matter of several more hours to do that when i imagine that once i create the template for each page (neighborhood, gallery, places, history, points of interest) the client could then create those pages and link them to each other.

I’ll figure out how to link pages together in WordPress since in know that the blog does that automatically with posts based on their timestamps, but how to link pages together to exact pages is another thing i haven’t attempted yet in wordpress.

So there are some totally noob questions in here that i’ll learn once i get hands on i just need a game plan with the correct terminology of how i’m going to put this site together and anyones input is greatly welcome.

Finally if there are new things in the latest version of WP that could aide in this build i would be grateful to learn about them, please share:)

Thank you.