Alcohol or vinegar added to the water will do that. You only need a little Dawn, it cuts any oil. A trick maids use is to polish any streaks away with a balled up piece of newspaper.
Michelle do you have any plans on using your enclosed yard?
I was trying to think if we've visited any botanical gardens or such down your way that had a multi-zoned green- houses. Mt. Cuba, Longwood Gardens, and Phipps Conservatory do but they're here in Pa.
Lewis Ginter Botanical Garden in Richmond does also I believe. I think I was to an FSU bamboo and banana research station that had one as well as a really cool Xeriscape garden, but can't remember where.