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 13:03:50') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:03:50') 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 13:03:50') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:03:50') 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 13:03:50') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:03:50') 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 13:03:50') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:03:50') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 2624 à 2666 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 13:03:50') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:03:50') 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 13:03:50') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:03:50') 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 13:03:50') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:03:50') 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 13:03:50') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:03:50') 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
Brouilla, Pyrénées-Orientales
3
240 m²
TAADH1114
€1,200,000
Ille-sur-Têt, Pyrénées-Orientales
10
290 m²
TAAVH1146
€499,000
Sussey, Côte-d'Or
4
1
131 m²
15,049 m²
ABART5498P
€295,000
Cormot le Grand, Côte-d'Or
4
2
111 m²
2,616 m²
ABACR5548BS
€216,000
Cussy la Colonne, Côte-d'Or
3
3
125 m²
3,020 m²
ABACR5482BS
€270,000
Couches, Saône-et-Loire
4
3
131 m²
3,780 m²
ABAPM5521D
€315,000
Autun, Saône-et-Loire
3
2
157 m²
13,516 m²
ABAPM5544D
€240,000
Nolay, Côte-d'Or
5
4
250 m²
690 m²
ABACR5547BS
€326,000
Sully, Saône-et-Loire
5
2
150 m²
7,881 m²
ABAPM5467D
€200,000
ST SYMPHORIEN DE MARMAGNE, Saône-et-Loire
4
2
166 m²
14,536 m²
ABABH5504D
€197,500
Colméry, Nièvre
3
1
93 m²
9,075 m²
ABALB5535N
€148,500
ST MARCELIN DE CRAY, Saône-et-Loire
3
3
330 m²
5,465 m²
ABADF5505C
€399,000
ISSY L EVEQUE, Saône-et-Loire
4
1
105 m²
11,394 m²
ABADF5469C
€199,900
Painblanc, Côte-d'Or
3
2
212 m²
4,353 m²
ABART5466P
€320,000
Joncy, Saône-et-Loire
3
2
134 m²
2,183 m²
ABAJP5461S
€149,500
Dennevy, Saône-et-Loire
3
2
137 m²
375 m²
ABABH5456H
€196,000
Beaune, Côte-d'Or
4
1
205 m²
1,573 m²
ABACR5447BS
€399,000
Aignay le Duc, Côte-d'Or
4
4
193 m²
636 m²
ABABH5485H
€270,000
Vézelay, Yonne
8
5
227 m²
717 m²
ABABH5513H
€349,500
Marmagne, Saône-et-Loire
4
1
227 m²
5,430 m²
ABABH5503D
€395,000
ST AGNAN, Saône-et-Loire
2
2
295 m²
1,075 m²
ABADF5472C
€315,000
Mâcon, Saône-et-Loire
10
4
530 m²
115,000 m²
ABALE5471S
€1,590,000
Vireaux, Yonne
4
3
168 m²
505 m²
ABART5475P
€155,000
Baubigny, Côte-d'Or
3
1
82 m²
108 m²
ABACR5532BS
€239,000
PARIS L HOPITAL, Saône-et-Loire
4
1
174 m²
1,000 m²
ABABH5487M
€220,000
Nolay, Côte-d'Or
3
1
195 m²
5,800 m²
ABACR5494BS
€475,000
Culêtre, Côte-d'Or
2
1
112 m²
2,939 m²
ABART5508P
€240,000
Ravières, Yonne
4
3
167 m²
333 m²
ABART5509P
€160,000
Varzy, Nièvre
5
3
274 m²
1,341 m²
ABALB5507N
€305,000
Montceau et Écharnant, Côte-d'Or
4
2
228 m²
1,435 m²
ABACR5512BS
€235,000
Mervans, Saône-et-Loire
4
2
163 m²
1,405 m²
ABABH5517H
€180,000
Verdun sur le Doubs, Saône-et-Loire
3
2
224 m²
1,508 m²
ABABH5520H
€280,000
Nolay, Côte-d'Or
4
2
213 m²
493 m²
ABACR5542BS
€280,000
Salies-de-Béarn, Pyrénées-Atlantiques
8
314 m²
2,014 m²
ALA1880
€498,750
Oloron-Sainte-Marie, Pyrénées-Atlantiques
9
1,025 m²
ALA1887
€406,000
L’Hôpital-d’Orion, Pyrénées-Atlantiques
4
158 m²
5,324 m²
ALA1936
€345,000
Tilh, Landes
7
292 m²
12,000 m²
ALA1917
€630,000
Salies-de-Béarn, Pyrénées-Atlantiques
3
130 m²
ALA1834
€175,000
Salies-de-Béarn, Pyrénées-Atlantiques
3
115 m²
ALA1813
€154,000
Salies-de-Béarn, Pyrénées-Atlantiques
440 m²
ALA1893
€260,000
Salies-de-Béarn, Pyrénées-Atlantiques
4
3,656 m²
ALA1900
€449,000
Orthez, Pyrénées-Atlantiques
3
125 m²
1,490 m²
ALA1938
€255,000
Salies-de-Béarn, Pyrénées-Atlantiques
3
152 m²
ALA1947
