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:22:48') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-19 06:22:48') 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:22:48') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-19 06:22:48') 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:22:48') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-19 06:22:48') 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:22:48') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-19 06:22:48') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 1248 à 1290 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-01-19 06:22:48') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-19 06:22:48') 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:22:48') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-19 06:22:48') 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:22:48') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-19 06:22:48') 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:22:48') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-19 06:22:48') 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
Saint-Paul-Lizonne, Dordogne
4
3
268 m²
2,379 m²
BVI72747
€381,600
Boussac, Creuse
2
2
151 m²
4,796 m²
BVI72374
€425,000
Montcuq, Lot
9
8
350 m²
67,900 m²
BVI73685
€995,000
Nogaro, Gers
6
5
330 m²
33,451 m²
BVI72215
€985,000
Sainte-Foy-la-Grande, Gironde
6
3
330 m²
4,420 m²
BVI67809
€540,000
Valdelaume, Deux-Sèvres
2
1
87 m²
375 m²
BVI69530
€61,000
La Rochelle, Charente-Maritime
7
4
300 m²
1,302 m²
BVI58561
€988,000
Ségur-le-Château, Corrèze
2
1
88 m²
1,888 m²
BVI73790
€172,800
Jarnac-Champagne, Charente-Maritime
7
2
273 m²
3,154 m²
BVI68066
€695,000
Boussac, Creuse
2
1
110 m²
107,842 m²
BVI73254
€163,000
Toulouse, Haute-Garonne
11
9
1500 m²
103,719 m²
BVI72763
€7,245,000
Montlieu-la-Garde, Charente-Maritime
6
4
300 m²
1,553 m²
BVI73471
€455,800
Sauliac-sur-Célé, Lot
184 m²
98,843 m²
BVI70472
€288,900
Lathus St Remy, Vienne
3
1
98 m²
503 m²
BVI19103
€119,900
La Brée-les-Bains, Charente-Maritime
3
3
85 m²
510 m²
BVI73715
€447,370
Roquecor, Tarn-et-Garonne
3
1
115 m²
294 m²
BVI72220
€125,000
Chéronnac, Haute-Vienne
3
4
252 m²
1,620 m²
BVI73500
€246,100
Montmorillon, Vienne
3
3
232 m²
12,607 m²
BVI73693
€172,800
Lamothe-Fénelon, Lot
7
2
260 m²
1,912 m²
BVI73388
€240,750
Le Dorat, Haute-Vienne
2
1
93 m²
34,164 m²
BVI73537
€224,700
Bussière-Dunoise, Creuse
3
2
205 m²
5,464 m²
BVI73188
€371,000
Barbezieux-Saint-Hilaire, Charente
2
1
95 m²
4,496 m²
BVI73350
€135,000
Montcuq, Lot
9
8
350 m²
208,090 m²
BVI67090
€1,044,000
Servanches, Dordogne
3
2
127 m²
6,090 m²
BVI73606
€143,880
Cromac, Haute-Vienne
1830 m²
BVI71775
€19,000
Duras, Lot-et-Garonne
5
6
384 m²
4,756 m²
BVI73427
€425,550
Confolens, Charente
4
2
195 m²
213 m²
BVI73363
€244,000
Coulonges, Vienne
3
2
96 m²
4,279 m²
BVI73506
€155,000
Lorignac, Charente-Maritime
1
1
83 m²
6,870 m²
BVI65812
€203,226
Nérac, Lot-et-Garonne
4
2
200 m²
74,038 m²
BVI72943
€650,000
Liglet, Vienne
3
2
100 m²
113 m²
BVI73571
€66,000
Sauviat-sur-Vige, Haute-Vienne
13
13
910 m²
2,378 m²
BVI68907
€371,000
Douzens, Aude
14
9
530 m²
21,429 m²
BVI72091
€1,175,000
Montmoreau, Charente
3
2
175 m²
1,126 m²
BVI73485
€192,000
Cabrerets, Lot
3
1
110 m²
9,368 m²
BVI70710
€259,000
Étouars, Dordogne
4
1
150 m²
1,005 m²
BVI60652
€152,600
Mansle-les-fontaines, Charente
7
3
378 m²
2,565 m²
BVI73423
€399,950
Verteillac, Dordogne
6
4
470 m²
9,895 m²
BVI59335
€750,000
Jonzac, Charente-Maritime
6
2
375 m²
4,674 m²
BVI68968
€540,750
Caunay, Deux-Sèvres
4
3
191 m²
1,450 m²
BVI73366
€289,000
Ribérac, Dordogne
3
2
120 m²
2,017 m²
BVI73189
€150,000
Barbezieux-Saint-Hilaire, Charente
4
1
145 m²
695 m²
BVI72587
€194,400
Secondigny, Deux-Sèvres
2
1
583 m²
583 m²
BVI73400
