559,426 US Realtors / Agents Database (Phone, Specs, Certs, Zip)

Database Description:

This 3-table database lists all United States realtors (property agents / companies) with a variety of certifications, specifications and affiliations, categorized by city and state.

Each realtor record has office phone number, fax number, toll free number, mobile number and / or home office number. Each agent or company is categorized by state and city, by zip code, with specialized properties and certifications.

The total number of unique office phone numbers are 170,272. The total number of unique realtor names are 559,426.

Database Meta:

• Size: 204.7 MB
• Last updated: Oct. 27th, 2011
• Formats Included: MySQL dump .sql text file, CSV, MS Excel
• Tables: 3

Buy Now & Download: $189.00 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• city

  Records:30,228

  US cities table with zip codes.

  Data fields

  1. id: int(10) unsigned
  2. title: varchar(255)
  3. zip: varchar(255)
  4. state: smallint(6)

• realtor

  Records:1,430,716

  US realtor agents / companies table.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. type: varchar(255)
  4. office: varchar(255)
  5. fax: varchar(255)
  6. toll_free: varchar(255)
  7. mobile: varchar(255)
  8. home_office: varchar(255)
  9. locality: varchar(255)
  10. specializations: varchar(255)
  11. certifications: varchar(255)
  12. affiliation: varchar(255)
  13. zip: char(5)

• state

  Records:51

  US states table.

  Data fields

  1. id: smallint(5) unsigned
  2. abbreviation: varchar(255)
  3. title: varchar(255)

Buy Now & Download: $189.00 (USD)

Potential Applications / Usage:

• US Real estate help information site
• Realtors directory / US realtor agents search by property type and locality

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database
• Single Table Format