Landscape Contractors & Gardeners - Suppliers and Dealers across US

« Back to US Phone Number Home

Database Description:

US yellow pages database of Landscape Contractors & Gardeners is a phone number database contains contact information such as phone number and postal address of Landscape Contractors & Gardeners suppliers, manufacturers, stores, companies and dealers across United States.

Prospective Applications / Implementations:

• Landscape Contractors & Gardeners yellow pages site
• Online phone book of Landscape Contractors & Gardeners providers
• Local classified information portal of Landscape Contractors & Gardeners
• Landscape Contractors & Gardeners business directory
• Phone number lookup & search of Landscape Contractors & Gardeners businesses
• Marketing campaign targeted at Landscape Contractors & Gardeners businesses
• Landscape Contractors & Gardeners business information site enhancement
• Landscape Contractors & Gardeners business search site
• Landscape Contractors & Gardeners reverse phone lookup
• ...Order a custom build

Database Meta:

• Listing records: Contact us for the number of total records.
• Last updated: Mar. 2nd, 2009
• Format: MySQL 5 SQL text file, CSV for MS Excel
• Tables: 7

phpMyAdmin Screenshots (Mother Database):

Table Details:

• category

  Records:27

  Level 1 categorization.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. url: varchar(255)

• city

  Records:26170

  US cities and towns.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. url: varchar(255)
  4. state: smallint(6)
  5. letter: char(1)

• listing

  Records:Inquire

  Table containing all the company listings.

  Table fields

  1. id: int(11)
  2. title: varchar(255)
  3. phone: varchar(255)
  4. address: varchar(255)
  5. subcategory2city: mediumint(9)

• state

  Records:50

  All US states.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. url: varchar(255)
  4. count: smallint(6)

• subcategory

  Records:284

  Level 2 categorization.

  Table fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. url: varchar(255)
  4. category: smallint(6)

• subcategory2city

  Records:585069

  Relational table of subcategory to city.

  Table fields

  1. id: mediumint(9)
  2. subcategory: smallint(6)
  3. city: smallint(6)

• subcategory2state

  Records:13084

  Relational table of subcategory to state.

  Table fields

  1. id: mediumint(9)
  2. subcategory: smallint(6)
  3. state: smallint(6)

Price(USD): Inquire