Array
(
[id] => 319390
)
SELECT p.province_combi,p.county_combi,p.*, p.id AS id, p.province_num, p.title AS title, p.exc, p.office, p.liv, p.vtour, p.video, p.street_num, p.street_dir, p.street, p.street2, p.garage_type, p.heating_device, p.drainage, p.garage_size, p.description as description, p.created as created, p.alias as alias, p.heating_access, p.listing_info, pm.cat_id FROM j7m8s_iproperty AS p LEFT JOIN j7m8s_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND `p`.`id` IN ('319390') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:04:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:04:47') AND p.state = 1 AND p.approved = 1 AND p.id IN (SELECT pm.prop_id FROM j7m8s_iproperty_propmid pm WHERE pm.cat_id IN (SELECT id FROM j7m8s_iproperty_categories c WHERE c.state = 1 AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-01-18 10:04:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:04:47') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASC
En savoir plus ou réserver une visite Sauvegardez dans mes favoris
En savoir plus ou réserver une visite Imprimer Gérer les favoris Revenir Discuter d'une offre
Provence-Alpes-Côte d'Azur
Bouches-du-Rhône
Meyreuil
SELECT p.province_combi,p.county_combi,p.*, p.id AS id, p.province_num, p.title AS title, p.exc, p.office, p.liv, p.vtour, p.video, p.street_num, p.street_dir, p.street, p.street2, p.garage_type, p.heating_device, p.drainage, p.garage_size, p.description as description, p.created as created, p.alias as alias, p.heating_access, p.listing_info, pm.cat_id FROM j7m8s_iproperty AS p LEFT JOIN j7m8s_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND `p`.`id` IN ('319390') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:04:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:04:47') AND p.state = 1 AND p.approved = 1 AND p.id IN (SELECT pm.prop_id FROM j7m8s_iproperty_propmid pm WHERE pm.cat_id IN (SELECT id FROM j7m8s_iproperty_categories c WHERE c.state = 1 AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-01-18 10:04:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:04:47') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASC
Bien rare et unique offrant 8 chambres avec piscine et environ 5000m² de terrain
€4,500,000 BVI76659
Chambres
8
Salle des bains
8
Surface habitable
550 m2
Surface terrain
4,769 m2
Secteur
Meyreuil
Département
Bouches-du-Rhône
En savoir plus ou réserver une visite Sauvegardez dans mes favoris
Bien rare et unique offrant 8 chambres avec piscine et environ 5000m² de terrain
- Rare sur le marché
- Vue imprenable sur Ste Victoire
- Salle de sport et hammam
- Piscine
Les informations sur les risques auxquels ce bien est exposé sont disponibles sur le site Géorisques : www.georisques.gouv.fr
Type Mandat Honoraires à la charge du vendeur
€4,500,000
£ 3,859,695
Sauvegardez dans mes favoris
Exchange rate information
€ 1 = £ 0,85 
Last update: 18-01-2025
Lorem ipsum dolor sit amet, consectetur adipiscing elit.
More info
Référence
BVI76659
Type de bien
Maison , Villa
Chambres
8
Salle des bains
8
Surface habitable
550 m2
Surface terrain
4,769 m2
Secteur
Meyreuil
Département
Bouches-du-Rhône
En savoir plus ou réserver une visite Imprimer Gérer les favoris Revenir Discuter d'une offre
Surfaces
Détails
Chambres
8
Salle des bains
8
N° pieces
10
Surface habitable
550 m2
Surface terrain
4,769 m2
Piscine
Oui
État
Bon
Voisins
Eaux usées
Inconnu
Chauffage
Climatisation
Revenus
Inconnu
Tax fonciere
Certificat de performance énergétique
Réalisé: 13 September 2024
Estimation des dépenses énergétiques annuelles pour une utilisation typique € .
Pour tous les détails cliquez ici.
Consommation énergétique
Logement à consommation énergétique excessive : classe G
A
B
C
D
E
F
G
consumption
451
kWh/m².year
emission
81
kg CO2/m².year
Emission de gaz
A
B
C
D
E
F
emission
81
kg CO2/m².year
G
Emplacement
En savoir plus ou réserver une visite
Cette propriété est présentée par Gaelle Perreaux-Booth from our head office. Vous avez des questions ? Contactez-nous dès maintenant et nous vous répondrons.
Utilisez le formulaire ou contactez-nous par courriel ou par téléphone.
Gaelle Perreaux-Booth
+33 (0)5 56 71 36 59
info@beauxvillages.com
Discuter d'une offre
Si cette propriété ou d'autres sont susceptibles de vous intéresser sérieusement, vous souhaiterez peut-être parler en toute confidentialité et sans obligation ni engagement avec un négociateur principal sympathique pour discuter de la flexibilité possible du prix.
Obtenir la bonne affaire peut être une question de bon timing et nous avons cette information.
Quoi que vous lisiez dans la presse, il n'est tout simplement pas vrai que l'on peut appliquer un pourcentage de réduction sur le prix de n'importe quelle propriété qui nous plaît. Et il est vraiment dommage de tomber amoureux d'une propriété qui est au-delà de ce que vous souhaitez dépenser ou pouvez vous permettre.
Pour organiser un rappel, veuillez envoyer un courriel à in-confidence@beauxvillages.comVous aimeriez aussi...
Array
(
[id] => 319390
)
SELECT p.province_combi,p.county_combi,p.*, p.id AS id, p.province_num, p.title AS title, p.exc, p.office, p.liv, p.vtour, p.video, p.street_num, p.street_dir, p.street, p.street2, p.garage_type, p.heating_device, p.drainage, p.garage_size, p.description as description, p.created as created, p.alias as alias, p.heating_access, p.listing_info, pm.cat_id FROM j7m8s_iproperty AS p LEFT JOIN j7m8s_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND `p`.`id` IN ('319390') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:04:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:04:47') AND p.state = 1 AND p.approved = 1 AND p.id IN (SELECT pm.prop_id FROM j7m8s_iproperty_propmid pm WHERE pm.cat_id IN (SELECT id FROM j7m8s_iproperty_categories c WHERE c.state = 1 AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-01-18 10:04:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:04:47') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASCArray ( [province] => Bouches-du-Rhône )
SELECT p.province_combi,p.county_combi,p.price_reduced,p.id AS id, p.mls_id, p.mls_apimo, p.price, p.exc, p.liv, p.vtour, p.office, p.video,p.feature1, p.feature2, p.feature3,p.feature4,p.feature1_fr, p.feature2_fr, p.feature3_fr,p.feature4_fr, p.call_for_price, p.show_map, p.hide_address, p.price2, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.sav,p.lot_acres, p.lotsize, p.street_num, p.street_dir, p.street, p.street2, p.province_num, p.drainage, p.apt, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id FROM j7m8s_iproperty AS p LEFT JOIN j7m8s_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND (p.price BETWEEN 4050000 AND 4950000) AND `p`.`province` IN ('bouches-du-rhône') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:04:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:04:47') AND p.state = 1 AND p.approved = 1 AND p.id IN (SELECT pm.prop_id FROM j7m8s_iproperty_propmid pm WHERE pm.cat_id IN (102,115) AND pm.cat_id IN (SELECT id FROM j7m8s_iproperty_categories c WHERE c.state = 1 AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-01-18 10:04:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:04:47') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY RAND()
SELECT p.province_combi,p.county_combi,p.*, p.id AS id, p.province_num, p.title AS title, p.exc, p.office, p.liv, p.vtour, p.video, p.street_num, p.street_dir, p.street, p.street2, p.garage_type, p.heating_device, p.drainage, p.garage_size, p.description as description, p.created as created, p.alias as alias, p.heating_access, p.listing_info, pm.cat_id FROM j7m8s_iproperty AS p LEFT JOIN j7m8s_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND `p`.`id` IN ('319390') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:04:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:04:47') AND p.state = 1 AND p.approved = 1 AND p.id IN (SELECT pm.prop_id FROM j7m8s_iproperty_propmid pm WHERE pm.cat_id IN (SELECT id FROM j7m8s_iproperty_categories c WHERE c.state = 1 AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-01-18 10:04:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:04:47') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASCArray ( [province] => Bouches-du-Rhône )
SELECT p.province_combi,p.county_combi,p.price_reduced,p.id AS id, p.mls_id, p.mls_apimo, p.price, p.exc, p.liv, p.vtour, p.office, p.video,p.feature1, p.feature2, p.feature3,p.feature4,p.feature1_fr, p.feature2_fr, p.feature3_fr,p.feature4_fr, p.call_for_price, p.show_map, p.hide_address, p.price2, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.sav,p.lot_acres, p.lotsize, p.street_num, p.street_dir, p.street, p.street2, p.province_num, p.drainage, p.apt, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id FROM j7m8s_iproperty AS p LEFT JOIN j7m8s_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND (p.price BETWEEN 4050000 AND 4950000) AND `p`.`province` IN ('bouches-du-rhône') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:04:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:04:47') AND p.state = 1 AND p.approved = 1 AND p.id IN (SELECT pm.prop_id FROM j7m8s_iproperty_propmid pm WHERE pm.cat_id IN (102,115) AND pm.cat_id IN (SELECT id FROM j7m8s_iproperty_categories c WHERE c.state = 1 AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-01-18 10:04:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:04:47') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY RAND()
Sorry, no results to display
Notre selection de biens
Array
(
[featured] => 1
[listing_office] => 62
[stype] => 1
)
SELECT p.province_combi,p.county_combi,p.price_reduced,p.id AS id, p.mls_id, p.mls_apimo, p.price, p.exc, p.liv, p.vtour, p.office, p.video,p.feature1, p.feature2, p.feature3,p.feature4,p.feature1_fr, p.feature2_fr, p.feature3_fr,p.feature4_fr, p.call_for_price, p.show_map, p.hide_address, p.price2, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.sav,p.lot_acres, p.lotsize, p.street_num, p.street_dir, p.street, p.street2, p.province_num, p.drainage, p.apt, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id FROM j7m8s_iproperty AS p LEFT JOIN j7m8s_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND `p`.`featured` IN ('1') AND `p`.`listing_office` IN ('62') AND `p`.`stype` IN ('1') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:04:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:04:47') AND p.state = 1 AND p.approved = 1 AND p.id IN (SELECT pm.prop_id FROM j7m8s_iproperty_propmid pm WHERE pm.cat_id IN (SELECT id FROM j7m8s_iproperty_categories c WHERE c.state = 1 AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-01-18 10:04:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:04:47') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY RAND()
SELECT p.province_combi,p.county_combi,p.price_reduced,p.id AS id, p.mls_id, p.mls_apimo, p.price, p.exc, p.liv, p.vtour, p.office, p.video,p.feature1, p.feature2, p.feature3,p.feature4,p.feature1_fr, p.feature2_fr, p.feature3_fr,p.feature4_fr, p.call_for_price, p.show_map, p.hide_address, p.price2, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.sav,p.lot_acres, p.lotsize, p.street_num, p.street_dir, p.street, p.street2, p.province_num, p.drainage, p.apt, p.description as description, p.short_description, p.created, p.created_by, p.modified, p.stype, p.listing_office, p.city, p.locstate, p.county, p.region, p.subdivision, p.country, p.province, p.alias as alias, p.featured, p.latitude, p.longitude, p.available, p.income, p.tax, p.publish_up, p.state, p.checked_out, p.checked_out_time, p.hits, p.listing_info, pm.cat_id FROM j7m8s_iproperty AS p LEFT JOIN j7m8s_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND `p`.`featured` IN ('1') AND `p`.`listing_office` IN ('62') AND `p`.`stype` IN ('1') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:04:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:04:47') AND p.state = 1 AND p.approved = 1 AND p.id IN (SELECT pm.prop_id FROM j7m8s_iproperty_propmid pm WHERE pm.cat_id IN (SELECT id FROM j7m8s_iproperty_categories c WHERE c.state = 1 AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-01-18 10:04:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:04:47') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY RAND()
€750,000
Exclusive
Haute-Garonne (31)
€315,000
Lot-et-Garonne (47)
€299,600
Charente-Maritime (17)
€498,750
Charente (16)
€449,950
Charente (16)
€256,800
Charente (16)
€232,000
Aveyron (12)
€170,640
Exclusive
Haute-Vienne (87)
€162,000
Haute-Vienne (87)
€137,900
Indre (36)
€1,799,950
Dordogne (24)
€299,600
Indre (36)
