I don't know if you are aware but Majestic went down a couple of years ago. They are no longer around.
Majestic Village next door is being finished off by the buyers themselves. They have all put in several thousand euros to finish the development. I doubt they will pay for work on the roads though.
Majestic Hills is a nice development. They had some issues to begin with, as do most new communiites, but they do seem good apartments.
In terms of long term investment...who can tell. Saying that, there are few short term investment opportunities at the moment so everything has to be considered on a long term basis anyway!