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 07:59:30') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:59:30') 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 07:59:30') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:59:30') 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 07:59:30') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:59:30') 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 07:59:30') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:59:30') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 44 à 86 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 07:59:30') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:59:30') 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 07:59:30') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:59:30') 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 07:59:30') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:59:30') 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 07:59:30') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:59:30') 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
Faye-l’Abbesse, Deux-Sèvres
4
2
167 m²
1,512 m²
BVI77621
€214,000
Eymet, Dordogne
3
2
122 m²
1,055 m²
BVI61353
€199,000
Faye-l’Abbesse, Deux-Sèvres
3
5
310 m²
9,017 m²
BVI72143
€371,000
Villeréal, Lot-et-Garonne
6
3
194 m²
7,680 m²
BVI77598
€424,000
Marmande, Lot-et-Garonne
2
1
108 m²
3,002 m²
BVI76287
€119,900
Soumensac, Lot-et-Garonne
3
2
248 m²
3,684 m²
BVI73646
€455,800
Segonzac, Charente
4
2
224 m²
4,596 m²
BVI71043
€549,000
Mirandol-Bourgnounac, Tarn
4
2
155 m²
7,589 m²
BVI73884
€349,000
Chaillac, Indre
5
1
125 m²
646 m²
BVI75934
€168,500
Jarnac, Charente
3
3
198 m²
1,210 m²
BVI72934
€299,000
Limoux, Aude
5
4
187 m²
2,193 m²
BVI77533
€320,000
Payroux, Vienne
3
1
70 m²
635 m²
BVI77443
€77,000
Laguépie, Tarn-et-Garonne
3
3
134 m²
10,000 m²
BVI72413
€360,000
Monestier, Dordogne
2
1
100 m²
188 m²
BVI77539
€131,000
Cherves-Richemont, Charente
3
1
130 m²
3,122 m²
BVI71492
€320,000
Saint-Émilion, Gironde
5
3
334 m²
9,665 m²
BVI77612
€710,000
Beaugas, Lot-et-Garonne
5
2
195 m²
10,654 m²
BVI75441
€399,000
Saussignac, Dordogne
6
4
300 m²
11,677 m²
BVI77144
€750,000
Bussière-Poitevine, Haute-Vienne
4
2
212 m²
2,310 m²
BVI77010
€136,250
Bussière-Badil, Dordogne
3
1
140 m²
346 m²
BVI77216
€104,500
Bonneuil, Indre
3
2
87 m²
362 m²
BVI77191
€88,000
Ribérac, Dordogne
2
1
91 m²
1,180 m²
BVI73531
€137,500
Verteillac, Dordogne
3
1
85 m²
2,190 m²
BVI73144
€155,000
Condéon, Charente
3
1
100 m²
900 m²
BVI72473
€259,900
Reilhaguet, Lot
1
100 m²
2,092 m²
BVI74681
€89,000
Châteauponsac, Haute-Vienne
4
4
255 m²
96 m²
BVI77650
€143,000
Argenton-sur-Creuse, Indre
8
4
410 m²
13,905 m²
BVI77253
€472,500
Saint-Benoît-du-Sault, Indre
4
2
177 m²
769 m²
BVI76560
€190,250
Verteillac, Dordogne
3
1
98 m²
5,883 m²
BVI77490
€125,000
Ribérac, Dordogne
3
2
130 m²
1,130 m²
BVI77472
€167,400
Sarlat-la-Canéda, Dordogne
3
2
100 m²
4,410 m²
BVI77426
€214,950
Jouac, Haute-Vienne
3
2
160 m²
1,194 m²
BVI77548
€185,800
Brossac, Charente
3
3
213 m²
8,690 m²
BVI77331
€296,800
Penne-d’Agenais, Lot-et-Garonne
4
1
127 m²
31,140 m²
BVI75708
€345,000
Montmorillon, Vienne
1
1
32 m²
53 m²
BVI75803
€19,000
Brion-près-Thouet, Deux-Sèvres
2
1
51 m²
2,239 m²
BVI77540
€99,000
Brion-près-Thouet, Deux-Sèvres
8
5
315 m²
43,319 m²
BVI65341
€376,300
Jarnac, Charente
4
2
204 m²
3,369 m²
BVI76692
€575,000
Segonzac, Charente
4
2
240 m²
2,350 m²
BVI77240
€371,000
Castelnau-de-Montmiral, Tarn
3
1
195 m²
26,518 m²
BVI77204
€299,000
Allemans, Dordogne
3
2
143 m²
604 m²
BVI72267
€235,400
Aix-en-Provence, Bouches-du-Rhône
5
3
171 m²
BVI76544
€1,029,000
Bergerac, Dordogne
3
1
140 m²
39,375 m²
BVI71169
