These Neighbourhood Terrains are available here to download.
How to use a custom Neighbourhood Terrain.
How to make your own
As you will see, on most of my maps the roads go right to the edges. I use a simple hack which lets me play to the very edge of the map, but if you do not then you will only see the central area of the map. It's a simple adjustment to the cameras text file and works fine for me with ALL versions of Sims 2. If you want to use these Hoods without the camera hack, they will work perfectly well, but you will have less space to build on.
Get the hack at ModTheSims 2 in this thread
If you have SimCity 4, SimCity 4 Deluxe or SimCity 4 and SimCity Rush Hour, do have a go at making your own Neighbourhood. It's a lot of fun.
I make Custom Neighbourhoods! If you have an idea for a Neighbourhood for your Sims 2 game, please Contact me and tell me all about it! Real Life permitting, I would love to make it for you.