pulling information from html source file

I'm not sure how to describe this but here it goes.

i am going to remax's website and i get a ton of results based on my search parameters.

i get 30 houses per webpage.  I select view source on the webpage to see the html file.  I want to extract all the addresses without doing it manually.  is there a way to accomplish this.

attached is an html file that contains the information....
again i want to extract the information from the source code... addresses and populate an excel spreadsheet with the addresses
Charlotte-Real-Estate-Search.htm
jamesmetcalf74Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
The term you are looking for is called screen scraping.  You will use a scripting language such as javascript, php, asp, python or just about any scripting language to read the site's html and convert tags such as <tr><td> to line feeds and data delimiters.  You have to custom design your screen scrap for each site.

However, in this case, just about any real estate site where a REALTOR is involved, uses data from one or more local Multiple Listing Services (MLS).  The MLS is tightly guarded and you can not legally copy the data.  

See the TOS for remax under RESTRICTIONS, the first bullet point.
http://www.remax.com/c/corporate/terms-of-use 
Unless explicitly specified or with separate, written permission from RE/MAX, LLC, you may not and agree that you will not:
copy, modify, distribute, transmit, display, reproduce, publish, license, create derivative works from, frame in another web site, use on any other web site, transfer or sell any information obtained from this Web Site or any part thereof;
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.