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:57:14') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:57:14') 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:57:14') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:57:14') 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:57:14') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:57:14') 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:57:14') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:57:14') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 474 à 516 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:57:14') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:57:14') 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:57:14') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:57:14') 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:57:14') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:57:14') 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:57:14') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:57:14') 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
Verteillac, Dordogne
5
3
136 m²
3,271 m²
BVI76429
€295,000
Chalais, Charente
3
3
193 m²
3,467 m²
BVI75659
€195,700
Pineuilh, Gironde
3
1
142 m²
3,985 m²
BVI76059
€235,400
Mareuil en Périgord, Dordogne
4
2
172 m²
706 m²
BVI76236
€189,000
Sarlat-la-Canéda, Dordogne
3
3.608 m²
YAA6112
€550,000
Gagnac-sur-Cère, Lot
3
2
125 m²
14,120 m²
BVI76669
€215,000
Cordes-sur-Ciel, Tarn
3
2
199 m²
337 m²
BVI76450
€425,000
Pézenas, Hérault
4
4
374 m²
984 m²
BVI76676
€1,495,000
Rocamadour, Lot
9
8
320 m²
11,855 m²
BVI73711
€525,000
Monségur, Gironde
5
2
171 m²
5,000 m²
BVI76449
€395,000
Civray, Vienne
2
1
127 m²
804 m²
BVI73600
€189,000
Issigeac, Dordogne
4
2
240 m²
9,323 m²
BVI76428
€585,000
Vieux-Mareuil, Dordogne
3
3
118 m²
321 m²
BVI76283
€139,000
Lussac-les-Églises, Haute-Vienne
4
2
180 m²
3,600 m²
BVI75338
€189,000
Paizay-le-Chapt, Deux-Sèvres
5
4
315 m²
2,797 m²
BVI76264
€296,800
Peyrole, Tarn
5
2
253 m²
27,460 m²
BVI66561
€450,000
Magnac-Laval, Haute-Vienne
2
1
88 m²
2,799 m²
BVI76406
€88,000
Jarnac, Charente
5
3
238 m²
849 m²
BVI75716
€585,000
Brie, Charente
3
2
100 m²
1,502 m²
BVI76430
€235,400
La Roque-d’Anthéron, Bouches-du-Rhône
1
146 m²
1,030 m²
BVI76486
€663,000
Bellac, Haute-Vienne
4
1
236 m²
114 m²
BVI76369
€99,000
Aix-en-Provence, Bouches-du-Rhône
1
1
29 m²
39 m²
BVI76462
€249,000
Montbron, Charente
2
1
120 m²
1,894 m²
BVI67795
€162,000
Aumagne, Charente-Maritime
3
4
248 m²
1,105 m²
BVI76380
€379,480
Clussais-la-Pommeraie, Deux-Sèvres
5
4
220 m²
2,560 m²
BVI74331
€325,000
Mirambeau, Charente-Maritime
3
1
124 m²
363 m²
BVI60242
€95,000
Adriers, Vienne
3
2
189 m²
44,868 m²
BVI75817
€348,740
Bergerac, Dordogne
5
4
414 m²
23,637 m²
BVI76194
€1,112,000
Lunac, Aveyron
5
4
320 m²
13,357 m²
BVI76343
€585,000
Brantôme, Dordogne
4
2
360 m²
2,862 m²
BVI76397
€545,900
Verteillac, Dordogne
5
3
130 m²
1,628 m²
BVI76320
€315,000
Payroux, Vienne
3
4
147 m²
6,790 m²
BVI76379
€155,000
Saint-Mathieu, Haute-Vienne
3
2
138 m²
4,736 m²
BVI74942
€249,900
Aix-en-Provence, Bouches-du-Rhône
5
3
240 m²
3,810 m²
BVI76461
€1,830,000
Aubeterre-sur-Dronne, Charente
3
2
126 m²
3,900 m²
BVI76476
€214,000
Lacapelle-Marival, Lot
4
2
151 m²
123,355 m²
BVI76375
€455,800
Chef-Boutonne, Deux-Sèvres
5
3
290 m²
4,265 m²
BVI76113
€556,500
Caylus, Tarn-et-Garonne
7
6
416 m²
16,400 m²
BVI76104
€1,534,000
Eyragues, Bouches-du-Rhône
4
4
245 m²
4,788 m²
BVI76548
€980,000
Lourmarin, Vaucluse
9
4
470 m²
20,000 m²
BVI70764
€1,995,000
Douzains, Lot-et-Garonne
5
2
149 m²
2,126 m²
BVI76161
€292,700
Beaugas, Lot-et-Garonne
4
4
308 m²
34,773 m²
BVI67094
€524,000
Capendu, Aude
6
3
285 m²
564 m²
BVI73437
