Pile foundations are pivotal in ultra-high-rise building projects, serving not only as structural supports that provide requisite load-bearing capacity and seismic resilience but also as solutions to challenges posed by complex geological conditions and economic considerations. This study investigates the pile foundation design of a super high-rise complex in the Alamein region of Egypt, focusing on its distinctive geological context and design specifications. The project features a 300-meter landmark tower and four apartment-style hotels, each 221.74 meters tall. The site is characterized by complex geological conditions dominated by limestone with karstic features. Through the integration of geological survey data and structural load analysis, pile foundations with varying load capacities were employed. The design was optimized using test piling and post-grouting techniques to enhance load-bearing capacity and control settlement. Guided by the principles of balancing economic efficiency with structural safety, a staggered diamond-shaped arrangement of piles was adopted in the core tube area, while peripheral areas were arranged according to project requirements. The optimization led to ample load-bearing capacity and significant reductions in construction costs