Is rg6 good for 700 mhz at 50 feet? I want the least amount of signal loss.
So, there's a couple of things you need to consider here.
LMR400 has half the loss of basic RG-6 at 700MHz. So, LMR-400 is "better" in that sense.
LMR400 is large cable, has a larger bend radius, and unless you have the tools, putting connectors on is difficult. The tools to install connectors on it properly are expensive. Not worth it if you are installing one run. You can get custom lengths of cable with the connectors you want on the end.
LMR400 is stiff cable, and you do not want to connect it directly to your scanner. The stiffness of the cable will put a lot of strain on the antenna connector on the scanner and will risk breaking it. You'll want to use a short "whip" of thinner/more flexible cable to make that final connection.
RG-6 has more loss. But it's thinner cable, easier to route, and can be bent pretty tight without negative effects. It's also way easier to install or BNC connectors on, in fact you can get the stripper, installation tool and BNC connectors at your local Home Depot. That makes it easier to run the cable from outside to your scanner (don't forget the grounding block and proper grounding) and then terminate your own connector on the end. That can be better than having a lot of slack cable coiled up somewhere. And RG-6 is flexible enough that you can connect it directly to your scanner without issue.
Don't get hung up on loss quite yet….
Yes, less loss is "better", but it costs money. If you have a good antenna and are close to the site you want to hear, you may not need the more expensive lower loss cable.
Generally, if you can hear the radio site in your home with a scanner, then you don't need super high gain/low loss installation. But if you have a really hard time hearing the site when outside your home, then you need all the help you can get.
Low loss cable is helpful, but budgets are a real thing, and easier installation can be more beneficial. Not every installation needs the high end cable to work properly. But, it's your budget, your choice.
www.theantennafarm.com will make custom LMR400 cables for you. Make sure you order a short whip of RG-58 to make the final connection to your scanner if you go this route.