Array ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => [province_num] => [county] => [office] => [liv] => [sav] => [drainage] => [heating_device] => [heating_access] => [features1] => [mls_apimo] => [exc] => [income] => [mec_col] => [price_reduced] => [postcode] => [region] => [city] => [subdivision] => [listing_office] => [stype] => Array ( [0] => 11 [1] => 1 [2] => 5 ) [approved] => [featured] => [hoa] => [reo] => [waterfront] => )
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`.`stype` IN ('11','1','5') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-19 06:13:00') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-19 06:13:00') 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 (31,36,39,42,49,68,75,87,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117) 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-19 06:13:00') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-19 06:13:00') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => [province_num] => [county] => [office] => [liv] => [sav] => [drainage] => [heating_device] => [heating_access] => [features1] => [mls_apimo] => [exc] => [income] => [mec_col] => [price_reduced] => [postcode] => [region] => [city] => [subdivision] => [listing_office] => [stype] => Array ( [0] => 11 [1] => 1 [2] => 5 ) [approved] => [featured] => [hoa] => [reo] => [waterfront] => )
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`.`stype` IN ('11','1','5') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-19 06:13:00') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-19 06:13:00') 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 (31,36,39,42,49,68,75,87,119,124,135,139,143,146,153,161,35,37,40,43,50,69,76,88,120,125,140,144,147,154,32,38,41,44,51,70,77,89,121,126,141,148,155,33,45,52,78,90,122,127,149,156,162,46,47,53,79,91,128,150,157,163,30,54,80,92,129,151,158,25,48,55,81,93,130,159,56,72,74,82,94,131,57,83,86,95,132,58,84,96,118,133,59,85,97,123,136,60,98,134,137,61,99,138,62,100,142,63,101,145,64,102,152,65,103,160,66,104,67,105,106,107,108,109,110,111,112,113,114,115,116,117) 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-19 06:13:00') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-19 06:13:00') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC

Consultez nos annonces immobilières pour trouver la propriété qui vous convient. Nous disposons d’un large éventail de bien immobiliers: maisons, appartements, villas et terrains à bâtir à vendre.

Résultats 2108 à 2150 sur 3426
Vendu
Video available
Saint-Sulpice-les-Feuilles, Haute-Vienne
7
3
238 m²
13,443 m²
BVI68731
€445,200
Rouffiac, Charente-Maritime
4
4
315 m²
9,685 m²
BVI68297
€422,950
Sainte-Alvère, Dordogne
8
6
345 m²
450 m²
BVI58426
€546,000
Chéniers, Creuse
5
2
175 m²
663 m²
BVI68304
€129,710
Vendu
Bellac, Haute-Vienne
2
2
54 m²
160 m²
BVI67873
€29,900
Libourne, Gironde
7
3
318 m²
36,658 m²
BVI67637
€795,000
Virtual tour360
Verteillac, Dordogne
3
2
219 m²
1,912 m²
BVI66802
€510,000
Ruffec, Charente
10
3
320 m²
6,383 m²
BVI68550
€598,900
Eauze, Gers
3
360 m²
2,810 m²
AQA748
€307,000
Lauzerte, Tarn-et-Garonne
17
15
600 m²
2,661 m²
BVI67354
€670,000
Moulismes, Vienne
7
7
250 m²
262 m²
BVI68610
€71,500
Bellac, Haute-Vienne
6
4
220 m²
450 m²
BVI13136
€299,600
Pillac, Charente
2
2
60 m²
115 m²
BVI62703
€117,000
Villeréal, Lot-et-Garonne
8
6
324 m²
910 m²
BVI68182
€957,500
Haims, Vienne
1
1
60 m²
1,217 m²
BVI68293
€34,000
Sainte-Alvère, Dordogne
5
2
199 m²
5,406 m²
BVI66562
€395,000
Minerve, Hérault
3
4
234 m²
34,200 m²
BVI66153
€1,100,000
Sarlat-la-Canéda, Dordogne
3
2776 m²
YAA6044
€181,000
Busserolles, Dordogne
10299 m²
BVI68249
€41,000
Virtual tour360
Brassac, Tarn-et-Garonne
5
5
292 m²
30,000 m²
BVI68385
€609,000
Saint-Aubin-le-Cloud, Deux-Sèvres
4
3
160 m²
10,000 m²
BVI68134
€129,950
Valence, Charente
9
4
350 m²
8,481 m²
BVI66227
€396,900
Bétaille, Lot
2
1
67 m²
41 m²
BVI68441
€130,800
Marignac, Charente-Maritime
4
2
210 m²
815 m²
BVI67414
€199,950
Vendu
Confolens, Charente
2
3
97 m²
87 m²
BVI66724
€46,000
Bétaille, Lot
2
1
58 m²
47 m²
BVI68439
€125,350
Pillac, Charente
3
2
139 m²
300 m²
BVI64789
€152,600
Carsac-de-Gurson, Dordogne
5
2
207 m²
3,820 m²
BVI67918
€189,000
Paizay-le-Tort, Deux-Sèvres
6
2
225 m²
3,706 m²
BVI68292
€239,800
Clessé, Deux-Sèvres
3
3
182 m²
5,115 m²
BVI68231
€199,800
Charroux, Vienne
3
2
107 m²
2,708 m²
BVI67967
€130,800
Chillac, Charente
5
4
310 m²
113,151 m²
BVI61920
€392,200
Chillac, Charente
5,878 m²
BVI61738
€30,000
Charroux, Vienne
4
2
110 m²
168 m²
BVI68260
€119,900
Beaulieu-sur-Dordogne, Corrèze
200 m²
850 m²
BVI67233
€191,000
Le Beugnon, Deux-Sèvres
4
3
120 m²
688 m²
BVI66819
€136,250
La Coquille, Dordogne
8265 m²
BVI68028
€31,000
Sarlat-la-Canéda, Dordogne
2
Terrasse 9.7 m²
YAA6045
€337,600
Saint-Claud, Charente
1
110 m²
3,262 m²
BVI67318
€135,000
Video available
Virtual tour360
Bergerac, Dordogne
7
5
472 m²
8,540 m²
BVI58342
€895,000
Virtual tour360
Périgueux, Dordogne
8
8
1000 m²
180,000 m²
BVI59171
€1,657,900
Gourdon, Lot
9
5
307 m²
1,350 m²
BVI60597
€299,600
Condom, Gers
8
6
599 m²
15,000 m²
AAB2803
€1,050,000

Beaux Villages in the press

French property article featured in the Telegraph France property article in the Irish Times French property news featured in The Times