What I do is the following:

1. Go to maps.yahoo.com
2. Type in the name of a station, for example "Embarcadero BART"
3. Once it finds the station, click "Find Nearby"
4. In the search box, type "hotel"

This will give you a list of nearby hotels, along with the distance that each one is from the station.