-- MySQL dump 10.9 -- -- Host: localhost Database: brk7_orlt1 -- ------------------------------------------------------ -- Server version 4.1.14-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `default_addons` -- DROP TABLE IF EXISTS `default_addons`; CREATE TABLE `default_addons` ( `addons_version` varchar(15) NOT NULL default '', `addons_name` varchar(150) NOT NULL default '', PRIMARY KEY (`addons_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_addons` -- /*!40000 ALTER TABLE `default_addons` DISABLE KEYS */; LOCK TABLES `default_addons` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `default_addons` ENABLE KEYS */; -- -- Table structure for table `default_controlpanel` -- DROP TABLE IF EXISTS `default_controlpanel`; CREATE TABLE `default_controlpanel` ( `controlpanel_version` varchar(15) NOT NULL default '', `controlpanel_basepath` varchar(150) NOT NULL default '', `controlpanel_baseurl` varchar(150) NOT NULL default '', `controlpanel_admin_name` varchar(45) NOT NULL default '', `controlpanel_admin_email` varchar(45) NOT NULL default '', `controlpanel_site_title` varchar(45) NOT NULL default '', `controlpanel_company_name` varchar(45) default NULL, `controlpanel_company_location` varchar(45) default NULL, `controlpanel_company_logo` varchar(45) default NULL, `controlpanel_phpmyadmin` varchar(45) default NULL, `controlpanel_manage_index_permissions` smallint(6) NOT NULL default '0', `controlpanel_url_style` smallint(6) NOT NULL default '0', `controlpanel_template` varchar(45) NOT NULL default '', `controlpanel_admin_template` varchar(45) NOT NULL default '', `controlpanel_listing_template` varchar(45) NOT NULL default '', `controlpanel_search_result_template` varchar(45) NOT NULL default '', `controlpanel_lang` char(2) NOT NULL default '', `controlpanel_listings_per_page` int(11) NOT NULL default '0', `controlpanel_num_featured_listings` int(11) NOT NULL default '0', `controlpanel_add_linefeeds` smallint(6) NOT NULL default '0', `controlpanel_strip_html` smallint(6) NOT NULL default '0', `controlpanel_allowed_html_tags` varchar(45) NOT NULL default '', `controlpanel_money_sign` varchar(20) NOT NULL default '', `controlpanel_show_no_photo` smallint(6) NOT NULL default '0', `controlpanel_number_format_style` int(11) NOT NULL default '0', `controlpanel_money_format` int(11) NOT NULL default '0', `controlpanel_date_format` int(11) NOT NULL default '0', `controlpanel_max_listings_uploads` int(11) NOT NULL default '0', `controlpanel_max_listings_upload_size` int(11) NOT NULL default '0', `controlpanel_max_listings_upload_width` int(11) NOT NULL default '0', `controlpanel_max_user_uploads` int(11) NOT NULL default '0', `controlpanel_max_user_upload_size` int(11) NOT NULL default '0', `controlpanel_max_user_upload_width` int(11) NOT NULL default '0', `controlpanel_max_vtour_uploads` int(11) NOT NULL default '0', `controlpanel_max_vtour_upload_size` int(11) NOT NULL default '0', `controlpanel_max_vtour_upload_width` int(11) NOT NULL default '0', `controlpanel_allowed_upload_extensions` varchar(45) NOT NULL default '', `controlpanel_make_thumbnail` smallint(6) NOT NULL default '0', `controlpanel_thumbnail_width` int(11) NOT NULL default '0', `controlpanel_gd_version` smallint(6) NOT NULL default '0', `controlpanel_thumbnail_prog` varchar(20) NOT NULL default '', `controlpanel_path_to_imagemagick` varchar(255) NOT NULL default '', `controlpanel_resize_img` smallint(6) NOT NULL default '0', `controlpanel_jpeg_quality` smallint(6) NOT NULL default '0', `controlpanel_use_expiration` smallint(6) NOT NULL default '0', `controlpanel_days_until_listings_expire` int(11) NOT NULL default '0', `controlpanel_allow_member_signup` smallint(6) NOT NULL default '0', `controlpanel_allow_agent_signup` smallint(6) NOT NULL default '0', `controlpanel_agent_default_active` smallint(6) NOT NULL default '0', `controlpanel_agent_default_admin` smallint(6) NOT NULL default '0', `controlpanel_agent_default_feature` smallint(6) NOT NULL default '0', `controlpanel_agent_default_moderate` smallint(6) NOT NULL default '0', `controlpanel_agent_default_logview` smallint(6) NOT NULL default '0', `controlpanel_agent_default_editforms` smallint(6) NOT NULL default '0', `controlpanel_agent_default_canchangeexpirations` smallint(6) NOT NULL default '0', `controlpanel_agent_default_editpages` smallint(6) NOT NULL default '0', `controlpanel_agent_default_havevtours` smallint(6) NOT NULL default '0', `controlpanel_agent_default_num_listings` smallint(6) NOT NULL default '0', `controlpanel_rental_step` int(11) NOT NULL default '0', `controlpanel_max_rental_price` int(11) NOT NULL default '0', `controlpanel_min_rental_price` int(11) NOT NULL default '0', `controlpanel_moderate_agents` smallint(6) NOT NULL default '0', `controlpanel_moderate_members` smallint(6) NOT NULL default '0', `controlpanel_moderate_listings` smallint(6) NOT NULL default '0', `controlpanel_email_notification_of_new_users` smallint(6) NOT NULL default '0', `controlpanel_email_notification_of_new_listings` smallint(6) NOT NULL default '0', `controlpanel_allowed_upload_types` varchar(95) NOT NULL default '', `controlpanel_configured_langs` varchar(100) NOT NULL default '', `controlpanel_email_users_notification_of_new_listings` smallint(6) NOT NULL default '0', `controlpanel_configured_show_count` smallint(6) NOT NULL default '0', `controlpanel_map_type` varchar(45) NOT NULL default '', `controlpanel_map_address` varchar(45) NOT NULL default '', `controlpanel_map_city` varchar(45) NOT NULL default '', `controlpanel_map_state` varchar(45) NOT NULL default '', `controlpanel_map_zip` varchar(45) NOT NULL default '', `controlpanel_wysiwyg_editor` varchar(45) NOT NULL default '', `controlpanel_wysiwyg_execute_php` int(11) NOT NULL default '0', `controlpanel_number_decimals_number_fields` smallint(6) NOT NULL default '0', `controlpanel_number_decimals_price_fields` smallint(6) NOT NULL default '0', PRIMARY KEY (`controlpanel_version`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_controlpanel` -- /*!40000 ALTER TABLE `default_controlpanel` DISABLE KEYS */; LOCK TABLES `default_controlpanel` WRITE; INSERT INTO `default_controlpanel` VALUES ('2.0.4','/home3/brk7/public_html/immobiliare','http://immobiliare.brunicardi.com','brk','brkseven@brunicardi.com','brunicardi.com','Brunicardi immobiliare','Tuscany','brunicardiimmobiliarelogo.jpg','',1,2,'vertical-menu','OR','listing_detail_default.html','search_result_default.html','en',10,4,0,0,'
','€',1,1,1,3,7,100000,700,5,100000,700,15,900000,3000,'jpg,gif,png,egg',1,100,1,'gd','/usr/X11R6/bin/convert',1,100,0,365,1,0,1,0,0,0,0,0,0,0,0,-1,20,800,100,0,0,0,1,1,'image/pjpeg,image/jpeg,image/gif,image/x-png,application/octet-stream','en',1,1,'mapquest_IT','address','city','state','zip','xinha',0,0,0); UNLOCK TABLES; /*!40000 ALTER TABLE `default_controlpanel` ENABLE KEYS */; -- -- Table structure for table `default_en_activitylog` -- DROP TABLE IF EXISTS `default_en_activitylog`; CREATE TABLE `default_en_activitylog` ( `activitylog_id` int(11) NOT NULL auto_increment, `activitylog_log_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `userdb_id` int(11) NOT NULL default '0', `activitylog_action` varchar(150) NOT NULL default '', `activitylog_ip_address` varchar(15) NOT NULL default '', PRIMARY KEY (`activitylog_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_activitylog` -- /*!40000 ALTER TABLE `default_en_activitylog` DISABLE KEYS */; LOCK TABLES `default_en_activitylog` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_activitylog` ENABLE KEYS */; -- -- Table structure for table `default_en_agentformelements` -- DROP TABLE IF EXISTS `default_en_agentformelements`; CREATE TABLE `default_en_agentformelements` ( `agentformelements_id` int(11) NOT NULL auto_increment, `agentformelements_field_type` varchar(20) NOT NULL default '', `agentformelements_field_name` varchar(20) NOT NULL default '', `agentformelements_field_caption` varchar(80) NOT NULL default '', `agentformelements_default_text` text NOT NULL, `agentformelements_field_elements` text NOT NULL, `agentformelements_rank` int(11) NOT NULL default '0', `agentformelements_required` char(3) NOT NULL default '', `agentformelements_display_priv` int(11) NOT NULL default '0', PRIMARY KEY (`agentformelements_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_agentformelements` -- /*!40000 ALTER TABLE `default_en_agentformelements` DISABLE KEYS */; LOCK TABLES `default_en_agentformelements` WRITE; INSERT INTO `default_en_agentformelements` VALUES (3,'textarea','info','Info','','',10,'No',0),(4,'text','phone','Phone','','',1,'No',0),(5,'text','mobile','Mobile','','',3,'No',0),(6,'text','fax','Fax','','',5,'No',0),(7,'url','homepage','Homepage','','',7,'No',0); UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_agentformelements` ENABLE KEYS */; -- -- Table structure for table `default_en_listingsdb` -- DROP TABLE IF EXISTS `default_en_listingsdb`; CREATE TABLE `default_en_listingsdb` ( `listingsdb_id` int(11) NOT NULL auto_increment, `userdb_id` int(11) NOT NULL default '0', `listingsdb_title` varchar(80) NOT NULL default '', `listingsdb_expiration` date NOT NULL default '0000-00-00', `listingsdb_notes` text NOT NULL, `listingsdb_creation_date` date NOT NULL default '0000-00-00', `listingsdb_last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `listingsdb_hit_count` int(11) NOT NULL default '0', `listingsdb_featured` char(3) NOT NULL default '', `listingsdb_active` char(3) NOT NULL default '', `listingsdb_mlsexport` char(3) NOT NULL default '', PRIMARY KEY (`listingsdb_id`), KEY `idx_active` (`listingsdb_active`), KEY `idx_user` (`userdb_id`), KEY `idx_mlsexport` (`listingsdb_mlsexport`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_listingsdb` -- /*!40000 ALTER TABLE `default_en_listingsdb` DISABLE KEYS */; LOCK TABLES `default_en_listingsdb` WRITE; INSERT INTO `default_en_listingsdb` VALUES (1,1,'Example Listing','2003-07-01','This is an example listing!','2002-07-01','2005-07-16 04:22:25',18,'yes','yes','no'); UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_listingsdb` ENABLE KEYS */; -- -- Table structure for table `default_en_listingsdbelements` -- DROP TABLE IF EXISTS `default_en_listingsdbelements`; CREATE TABLE `default_en_listingsdbelements` ( `listingsdbelements_id` int(11) NOT NULL auto_increment, `listingsdbelements_field_name` varchar(20) NOT NULL default '', `listingsdbelements_field_value` text NOT NULL, `listingsdb_id` int(11) NOT NULL default '0', `userdb_id` int(11) NOT NULL default '0', PRIMARY KEY (`listingsdbelements_id`), KEY `idx_name` (`listingsdbelements_field_name`), KEY `idx_value` (`listingsdbelements_field_value`(255)), KEY `idx_listing_id` (`listingsdb_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_listingsdbelements` -- /*!40000 ALTER TABLE `default_en_listingsdbelements` DISABLE KEYS */; LOCK TABLES `default_en_listingsdbelements` WRITE; INSERT INTO `default_en_listingsdbelements` VALUES (962,'home_features','Balcony||Patio/Deck||Waterfront||Dishwasher||Disposal||Gas Range||Microwave||Washer/Dryer||Carpeted Floors||Hardwood Floors||Air Conditioning||Alarm||Cable/Satellite TV||Fireplace||Wheelchair Access ',1,1),(963,'community_features','Fitness Center||Golf Course||Pool||Spa/Jacuzzi||Sports Complex||Tennis Courts||Bike Paths||Boating||Courtyard||Playground/Park||Association Fee||Clubhouse||Controlled Access||Public Transportation',1,1),(961,'mls','13013',1,1),(960,'status','Active',1,1),(958,'prop_tax','0',1,1),(959,'garage_size','40 car',1,1),(957,'lot_size','20 Acres',1,1),(956,'sq_feet','35,000',1,1),(954,'floors','6',1,1),(955,'year_built','1800',1,1),(953,'baths','35',1,1),(952,'beds','10',1,1),(951,'type','Home',1,1),(950,'full_desc','Exclusive to this site! For two hundred years, the White House has\r\n\r\n stood as a symbol of the Presidency, the United States government,\r\nand the American people.',1,1),(949,'price','2500000',1,1),(948,'neighborhood','Capitol',1,1),(947,'zip','20500',1,1),(946,'state','District of Columbia',1,1),(945,'city','Washington',1,1),(944,'address','1600 Pennsylvania Avenue',1,1),(943,'owner','1',1,1); UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_listingsdbelements` ENABLE KEYS */; -- -- Table structure for table `default_en_listingsformelements` -- DROP TABLE IF EXISTS `default_en_listingsformelements`; CREATE TABLE `default_en_listingsformelements` ( `listingsformelements_id` int(11) NOT NULL auto_increment, `listingsformelements_field_type` varchar(20) NOT NULL default '', `listingsformelements_field_name` varchar(20) NOT NULL default '', `listingsformelements_field_caption` varchar(80) NOT NULL default '', `listingsformelements_default_text` text NOT NULL, `listingsformelements_field_elements` text NOT NULL, `listingsformelements_rank` int(11) NOT NULL default '0', `listingsformelements_search_rank` int(11) NOT NULL default '0', `listingsformelements_search_result_rank` int(11) NOT NULL default '0', `listingsformelements_required` char(3) NOT NULL default '', `listingsformelements_location` varchar(15) NOT NULL default '', `listingsformelements_display_on_browse` char(3) NOT NULL default '', `listingsformelements_searchable` int(11) NOT NULL default '0', `listingsformelements_search_type` varchar(10) default NULL, `listingsformelements_search_label` varchar(50) default NULL, `listingsformelements_search_step` int(11) NOT NULL default '0', `listingsformelements_display_priv` int(11) NOT NULL default '0', PRIMARY KEY (`listingsformelements_id`), KEY `idx_searchable` (`listingsformelements_searchable`), KEY `idx_field_type` (`listingsformelements_field_type`), KEY `idx_browse` (`listingsformelements_display_on_browse`), KEY `idx_field_name` (`listingsformelements_field_name`), KEY `idx_rank` (`listingsformelements_rank`), KEY `idx_search_rank` (`listingsformelements_search_rank`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_listingsformelements` -- /*!40000 ALTER TABLE `default_en_listingsformelements` DISABLE KEYS */; LOCK TABLES `default_en_listingsformelements` WRITE; INSERT INTO `default_en_listingsformelements` VALUES (1,'text','city','City','','',2,1,1,'Yes','top_left','Yes',0,NULL,NULL,0,0),(2,'text','address','Address','','',0,2,2,'Yes','top_left','Yes',0,NULL,NULL,0,0),(3,'text','mls','mls','','',33,0,16,'No','top_right','No',0,NULL,NULL,0,0),(21,'checkbox','home_features','Home Features','','Balcony||Patio/Deck||Waterfront||Dishwasher||Disposal||Gas Range||Microwave||Washer/Dryer||Carpeted Floors||Hardwood Floors||Air Conditioning||Alarm||Cable/Satellite TV||Fireplace||Wheelchair Access ',80,0,17,'No','feature1','No',0,NULL,NULL,0,0),(5,'number','prop_tax','Annual Property Tax','','',29,0,15,'No','top_right','No',0,NULL,NULL,0,0),(6,'select','status','Status','','Active||Pending||Sold',31,0,19,'No','top_right','No',0,NULL,NULL,0,0),(7,'text','lot_size','Lot Size','','',27,0,12,'No','top_right','No',0,NULL,NULL,0,0),(8,'text','garage_size','Garage Size','','',0,29,9,'No','top_right','No',0,NULL,NULL,0,0),(9,'text','year_built','Year Built','','',23,0,11,'No','top_left','No',0,NULL,NULL,0,0),(10,'number','sq_feet','Square Feet','','',25,0,10,'No','top_right','No',0,NULL,NULL,0,0),(11,'text','baths','Baths','','',19,0,7,'No','top_left','Yes',0,NULL,NULL,0,0),(12,'number','floors','Floors','','',21,0,8,'No','top_left','No',0,NULL,NULL,0,0),(13,'text','beds','Beds','','',17,0,6,'No','top_left','Yes',0,NULL,NULL,0,0),(14,'select','type','Type','','Home||Land||Farms||Commercial||Rental',1,0,13,'Yes','top_right','No',0,NULL,NULL,0,0),(16,'textarea','full_desc','Full Description','','',13,0,1,'No','center','Yes',0,NULL,NULL,0,0),(17,'text','neighborhood','Neighborhood','','',7,0,14,'No','top_left','No',0,NULL,NULL,0,0),(18,'price','price','Price','','',9,0,5,'No','top_left','Yes',1,'minmax','Price',5000,0),(19,'text','zip','Zip','','',5,3,3,'Yes','top_left','Yes',0,NULL,NULL,0,0),(20,'select','state','State','','Alabama||Alaska||Arizona||Arkansas||California||Colorado||Connecticut||Delaware||District of Columbia||Florida||Georgia||Hawaii||Idaho||Illinois||Indiana||Iowa||Kansas||Kentucky||Louisiana||Maine||Maryland||Massachusetts||Michigan||Minnesota||Mississippi||Missouri||Montana||Nebraska||Nevada||New Hampshire||New Jersey||New Mexico||New York||North Carolina||North Dakota||Ohio||Oklahoma||Oregon||Pennsylvania||Rhode Island||South Carolina||South Dakota||Tennessee||Texas||Utah||Vermont||Virginia||Washington||West Virginia||Wisconsin||Wyoming',4,4,4,'Yes','top_left','Yes',0,NULL,NULL,0,0),(22,'checkbox','community_features','Community Features','','Fitness Center||Golf Course||Pool||Spa/Jacuzzi||Sports Complex||Tennis Courts||Bike Paths||Boating||Courtyard||Playground/Park||Association Fee||Clubhouse||Controlled Access||Public Transportation',85,0,18,'No','feature2','No',1,'optionlist','Community Features',0,0); UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_listingsformelements` ENABLE KEYS */; -- -- Table structure for table `default_en_listingsimages` -- DROP TABLE IF EXISTS `default_en_listingsimages`; CREATE TABLE `default_en_listingsimages` ( `listingsimages_id` int(11) NOT NULL auto_increment, `userdb_id` int(11) NOT NULL default '0', `listingsimages_caption` varchar(255) NOT NULL default '', `listingsimages_file_name` varchar(80) NOT NULL default '', `listingsimages_thumb_file_name` varchar(80) NOT NULL default '', `listingsimages_description` text NOT NULL, `listingsdb_id` int(11) NOT NULL default '0', `listingsimages_rank` int(11) NOT NULL default '0', `listingsimages_active` char(3) NOT NULL default '', PRIMARY KEY (`listingsimages_id`), KEY `idx_images_listing_id` (`listingsdb_id`), KEY `idx_images_rank` (`listingsimages_rank`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_listingsimages` -- /*!40000 ALTER TABLE `default_en_listingsimages` DISABLE KEYS */; LOCK TABLES `default_en_listingsimages` WRITE; INSERT INTO `default_en_listingsimages` VALUES (1,1,'View From the Lawn','1_white-house.jpg','thumb_1_white-house.jpg','This property has six floors, 132 rooms, 35 bathrooms, 147 windows, 412 doors, 12 chimneys, 8 staircases, and 3 elevators.',1,1,'yes'),(2,1,'Vermeil Room','1_vermeil_room.jpg','thumb_1_vermeil_room.jpg','The Vermeil Room, sometimes called the Gold Room, was last refurbished in 1991; it serves as a display room and, for formal occasions, as a ladies sitting room. The soft yellow of the paneled walls complements the collection of vermeil, or gilded silver, bequeathed to the White House in 1956 by Mrs. Margaret Thompson Biddle.',1,5,'yes'),(3,1,'The China Room','1_china_room.jpg','thumb_1_china_room.jpg','The Presidential Collection Room, now the China Room, was designated by Mrs. Woodrow Wilson in 1917 to display the growing collection of White House china. The room was redecorated in 1970, retaining the traditional red color scheme determined by the portrait of Mrs. Calvin Coolidge--painted by Howard Chandler Christy in 1924. President Coolidge, who was scheduled to sit for Christy, was too occupied that day with events concerning the Teapot Dome oil scandal. So the President postponed his appointment, and Mrs. Coolidge posed instead.',1,5,'yes'),(4,1,'State Dining Room','1_dining_room.jpg','thumb_1_dining_room.jpg','The State Dining Room, which now seats as many as 140 guests, was originally much smaller and served at various times as a drawing room, office, and Cabinet Room. Not until the Andrew Jackson administration was it called the State Dining Room, although it had been used for formal dinners by previous Presidents.',1,5,'yes'),(5,1,'The Green Room','1_green_room.jpg','thumb_1_green_room.jpg','Although intended by architect James Hoban to be the Common Dining Room, the Green Room has served many purposes since the White House was first occupied in 1800. The inventory of February 1801 indicates that it was first used as a Lodging Room. Thomas Jefferson, the second occupant of the White House, used it as a dining room with a canvas floor cloth, painted green, foreshadowing the present color scheme. James Madison made it a sitting room since his Cabinet met in the East Room next door, and the Monroes used it as the Card Room with two tables for the whist players among their guests. ',1,5,'yes'); UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_listingsimages` ENABLE KEYS */; -- -- Table structure for table `default_en_memberformelements` -- DROP TABLE IF EXISTS `default_en_memberformelements`; CREATE TABLE `default_en_memberformelements` ( `memberformelements_id` int(11) NOT NULL auto_increment, `memberformelements_field_type` varchar(20) NOT NULL default '', `memberformelements_field_name` varchar(20) NOT NULL default '', `memberformelements_field_caption` varchar(80) NOT NULL default '', `memberformelements_default_text` text NOT NULL, `memberformelements_field_elements` text NOT NULL, `memberformelements_rank` int(11) NOT NULL default '0', `memberformelements_required` char(3) NOT NULL default '', PRIMARY KEY (`memberformelements_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_memberformelements` -- /*!40000 ALTER TABLE `default_en_memberformelements` DISABLE KEYS */; LOCK TABLES `default_en_memberformelements` WRITE; INSERT INTO `default_en_memberformelements` VALUES (3,'textarea','info','Info','','',10,'No'),(4,'text','phone','Phone','','',1,'No'),(5,'text','mobile','Mobile','','',3,'No'),(6,'text','fax','Fax','','',5,'No'),(7,'url','homepage','Homepage','','',7,'No'); UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_memberformelements` ENABLE KEYS */; -- -- Table structure for table `default_en_pagesmain` -- DROP TABLE IF EXISTS `default_en_pagesmain`; CREATE TABLE `default_en_pagesmain` ( `pagesmain_id` int(11) NOT NULL auto_increment, `pagesmain_title` varchar(70) NOT NULL default '', `pagesmain_date` varchar(20) NOT NULL default '', `pagesmain_summary` varchar(255) NOT NULL default '', `pagesmain_full` text NOT NULL, `pagesmain_no_visitors` int(11) NOT NULL default '0', `pagesmain_complete` smallint(6) NOT NULL default '0', PRIMARY KEY (`pagesmain_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_pagesmain` -- /*!40000 ALTER TABLE `default_en_pagesmain` DISABLE KEYS */; LOCK TABLES `default_en_pagesmain` WRITE; INSERT INTO `default_en_pagesmain` VALUES (1,'Contattateci','17 August 2003','Welcome Page','

BRUNICARDI Agenzia immobiliare di Marina di Carrara

www.immobiliare.brunicardi.com

BRUNICARDI IMMOBILIARE

Via Genova 17b (angolo Via Rinchiosa) nella zona pedonale di Marina di Carrara 54036 (MS) Toscana Settentrionale

Tel: 0585 789059 - 347 9071641 - 0585 632743

',0,1),(2,'Contact Us','17 August 2003','contact us page','

Contatta Brunicardi Immobiliare!


Puoi contattarci in diversi modi: 

Per Telefono: 0585 789059 - 347 9071641
Per Email admin@here.com
Per Fax 0585 632743
Per posta Via Genova 17b 54036 Marina di Carrara (MS) Toscana

Vi aspettiamo!


',0,1),(3,'About Us','17 August 2003','About Us Page','

Chi siamo:

BRUNICARDI Immobiliare - Marina di Carrara

Brunicardi Immobiliare e\' un\'agenzia immobiliare di Marina di Carrara dedita all\'intermediazione della compravendita internazionale, con speciale attenzione al mercato inglese:

  • Mulini
  • Casali
  • Fienili
  • Stalle
  • Cascinali
  • Ville
  • Case rurali
  • Case coloniche
  • Rustici
  • Monasteri
  • Case canoniche
  • Qualsiasi immobile di campagna
  • Appartamenti
  • Villette
  • Case padronali

Sono gli immobili che trattiamo preferibilmente e che collochiamo sul mercato immobiliare inglese.

Notoriamente ci sono moltissimi investitori inglesi che beneficiando di una congiuntura economica particolarmente favorevole, con immobili inglesi superapprezzati quanto mai era successo in Inghilterra e in tutto il Regno Unito, cercano di capitalizzare gli investimenti immobiliari inglesi e diversificare investendo all\'estero. L\'Italia e\' uno delle destinazioni preferite dagli inglesi in virtu\' della vicinanza, dei molti voli a basso costo, della bellezza di varie regioni d\'Italia, del folclore che accompagna riccamente ogni evento quotidiano, del buon vino e ottimo cibo, dell\'appartenenza all\'Unione Europea, e per tanti altri motivi.

Noi cerchiamo di acquisire proprieta\' rustiche e rurali che non sono apprezzate dal mercato dei compratori immobiliari italiani e di valorizzarle proponendole a compratori immobiliari inglesi. Questi sono piu\' disposti a spendere cifre cospicue e adorano gli immobili da ristrutturare, soprattutto se hanno terreno a disposizione per giardino e piscina. Prediligendo addirittura gli immobili e le case meno accessibili per la massima tranquillita\' possibile.

RIVALUTATE I VOSTRI IMMOBILI RUSTICI E PERMETTETECI DI OFFRIRLI IN VENDITA AGLI INGLESI CHE SONO DISPOSTI A PAGARE CIFRE INASPETTATE PER IL RUDERE CHE NON SAPETE A CHI DARE!

Vi aspettiamo con i vostri rustici per spiegarvi la nostra strategia di vendita agli inglesi e le nostre tattiche di marketing in Inghilterra.

Prestiamo i nostri servizi sia ai privati che alle agenzie titolari di esclusiva su immobili invendibili.

BRUNICARDI IMMOBILIARE, MARINA DI CARRARA

Via Genova 17b (angolo Via Rinchiosa) nella zona pedonale di Marina di Carrara

Tel: 0585 789059 - 347 9071641 - 0585 632743

',0,1),(4,'Legal Page','17 August 2003','Legal Page','

Legal Disclaimer

Use of this legal page is not suggested or reccomended., you should consult your lawyer to get proper legal disclaimers for your state/country.


Information Not Warranted or Guaranteed:
The official {company_name} website and all pages linked to it or from it, are PROVIDED ON AN \"AS IS, AS AVAILABLE\" BASIS. {company_name} MAKES NO WARRANTIES, EXPRESSED OR IMPLIED, INCLUDING, WITHOUT LIMITATION, THOSE OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO ANY INFORMATION OR USE OF INFORMATION CONTAINED IN THE WEBSITE, OR LINKED FROM IT OR TO IT.

{company_name} does not warrant or guarantee the accuracy, adequacy, quality, currentness, completeness, or suitability of any information for any purpose; that any information will be free of infection from viruses, worms, Trojan horses or other destructive contamination; that the information presented will not be objectionable to some individuals or that this service will remain uninterrupted.

No Liability:
{company_name}, its agents or employees shall not be held liable to anyone for any errors, omissions or inaccuracies under any circumstances. The entire risk for utilizing the information contained on this site or linked to this site rests solely with the users of this site.',0,1),(6,'Agenzia Brunicardi','2005-07-17','','Agenzia+Brunicardi',0,1),(7,'Chi Siamo','2005-07-17','',' 

Chi siamo:

BRUNICARDI Immobiliare - Marina di Carrara

Brunicardi Immobiliare e\' un\'agenzia immobiliare di Marina di Carrara dedita all\'intermediazione della compravendita internazionale, con speciale attenzione al mercato inglese:

  • Mulini
  • Casali
  • Fienili
  • Stalle
  • Cascinali
  • Ville
  • Case rurali
  • Case coloniche
  • Rustici
  • Monasteri
  • Case canoniche
  • Qualsiasi immobile di campagna
  • Appartamenti
  • Villette
  • Case padronali

Sono gli immobili che trattiamo preferibilmente e che collochiamo sul mercato immobiliare inglese.

Notoriamente ci sono moltissimi investitori inglesi che beneficiando di una congiuntura economica particolarmente favorevole, con immobili inglesi superapprezzati quanto mai era successo in Inghilterra e in tutto il Regno Unito, cercano di capitalizzare gli investimenti immobiliari inglesi e diversificare investendo all\'estero. L\'Italia e\' uno delle destinazioni preferite dagli inglesi in virtu\' della vicinanza, dei molti voli a basso costo, della bellezza di varie regioni d\'Italia, del folclore che accompagna riccamente ogni evento quotidiano, del buon vino e ottimo cibo, dell\'appartenenza all\'Unione Europea, e per tanti altri motivi.

Noi cerchiamo di acquisire proprieta\' rustiche e rurali che non sono apprezzate dal mercato dei compratori immobiliari italiani e di valorizzarle proponendole a compratori immobiliari inglesi. Questi sono piu\' disposti a spendere cifre cospicue e adorano gli immobili da ristrutturare, soprattutto se hanno terreno a disposizione per giardino e piscina. Prediligendo addirittura gli immobili e le case meno accessibili per la massima tranquillita\' possibile.

RIVALUTATE I VOSTRI IMMOBILI RUSTICI E PERMETTETECI DI OFFRIRLI IN VENDITA AGLI INGLESI CHE SONO DISPOSTI A PAGARE CIFRE INASPETTATE PER IL RUDERE CHE NON SAPETE A CHI DARE!

Vi aspettiamo con i vostri rustici per spiegarvi la nostra strategia di vendita agli inglesi e le nostre tattiche di marketing in Inghilterra.

Prestiamo i nostri servizi sia ai privati che alle agenzie titolari di esclusiva su immobili invendibili.

BRUNICARDI IMMOBILIARE, MARINA DI CARRARA

Via Genova 17b (angolo Via Rinchiosa) nella zona pedonale di Marina di Carrara

Tel: 0585 789059 - 347 9071641 - 0585 632743

',0,1),(8,'Contattaci','2005-07-17','','',0,1),(9,'Mappa Sito','2005-07-17','','Mappa+Sito',0,1),(5,'Links','2005-07-16','','

italy house for sale

tuscany house for sale

agenzia immobiliare a marina di carrara

',0,1); UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_pagesmain` ENABLE KEYS */; -- -- Table structure for table `default_en_userdb` -- DROP TABLE IF EXISTS `default_en_userdb`; CREATE TABLE `default_en_userdb` ( `userdb_id` int(11) NOT NULL auto_increment, `userdb_user_name` varchar(80) NOT NULL default '', `userdb_emailaddress` varchar(80) NOT NULL default '', `userdb_comments` text NOT NULL, `userdb_user_password` varchar(50) NOT NULL default '', `userdb_is_admin` char(3) NOT NULL default '', `userdb_can_edit_forms` char(3) NOT NULL default '', `userdb_creation_date` date NOT NULL default '0000-00-00', `userdb_can_feature_listings` char(3) NOT NULL default '', `userdb_can_view_logs` char(3) NOT NULL default '', `userdb_last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `userdb_hit_count` int(11) NOT NULL default '0', `userdb_can_moderate` char(3) NOT NULL default '', `userdb_can_edit_pages` char(3) NOT NULL default '', `userdb_can_have_vtours` char(3) NOT NULL default '', `userdb_is_agent` char(3) NOT NULL default '', `userdb_active` char(3) NOT NULL default '', `userdb_limit_listings` int(11) NOT NULL default '0', PRIMARY KEY (`userdb_id`), KEY `idx_user_name` (`userdb_user_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_userdb` -- /*!40000 ALTER TABLE `default_en_userdb` DISABLE KEYS */; LOCK TABLES `default_en_userdb` WRITE; INSERT INTO `default_en_userdb` VALUES (1,'brk','brkseven@brunicardi.com','','4ff036e0617a0aea69c775c253c9ee44','yes','yes','2002-07-01','yes','yes','2002-07-01 22:38:50',1,'yes','yes','yes','no','yes',-1); UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_userdb` ENABLE KEYS */; -- -- Table structure for table `default_en_userdbelements` -- DROP TABLE IF EXISTS `default_en_userdbelements`; CREATE TABLE `default_en_userdbelements` ( `userdbelements_id` int(11) NOT NULL auto_increment, `userdbelements_field_name` varchar(80) NOT NULL default '', `userdbelements_field_value` text NOT NULL, `userdb_id` int(11) NOT NULL default '0', PRIMARY KEY (`userdbelements_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_userdbelements` -- /*!40000 ALTER TABLE `default_en_userdbelements` DISABLE KEYS */; LOCK TABLES `default_en_userdbelements` WRITE; INSERT INTO `default_en_userdbelements` VALUES (1,'edit_user_name','admin',1),(2,'phone','215.850.0710',1),(3,'mobile','215.850.0710',1),(4,'fax','702.995.6591',1),(5,'homepage','http://www.open-realty.org',1),(6,'info','I am the system administrator!',1); UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_userdbelements` ENABLE KEYS */; -- -- Table structure for table `default_en_userfavoritelistings` -- DROP TABLE IF EXISTS `default_en_userfavoritelistings`; CREATE TABLE `default_en_userfavoritelistings` ( `userfavoritelistings_id` int(11) NOT NULL auto_increment, `userdb_id` int(11) NOT NULL default '0', `listingsdb_id` int(11) NOT NULL default '0', PRIMARY KEY (`userfavoritelistings_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_userfavoritelistings` -- /*!40000 ALTER TABLE `default_en_userfavoritelistings` DISABLE KEYS */; LOCK TABLES `default_en_userfavoritelistings` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_userfavoritelistings` ENABLE KEYS */; -- -- Table structure for table `default_en_userimages` -- DROP TABLE IF EXISTS `default_en_userimages`; CREATE TABLE `default_en_userimages` ( `userimages_id` int(11) NOT NULL auto_increment, `userdb_id` int(11) NOT NULL default '0', `userimages_caption` varchar(255) NOT NULL default '', `userimages_file_name` varchar(80) NOT NULL default '', `userimages_thumb_file_name` varchar(80) NOT NULL default '', `userimages_description` text NOT NULL, `userimages_rank` int(11) NOT NULL default '0', `userimages_active` char(3) NOT NULL default '', PRIMARY KEY (`userimages_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_userimages` -- /*!40000 ALTER TABLE `default_en_userimages` DISABLE KEYS */; LOCK TABLES `default_en_userimages` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_userimages` ENABLE KEYS */; -- -- Table structure for table `default_en_usersavedsearches` -- DROP TABLE IF EXISTS `default_en_usersavedsearches`; CREATE TABLE `default_en_usersavedsearches` ( `usersavedsearches_id` int(11) NOT NULL auto_increment, `userdb_id` int(11) NOT NULL default '0', `usersavedsearches_title` varchar(255) NOT NULL default '', `usersavedsearches_query_string` text NOT NULL, `usersavedsearches_last_viewed` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `usersavedsearches_new_listings` smallint(6) NOT NULL default '0', PRIMARY KEY (`usersavedsearches_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_usersavedsearches` -- /*!40000 ALTER TABLE `default_en_usersavedsearches` DISABLE KEYS */; LOCK TABLES `default_en_usersavedsearches` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_usersavedsearches` ENABLE KEYS */; -- -- Table structure for table `default_en_vtourimages` -- DROP TABLE IF EXISTS `default_en_vtourimages`; CREATE TABLE `default_en_vtourimages` ( `vtourimages_id` int(11) NOT NULL auto_increment, `userdb_id` int(11) NOT NULL default '0', `vtourimages_caption` varchar(255) NOT NULL default '', `vtourimages_file_name` varchar(80) NOT NULL default '', `vtourimages_thumb_file_name` varchar(80) NOT NULL default '', `vtourimages_description` text NOT NULL, `listingsdb_id` int(11) NOT NULL default '0', `vtourimages_rank` int(11) NOT NULL default '0', `vtourimages_active` char(3) NOT NULL default '', PRIMARY KEY (`vtourimages_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_en_vtourimages` -- /*!40000 ALTER TABLE `default_en_vtourimages` DISABLE KEYS */; LOCK TABLES `default_en_vtourimages` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `default_en_vtourimages` ENABLE KEYS */; -- -- Table structure for table `default_forgot` -- DROP TABLE IF EXISTS `default_forgot`; CREATE TABLE `default_forgot` ( `forgot_id` int(10) unsigned NOT NULL auto_increment, `forgot_rand` int(10) unsigned NOT NULL default '0', `forgot_email` varchar(45) NOT NULL default '', `forgot_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`forgot_id`), KEY `forgot_idx_forgot_email` (`forgot_email`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `default_forgot` -- /*!40000 ALTER TABLE `default_forgot` DISABLE KEYS */; LOCK TABLES `default_forgot` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `default_forgot` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;