Village house Villeneuve les Avignon (30)

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_en WHERE bien_fiche_id = 'VM873'Array ( [nb_toilettes] => 3 [type_construction] => Stones [nb_bureaux] => [restauration_date] => 2009 / 2014 [etat_general_bien] => Excellent [surface_sejour] => 45 [surface_terrain] => 231 [surface_terrasse] => 25 [surface_garage] => 0 [surface_dependances] => 15 [surface_balcon] => 0 [surfaces_approximatives] => 1 [type_exposition] => North-East [type_vue] => Garden [nb_faces] => 0 [type_piscine] => [piscine_dim] => 2 par 2 [chauffages] => [{"bien_id": 873, "principal": 1, "chauffage_id": 1477, "chauffage_type": "Heat pump on the floor"}, {"bien_id": 873, "principal": 0, "chauffage_id": 1478, "chauffage_type": "reversible air-conditioning"}] [estimation_chauffage] => 0 [charges_copropriete] => 0 [eau] => [{"eau_type": "Water of city"}] [type_evacuation] => sewage system [charges_diverses] => [nb_lots] => 0 [frais_notaire] => 44330 [impots_fonciers] => 1835 [prix_vente] => 640000 [commission_partenaire] => 26000 [pourcentage_commission] => 4.23 [is_honoraires_vendeur] => 0 [garantie_decenale] => 0 [assurance_dommage_ouvrage] => 0 [procedure_type] => [syndic_type] => ) testArray ( [nb_toilettes] => 3 [type_construction] => Stones [nb_bureaux] => [restauration_date] => 2009 / 2014 [etat_general_bien] => Excellent [surface_sejour] => 45 [surface_terrain] => 231 [surface_terrasse] => 25 [surface_garage] => 0 [surface_dependances] => 15 [surface_balcon] => 0 [surfaces_approximatives] => 1 [type_exposition] => North-East [type_vue] => Garden [nb_faces] => 0 [type_piscine] => [piscine_dim] => 2 par 2 [chauffages] => Array ( [0] => stdClass Object ( [bien_id] => 873 [principal] => 1 [chauffage_id] => 1477 [chauffage_type] => Heat pump on the floor ) [1] => stdClass Object ( [bien_id] => 873 [principal] => 0 [chauffage_id] => 1478 [chauffage_type] => reversible air-conditioning ) ) [estimation_chauffage] => 0 [charges_copropriete] => 0 [eau] => Array ( [0] => stdClass Object ( [eau_type] => Water of city ) ) [type_evacuation] => sewage system [charges_diverses] => [nb_lots] => 0 [frais_notaire] => 44330 [impots_fonciers] => 1835 [prix_vente] => 640000 [commission_partenaire] => 26000 [pourcentage_commission] => 4.23 [is_honoraires_vendeur] => 0 [garantie_decenale] => 0 [assurance_dommage_ouvrage] => 0 [procedure_type] => [syndic_type] => )