The train isnt an option now, and may never be, its the same as many places including the proposed Caloundra inland link (does anyone know if that one is all go now?).
From what I heard the train link proposal was from mango hill to petrie (anyone know for sure?), I would think it would take longer than driving directly to sandgate and then train to the city from there?
However
Its a 10 minute drive to Sandgate, big deal.
If you so wish, there is a designated foot/cycle bridge if you wish to cycle to sandgate, I would estimate 20-30 minutes cycle depending on where in Redcliffe you buy.
As mentioned already there are also designated bus links to the sandgate train, or direct to the city.
As for Redcliffe real estate. Take a drive along the waterfront from newport to woody point.
The first thing you will likely notice is Redcliffe has beaches with sand (which is fairly unique in Bris), and deep(ish) blue water.
Secondly you may notice the quality of the roads and footpath areas in redcliffe (keep in mind Redcliffe has its own council)
You may also notice the number of cafes, resteraunts, bars and shops in redcliffe opposite the beaches.
Or perhaps as you drive through the mansions in the canal estate you may catch a glimpse of a launch you have a spare fortune to spend on, and drive down to the marina to see what else is available.
You may then start to notice the physical real estate.
IMHO redcliffe is simply spectacular.
The last thing I would be worried about in redcliffe would be the train. But sssshhhhh dont tell to many people about it, they might cotton on to safe swimming sandy beaches, cafes, lifestyle and close proximity to the CBD.
Sure a train station is a good thing, but redcliffe makes up for it many times over.