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 10:46:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:46:47') 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 10:46:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:46:47') 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 10:46:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:46:47') 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 10:46:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:46:47') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 560 à 602 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-18 10:46:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:46:47') 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 10:46:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:46:47') 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 10:46:47') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:46:47') 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 10:46:47') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:46:47') 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-Antonin-Noble-Val, Tarn-et-Garonne
3
2
128 m²
12,148 m²
BVI76005
€537,000
Lamothe-Cumont, Tarn-et-Garonne
2
2
220 m²
2,453 m²
BVI75552
€125,000
Saint-Mathieu, Haute-Vienne
2
1
84 m²
6,279 m²
BVI71131
€136,250
Saint-Hilaire-la-Treille, Haute-Vienne
4
2
217 m²
4,350 m²
BVI76227
€135,160
Messé, Deux-Sèvres
5
5
442 m²
4,166 m²
BVI76312
€318,000
Sarlat-la-Canéda, Dordogne
6
YAA6109
€949,000
Azay-le-Ferron, Indre
2
2
170 m²
8,409 m²
BVI75860
€199,995
Saint-Savin, Vienne
6
3
199 m²
1,054 m²
BVI76201
€178,200
Lalinde, Dordogne
4
2
147 m²
7,363 m²
BVI76306
€269,640
Rouillac, Charente
11
9
500 m²
4,245 m²
BVI75626
€975,000
Nalliers, Vienne
3
2
110 m²
10,110 m²
BVI72780
€150,000
Monbahus, Lot-et-Garonne
4
3
160 m²
18,318 m²
BVI70262
€381,600
Monteils, Aveyron
6
3
214 m²
72,779 m²
BVI75370
€325,000
Barbezieux-Saint-Hilaire, Charente
3
1
117 m²
965 m²
BVI76235
€233,200
Sainte-Lheurine, Charente-Maritime
7
1
177 m²
7,798 m²
BVI74852
€172,800
Chalais, Charente
2
1
200 m²
775 m²
BVI76176
€95,000
Saint-Front-de-Pradoux, Dordogne
6
2
217 m²
5,713 m²
BVI76285
€399,999
Marmande, Lot-et-Garonne
5
2
272 m²
612 m²
BVI76332
€422,000
Tilly, Indre
1
1
65 m²
1,160 m²
BVI75826
€71,500
Saint-Vincent-Lespinasse, Tarn-et-Garonne
12
8
619 m²
31,912 m²
BVI68756
€635,000
Anduze, Gard
6
5
365 m²
6,225 m²
BVI73916
€904,000
Berneuil, Charente
938 m²
BVI76344
€20,000
Berneuil, Charente
872 m²
BVI75847
€20,000
Bellac, Haute-Vienne
4
2
145 m²
856 m²
BVI73830
€75,000
Mauzac-et-Grand-Castang, Dordogne
6
3
211 m²
19,246 m²
BVI75843
€466,400
Nérac, Lot-et-Garonne
2
1
100 m²
585 m²
BVI73447
€178,200
Lauzun, Lot-et-Garonne
6
5
273 m²
22,489 m²
BVI75416
€638,300
Albussac, Corrèze
4
2
176 m²
3,000 m²
BVI75766
€375,000
Monbahus, Lot-et-Garonne
3
2
332 m²
5,768 m²
BVI71767
€333,900
Sauveterre-de-Guyenne, Gironde
5
5
332 m²
10,110 m²
BVI75447
€470,000
Beauville, Lot-et-Garonne
3
1
123 m²
14,527 m²
BVI75440
€249,000
Cléré-sur-Layon, Maine-et-Loire
3
3
180 m²
45,060 m²
BVI76321
€542,600
Bioussac, Charente
4
2
202 m²
23,402 m²
BVI76186
€328,600
Taizé-Aizie, Charente
1980 m²
BVI76269
€17,000
Saint-Vallier, Charente
3
1
90 m²
2,137 m²
BVI71107
€141,150
Libourne, Gironde
6
4
294 m²
8,547 m²
BVI76083
€798,000
Roquecor, Tarn-et-Garonne
3
2
157 m²
4,900 m²
BVI76255
€455,800
Le Temple-sur-Lot, Lot-et-Garonne
3
1
145 m²
2,005 m²
BVI76292
€318,000
Le Lindois, Charente
5
5
250 m²
942 m²
BVI75295
€178,200
La Sauvetat-du-Dropt, Lot-et-Garonne
3
2
167 m²
122 m²
BVI76118
€235,400
Barbezieux-Saint-Hilaire, Charente
4
1
194 m²
1,445 m²
BVI76245
€212,000
Labastide Murat, Lot
4
1
123 m²
239,824 m²
BVI75670
€530,000
Civray, Vienne
2
3
79 m²
145 m²
BVI75944
