Château 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 = 'VM284'Array ( [nb_toilettes] => 6 [type_construction] => Pierres [nb_bureaux] => [restauration_date] => 1990 [etat_general_bien] => Excellent [surface_sejour] => 80 [surface_terrain] => 4000 [surface_terrasse] => 300 [surface_garage] => 30 [surface_dependances] => 0 [surface_balcon] => 0 [surfaces_approximatives] => 1 [type_exposition] => Nord-Sud [type_vue] => Panoramique [nb_faces] => 0 [type_piscine] => [piscine_dim] => 11/5 [chauffages] => [{"bien_id": 284, "principal": 1, "chauffage_id": 317, "chauffage_type": "Central fioul"}, {"bien_id": 284, "principal": 0, "chauffage_id": 318, "chauffage_type": "Electrique"}] [estimation_chauffage] => 0 [charges_copropriete] => 0 [eau] => [{"eau_type": "Eau de ville"}, {"eau_type": "Puits"}] [type_evacuation] => tout à l'égout [charges_diverses] => [nb_lots] => 0 [frais_notaire] => 219000 [impots_fonciers] => 1345 [prix_vente] => 3900000 [commission_partenaire] => 250000 [pourcentage_commission] => 6.84 [is_honoraires_vendeur] => 0 [garantie_decenale] => 0 [assurance_dommage_ouvrage] => 0 [procedure_type] => [syndic_type] => ) testArray ( [nb_toilettes] => 6 [type_construction] => Pierres [nb_bureaux] => [restauration_date] => 1990 [etat_general_bien] => Excellent [surface_sejour] => 80 [surface_terrain] => 4000 [surface_terrasse] => 300 [surface_garage] => 30 [surface_dependances] => 0 [surface_balcon] => 0 [surfaces_approximatives] => 1 [type_exposition] => Nord-Sud [type_vue] => Panoramique [nb_faces] => 0 [type_piscine] => [piscine_dim] => 11/5 [chauffages] => Array ( [0] => stdClass Object ( [bien_id] => 284 [principal] => 1 [chauffage_id] => 317 [chauffage_type] => Central fioul ) [1] => stdClass Object ( [bien_id] => 284 [principal] => 0 [chauffage_id] => 318 [chauffage_type] => Electrique ) ) [estimation_chauffage] => 0 [charges_copropriete] => 0 [eau] => Array ( [0] => stdClass Object ( [eau_type] => Eau de ville ) [1] => stdClass Object ( [eau_type] => Puits ) ) [type_evacuation] => tout à l'égout [charges_diverses] => [nb_lots] => 0 [frais_notaire] => 219000 [impots_fonciers] => 1345 [prix_vente] => 3900000 [commission_partenaire] => 250000 [pourcentage_commission] => 6.84 [is_honoraires_vendeur] => 0 [garantie_decenale] => 0 [assurance_dommage_ouvrage] => 0 [procedure_type] => [syndic_type] => )