Hi gchild, welcome to the forum
i would agree with everything that jeffrz says. I have the diesel as well, and get about 34 mpg internal and about 45 mpg on the motorway. I have had no problems, and don't expect any either. One thing I would say, however, is that compared to some of the other MPVs, which can have about 2000l of space when the seats are folded down, the FRV has considerably less, almost half in fact. This might be a consideration for you. But the boot with the seats up is bigger than most of the 7seaters.
Saying that, I believe that this car is the best compromise for luggage and number of people it can carry. Service is reasonable, especially if you go somewhere like KwikFit. I travel to Birmingham about 10 times a year (approx. 220 miles), and the journey is a breeze for all of us. I hope to travel to Europe with the family and luggage soon too.
I would recommend one thing, though - go for the highest spec you can afford. The one with as many toys as possible. I have the SatNav and I cannot imagine not having it. I bought mine in December, and it was three years old, and had done 84,000 miles - it felt like new. I have owned a Ford Mondeo, BMW 5series, and the Honda FRV. The FRV is the best car I have owned so far, in terms of comfort, built quality (not better, but at least equal to the BMW), and practicality.
Any more questions, please ask. Let us know what you have decided