User interactive map and grid

Here’s what I’m looking to do and was hoping someone had some insite on how…

I used Scriptcase (current version) and a MySql database to store various locations. What I would like to do is:

  1. Create a grid and a map and display them side by side

  2. Allow the end-user to view all records, or search for records in the grid, and show the results on the map.

  3. Allow the end-user to draw a shape on the map and display the results contained within the shape the end-user made in the grid

I’ve scoured Google for information on this and can’t seem to get anywhere. I do know it’s possible as I’ve seen exactly what I want to do on www.zillow.com. If anyone has any insite on how to do something like this I would greatly appreciate the tips. Thanks!