You gain the abilities, not the possessions.
Besides, there are a lot of lower level spells that can give you "unlimited" salable goods. Magnificent Mansion, for example, gives you gourmet food enough to feed hundreds. (In earlier editions this was supposed to be illusory food and drink, but that qualifier vanished when 3.0 came out.) And there's nothing in the spell that says you can't take the food out of the Mansion. Just throw your feast, or make sure it's served before the spell goes down.
We had to include a house rule regarding Major Creation: 5th level spell, requiring a 9th level caster, allowing you to produce a cubic foot of gold per caster level. For an 11th level caster, at 1026 pounds per cubic foot, it totals to 564,300 gp per casting. Close enough to "unlimited"? Or perhaps you should create platinum, which is actually heavier (1,336 lbs). That produces 7,348,000 gp in value per casting.
It only lasts a little over three hours (20 minutes per caster level), but that's plenty of time to spend it on real goods. Like, the kingdom of your choice?
Gems last half as long, but since there's no rule on weight to value for them, it's best to leave that aspect alone.
Our house rule on it was that it's "fairy gold", and can be dispelled by contact with cold iron. Pretty much every vendor in any town of any size has a cold iron plate on their counter, where they count out the money they're paid. The spell specifically says that you can't create cold iron with it, hence the basis for our house rule.
