Your grandmother or great grandmother likely had one. A really deep well could be a problem. You can pull water only so high, but you can always push it up. Here's a website which states that their "deep" hand pump can manage 200'. That's down to the water level, not to the bottom of the well. Their shallow pump is only good to 25'.
This is the "Deep" model, which can be used with a submersible pump still present.
Cost's 1,655.00, although that includes only 64 feet of pipe and lift rod.So your cost would depend on how deep you need to go.