Author : Collection
Price : $7
Rights : None
Category : mySQL database
Share to your friend

Are you planning to start an apartment portal website. This collection of 100,000+ apartments list database is a very good way to start your own website or add to your existing yellow page site.

Database Structure

CREATE TABLE `BIZ_APARTMENTS` (
`bizID` int(11) NOT NULL auto_increment,
`bizCat` varchar(255) default NULL,
`bizCatSub` varchar(255) default NULL,
`bizName` varchar(255) default NULL,
`bizAddr` varchar(255) default NULL,
`bizCity` varchar(255) default NULL,
`bizState` varchar(255) default NULL,
`bizZip` varchar(255) default NULL,
`bizPhone` varchar(255) default NULL,
`bizFax` varchar(255) default NULL,
`bizEmail` varchar(255) default NULL,
`bizURL` varchar(255) default NULL,
`locAreaCode` char(3) default NULL,
`locCounty` varchar(30) default NULL,
`status` varchar(25) NOT NULL default 'Active',
`misc` varchar(25) NOT NULL default 'old',
PRIMARY KEY (`bizID`),
FULLTEXT KEY `bizCat` (`bizCat`,`bizCatSub`,`bizName`,`bizAddr`,`bizCity`,`bizState`,`bizZip`,`locCounty`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=172440 ;



Sample data entries

INSERT INTO `BIZ_APARTMENTS` VALUES (1, 'Apartments', 'Apartment & Home Rental', 'Daleville Real Estate Inc', '433 North Daleville Avenue # A', 'Daleville', 'AL', '36322', '(334)598-4433', '(334)598-6257', 'dalere@snowhill.com', 'www.dalevillerealestate.com', '334', 'Dale', 'Active', 'old');
INSERT INTO `BIZ_APARTMENTS` VALUES (2, 'Apartments', 'Apartment Buildings', 'Brittany Place Apartments', '1890 Cathedral Mills Lane Ofc', 'Rock Hill', 'SC', '29732', '(803)328-2818', NULL, NULL, NULL, '803', 'York', 'Active', 'old');
INSERT INTO `BIZ_APARTMENTS` VALUES (3, 'Apartments', 'Retirement Apartments & Hotels', 'Cabot Manor Nursing Center', '200 Northport Drive', 'Cabot', 'AR', '72023', '(501)843-6181', NULL, NULL, NULL, '501', 'Lonoke', 'Active', 'old');
INSERT INTO `BIZ_APARTMENTS` VALUES (4, 'Apartments', 'Apartment & Home Rental', 'Eden Green Apartments', '2201 Reed Street', 'Fort Wayne', 'IN', '46803', '(260)456-2157', NULL, NULL, NULL, '260', 'Allen', 'Active', 'old');
INSERT INTO `BIZ_APARTMENTS` VALUES (5, 'Apartments', 'Apartments', 'Corporate Housing by Healey Ramme', '13905 Chestnut Drive', 'Eden Prairie', 'MN', '55344', '(952)944-8400', NULL, NULL, 'www.healeyramme.com', '952', 'Hennepin', 'Active', 'old');