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-04-24 13:46:02') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-04-24 13:46:02') 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-04-24 13:46:02') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-24 13:46:02') 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-04-24 13:46:02') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-04-24 13:46:02') 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-04-24 13:46:02') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-24 13:46:02') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 87 à 129 sur 3165
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-04-24 13:46:02') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-04-24 13:46:02') 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-04-24 13:46:02') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-24 13:46:02') 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-04-24 13:46:02') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-04-24 13:46:02') 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-04-24 13:46:02') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-24 13:46:02') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Nos dernières annonces immobilières
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” !
Les dernières propriétés dans votre boîte email. Ne manquez pas celle-ci.
S'inscrire
Aix-en-Provence, Bouches-du-Rhône
322 m²
423 m²
BVI77577
€2,040,000
Nérac, Lot-et-Garonne
7
2
340 m²
389 m²
BVI77493
€360,400
Maisonnais-sur-Tardoire, Haute-Vienne
3
1
87 m²
755 m²
BVI76334
€78,999
Castillonnès, Lot-et-Garonne
3
1
220 m²
3,412 m²
BVI74591
€424,000
Champniers-et-Reilhac, Dordogne
1
68 m²
2,202 m²
BVI77497
€56,000
Bouteilles St Sebastien, Dordogne
2
2
102 m²
1,372 m²
BVI77534
€275,000
Bélesta, Ariège
8
3
444 m²
7,749 m²
BVI76988
€430,000
Duras, Lot-et-Garonne
4
3
208 m²
18,874 m²
BVI77420
€600,000
Aix-en-Provence, Bouches-du-Rhône
4
2
122 m²
300 m²
BVI76472
€773,195
Labastide Murat, Lot
3
2
120 m²
6,550 m²
BVI77212
€201,950
Saint-Léger-Magnazeix, Haute-Vienne
3
2
109 m²
1,582 m²
BVI77145
€162,000
Aix-en-Provence, Bouches-du-Rhône
4
3
200 m²
324 m²
BVI76490
€2,995,000
Verteillac, Dordogne
4
3
206 m²
1,704 m²
BVI74137
€318,000
Allemans-du-Dropt, Lot-et-Garonne
5
5
292 m²
2,265 m²
BVI72066
€434,600
Cardaillac, Lot
7
5
250 m²
20,900 m²
BVI76456
€595,000
Éguzon-Chantôme, Indre
4
2
150 m²
1,700 m²
BVI77517
€179,280
La Trimouille, Vienne
2
1
46 m²
40 m²
BVI77384
€41,000
La Trimouille, Vienne
4
2
170 m²
83,961 m²
BVI61260
€320,000
Charroux, Vienne
3
2
99 m²
7,351 m²
BVI72008
€195,000
Barbezieux-Saint-Hilaire, Charente
1
77 m²
236 m²
BVI77140
€113,400
Pineuilh, Gironde
4
2
117 m²
680 m²
BVI76416
€204,310
La Calmette, Gard
4
2
363 m²
220,000 m²
BVI76098
€1,260,000
Limoux, Aude
2
1
80 m²
512 m²
BVI75671
€178,200
Le Temple-sur-Lot, Lot-et-Garonne
2
1
108 m²
27,009 m²
BVI77424
€212,000
Montaigu-de-Quercy, Tarn-et-Garonne
6
2
200 m²
76,487 m²
BVI77112
€477,000
Monflanquin, Lot-et-Garonne
950 m²
BVI67977
€26,000
Tournon-d’Agenais, Lot-et-Garonne
6
3
190 m²
10,638 m²
BVI76189
€558,000
Chaillac, Indre
3
1
182 m²
1,063 m²
BVI73550
€72,300
Brioux-sur-Boutonne, Deux-Sèvres
3
3
329 m²
339 m²
BVI76825
€229,355
La Châtre-Langlin, Indre
4
1
94 m²
22,192 m²
BVI76442
€99,000
Port-Sainte-Marie, Lot-et-Garonne
3
2
114 m²
11,493 m²
BVI77225
€235,400
Sarlat-la-Canéda, Dordogne
4
14.353 m²
YAA6115
€499,000
Coulonges, Vienne
3
1
62 m²
1,572 m²
BVI73257
€46,000
Lalinde, Dordogne
4
2
183 m²
5,036 m²
BVI77350
€371,000
Cognac, Charente
4
1
217 m²
2,468 m²
BVI76654
€292,000
Chalais, Charente
6
2
216 m²
1,979 m²
BVI77439
€330,000
Issigeac, Dordogne
4
6
360 m²
28,700 m²
BVI76725
€895,000
Montguyon, Charente-Maritime
4
3
162 m²
972 m²
BVI69052
€325,000
Longeville-sur-Mer, Vendée
5
4
223 m²
968 m²
BVI77254
€745,000
Bussière-Badil, Dordogne
4
3
275 m²
1,393 m²
BVI76035
€337,780
Pleuville, Charente
2
1
126 m²
1,490 m²
BVI69567
€189,999
Chalais, Charente
5
3
262 m²
587 m²
BVI69317
€328,600
Allemans-du-Dropt, Lot-et-Garonne
3
2
115 m²
127 m²
BVI77261
