Hotels - SQL Database

Download free Hotels - SQL Database. List of hotels to build your website or application.

Hotels - SQL Database
Hotels - SQL Database

Hotels database. Contact information, location.

CREATE TABLE `BIZ_HOTELS_MOTELS` (
  `bizID` INTEGER, 
  `bizCat` VARCHAR(255), 
  `bizCatSub` VARCHAR(255), 
  `bizName` VARCHAR(255), 
  `bizAddr` VARCHAR(255), 
  `bizCity` VARCHAR(255), 
  `bizState` VARCHAR(255), 
  `bizZip` VARCHAR(255), 
  `bizPhone` VARCHAR(255), 
  `bizFax` VARCHAR(255), 
  `bizEmail` VARCHAR(255), 
  `bizURL` VARCHAR(255), 
  `locAreaCode` VARCHAR(3), 
  `locFIPS` VARCHAR(5), 
  `locTimeZone` VARCHAR(6), 
  `locDST` VARCHAR(1), 
  `locLat` VARCHAR(10), 
  `locLong` VARCHAR(10), 
  `locMSA` VARCHAR(5), 
  `locPMSA` VARCHAR(5), 
  `locCounty` VARCHAR(30)
) TYPE=MyISAM;

Example table.

'Hotels & Motels', 'Hotels', 'Holiday Inn Ft Collins', '3836 East Mulberry', 'Fort Collins', 'CO', '80524', '(970)484-4660', '(970)484-2326', NULL, NULL, '970', '08069', 'MST', 'Y', '40.6475', '-105.0476', '2670', NULL, 'Larimer'

 

Our website is for sale! The domain and website has been running for more than 3 years, but it's time to part with it. There is no price, so I consider any offer. Contact us if you are interested in buying in the feedback form, we will discuss options, price and details for transferring the site. (script, database and everything else for the site to work).