custom_importproperty | CREATE TABLE `custom_importproperty` (
  `id` int(11) NOT NULL auto_increment,
  `firstName` text,
  `lastName` text,
  `addressNo` varchar(6) default NULL,
  `addressStreet` varchar(255) default NULL,
  `addressSuburb` varchar(255) default NULL,
  `isUnitApartment` float default NULL,
  `apartmentNo` int(6) default NULL,
  `postcode` int(6) default NULL,
  `city` varchar(255) default NULL,
  `squareMeters` int(6) default NULL,
  `noBedrooms` int(6) default NULL,
  `singleBeds` int(6) default NULL,
  `queenBeds` int(6) default NULL,
  `singleFoldBeds` int(6) default NULL,
  `kingBeds` int(6) default NULL,
  `doubleBeds` int(6) default NULL,
  `bunkBeds` int(6) default NULL,
  `sofaBeds` int(6) default NULL,
  `cotBeds` int(6) default NULL,
  `noBathrooms` int(6) default NULL,
  `noCarparks` int(6) default NULL,
  `noInfants` int(10) default NULL,
  `noChildren` int(10) default NULL,
  `noAdults` int(10) default NULL,
  `isEnsuite` int(6) default NULL,
  `dayPrice` float default NULL,
  `description` text,
  `maxStay` int(10) default NULL,
  `minStay` int(10) default NULL,
  `commenceDate` varchar(14) default NULL,
  `endDate` varchar(14) default NULL,
  `status` varchar(255) default NULL,
  `budget` varchar(255) default NULL,
  `luxe` varchar(255) default NULL,
  `deluxe` varchar(255) default NULL,
  `beaches` varchar(255) default NULL,
  `cafesRestaurants` varchar(255) default NULL,
  `shopping` varchar(255) default NULL,
  `parksGardens` varchar(255) default NULL,
  `petFriendly` varchar(255) default NULL,
  `disabledAccess` varchar(255) default NULL,
  `elevator` varchar(255) default NULL,
  `stairs` varchar(255) default NULL,
  `balconyTerrace` varchar(255) default NULL,
  `courtyard` varchar(255) default NULL,
  `views` varchar(255) default NULL,
  `swimmingPool` varchar(255) default NULL,
  `gym` varchar(255) default NULL,
  `bbq` varchar(255) default NULL,
  `tennisCourt` varchar(255) default NULL,
  `airConditioning` varchar(255) default NULL,
  `ceilingFans` varchar(255) default NULL,
  `heating` varchar(255) default NULL,
  `familyFriendly` varchar(255) default NULL,
  `stove` varchar(255) default NULL,
  `grill` varchar(255) default NULL,
  `microwave` varchar(255) default NULL,
  `dishwasher` varchar(255) default NULL,
  `CookingEquipment` varchar(255) default NULL,
  `cutleryCrockery` varchar(255) default NULL,
  `Television` varchar(255) default NULL,
  `VCR` varchar(255) default NULL,
  `DVD` varchar(255) default NULL,
  `StereoSystem` varchar(255) default NULL,
  `cableTV` varchar(255) default NULL,
  `internetConnection` varchar(255) default NULL,
  `fax` varchar(255) default NULL,
  `telephone` varchar(255) default NULL,
  `washingMachine` varchar(255) default NULL,
  `clothesDryer` varchar(255) default NULL,
  `Iron` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8