Array
(
[id] => 219768
)
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 ('219768') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 11:00:34') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 11:00:34') 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 11:00:34') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 11:00:34') 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
Aquitaine
Lot-et-Garonne
Granges-sur-Lot
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 ('219768') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 11:00:34') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 11:00:34') 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 11:00:34') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 11:00:34') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASC
Beau lac de 2 hectares à niveau constant, entouré de plus de 4 hectares de bonnes terres de vallée
€129,000 BVI21458
Surface terrain
62,120 m2
Secteur
Granges-sur-Lot
Département
Lot-et-Garonne
En savoir plus ou réserver une visite Sauvegardez dans mes favoris
Beau lac de 2 hectares à niveau constant, entouré de plus de 4 hectares de bonnes terres de vallée
- Lac de 2 hectares entouré de plus de 4 hectares de bonne terres de vallée
- Alimentation permanente par source de nappe phréatique
- Profondeur de 2,50 a 3 mètres et trop plein, pas de baisse de niveau
- Grandes quantités de poissons de tout genre
- Environnement arbustif, ombre
- Proximité a quelques km de petits commerces Possibilité de création d'activité nautique ou de concours de pêche 30 km de la gare d'Agen et 50 km de l'aéroport de Bergerac
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
€129,000
£ 110,645
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
BVI21458
Type de bien
Appartement , Maison , Lac
Surface terrain
62,120 m2
Secteur
Granges-sur-Lot
Département
Lot-et-Garonne
En savoir plus ou réserver une visite Imprimer Gérer les favoris Revenir Discuter d'une offre
Surfaces
Détails
Chambres
0
Salle des bains
0
N° pieces
0
Surface habitable
0 m2
Surface terrain
62,120 m2
Piscine
Non
État
Bon
Voisins
Éloigné
Eaux usées
Inconnu
Chauffage
unknown
Revenus
Oui
Tax fonciere
Certificat de performance énergétique
Réalisé: 31 December 2012
Consommation énergétique
A
B
C
D
E
F
G
DPE Non Applicable
Emplacement
En savoir plus ou réserver une visite
Monflanquin
Cette propriété est présentée par Eric Garnier de notre bureau à Monflanquin. 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.
49 Place des Arcades
47150 Monflanquin
Lot-et-Garonne
05 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] => 219768
)
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 ('219768') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 11:00:34') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 11:00:34') 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 11:00:34') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 11:00:34') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASCArray ( [province] => Lot-et-Garonne )
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 116100 AND 141900) AND `p`.`province` IN ('lot-et-garonne') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 11:00:34') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 11:00:34') 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 (74,86,120) 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 11:00:34') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 11:00:34') 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 ('219768') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 11:00:34') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 11:00:34') 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 11:00:34') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 11:00:34') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASCArray ( [province] => Lot-et-Garonne )
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 116100 AND 141900) AND `p`.`province` IN ('lot-et-garonne') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 11:00:34') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 11:00:34') 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 (74,86,120) 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 11:00:34') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 11:00:34') 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 11:00:34') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 11:00:34') 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 11:00:34') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 11:00:34') 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 11:00:34') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 11:00:34') 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 11:00:34') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 11:00:34') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY RAND()
€519,400
Vienne (86)
€178,200
Deux-Sèvres (79)
€449,950
Charente (16)
€930,000
Exclusive
Tarn (81)
€742,000
Lot-et-Garonne (47)
€65,850
Charente (16)
€699,000
Lot (46)
€77,800
Lot (46)
€595,750
Lot (46)
€583,000
Dordogne (24)
€572,000
Lot-et-Garonne (47)
€750,000
Exclusive
Haute-Garonne (31)
