INSERT INTO `layardbuser`.`POI_RealEstate_Table` (
  `id` ,
  `attribution` ,
  `title` ,
  `lat` ,
  `lon` ,
  `imageURL` ,
  `line4` ,
  `line3` ,
  `line2` ,
  `type` ,
  `dimension` ,
  `alt` ,
  `relativeAlt` ,
  `distance` ,
  `inFocus` ,
  `doNotIndex` ,
  `showSmallBiw` ,
  `showBiwOnClick` ,
  `Radiolist` ,
  `Checkbox` ,
  `Custom_Slider`
  )
  
  VALUES (
  ‘1’, ‘<your layer name>’, ‘Water Street’, ‘<lat>’, ‘<lon>’,
  ‘http://www.yourserver.com/apartment3_water.jpg’, ‘Large apartment by the
  river’, ‘Distance:\%distance%’, ‘2 bedrooms’, ‘1’, ‘1’, NULL , NULL ,
  ‘’, ‘0’, ‘0’, ‘1’, ‘1’, ‘sale’, ‘2’, ‘550000’),
  
  (‘2’, ‘<your layer name>’, ‘Water Street’, ‘<lat>’, ‘<lon>’,
  ‘http://www.yourserver.com/apartment3_water.jpg’, ‘Large apartment by the
  river’, ‘Distance:\%distance%’, ‘3 bedrooms’, ‘1’, ‘1’, NULL , NULL ,
  ‘’, ‘0’, ‘0’, ‘1’, ‘1’, ‘rent’, ‘2’, ‘3000’),
  
  (‘3’, ‘<your layer name>’, ‘Poor Street’, ‘<lat>’, ‘<lon>’,
  ‘http://www.yourserver.com/apartment3.jpg’, ‘Small apartment’,
  ‘Distance:\%distance%’, ‘2 bedrooms’, ‘1’, ‘1’, NULL , NULL , ‘’, ‘0’, ‘0’,
  ‘1’, ‘1’, ‘sale’, ‘2’, ‘120000’),
  
  (‘4’, ‘<your layer name>’, ‘Rich Road’, ‘<lat>’, ‘<lon>’,
  ‘http://www.yourserver.com/appartment4.jpg’, ‘Nice apartment in a
  rich area’, ‘Distance:\%distance%’, ‘4 bedrooms’, ‘1’, ‘1’, NULL ,
  NULL , ‘’, ‘0’, ‘0’, ‘1’, ‘1’, ‘sale’, ‘2’, ‘420000’),
  
  (‘5’, ‘<your layer name>’, ‘Poor Hill’, ‘<lat>’, ‘<lon>’,
  ‘http://www.yourserver.com/house.jpg’, ‘House on the hill’,
  ‘Distance:\%distance%’, ‘4 bedrooms’, ‘1’, ‘1’, NULL , NULL ,
  ‘’, ‘0’, ‘0’, ‘1’, ‘1’, ‘rent’, ‘1’, ‘3100’),
  
  (‘6’, ‘<your layer name>’, ‘Poor Street’, ‘<lat>’, ‘<lon>’,
  ‘http://www.yoursever.com/house2.jpg’, ‘Needs a little work’,
  ‘Distance:\%distance%’, ‘4 bedrooms’, ‘1’, ‘1’, NULL , NULL ,
  ‘’, ‘0’, ‘0’, ‘1’, ‘1’, ‘sale’, ‘1’, ‘70000’),
  
  (‘7’, ‘<your layer name>’, ‘Super Rich Street’, ‘<lat>’, ‘<lon>’,
  ‘http://www.yourserver.com/house3.jpg’, ‘Very nice house in a
  rich area’, ‘Distance:\%distance%’, ‘4 bedrooms’, ‘1’, ‘1’, NULL ,
  NULL , ‘’, ‘0’, ‘0’, ‘1’,’1’, ‘sale’, ‘1’, ‘800000’),
  
  (‘8’, ‘<your layer name>’, ‘Main Street’, ‘<lat>’, ‘<lon>’,
  ‘http://www.yourserver.com/house5.jpg’,
  ‘House on main street’,
  ‘Distance:\%distance%’, ‘7 bedrooms’, ‘1’, ‘1’, NULL , NULL ,
  ‘’, ‘0’, ‘0’, ‘1’, ‘1’, ‘sale’, ‘1’, ‘950000’),
  
  (‘9’, ‘<your layer name>’, ‘Central Lane’, ‘<lat>’, ‘<lon>’,
  ‘http://www.yourserver.com/house6.jpg’,
  ‘House with a large garage’,
  ‘Distance:\%distance%’, ‘2 bedrooms’, ‘1’, ‘1’, NULL , NULL ,
  ‘’, ‘0’, ‘0’, ‘1’, ‘1’, ‘rent’, ‘1’, ‘4500’),
  
  (‘10’, ‘<your layer name>’, ‘Hobbit Hill’, ‘<lat>’, ‘<lon>’,
  ‘http://www.yourserver.com/house_green.jpg’,
  ‘Unique underground house‘,
  ‘Distance:\%distance%’, ‘2 bedrooms’, ‘1’, ‘1’, NULL , NULL,
  ‘’, ‘0’, ‘0’, ‘1’, ‘1’, ‘rent’, ‘1’, ‘5200’);