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-18 19:19:59') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 19:19:59') 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-18 19:19:59') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 19:19:59') 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-18 19:19:59') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 19:19:59') 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-18 19:19:59') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 19:19:59') 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 2409 à 2451 sur 3165
Capestang, Hérault
2
2
CAAPC198000EC
€195,000
Bize Minervois, Aude
3
2
CAAMB648000E
€648,000
Cessenon sur Orb, Hérault
4
2
CAACC588500E
€518,950
Autignac, Hérault
5
3
CAASA449000E
€449,000
Puimisson, Hérault
7
7
CAAMP792720E
€792,720
Sarlat-la-Canéda, Dordogne
3
530 m²
YAA5666
€280,900
Eauze, Gers
3
1
153 m²
3,057 m²
AQA512
€192,600
Sarlat-la-Canéda, Dordogne
1.16 ha m²
YAA5435
€167,100
Betbezer d armagnac, Landes
3
220 m²
AQA74
€2,014,000
Fourcès, Gers
10
10
980 m²
5,600 m²
AQA3
€1,500,000
Barjols, Var
2
2
77 m²
DAA1199
€298,000
Châteauvert, Var
12
532 m²
24,100 m²
DAA1048VB2
€1,545,000
Le Val, Var
4
170 m²
3,635 m²
DAA1180
€595,000
Châteauvert, Var
3
110 m²
30,000 m²
DAA1171
€360,000
Carcès, Var
3
1
164 m²
800 m²
DAA1170
€415,000
Le Val, Var
4
525 m²
150,000 m²
DAA1115
€2,700,000
Le Val, Var
4
300 m²
130,000 m²
DAA1115B
€1,475,000
Le Val, Var
4
225 m²
100,000 m²
DAA1115A
€2,000,000
Montfort-sur-Argens, Var
3
93 m²
398 m²
DAA1178
€388,000
Cotignac, Var
3
210 m²
7,500 m²
DAA1154
€1,049,000
Le Val, Var
4
200 m²
6,290 m²
DAA1103
€699,000
Correns, Var
4
150 m²
DAA1112
€199,000
Tourves, Var
9
2
1000 m²
148,855 m²
DAA1124
€3,190,000
Nogent-sur-Marne, Val-de-Marne
10
700 m²
1,000 m²
DAADELAM3
€9,170,000
Saint-Maximin-la-Sainte-Baume, Var
7
1
174 m²
2,073 m²
DAA1155
€652,000
Pontevès, Var
5
140 m²
5,570 m²
DAA1162
€550,000
Le Val, Var
6
300 m²
3,800 m²
DAA1197
€795,000
Carcès, Var
5
108 m²
550 m²
DAA1188
€345,000
Châteauvert, Var
270 m²
830,000 m²
DAA1184
€2,740,000
Le Val, Var
5
170 m²
2,000 m²
DAA1190
€650,000
Tavernes, Var
4
250 m²
3,034 m²
DAA1158
€840,000
Seillons-Source-d’Argens, Var
2
2
76 m²
DAA1186
€235,000
Châteauvert, Var
8
305 m²
11,777 m²
DAA1176
€895,000
Video available
Montfort-sur-Argens, Var
5
145 m²
1,604 m²
DAADELHM
€440,000
Montfort-sur-Argens, Var
5
183 m²
13,000 m²
DAA1146
€520,000
Cotignac, Var
7
2
430 m²
DAADEL705VB
€630,000
Hyères, Var
4
288 m²
3,500 m²
DAA1521798
€2,070,000
Châteauvert, Var
4
227 m²
12,323 m²
DAA1177
€682,500
Correns, Var
7
375 m²
35,000 m²
DAADELLK
€1,275,000
Video available
Le Muy, Var
4
206 m²
2,330 m²
DAA1181
€895,000
Le Val, Var
6
300 m²
2,700 m²
DAA1182
€990,000
Châteauvert, Var
4
176 m²
5,000 m²
DAA1174
€680,000
Video available
Entrecasteaux, Var
3
3
140 m²
27 m²
DAA1185
€299,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