The Pyramids area is near Giza part of Cairo if your holiday to Cairo is going to be more focused on the Pyramids this is the area you should stay in.
The pyramids area around and south of Cairo is where nearly all pyramids were built more than four thousand years ago. Apart from some smaller pyramids, all were built during the Old Kingdom which lasted from the 4th to the 6th dynasty (about 2613-2181BC).
They are located in and around the old capital Hwt-ka-Ptah (Memphis). South of To-She (Fayoum) there is only found a handful of pyramids, and then only very small pyramids.
The most known pyramids are of course the three main 4th dynasty pyramids of Giza where the pyramid of Kufu (Cheops) are the largest and most referred to. Name of Kufu's pyramid is the "Pyramid which is the Place of Sunrise and Sunset" and it had an original height of 146 meters (479ft).
If you go to the pyramids area before this, please don't forget to visit the Solar-ship museum! Not only is it the oldest remaining boat in the world, but it's a true 43 meters (141ft) long beauty which shows you how the pharaohs of ancient Egypt travelled the Nile in style, gods as they were.
Where ever you stay in Cairo whether it be in Cairo or the Pyramids area you are still never far from all that Cairo has to offer.