[ajays]

http://housingmaps.com/ is the granddaddy of them all. IIRC, it was one of the first such mashup apps with the newly launched Google Maps API (well, it was one of the first to become popular, at least (for the pedantic crowd who hasn't had their morning coffee yet ;-) ) )

Also: Redwood City is in the Peninsula (i.e. directly South of San Francisco). BART does not serve RWC; Caltrain does. Assuming you meant Caltrain, then you should look for places near the intersection of 4th St & King St (that's where all Caltrains start). There's ATT Park nearby, and a decent amount of stuff to do.

Also: it may be hard to find something now, given that you're interested in June. Most apartments are advertised just a month before being vacant.

[lsb]

If you really want to be pedantic, it was one of the first such mashup apps with the Google Maps "API" that hadn't even launched yet. That's what was so cool about it, and why Google was so interested in bringing him on, he reverse-engineered their API that they were still building.