The type of lens you are looking for is probably the Canon 28-135mm which translates to the 35mm equivalent of 49-216mm. (use a multiplier of 1.6 for Digital Rebel).

This lens has a close focus of 20 inches, but not true macro.

This Canon lens has image stabilization and sells for about $400.

It is possible that some of the other lens companies (Sigma, Vivitar, Tokina) makes a zoom lens with true macro.

Here is a link to all current Canon lenses: