Maison de ville Avignon (84)

SELECT nb_toilettes, type_construction, nb_bureaux, restauration_date, etat_general_bien, surface_sejour, surface_terrain, surface_terrasse, surface_garage, surface_dependances, surface_balcon, surfaces_approximatives, type_exposition, type_vue, nb_faces, type_piscine, piscine_dim, chauffages, estimation_chauffage, charges_copropriete, eau, type_evacuation, charges_diverses, charges_copropriete, nb_lots, frais_notaire, impots_fonciers, prix_vente, commission_partenaire, pourcentage_commission, is_honoraires_vendeur, garantie_decenale, assurance_dommage_ouvrage, procedure_type, syndic_type FROM bien_data_fr WHERE bien_fiche_id = 'VM839'Array ( [nb_toilettes] => 4 [type_construction] => Pierres [nb_bureaux] => [restauration_date] => 2003 et 2011 [etat_general_bien] => Très bon [surface_sejour] => 37 [surface_terrain] => 535 [surface_terrasse] => 50 [surface_garage] => 18 [surface_dependances] => 0 [surface_balcon] => 0 [surfaces_approximatives] => 1 [type_exposition] => Sud [type_vue] => Jardin [nb_faces] => 0 [type_piscine] => Avec liner [piscine_dim] => 8 x 4 [chauffages] => [{"bien_id": 839, "principal": 1, "chauffage_id": 1415, "chauffage_type": "Pompe à chaleur"}, {"bien_id": 839, "principal": 0, "chauffage_id": 1416, "chauffage_type": "Climatisation réversible"}] [estimation_chauffage] => 0 [charges_copropriete] => 0 [eau] => [{"eau_type": "Forage"}] [type_evacuation] => tout à l'égout [charges_diverses] => [nb_lots] => 0 [frais_notaire] => 29600 [impots_fonciers] => 1803 [prix_vente] => 420000 [commission_partenaire] => 20000 [pourcentage_commission] => 5 [is_honoraires_vendeur] => 0 [garantie_decenale] => 0 [assurance_dommage_ouvrage] => 0 [procedure_type] => [syndic_type] => ) testArray ( [nb_toilettes] => 4 [type_construction] => Pierres [nb_bureaux] => [restauration_date] => 2003 et 2011 [etat_general_bien] => Très bon [surface_sejour] => 37 [surface_terrain] => 535 [surface_terrasse] => 50 [surface_garage] => 18 [surface_dependances] => 0 [surface_balcon] => 0 [surfaces_approximatives] => 1 [type_exposition] => Sud [type_vue] => Jardin [nb_faces] => 0 [type_piscine] => Avec liner [piscine_dim] => 8 x 4 [chauffages] => Array ( [0] => stdClass Object ( [bien_id] => 839 [principal] => 1 [chauffage_id] => 1415 [chauffage_type] => Pompe à chaleur ) [1] => stdClass Object ( [bien_id] => 839 [principal] => 0 [chauffage_id] => 1416 [chauffage_type] => Climatisation réversible ) ) [estimation_chauffage] => 0 [charges_copropriete] => 0 [eau] => Array ( [0] => stdClass Object ( [eau_type] => Forage ) ) [type_evacuation] => tout à l'égout [charges_diverses] => [nb_lots] => 0 [frais_notaire] => 29600 [impots_fonciers] => 1803 [prix_vente] => 420000 [commission_partenaire] => 20000 [pourcentage_commission] => 5 [is_honoraires_vendeur] => 0 [garantie_decenale] => 0 [assurance_dommage_ouvrage] => 0 [procedure_type] => [syndic_type] => )