From Jack Britt Dirve towards Hope Mills turn left on Dudnle Road. About a mile on the right there is a pond with bass bream. Dundle Road pond is close to you.
Also there is a pond in Hoke County on the game land, the state has built a dock and improved the access.
Of course as close as you are to Hope Mills, I would suggest that you try RockFish Creek. I have had success just below the Dam at Hope Mills Pond. You can also access the creek from 301N Just past Tom Starling Rd on the right, there is a Dirt Road. I have had luck there as well.
I grew up on the Cape Fear River, it is practically a habit for me to fish the Cape Fear. Since you dont have a Boat, You can try the boat ramp, there is always a crowd there this time of year. Arnette Park is open During the Daytime with trails leading to the river. I see people fishing the Bank above and below Riverside in Fayetteville as well.