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] => 1 ) [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 ('1') 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:20:06') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-19 06:20:06') 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:20:06') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-19 06:20:06') 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] => 1 ) [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 ('1') 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:20:06') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-19 06:20:06') 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:20:06') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-19 06:20:06') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC

Accédez directement aux dernières annonces immobilières ! Visitez notre page régulièrement ou inscrivez-vous pour recevoir les biens correspondant à vos critères directement dans votre boîte email.

Détendez-vous en sachant que vous ne manquerez jamais “VOTRE MAISON” !

Résultats 1291 à 1333 sur 3165
Saint-Romain, Vienne
3
1
125 m²
451 m²
BVI73146
€48,600
Puycelsi, Tarn
4
1
139 m²
879 m²
BVI73201
€139,000
Longré, Charente
17,599 m²
BVI71948
€79,992
Video available
Virtual tour360
Gardonne, Dordogne
9
5
639 m²
35,859 m²
BVI61723
€1,588,000
Hanc, Deux-Sèvres
3
4
324 m²
3,077 m²
BVI72918
€246,100
Sainte-Foy-la-Grande, Gironde
9
2
520 m²
886,085 m²
BVI72410
€2,743,000
Tanus, Tarn
5
430 m²
716 m²
BVI73259
€395,000
Limoux, Aude
3
1
91 m²
1,150 m²
BVI73331
€135,000
Monségur, Gironde
2
108 m²
20,415 m²
AIA83855510
€249,100
Virtual tour360
Blasimon, Gironde
7
3
284 m²
6,460 m²
BVI71753
€498,200
En exclusivité
Groléjac, Dordogne
130 m²
2,480 m²
BVI72995
€70,000
Lignac, Indre
5
2
132 m²
2,020 m²
BVI71561
€149,800
Cussac, Haute-Vienne
4
2
185 m²
15,377 m²
BVI63241
€214,000
Jonzac, Charente-Maritime
3
1
106 m²
389 m²
BVI73278
€199,800
Le Blanc, Indre
4
1
145 m²
2,454 m²
BVI73264
€205,200
Chaillac, Indre
3
1
96 m²
1,703 m²
BVI73051
€65,900
Virtual tour360
Cordes-sur-Ciel, Tarn
4
3
322 m²
170,970 m²
BVI71506
€1,790,000
Castelsagrat, Tarn-et-Garonne
10
9
864 m²
69,842 m²
BVI20675
€999,000
Chaunay, Vienne
3
1
160 m²
1,499 m²
BVI73265
€185,760
En exclusivité
Virtual tour360
Lisle-sur-Tarn, Tarn
5
5
350 m²
9,254 m²
BVI69293
€575,000
Video available
Uzès, Gard
22
22
2700 m²
60,000 m²
BVI73033
€3,800,000
Virtual tour360
Saint-Savin, Vienne
6
4
391 m²
4,615 m²
BVI72827
€519,400
Montauban, Tarn-et-Garonne
6
2
197 m²
3,000 m²
BVI72756
€426,000
En exclusivité
Video available
Bellac, Haute-Vienne
3
2
130 m²
16,970 m²
BVI67234
€386,900
Virtual tour360
Cordes-sur-Ciel, Tarn
3
2
212 m²
11,135 m²
BVI75717
€636,000
Virtual tour360
Carcassonne, Aude
8
5
413 m²
6,645 m²
BVI72656
€895,000
En exclusivité
Thollet, Vienne
4
1
80 m²
699 m²
BVI72280
€109,000
Virtual tour360
Castelnaudary, Aude
11
9
880 m²
36,800 m²
BVI65315
€1,768,000
En exclusivité
Montmorillon, Vienne
1
1
47 m²
181 m²
BVI72998
€61,000
Saint-Barthélemy-d’Agenais, Lot-et-Garonne
4
1
126 m²
9,870 m²
BVI73239
€254,660
Cherves-Richemont, Charente
5
4
275 m²
1,630 m²
BVI72893
€615,000
En exclusivité
Sauveterre-de-Guyenne, Gironde
8
6
295 m²
10,949 m²
BVI72207
€740,000
Video available
Loubès-Bernac, Lot-et-Garonne
4
2
156 m²
2,184 m²
BVI71359
€386,900
Sarlat-la-Canéda, Dordogne
2
202 m²
YAA6080
€202,000
Video available
Bellac, Haute-Vienne
2
2
60 m²
49 m²
BVI73149
€55,000
En exclusivité
Video available
Boussac, Creuse
4
3
206 m²
14,492 m²
BVI72878
€649,000
En exclusivité
Monsempron-Libos, Lot-et-Garonne
4
1
275 m²
4,000 m²
BVI66029
€152,200
Monségur, Gironde
3
1
141 m²
2,480 m²
BVI71942
€198,000
Thézan-des-Corbières, Aude
6
2
290 m²
1,720 m²
BVI72848
€265,000
Barbezieux-Saint-Hilaire, Charente
2
1
71 m²
1,115 m²
BVI72371
€127,000
Verteillac, Dordogne
3
3
148 m²
2,407 m²
BVI72853
€210,000
En exclusivité
Video available
Virtual tour360
L’Isle-Jourdain, Vienne
8
8
549 m²
399,641 m²
BVI73111
€2,205,000
En exclusivité
Virtual tour360
La Chapelle-Montmoreau, Dordogne
5
3
304 m²
24,545 m²
BVI64826
€395,000

Ce que vous dites de nous

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