off the shelf rods/pistons for 470 B stroker for best rod ratio

I have a 400 block and want to make a 440 crank stroker,and I'm leaning towards the 470 with the offset ground rod journals vs a 451.

Because this is a street combo and I want it to last as long as possible before rebuilding, I've been advised to try and achieve a rod ratio of 1.8:1 or close to, and to use as tall of piston as possible.

What off the shelf rod and piston choices do I have?

You have zero choices that will give you a 1.80 rod ratio in a low deck 470. The first thing you need to do is check the math with people on the internet give you advice. A lot of people on the internet who talk about engines don't know what they are talking about so you should stop listening to them.

If you do some research you'll quickly figure out that there are only a handful of ways to build a 470 using off the shelf parts. I built a chart a couple of years ago so some of it could be out of date but at the time it showed all of the possible ways to build a 470. This chart took me about an hour to build so if you want to spend an hour of your time doing the same thing you'll be the world expert on 470 combinations.