Foreclosure List in Spreadsheet

This is a simple copy and paste operation performed once a week for an initial 5 weeks period. No software development required.

Contact will be extended for another 5 week period if performance is satisfactory.

Task is to produce a weekly Excel spreadsheet of foreclosure data retrieved from newspaper advertisements and from the RealtyTrac website (public account).

Ability to read and understand English is mandatory.

Task requires websearch, reading and selecting advertisements, copying and pasting text into an Excel or google docs spreadsheet and sent to my email address.

There will be approximately 200 ads to screen of which about 10 to 50 will meet the criteria.

An example of a completed spreadsheet can be found at:

[url removed, login to view]

Bid amount should be for the entire 5 week period. Bid range of thirty dollars US to fifty dollars US.

Performance on the contract requires the following steps:

Part I - Newspaper Listing, the Washington Times legal notices

1) Log on to [url removed, login to view]

2) Start in the upper right hand corner and follow the path 'Marketplace > Classifieds'.

3) In the search box do:

Select a Category : Legal Notices

Date Range : Last Seven Days

Search : trustee Virginia

Search Classifieds: ON

Advanced Search : All Words

4) SEARCH. Results is a list of the ads for the past 7 days. Notice should be in the form: 1. 03/30/2009 TRUSTEE'S SALE

5) Record every advertisement matching the criteria:

5.1 Address of property limited to the following cities (VA is the state abbreviation of Virginia):

Annandale, Virginia

Arlington, Virginia

Burke, Virginia

Fairfax, Virginia

Falls Church, Virginia

McLean, Virginia

Springfield, Virginia

Vienna, Virginia

5.2 Cost or sum of no more than $250,000.00. May be listed in the advertisement as:

original sum of $

original principal amount of $

which was originally $

with a face amount of $

6) For every notice of a foreclosure match the above criteria, please record the follow in separate columns in an Excel spreadsheet

6.1 date of advertisement

6.2 street address

6.3 city

6.4 zip code

6.5 cost or sum $

6.6 date of public auction sale

6.7 location of public auction sale

6.8 the body of the announcement copy and paste into a single cell

7) Example. The following would be recorded across one line of an Excel spreadsheet


A 03/23/2009

B 7612 Savannah Street, Unit 103,

C Falls Church

D 22043

E 225,000

F April 6, 2009 at 11:02 am

G Circuit Court of the COUNTY OF FAIRFAX, VA located at 4110 Chain Bridge Road, Fairfax, Virginia, 22030

L 17. 03/23/2009 TRUSTEE'S SALE

7612 Savannah Street, Unit 103,

Falls Church, Virginia 22043

Pursuant to the terms of a deed of trust dated April 7, 2006, recorded in the Clerk's Office of the Circuit Court of the County of Fairfax, VA in Deed Book 18370 , Page 1094, made by Dania E. Cross and Thomas R. Cross and securing a note drawn in the original sum of $225,000.00, the undersigned Substitute Trustee, will offer for public sale at the front of the building housing the Circuit Court of the COUNTY OF FAIRFAX, VA located at 4110 Chain Bridge Road, Fairfax, Virginia, 22030 on

April 6, 2009 at 11:02 am

, the property described in said deed of trust, located at the above address and briefly described as:

Condominium Unit Numbered 103, Building 7612, Phase VI, Falls Church Gardens Condominium

The property and the improvements thereon will be sold "AS IS" and without representation or warranties of any kind. The sale is subject to all liens, encumbrances, conditions, easements and restrictions, if any, superior to the mentioned deed of trust and lawfully affecting the property. Neither the Substitute Trustee nor the holder of the note secured by the deed of trust will deliver possession of the property to the successful bidder. The purchaser at the sale will be required to pay all closing costs. Real estate taxes, water/sewer fees and other public charges will be prorated as of the date of sale.. The risk of loss or damage to the property passes to the purchaser immediately upon the conclusion of the Substitute Trustee's sale.


CASH or certified funds. A bidder's deposit of $25,000.00 or 10% of successful bid, whichever is lower, will be required with the balance of the sale price to be paid within 15 days at the office of the Substitute Trustee. Time is of the essence as to the closing date and the payment of the purchase price. If payment of the balance does not occur within fifteen days of the sale date, the deposit will be forfeited. If the Substitute Trustee is unable to convey good and marketable title, the purchaser's sole remedy in law or equity shall be limited to the refund of the deposit to the purchaser. Additional terms may be announced at the sale. Pursuant to the Federal Fair Debt Collection Practices Act, we advise you that this firm is a debt collector and any information obtained will be used for that purpose. Surety Trustees, LLC.


