Notice (8): unserialize(): Error at offset 40941 of 40949 bytes [CORE/Cake/Cache/Engine/FileEngine.php, line 194]Code Context$data = str_replace('\\\\\\\\', '\\', $data);}$data = unserialize((string)$data);$key = 'myapp_cake_core_method_cache' $time = (int) 1762188008 $cachetime = (int) 1762188018 $data = 'a:3:{i:0;b:0;s:4:"name";a:340:{s:32:"6ffdd24df8128bd2dee144f2bc4c26ba";s:18:"`Departement`.`id`";s:32:"92b4c6c2973b147cd7bcaa9c8a75f316";s:18:"`Departement__lib`";s:32:"7ec0ac3433bbef218f0ee2815213e9e3";s:4:"" ("";s:32:"a0361a9cbe98c2ea2ccd8b7ee8842382";s:3:"")"";s:32:"c90ae449a68f32be8118d349874ba385";s:14:"`lepetitbz331`";s:32:"bced73ca92db4ae12dc958018ccb4c26";s:14:"`departements`";s:32:"c184ef7a5ca82d94a917d9a5c4ba23ed";s:13:"`Departement`";s:32:"29126a3a52be88127591ae5c23ca88cf";s:6:"`code`";s:32:"a3bda72c8358843bdc43fbcd52c8f5b5";s:24:"`Ville`.`departement_id`";s:32:"11d2680b8852e8a1913406ed1a52ac08";s:8:"`villes`";s:32:"abfe790023ff0d1611edcb6dfce6802d";s:14:"`Moyennevente`";s:32:"c1955c45da499f15d5021c8c72d79c2f";s:26:"`Moyennevente`.`codeinsee`";s:32:"63a2ac815a36fbcbf376027705467c8a";s:22:"`Ville`.`code_commune`";s:32:"3c8d21fc2164772cb7201fe48deb9396";s:15:"`moyenneventes`";s:32:"4074550b4bbee6a4267a989b94eb3c28";s:9:"`Service`";s:32:"2820d7e3c0cdadb2d655400d922db24a";s:18:"`Service`.`CODGEO`";s:32:"c359b7626061b1039ae6a3000e4cfe3c";s:10:"`services`";s:32:"b2c7c45f9ab47735e87c3b000b4368af";s:14:"`Ville`.`slug`";s:32:"08d8101334237ff0a755e8a585391ccf";s:25:""gerbecourt-et-haplemont"";s:32:"155d4ed88991347fe7ea82b4e0b41352";s:7:"`Ville`";s:32:"f6f73245755f80817e02585396487347";s:12:"`Ville`.`id`";s:32:"b3a132b3002f0a095c207367d2386438";s:13:"`Ville`.`dep`";s:32:"c5697e1e5c979d7ac16a2058fe255e21";s:13:"`Ville`.`nom`";s:32:"f340c52a13f3cf8684f61cdbc6725f3f";s:13:"`Ville`.`lat`";s:32:"b4707c5ae31d038ddd76310d59aceb1c";s:13:"`Ville`.`lng`";s:32:"8af9a7412209202b2e0e984c3f255d07";s:10:"`distance`";s:32:"c1f9b57df40a583acfdf261e4793fe99";s:20:"`Ville`.`population`";s:32:"f721416f99749f3df35aa11d34cb1cf3";s:12:"`population`";s:32:"3857f2e1b78a705845c11758b879ec11";s:11:"`Epublic`.*";s:32:"6504b0970e350614eba7cc0cf66aae51";s:10:"`epublics`";s:32:"311ac503c2c83d277449d5c03a0ee2e8";s:23:"`Epublic`.`identifiant`";s:32:"95ccb19139b56742a7732f163bad069e";s:10:""%mairie%"";s:32:"47b08794347dfb2384d73f46d8cdcb32";s:21:"`Epublic`.`codeinsee`";s:32:"f69a35e86d63bf05c91e3dc865dd3709";s:7:""54221"";s:32:"8c0b662da940de7037c2bab929dcef1d";s:9:"`Epublic`";s:32:"9a3600fb95e8205f33e11d93f770cfb9";s:16:"`etablissements`";s:32:"1be622d935eb0dd0c7e58a62e227a657";s:20:"`Etablissement`.`id`";s:32:"f3d82e8ee5e91d5866793a4ca4ed0c93";s:23:"`Etablissement`.`siren`";s:32:"0efb4e97ead0410107e96ae6cb489c14";s:20:"`Etablissement`.`rs`";s:32:"8bcebc6efad54c5593f8cc8592d732c7";s:22:"`Etablissement`.`slug`";s:32:"2838dc68d05ac3364132f45f55975893";s:21:"`Etablissement`.`img`";s:32:"d61d90b9849537e0cf77726d4d1bed4c";s:21:"`Etablissement`.`pdf`";s:32:"75c6571d87fb87d853fdf142c6f4ee34";s:21:"`Etablissement`.`lng`";s:32:"b0a9c0163be136679cb7aaaf68eb67fa";s:21:"`Etablissement`.`lat`";s:32:"8b905edc230cf3ba9566668da045397d";s:22:"`Etablissement`.`desc`";s:32:"17ce0a1b745586b5481bd2659670ce01";s:28:"`Etablissement`.`historique`";s:32:"190556c243fea80e29a79f8d71231cc8";s:26:"`Etablissement`.`chambres`";s:32:"266364fcf4472684468e83b306fd4686";s:30:"`Etablissement`.`restauration`";s:32:"8be5e44c45f7287eb279be0f26743cdb";s:27:"`Etablissement`.`situation`";s:32:"e96a683a32c44452e7a0e3821f19e6d5";s:25:"`Etablissement`.`parking`";s:32:"ef4980c19106906ba4e419b623dbcc5d";s:30:"`Etablissement`.`animauxadmis`";s:32:"05c511133282e79f3cb2aada631c4bb1";s:29:"`Etablissement`.`equipements`";s:32:"1e1f64fe2b6c940a130904c95995b7da";s:25:"`Etablissement`.`langues`";s:32:"14162a432865948bdf4a852e0faeb95f";s:24:"`Etablissement`.`tarifs`";s:32:"88508b25214c29f69cc3b07a1f9fe894";s:28:"`Etablissement`.`supplement`";s:32:"06242cdb74ecd096ab7c648ed232b419";s:26:"`Etablissement`.`capacite`";s:32:"9a47b0361d47e3f745fafced9219786f";s:26:"`Etablissement`.`categ_id`";s:32:"a10db395b9efb7ad27b39a3859a5c1ec";s:24:"`Etablissement`.`adress`";s:32:"4eef95bfa78d9bd42003f1b7709f21f1";s:25:"`Etablissement`.`adress2`";s:32:"8e8f9fbf2febbf9da306a06db31eaf5c";s:26:"`Etablissement`.`cp_ville`";s:32:"7c21cde53b6fbdec5f13e813f2420207";s:20:"`Etablissement`.`cp`";s:32:"5dca682eb27a5c39e2c4bb44c376205c";s:26:"`Etablissement`.`ville_id`";s:32:"84794120bcf00d57d5c95509c6dd6ba9";s:21:"`Etablissement`.`tel`";s:32:"40fa51bb8cb7c4a9c2b097c28ac7dc80";s:27:"`Etablissement`.`telecopie`";s:32:"a308ab77d34b589977fbb1facf28056c";s:23:"`Etablissement`.`email`";s:32:"0d21b27b030a717527b9174797aa4235";s:26:"`Etablissement`.`site_web`";s:32:"5357163bc68467b6ae009dac63462c2b";s:25:"`Etablissement`.`partner`";s:32:"5a971db96511a81c17f5ea0171270e5c";s:27:"`Etablissement`.`full_desc`";s:32:"65ee872b9d308ffcde62806477c81284";s:21:"`Etablissement`.`fin`";s:32:"302e47de74b9bb812f1f70870dab0ddc";s:22:"`Etablissement`.`view`";s:32:"52249bd313f1f7619ae93de0d5d72bee";s:32:"`Etablissement`.`departement_id`";s:32:"1ab99d655aaa071ba2feb461a67aa186";s:28:"`Etablissement`.`agregat_id`";s:32:"d412679177dd4e90e8985bf3c84dee16";s:22:"`Etablissement`.`pets`";s:32:"e05f5b4413dedb2732599617f807556c";s:26:"`Etablissement`.`horaires`";s:32:"8d4ea0d8b5d80a07d6122537a36be68c";s:27:"`Etablissement`.`date_call`";s:32:"51e93a971b8f4be41e95691839c4837d";s:32:"`Etablissement`.`recall_creneau`";s:32:"bc4f8d27d98c9ea99bf6ae1fb62d791c";s:28:"`Etablissement`.`convention`";s:32:"f48c736cd00796c91312e38ca69aa43b";s:33:"`Etablissement`.`convention_text`";s:32:"4a3f0be93fdcc639ed15c3d03151d791";s:33:"`Etablissement`.`convention_date`";s:32:"b28f65eaedd4583e7422316d630fb0b9";s:29:"`Etablissement`.`financement`";s:32:"986ca076e9ffa66abb309a36ca4c14f6";s:34:"`Etablissement`.`financement_text`";s:32:"dd6b8fdd4906dc87d48ff763bcbdbe41";s:34:"`Etablissement`.`financement_date`";s:32:"4f8b1c8519d2fe54dce650d814e94efb";s:27:"`Etablissement`.`direction`";s:32:"85ca6a6983e5f098380837e26f828b01";s:32:"`Etablissement`.`direction_name`";s:32:"977c186d9000ab3cdf33f96f0ccb58e6";s:33:"`Etablissement`.`direction_email`";s:32:"e42057de332eb8fe8e943fa011e138e6";s:32:"`Etablissement`.`direction_move`";s:32:"6b77f9d061073c49dc210d6295535089";s:32:"`Etablissement`.`direction_text`";s:32:"c3327fd912d046d8a589fe7e9dea4756";s:32:"`Etablissement`.`direction_date`";s:32:"77aefda4d62a6524b40989b2d8d15612";s:32:"`Etablissement`.`recall_travaux`";s:32:"24413814ddfd478c355947b937143676";s:32:"`Etablissement`.`recall_maladie`";s:32:"971288ff498287b31eda6792a8e4dd29";s:30:"`Etablissement`.`recall_autre`";s:32:"23c62e5f800aafcedf58fffe048dd68d";s:29:"`Etablissement`.`recall_date`";s:32:"348cae104a01acaf1c087f05c56a58fc";s:29:"`Etablissement`.`observation`";s:32:"7de0eb817f98e54fb4e1545b78d80fe1";s:25:"`Etablissement`.`user_id`";s:32:"808ffbab4bd715dce1b305cf62835111";s:26:"`Etablissement`.`modified`";s:32:"291996f689feffd916e98d0b476e3a52";s:25:"`Etablissement`.`created`";s:32:"c28944d2d6eb600005c2af84c65564ab";s:12:"`Ville`.`cp`";s:32:"dae70075c678611634e66603f2507e87";s:17:"`Ville`.`commune`";s:32:"57bf3bd16d22d1b823018a6025079b24";s:24:"`Ville`.`arrondissement`";s:32:"b052d37be080aa8824cc9854ed3cf459";s:16:"`Ville`.`canton`";s:32:"7f00fac894bcaa6f6957e1656c394953";s:14:"`Ville`.`amdi`";s:32:"43701643bdb6302c47823411692303ff";s:17:"`Ville`.`surface`";s:32:"d566309c0012ca98a5e57a7bedb032f9";s:13:"`Ville`.`ski`";s:32:"55be94b87f050cb7030cf3de79cb27a6";s:17:"`Ville`.`created`";s:32:"e782832d7a2689f8cdf15060a110a972";s:20:"`Ville`.`descriptif`";s:32:"691e753cebf5a915d0de75218e3ea067";s:13:"`Ville`.`img`";s:32:"a6382f688c824218203f0808712ffca6";s:14:"`Agregat`.`id`";s:32:"e478222606bf391f2d59503a883e870f";s:10:"`agregats`";s:32:"5014af7f66e2b32efa7aa3a47124f74b";s:15:"`Agregat`.`lib`";s:32:"6f50392488f24686919a1b4910dc7689";s:16:"`Agregat`.`lib2`";s:32:"ffb7b854b5ab9be92d699d39783561d3";s:19:"`Agregat`.`libRech`";s:32:"0f5491fbe3c71a8d5c826cdb6cf884ec";s:15:"`Agregat`.`img`";s:32:"286f28574d7bea14d39d2894e34cb51a";s:18:"`Agregat`.`imgCat`";s:32:"43a3e95b8a02906d1ec54cfdf661c369";s:23:"`Agregat`.`code_finess`";s:32:"3b461942687bd09977212f947e998a70";s:19:"`Agregat`.`nb_view`";s:32:"ff25dfd114b40931caf9a50acfbc857f";s:16:"`Agregat`.`slug`";s:32:"225eb7b2f28fe983777b8178353a316c";s:16:"`Agregat`.`desc`";s:32:"39bbb01a6b52f4aa883c7280d7fdd615";s:24:"`Agregat`.`ensavoirplus`";s:32:"738ba2bd6d4be2d93d680ba6bbaa48e3";s:19:"`Agregat`.`imglist`";s:32:"56172bdc6f68aa3180cb6797b14ad59d";s:19:"`Agregat`.`created`";s:32:"700b564bc6ce9eca080f8dd142ba3e8f";s:17:"`Agregat`.`class`";s:32:"4526819598ac2d82a6502a37524ffe7c";s:9:"`Agregat`";s:32:"a27ec4135f193498d357b9b4deb6a063";s:15:"`Etablissement`";s:32:"0e65ec17b9dc5f6d10c5bf139e8608fb";s:14:""lissay-lochy"";s:32:"d1e0526e00f2379d3747f074bfcefbde";s:7:""18129"";s:32:"ef1c400f08969e60c0dc4044586b453e";s:10:""liergues"";s:32:"6f73c8cbf875a96f975ce96275a46233";s:7:""69114"";s:32:"4980ed713520c53a5ef7bfe59bfe3568";s:14:"`Mur`.`pseudo`";s:32:"5df22fc0ee63f77314a59940fedac466";s:15:"`Mur`.`contenu`";s:32:"78f75bec59f89c734ad73833bc56b727";s:14:"`Mur`.`posted`";s:32:"f0a34e9f16b52b8585fb8852c455febf";s:6:"`murs`";s:32:"025bf5e280fa1a5abe6649e1e4de4e90";s:16:"`Mur`.`ville_id`";s:32:"aeb9c0f91b83d19a86e2de9383c8aea7";s:16:"`Mur`.`validate`";s:32:"9d1b58c9bf83bd6b146c7059e2971034";s:5:"`Mur`";s:32:"d2c23d1b4feeec456d72cdc94cc44595";s:4:"`id`";s:32:"359ac070c703c6225869362821552643";s:11:"`Annonce`.*";s:32:"40afeb1c40614860e01d0748c5f553df";s:10:"`annonces`";s:32:"8027d37245b611a3fbdf14a1e89d8f29";s:20:"`Annonce`.`ville_id`";s:32:"404f56ef6af3757e2e643f86960284d3";s:18:"`Annonce`.`statut`";s:32:"f95ddc2be023960209cb5ce5f087ddbd";s:9:"`Annonce`";s:32:"37268c5bb04e1e90ba6524030193da94";s:10:""maron-54"";s:32:"d66e804f92b6c40fb0067bd426018195";s:7:""54352"";s:32:"11b64736e402338e602801c157ef0aa3";s:22:""fraisnes-en-saintois"";s:32:"a0bce452400d88800de33266593bd671";s:7:""54207"";s:32:"a187a2c56244b07522c556ed863a58ef";s:10:""theillay"";s:32:"5549c6f671f4e31bb557ee6620912357";s:7:""41256"";s:32:"642fe39c169620ec3fb4bc567b938fcc";s:7:""foecy"";s:32:"0633c3fbc607e787be06c57722a8fced";s:7:""18096"";s:32:"b0b1b9e61fc546e2c7f59fe4eeb9cb14";s:9:""hatrize"";s:32:"42bb62446d46c666746cc42a6b98d01a";s:7:""54253"";s:32:"1243b4d087836a2b0de8dab1f3ab6970";s:12:""giriviller"";s:32:"f46433efa9f46fd81563575ff1422ee5";s:7:""54228"";s:32:"4ef276b05b248eec971b64bec83b9879";s:13:""dignonville"";s:32:"26c26de113d1624f9a9aa59723ea716a";s:7:""88133"";s:32:"21101fc067ddf6e598d01355e22c6450";s:17:""art-sur-meurthe"";s:32:"8078b880d1af8256e58b0ac6cf823aa6";s:7:""54025"";s:32:"466490d29a32fcc133956931c04f7be8";s:11:""villerupt"";s:32:"8b16fc903f54a1fde30bbbb8b52c5a34";s:7:""54580"";s:32:"135d2fb6a5844052afa9f3e36a73a347";s:9:""velines"";s:32:"e7893031e5d64baa00c0605494e6e74f";s:7:""24568"";s:32:"7706781f5550f585dd89fc543d74c9a2";s:21:""chaillac-sur-vienne"";s:32:"a5638b222ece144000e42dc70668c07d";s:7:""87030"";s:32:"369d7720b800e27bdabacdedb3f88a11";s:11:""torpes-25"";s:32:"c110660d60b1d3328ffb52ff4c356570";s:7:""25564"";s:32:"2cfab138b051f37c663573bd2eee4c87";s:8:""landec"";s:32:"bd659da7f0b8f181fb253434033771da";s:7:""22097"";s:32:"fd548825d1a4ff5bdc0f32b86dbc20ba";s:7:""vichy"";s:32:"bec193063a043aeccf0338d4d3e572b2";s:7:""03310"";s:32:"4b5b179f3d4d02caf2bc8f10c9508150";s:17:"`Etablissement`.*";s:32:"ddd34ba2fe5b8a28f2a178b624f2dbdf";s:11:"`Agregat`.*";s:32:"db3637d11fcdcd69df12fd155007380a";s:27:"`Etablissement`.`codeinsee`";s:32:"9e9324354827438087cb97d78e67cb63";s:11:"`Categorie`";s:32:"6c96c7067859c92b2cd5c584da7020fd";s:19:"`Categorie`.`siret`";s:32:"becfa4e4a7c9b2d19025948a972a6478";s:23:"`Etablissement`.`siret`";s:32:"469f0eca4934529a8ebe3db2dddf24e6";s:12:"`categories`";s:32:"2c62152eb8c6e394c181c6dd4ec49616";s:23:"`Categorie`.`categorie`";s:32:"e2a92904f19ac3741c5289826f443a98";s:10:""clion-36"";s:32:"0e9ee84db222118ed0b28d2fd4e999fa";s:7:""36055"";s:32:"ddb87ae18297efbd307f7004210ebc40";s:12:""chenelette"";s:32:"eef0592a9d820a96564ec4f63b8bd200";s:7:""69054"";s:32:"c9770f37cbb205ecd4a3b93224898de1";s:12:""balaiseaux"";s:32:"5fe2b22077ec7ee29a799d492eb93830";s:7:""39034"";s:32:"c60362cc523d4f7e463bcca01bddf2ac";s:10:""azolette"";s:32:"1b004f5b330205d2f03198afea89e879";s:7:""69016"";s:32:"3094ae42a6c9e061ecf5fa45aa022dac";s:20:""neauphe-sous-essai"";s:32:"c6bae6a6a6a036bc096ff8bd68c9c2dc";s:7:""61301"";s:32:"485cf49ced0f4d5d88b89505ebe6f7f8";s:23:""cormeilles-en-parisis"";s:32:"bad5161e691d58264430eaa5dd3d185e";s:7:""95176"";s:32:"f488fbd8fe9e087774ba7b16d215395f";s:9:""bendorf"";s:32:"df7d27d2da669b261d16acda35ed0988";s:7:""68025"";s:32:"9892e3dbce2d098811de7a8389824e07";s:22:""morainville-jouveaux"";s:32:"ae653392a2eff462ffdcf1351ade4f9b";s:7:""27415"";s:32:"c137ea35bb5e17290eb6dd61df7bbc2f";s:20:""st-genis-d-hiersac"";s:32:"4af9c66051cd39be3e8a240abf16293c";s:7:""16320"";s:32:"4a734a2cf1fb450a5ae753829c5b7424";s:8:""ranton"";s:32:"80be4076cb5078073fd06de506cbacdc";s:8:"`Info`.*";s:32:"65c814b1b540f6da677533b16200a366";s:9:"`Sujet`.*";s:32:"6e09c806ee1568f15d870232c9ad7192";s:7:"`Sujet`";s:32:"9cc9932f961dd20be2485b6e784c67c9";s:9:"`Ville`.*";s:32:"0d0d440f3c7e653c8e2c7441c2a0d952";s:7:"`infos`";s:32:"3173fb2701c28779fb55d9fccb0214d0";s:17:"`Info`.`ville_id`";s:32:"3f291f5951c2401d928d43a105167167";s:17:"`Sujet`.`info_id`";s:32:"47595faa5061b239a137aa95ab2d051e";s:11:"`Info`.`id`";s:32:"b790d6f73c2cec29a0d7d28fa5e12bce";s:8:"`sujets`";s:32:"e8e3ca76fb86257b3cc96203366fa277";s:6:"`Info`";s:32:"09dd8fecc401560e8d221105a5a4dca7";s:12:"`Sujet`.`id`";s:32:"18515f279b76884629108fa3bad1c810";s:13:""bucy-le-roi"";s:32:"a63d4b3f7bf810dc760868643fe3cc0a";s:7:""45058"";s:32:"86e9a0ff5e282f74de84fcd1e8627548";s:21:""touquet-paris-plage"";s:32:"41fd8c6d963f0e25e3ef2ba82460fa61";s:7:""62826"";s:32:"89e58e03e013b07022b9c05762b87d87";s:10:""beugnies"";s:32:"a13035521bf28ea9b10168ce843a8519";s:7:""59078"";s:32:"21e2551219b4f38d023a345c252eae2b";s:17:""livers-cazelles"";s:32:"13c0aef4139b06332e7bdcd2e11b3e76";s:7:""81146"";s:32:"e205de2bf786bf4f3cbd58d0df9ce3a7";s:10:""varesnes"";s:32:"ed04e2b41d80f77569400242cfa8e286";s:7:""60655"";s:32:"cd247acfcb474b0b227ec96fb0fa7192";s:25:""st-aubin-sur-quillebeuf"";s:32:"3d6514463f4ca0f1c3ef3d68366436b7";s:7:""27518"";s:32:"eefc54df54f2556c8c52390d7fcf75c4";s:11:""lussac-16"";s:32:"d325f8f7b88d83ed20219824457fb7d9";s:7:""16195"";s:32:"e4f0a9877139c7464d9755010d0e84ac";s:21:""aubepierre-sur-aube"";s:32:"74143b2240027c46228957f69925e52b";s:7:""52022"";s:32:"7f7fe3bf1d9b5a6255c868c968bef039";s:9:""brombos"";s:32:"63eb4cd547115ab579466a09616cfd96";s:7:""60109"";s:32:"e98390f31e03ac9e907ae30feeeb76a0";s:22:"`EtablissementKeyword`";s:32:"f05318129420810d2df6af6f21777fb9";s:41:"`EtablissementKeyword`.`etablissement_id`";s:32:"08bee90596866040d3863d3b099b92dd";s:24:"`etablissement_keywords`";s:32:"6c66eb299f72f8ea6373806e1792c9db";s:9:"`Keyword`";s:32:"bcbd8f2dbc9172e3a3142affb2892e5f";s:14:"`Keyword`.`id`";s:32:"093651e381ef81925313bc1034b19f99";s:35:"`EtablissementKeyword`.`keyword_id`";s:32:"a88baf43cd357230f8c9342b8d8c1fce";s:10:"`keywords`";s:32:"a82fe8f431f55ca3e5c6eeb1425d6fa5";s:16:"`Keyword`.`slug`";s:32:"2f6b7b0c1002ad67f4e455a17d784c94";s:2:"""";s:32:"cc7a4a34d97ffbb85978393c1dc3d808";s:27:"`EtablissementKeyword`.`id`";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"3e403ec04e7060cd9a887e3ae6a92853";s:6:"`pubs`";s:32:"550088f89f3fa9787476e21eb5d15785";s:13:"`Pub`.`actif`";s:32:"0a1510d0dffae11b88c8130de3cc3c6a";s:14:"`Pub`.`format`";s:32:"cc6101a4c51d389cc83aaaa353064e30";s:24:"`Pub`.`etablissement_id`";s:32:"61eedb5524a37da074a515d3499b0fc1";s:16:"`Pub`.`ville_id`";s:32:"777045f9d8b8ffc08a5f3a80ed5260f9";s:11:"`Pub`.`fin`";s:32:"7634cc5fb85e1b378361d06c6d0226a1";s:5:"`Pub`";s:32:"e21100ec788ecc79fc0571e6ec75d395";s:22:"`Pub`.`departement_id`";s:32:"85c4ac61347b5478fc7ddc509dcccc86";s:25:"`Departement`.`region_id`";s:32:"8ecaaa87ac95fb6026267ddc489d4e00";s:10:"`Pub`.`id`";s:32:"03bcab00ea59985094d3823102128dc9";s:13:"`Pub`.`title`";s:32:"19ae68421a7af6fd53280292661686a5";s:12:"`Pub`.`link`";s:32:"adf6b0dc760d6ba40793e6ccab265414";s:11:"`Pub`.`lat`";s:32:"3911c9de594ddd79639957c57fa6f86c";s:15:"`Pub`.`adresse`";s:32:"013acd686b9d6a62ae480ddd5854054a";s:11:"`Pub`.`lng`";s:32:"9a9117f5211facf70dbcba9197db0119";s:11:"`Pub`.`img`";s:32:"a0ec82037a4d9290d4b4962c6dd972ca";s:14:"`Pub`.`height`";s:32:"c584a2fb465c8e8da20fba3f63f5f9f5";s:12:"`Pub`.`view`";s:32:"40c6caef6b63d5cc208b1f45871b776a";s:16:"`Pub`.`view_max`";s:32:"fc9d6fd2d8db223be4a7484a8619f26b";s:0:"";s:32:"efe55a91281e52d79164b67c34af9b0e";s:6:"RAND()";s:32:"c022fd8f33970a7f843cd5bb09ee8a14";s:15:""st-sauvant-86"";s:32:"9019f7333cfa97f32eb4eb8246817f1f";s:10:""blargies"";s:32:"55ca9f61941dc69c8037e465b2762686";s:7:""60076"";s:32:"2550c8614a819f116833d59afeae0794";s:19:""st-martin-le-beau"";s:32:"fba6b3677aab96b89ce4ccfb2c0e0c1d";s:7:""37225"";s:32:"8f907ec7ffca5851dfe3b04b9b8218e1";s:10:""cuves-50"";s:32:"a85f3831aeedb38bd391aeff0188cbf3";s:7:""50158"";s:32:"9c3301b5d9c030d86e17a14c3bf73a88";s:17:""brin-sur-seille"";s:32:"6503c13bbbd3ec33ed38e73f80fc3ae0";s:7:""54100"";s:32:"6f474ebea68d1bd8295cca69e692a631";s:12:""hammeville"";s:32:"d9a5b90b0c90365316cd16344aafd2b2";s:7:""54247"";s:32:"392bb09a7c136f4151dc060d1cff8aa0";s:8:""nancay"";s:32:"145026314c6f7b5900f8485f99bb3596";s:7:""18159"";s:32:"93f7a550a9ba0e5f0f362c625010aa64";s:21:""bouilly-en-gatinais"";s:32:"03ce81e10fa64d109cf1d8daff6accae";s:7:""45045"";s:32:"23016cbdca4b8b7016c33cdbed3bb2ec";s:22:""dombasle-sur-meurthe"";s:32:"3546e05061cf9fcbbc1504e7e03630d1";s:7:""54159"";s:32:"233560cbbad0b67cb19a7125ff9146e0";s:13:""tantonville"";s:32:"257d2b6390fccead2cdf9dc707a67536";s:7:""54513"";s:32:"29a29de9d327daec907141252fa21acb";s:8:""longwy"";s:32:"55efe9eab5460756ed34fa05ae7dbd21";s:7:""54323"";s:32:"6e9da2e219ce12a7f26af57714a55b17";s:12:""hallotiere"";s:32:"a5e3d66f68b367ed3697a6afa9b23003";s:7:""76338"";s:32:"71518bc2ca0c93691d97ee116d020b63";s:8:""colmey"";s:32:"4faf1c4117c31fcbfbbc7575ec525a16";s:7:""54134"";s:32:"1d13eb5c9dbd2d909609053171c39d6b";s:19:""fleville-lixieres"";s:32:"bd2c12f108f43a4a3933b60b86d8b34f";s:7:""54198"";s:32:"69cf55234b6b1b20fcbc5b8fdfb62dab";s:14:""thiebaumenil"";s:32:"8a40cc44c8f228637bf62aa3f188a444";s:7:""54520"";s:32:"f1f8967cbb42ba9394263dd352e3334b";s:9:""belrain"";s:32:"e22b47770321b873c7981ba016d349db";s:7:""55044"";s:32:"35c73fe62c3fa7e75dd0c7663816b57e";s:8:""st-ail"";s:32:"6d0efd3fa77eb9293f84cea42b19d4e9";s:7:""54469"";s:32:"5b2d74d0165e4a5bd641f0de0f222f6b";s:10:""thenioux"";s:32:"f382ddc472466cd8ad4086321d0827f7";s:7:""18263"";s:32:"a992e786d64c77203eb04396ab8aff20";s:20:"`Departement`.`code`";s:32:"23ee5e2803f770cd3e4e3c92941738ce";s:19:"`Departement`.`nom`";s:32:"d01544646b9145c9f6a5d1c2e7eb0ed2";s:29:"`Departement`.`nom_uppercase`";s:32:"5152e5e9306b52b4d7df2bae19c8a812";s:20:"`Departement`.`slug`";s:32:"70a4a1faf343973daaf7a89bac3df075";s:27:"`Departement`.`nom_soundex`";s:32:"e6b58a6fd2dddaf18714b7433a8c7703";s:20:"`Departement`.`view`";s:32:"b74474e63c80be3416038fc312c4ea9c";s:28:"`Departement`.`presentation`";s:32:"aa3e4e25ef57c9a2187d8b8f38d66317";s:24:"`Departement`.`tourisme`";s:32:"58a859cc9ae1c3a16eba65ee4ba041d1";s:20:"`Departement`.`img1`";s:32:"8d1bfdd6c45677e3b05204c9cd512952";s:20:"`Departement`.`img2`";s:32:"f237f95c23798028c944020938923a2f";s:20:"`Departement`.`img3`";s:32:"f5807bd4b1e800229c1cfd99f42893f8";s:13:"`Region`.`id`";s:32:"5767ad9b0f3bcc5a12a47df58a8ab96d";s:14:"`Region`.`nom`";s:32:"976fd89e2c4c73a0e8f3638485c299c7";s:9:"`regions`";s:32:"e03a777181ec5a87bd0b60a2076b7467";s:8:"`Region`";s:32:"1025b45e6ad7a8048372b495709cf7fd";s:5:"`nom`";s:32:"b42b4c7247223233b0c5541183cc48a7";s:12:"`Pub`.`hook`";s:32:"592473832ad432920cfa4eb5718cdbcc";s:17:"`Pub`.`format_id`";s:32:"9da1d158b7b3f5102350b7a469c676c4";s:16:"`Pub`.`national`";s:32:"4a1d50ccad3d1703676cd78c57345ac1";s:14:""st-thomas-02"";s:32:"26ec495395dc6f6ff07e8cf0c990c531";s:7:""02696"";s:32:"3535eba56b333e3b4e693adcb420b6eb";s:10:""igney-88"";s:32:"f6322bf32f61a736d204ff0517ff9232";s:7:""88247"";s:32:"4e85a3c482bbcd59fc3b9e9691bdab59";s:10:""balan-08"";s:32:"e8f2e0e65ff3e5d7d43a80b611585fa1";s:7:""08043"";s:32:"9959bb69a172cda71a34592828cea25b";s:13:""blecourt-52"";s:32:"2be5b990738523e4674747061baeb41a";s:7:""52055"";s:32:"d132e386ecefa30e4419ec9e08e859a7";s:13:""montigny-54"";s:32:"6491d55956bd74250ca41366d1b8f02a";s:7:""54377"";s:32:"3b9fa1515f7647ade86c23941dcc8b99";s:6:""thor"";s:32:"e5693ebce15cc88f9705b580762be8c1";s:7:""84132"";s:32:"16e6486eabb8d24276ae6ca1cedb92bf";s:12:""boussay-37"";s:32:"0d882edf62684b9b80333d5ee3031fcf";s:7:""37033"";s:32:"4ee0597746f976a7bc6347838896a761";s:22:""st-maurice-le-girard"";s:32:"57f297cf0d8580320dd778dd934fe3c2";s:7:""85252"";s:32:"85b13c370a3167d0c0d755e452e70e31";s:10:""bagneaux"";s:32:"158677ed3118f3b841e01d2fe093bcc6";s:7:""89027"";s:32:"9b42120ece1700d7f19fd3d34f9aa561";s:11:""voinemont"";s:32:"4c876ceff42d8bb76fee2ae7d76a2fbb";s:7:""54591"";s:32:"ae024d908b580f38c4a881a90a030f93";s:8:""pretin"";s:32:"cfc7ee9878b82ef6441efac2f945bf89";s:7:""39444"";s:32:"89c19cbb5c9ab955fa452587c9b9156b";s:13:""joudreville"";s:32:"8d51cbe324e77ffc545aa79696a5f4d8";s:7:""54284"";s:32:"e54d1c54db8fd026b75806115ebb5981";s:13:""fremonville"";s:32:"62068d1ebbb5a448a629e9642fc804ec";s:7:""54211"";s:32:"45a5944390a9bdd1518c0ec2d8b48a50";s:11:""chenieres"";s:32:"d420378772b1f5fd5ee662e261b4d71b";s:7:""54127"";s:32:"c2b0bcac120a64cee7804ac957ba2a0b";s:21:""laître-sous-amance"";s:32:"170044ffc9fa770831b47adab50e08d2";s:7:""54289"";}s:6:"fields";a:98:{s:32:"0776bc5a07b6293ad7a608503c8f0fbb";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:52:"(CONCAT(nom, " (", code,")")) AS `Departement__lib`";}s:32:"6ebd007b29cf065d538dcc3a7c4187b9";a:2:{i:0;s:18:"`Departement`.`id`";i:1;s:37:"(CONCAT(code)) AS `Departement__lib`";}s:32:"d56346cbc1a9c1c07ecb6f77d7298a85";a:2:{i:0;s:87:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*, Moyennevente.*";i:1;s:18:"`Departement`.`id`";}s:32:"ff4dfa0353ec81e4209649333769810e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4b250b3dde838d4b4d7c519fcfd8ecb7";a:1:{i:0;s:11:"`Epublic`.*";}s:32:"8ee4e381878886a74715e50c607da897";a:60:{i:0;s:20:"`Etablissement`.`id`";i:1;s:23:"`Etablissement`.`siren`";i:2;s:20:"`Etablissement`.`rs`";i:3;s:22:"`Etablissement`.`slug`";i:4;s:21:"`Etablissement`.`img`";i:5;s:21:"`Etablissement`.`pdf`";i:6;s:21:"`Etablissement`.`lng`";i:7;s:21:"`Etablissement`.`lat`";i:8;s:22:"`Etablissement`.`desc`";i:9;s:28:"`Etablissement`.`historique`";i:10;s:26:"`Etablissement`.`chambres`";i:11;s:30:"`Etablissement`.`restauration`";i:12;s:27:"`Etablissement`.`situation`";i:13;s:25:"`Etablissement`.`parking`";i:14;s:30:"`Etablissement`.`animauxadmis`";i:15;s:29:"`Etablissement`.`equipements`";i:16;s:25:"`Etablissement`.`langues`";i:17;s:24:"`Etablissement`.`tarifs`";i:18;s:28:"`Etablissement`.`supplement`";i:19;s:26:"`Etablissement`.`capacite`";i:20;s:26:"`Etablissement`.`categ_id`";i:21;s:24:"`Etablissement`.`adress`";i:22;s:25:"`Etablissement`.`adress2`";i:23;s:26:"`Etablissement`.`cp_ville`";i:24;s:20:"`Etablissement`.`cp`";i:25;s:26:"`Etablissement`.`ville_id`";i:26;s:21:"`Etablissement`.`tel`";i:27;s:27:"`Etablissement`.`telecopie`";i:28;s:23:"`Etablissement`.`email`";i:29;s:26:"`Etablissement`.`site_web`";i:30;s:25:"`Etablissement`.`partner`";i:31;s:27:"`Etablissement`.`full_desc`";i:32;s:21:"`Etablissement`.`fin`";i:33;s:22:"`Etablissement`.`view`";i:34;s:32:"`Etablissement`.`departement_id`";i:35;s:28:"`Etablissement`.`agregat_id`";i:36;s:22:"`Etablissement`.`pets`";i:37;s:26:"`Etablissement`.`horaires`";i:38;s:27:"`Etablissement`.`date_call`";i:39;s:32:"`Etablissement`.`recall_creneau`";i:40;s:28:"`Etablissement`.`convention`";i:41;s:33:"`Etablissement`.`convention_text`";i:42;s:33:"`Etablissement`.`convention_date`";i:43;s:29:"`Etablissement`.`financement`";i:44;s:34:"`Etablissement`.`financement_text`";i:45;s:34:"`Etablissement`.`financement_date`";i:46;s:27:"`Etablissement`.`direction`";i:47;s:32:"`Etablissement`.`direction_name`";i:48;s:33:"`Etablissement`.`direction_email`";i:49;s:32:"`Etablissement`.`direction_move`";i:50;s:32:"`Etablissement`.`direction_text`";i:51;s:32:"`Etablissement`.`direction_date`";i:52;s:32:"`Etablissement`.`recall_travaux`";i:53;s:32:"`Etablissement`.`recall_maladie`";i:54;s:30:"`Etablissement`.`recall_autre`";i:55;s:29:"`Etablissement`.`recall_date`";i:56;s:29:"`Etablissement`.`observation`";i:57;s:25:"`Etablissement`.`user_id`";i:58;s:26:"`Etablissement`.`modified`";i:59;s:25:"`Etablissement`.`created`";}s:32:"f20b828ab391eb16a16d5e5df54bfec5";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"5ef5376c23915b319c95a55e27b463e2";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"62d6655bcba65365a33c42a0adc33f26";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"81f123267ebb511e1ae3fbd7628ebede";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((45.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.66667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1ac2a7de1032f79c4b8218c21288e0c1";a:3:{i:0;s:54:"Etablissement.id, Etablissement.rs, Etablissement.slug";i:1;s:12:"`Ville`.`id`";i:2;s:14:"`Agregat`.`id`";}s:32:"c4fd98c43562097d790d7e33c74a05f1";a:3:{i:0;s:14:"`Mur`.`pseudo`";i:1;s:15:"`Mur`.`contenu`";i:2;s:14:"`Mur`.`posted`";}s:32:"227110cb1331a56c3995a31fd8c4db7c";a:1:{i:0;s:11:"`Annonce`.*";}s:32:"bc013b7883512024414e377d97f654f5";a:14:{i:0;s:14:"`Agregat`.`id`";i:1;s:15:"`Agregat`.`lib`";i:2;s:16:"`Agregat`.`lib2`";i:3;s:19:"`Agregat`.`libRech`";i:4;s:15:"`Agregat`.`img`";i:5;s:18:"`Agregat`.`imgCat`";i:6;s:23:"`Agregat`.`code_finess`";i:7;s:19:"`Agregat`.`nb_view`";i:8;s:16:"`Agregat`.`slug`";i:9;s:16:"`Agregat`.`desc`";i:10;s:24:"`Agregat`.`ensavoirplus`";i:11;s:19:"`Agregat`.`imglist`";i:12;s:19:"`Agregat`.`created`";i:13;s:17:"`Agregat`.`class`";}s:32:"a91c3a02cc5398d42b59038348c43008";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.6333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.6333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"210c757c5a1767511f1398433a4da242";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((48.3833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.3833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.05- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"2fedd05cfd84246f95d36964dda8c30f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.3167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.3167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.04029- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"9b245e0c14a7c853d1280bf87031c926";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.16667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"039b5c9ec4db7e89199cac6579e43bb6";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((49.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"16c4959e46e9e07ceb008166c193e7c8";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.45*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.45*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fe6616c5d5ecea57b3eae7846b714de1";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:191:"(((acos(sin((48.25*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.25*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.5- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"3e2c89cecc04ff9878254636289678fb";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.65*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.65*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((6.26667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f5197a8f44858b81a180facc7a593535";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((49.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.93333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"476e84cac8571a4e9eb52ac1dd62e284";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((44.85*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.85*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.116667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c1907f428388f6791fc8fdc45de8c5bd";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((45.8833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.866667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"67d9fd8a1ce8231b368a2752e51be3d7";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.88333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"e12fd5d3f16f5056d1b1ae62589d54df";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((48.4333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.4333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-2.18333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"bbb4049ff44acfac692ab12128a8ad9c";a:2:{i:0;s:71:"Ville.*, Departement.nom, Departement.slug, Departement.code, Service.*";i:1;s:18:"`Departement`.`id`";}s:32:"97b543278131ea6890e30cfc3bcb5601";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.1167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b74f7fe998a123db88ff12e17adf5577";a:3:{i:0;s:17:"`Etablissement`.*";i:1;s:11:"`Agregat`.*";i:2;s:13:"`Ville`.`nom`";}s:32:"69e46e80de89b9239ad77046d4313ee5";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.9333*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9333*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.23333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b754189e88c9837561f7c1af2a2f5aff";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.48333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"b7e2d117d5742f4fce691a52a4edf012";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((46.9667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.9667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((5.46667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"66f9657bdb2b66b1707a8991b8dfcf8f";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:193:"(((acos(sin((46.2*pi()/180)) * sin((Ville.lat*pi()/180))+cos((46.2*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.41667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"5f62014286d825d70a236bfe89c2a153";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.5667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.5667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"6c45a331026962a9078f32fb65c1466a";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((48.9833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.9833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((2.2- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"efe14a9fc9974553b3eb77d671247067";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((47.4833*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47.4833*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((7.28333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"0cde3f518b48d5ac5d6fd21ab11c0d0d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:198:"(((acos(sin((49.222*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.222*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.445556- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"1717649b24575ab9f159f300f8e5a68b";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:196:"(((acos(sin((45.75*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.75*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.033333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"c2b5dea3860db439a0511fae9f642b65";a:19:{i:0;s:12:"`Ville`.`id`";i:1;s:13:"`Ville`.`dep`";i:2;s:14:"`Ville`.`slug`";i:3;s:13:"`Ville`.`nom`";i:4;s:12:"`Ville`.`cp`";i:5;s:17:"`Ville`.`commune`";i:6;s:22:"`Ville`.`code_commune`";i:7;s:24:"`Ville`.`arrondissement`";i:8;s:16:"`Ville`.`canton`";i:9;s:14:"`Ville`.`amdi`";i:10;s:20:"`Ville`.`population`";i:11;s:17:"`Ville`.`surface`";i:12;s:13:"`Ville`.`ski`";i:13;s:13:"`Ville`.`lng`";i:14;s:13:"`Ville`.`lat`";i:15;s:24:"`Ville`.`departement_id`";i:16;s:17:"`Ville`.`created`";i:17;s:20:"`Ville`.`descriptif`";i:18;s:13:"`Ville`.`img`";}s:32:"6a7873cb1e20402c5543d0c3042d5acc";a:5:{i:0;s:8:"`Info`.*";i:1;s:9:"`Sujet`.*";i:2;s:29:"COUNT(`Sujet`.`id`) as nbComs";i:3;s:9:"`Ville`.*";i:4;s:191:"(((acos(sin((47*pi()/180)) * sin((Ville.lat*pi()/180))+cos((47*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((-0.033333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"946ddc63ae14c942de34f4c598efc416";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((48.0667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((48.0667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.91667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d3d593ab76510ca4681a712522f8f267";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((50.5167*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.5167*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.58333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"f88b67f7b544061fe390c1095d27b268";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((50.1667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((50.1667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((4.01667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"d5ba05e47a65c14669a8c77f36859b4d";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:199:"(((acos(sin((44.0523*pi()/180)) * sin((Ville.lat*pi()/180))+cos((44.0523*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((1.99833- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"587eadcfd4fc8984572cfcf5265ec94c";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:195:"(((acos(sin((49.55*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.55*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((3.06667- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"a27c3126481cbf07ec233b568a576a3e";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((49.4667*pi()/180)) * sin((Ville.lat*pi()/180))+cos((49.4667*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.533333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"fb6b3e3312ed0a8270546a30895c3f23";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Ville`.`dep`";i:3;s:13:"`Ville`.`nom`";i:4;s:13:"`Ville`.`lat`";i:5;s:13:"`Ville`.`lng`";i:6;s:200:"(((acos(sin((45.8609*pi()/180)) * sin((Ville.lat*pi()/180))+cos((45.8609*pi()/180)) * cos((Ville.lat*pi()/180)) * cos(((0.463333- Ville.lng)*pi()/180))))*180/pi())*60*1.1515*1.609344*1000) as distance";}s:32:"4b7d944ab57adcd928a0f33b2c6378d0";a:7:{i:0;s:12:"`Ville`.`id`";i:1;s:14:"`Ville`.`slug`";i:2;s:13:"`Vil'unserialize - [internal], line ?? FileEngine::read() - CORE/Cake/Cache/Engine/FileEngine.php, line 194 Cache::read() - CORE/Cake/Cache/Cache.php, line 363 DboSource::cacheMethod() - CORE/Cake/Model/Datasource/DboSource.php, line 828 DboSource::fields() - CORE/Cake/Model/Datasource/DboSource.php, line 2658 DboSource::read() - CORE/Cake/Model/Datasource/DboSource.php, line 1171 Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053 Model::find() - CORE/Cake/Model/Model.php, line 3025 VillesController::index() - APP/Controller/VillesController.php, line 14 ReflectionMethod::invokeArgs() - [internal], line ?? Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 499 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167 [main] - APP/webroot/index.php, line 111
Warning (2): Cannot modify header information - headers already sent by (output started at /home/lepetitbz/dansmaprovince/lib/Cake/Utility/Debugger.php:797) [CORE/Cake/Network/CakeResponse.php, line 458]Code Contextsetcookie($name, $c['value'], $c['expire'], $c['path'],$c['domain'], $c['secure'], $c['httpOnly']$c = array( 'name' => 'CakeCookie[autologin]', 'value' => '', 'expire' => (int) 1762146008, 'path' => '/', 'domain' => '', 'secure' => false, 'httpOnly' => false ) $name = 'CakeCookie[autologin]'setcookie - [internal], line ?? CakeResponse::_setCookies() - CORE/Cake/Network/CakeResponse.php, line 458 CakeResponse::send() - CORE/Cake/Network/CakeResponse.php, line 429 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 174 [main] - APP/webroot/index.php, line 111
Pour la recherche d'une maison à rénover à Soulangis en Cher (18), nous comptabilisons à ce jour peu de résultats dans cette ville.
Maison datant des années 60 en centre bourg de Soulangis, elle comprend 4 chambres, 2 salles de bain...
en savoir plus
Situation géographique : Bourges 14 kms - Vierzon 33 kms - Nevers 54 kms -
Dans cette commune de 485 habitants, installée en Cher (18), une seule agence immobilière pourra vous conseiller. À noter que 1 biens ont été vendus durant l'année passée (2020) pour un prix de vente moyen de 1000 € / par m², une indication clé dans votre future négocation immobilière. Vous voulez en savoir plus ? Consultez les agences immobilières locales.
Vous habitez Soulangis ou dans un secteur proche et vous avez une maison à rénover à vendre ?
| Ventes | Prix € / m² | |
|---|---|---|
| 2019 | 2 | 859 € |
| 2020 | 1 | 1000 € |
| Évolution | -50% | 16.4% |
Soit une hausse significative de 16.4 % pour le prix du mètre carré à Soulangis entre 2019 et 2020.
Située Pl De L Eglise à Soulangis, maison composée de 5 pièces principales pour 160 m² sur un terrain de 1000 m² - Vendue 160000 €
Pour vous accompagner dans la rénovation de votre maison à Soulangis, nous avons listé les entreprises du bâtiment.
Selon la rénovation envisagée, une déclaration préalable de travaux doit être réalisée auprès de la mairie de Soulangis par le formulaire 13703*07. Agrandissement de la maison, réalisation d'une pièce annexe (véranda, garage...), création d'une fenêtre...
Mairie - Soulangis
5 route de Parassy 18220 Soulangis
02 48 64 42 52
Selon vos revenus et les travaux envisagés dans votre logement, l'ANAH Cher (18) peut vous venir en aide.