Melissa Ampah

8101 Sandy Spring Road, Suite 100

Laurel, Maryland 20707

(301) 490-3361

March 23, 2009

March 30, 2009


Part II -- RealtyTrac foreclosure listings

8) Log onto [url removed, login to view]

9) In the Search Properties box enter the property address:

7612 Savannah Street, Unit 103, Falls Church 22043

10) Click on the link to the property description and record the following in the spreadsheet

Property ID





Lot Size

Year Built

MLS Number

11) Example


H 1000008550

I Fairfax County

J Single Family Residence

K 5

L 3

M 0.266757994890213

N 1959

O FX6912743

Taidot: tietojenkäsittely, Excel

Näytä lisää: foreclosure spreadsheet, melissa ampah, surety trustees llc, realtytrac foreclosure data excel, surety trustees llc 8101 sandy spring laurel, foreclosure list spreadsheet, foreclosure auction spreadsheet, property list spreadsheet, foreclosure data list, www principal com, website development price list, website development in simple words, website development fees, website development advertisement, washington times, washington federal, us trust, title clerk, the sum of 11 times s and 3, the state newspaper

Tietoa työnantajasta:
( 0 arvostelua ) Fairfax, United States

Projektin tunnus: #410851

Myönnetty käyttäjälle:


Please check pm

$30 USD 30 päivässä
(7 Arvostelua)

30 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Please see the PM for details. Thanks

$250 USD 25 päivässä
(2 arvostelua)

Hello, I would like this opportunity to work for you. I have several years of experience in research including data extraction, data entry and data management and am confident in internet research and excel. Auditing Lisää

$40 USD 35 päivässä
(1 arvostelu)

hi..please see pm for more detail thanks

$30 USD 5 päivässä
(0 arvostelua)

ill doing good job

$35 USD 5 päivässä
(0 arvostelua)

Hello, I have great experience with excel. I completed my MCA in India. I would love to have an opportunity to complete this project for you. Let me know if you are interested. Thank you , Satish

$30 USD 5 päivässä
(0 arvostelua)

I have advanced excel, word, data and numeric, and copy and paste skills. I am looking to establish myself on this website so any opportunity is greatly appreciated.

$35 USD 1 päivässä
(0 arvostelua)

I have a great deal experience in using Excel. I currently do court research for the state of Utah. Its sounds like the same thing you are asking for state of Virginia. I can start right away.

$100 USD 3 päivässä
(0 arvostelua)

Hello, I have great experience with excel. I actually work as a teacher here in the US, teaching excel to high school students. I would love to have an opportunity to complete this project for you. Let me know if yo Lisää

$30 USD 5 päivässä
(0 arvostelua)

Sir. I am ready to work on this.

$30 USD 35 päivässä
(0 arvostelua)

Hello Sir. I would like to do this task for you. The task is described very clearly and was easy to follow. I will have no problem doing this task for you for the next 10 weeks. I am ready to start imediately. Tha Lisää

$45 USD 3 päivässä
(0 arvostelua)

Hello Sir/Madam, As per your terms and condition i am agree to work and provide a 100% Quality Deliverable. Here i provided my bid for 5 weeks. Looking for your reply to start the project immediately. Thanks Bala

$50 USD 35 päivässä
(0 arvostelua)

I have all the skills required for this job and I would really like to do this job. I have been on GAF for almost a month now and have not received a job yet. I am a single mother and could really use all the jobs that Lisää

$30 USD 2 päivässä
(0 arvostelua)

Dear sir, I have lot experience on excel . I have placed the bid for 1 week dollar 50. Have a great day. Looking for ward for a favourable reply

$50 USD 5 päivässä
(0 arvostelua)

Dear Sir, Please check PM for details. Thanks.

$30 USD 1 päivässä
(0 arvostelua)

Please check PM for sample

$50 USD 35 päivässä
(1 arvostelu)

please see the PMB for details. thanx

$30 USD 5 päivässä
(0 arvostelua)

sir i m read to do this , i have 5 yr of experience of working on excelsheet, finding data online and puttig on excelsheet , i wll do my work in time thank u

$45 USD 5 päivässä
(0 arvostelua)

Can you borrow your account on [login to view URL] We need to check the MLS number . We are a team eager to meet your requirement, and have software development team back up, so feel free to contact us

$30 USD 1 päivässä
(0 arvostelua)

i am experinced and dedicated worker and confident that ican do this project easily.

$60 USD 5 päivässä
(0 arvostelua)

I will be the right person

$150 USD 10 päivässä
(0 arvostelua)