Array
(
[keyword] =>
[province_combi] =>
[county_combi] =>
[country] =>
[locstate] =>
[province] =>
[province_num] =>
[county] =>
[office] =>
[liv] =>
[sav] => 1
[drainage] =>
[heating_device] =>
[heating_access] =>
[features1] =>
[mls_apimo] =>
[exc] =>
[income] =>
[mec_col] =>
[price_reduced] =>
[postcode] =>
[region] =>
[city] =>
[subdivision] =>
[listing_office] =>
[stype] => Array
(
[0] => 1
[1] => 5
)
[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`.`sav` IN ('1') AND `p`.`stype` IN ('1','5') 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:40:46') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:40:46') 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:40:46') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:40:46') 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] => 1 [drainage] => [heating_device] => [heating_access] => [features1] => [mls_apimo] => [exc] => [income] => [mec_col] => [price_reduced] => [postcode] => [region] => [city] => [subdivision] => [listing_office] => [stype] => Array ( [0] => 1 [1] => 5 ) [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`.`sav` IN ('1') AND `p`.`stype` IN ('1','5') 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:40:46') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:40:46') 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:40:46') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:40:46') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 130 à 172 sur 451
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`.`sav` IN ('1') AND `p`.`stype` IN ('1','5') 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:40:46') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:40:46') 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:40:46') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:40:46') 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] => 1 [drainage] => [heating_device] => [heating_access] => [features1] => [mls_apimo] => [exc] => [income] => [mec_col] => [price_reduced] => [postcode] => [region] => [city] => [subdivision] => [listing_office] => [stype] => Array ( [0] => 1 [1] => 5 ) [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`.`sav` IN ('1') AND `p`.`stype` IN ('1','5') 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:40:46') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:40:46') 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:40:46') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:40:46') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Propriétés à vendre en partenariat avec Savills
En tant qu'associé international de Savills pour le sud-ouest de la France, nous pouvons vous proposer les plus belles propriétés à la vente à partir de 500 000 €.
Châteaux, demeures de prestige, villas et fermes, ainsi que des entreprises telles que des gîtes, des lieux d'événements et des hôtels de luxe.
Sainte-Foy-la-Grande, Gironde
10
6
512 m²
27,450 m²
BVI72408
€1,395,000
Saint-Antonin-Noble-Val, Tarn-et-Garonne
9
7
460 m²
473 m²
BVI60146
€860,000
Beauville, Lot-et-Garonne
6
5
300 m²
7,762 m²
BVI75905
€649,000
Le Ségur, Tarn
7
7
580 m²
17,600 m²
BVI72919
€730,000
Carcassonne, Aude
15
12
1100 m²
373,044 m²
BVI59001
€1,908,000
Cahuzac-sur-Vère, Tarn
10
3
445 m²
69,447 m²
BVI75528
€812,766
Cunèges, Dordogne
3
3
203 m²
7,196 m²
BVI68975
€563,000
Chantonnay, Vendée
8
10
843 m²
22,910 m²
BVI75604
€1,380,000
Saint-Angeau, Charente
7
3
398 m²
5,989 m²
BVI75696
€617,100
Limoux, Aude
5
3
314 m²
161,387 m²
BVI72597
€1,200,000
Bergerac, Dordogne
4
3
259 m²
13,000 m²
BVI74842
€789,500
Gourdon, Lot
6
6
361 m²
15,505 m²
BVI75697
€1,299,000
Tombebœuf, Lot-et-Garonne
14
6
450 m²
12,000 m²
BVI75491
€742,000
Avignon, Vaucluse
3
388 m²
377,152 m²
BVI73127
€3,895,000
Olonzac, Hérault
9
10
641 m²
705 m²
BVI75489
€875,000
Duras, Lot-et-Garonne
10
5
467 m²
1,164,695 m²
BVI71815
€2,751,500
Saint-Cirq-Lapopie, Lot
4
5
300 m²
5,807 m²
BVI75140
€639,000
Villefagnan, Charente
8
6
453 m²
17,272 m²
BVI72714
€742,000
Moulins, Allier
18
10
475 m²
400,000 m²
BVI75426
€799,000
Buzet-sur-Baïse, Lot-et-Garonne
5
4
480 m²
3,847 m²
BVI75517
€640,500
Ginals, Tarn-et-Garonne
6
5
237 m²
73,000 m²
BVI67692
€559,000
Agnac, Lot-et-Garonne
5
4
251 m²
11,886 m²
BVI75112
€567,100
Issigeac, Dordogne
4
2
184 m²
23,389 m²
BVI75593
€630,000
Sainte-Alvère, Dordogne
9
9
416 m²
20,349 m²
BVI66655
€795,000
Saint-Savin, Vienne
7
5
343 m²
744 m²
BVI74444
€692,000
Thiviers, Dordogne
14
12
411 m²
9,022 m²
BVI74998
€657,200
Cahuzac, Lot-et-Garonne
7
4
453 m²
133,396 m²
BVI71147
€1,680,000
Monbahus, Lot-et-Garonne
8
8
311 m²
13,155 m²
BVI74242
€558,500
Roquecor, Tarn-et-Garonne
7
4
355 m²
12,448 m²
BVI68554
€699,000
Cordes-sur-Ciel, Tarn
9
2
266 m²
531,340 m²
BVI71493
€1,132,000
Villeneuve-sur-Lot, Lot-et-Garonne
12
5
580 m²
47,472 m²
BVI61108
€1,390,000
Verteillac, Dordogne
4
3
223 m²
48,490 m²
BVI75585
€573,685
Lacour, Tarn-et-Garonne
5
5
195 m²
3,550 m²
BVI65516
€601,000
Lalinde, Dordogne
8
7
391 m²
6,050 m²
BVI73839
€570,000
Lectoure, Gers
11
3
950 m²
2,084,160 m²
BVI68228
€3,705,000
Lisle-sur-Tarn, Tarn
6
3
300 m²
88,053 m²
BVI75457
€765,960
Saint-Michel-de-Fronsac, Gironde
4
3
300 m²
3,583 m²
BVI75189
€998,000
Pont-de-Larn, Tarn
8
3
320 m²
43,305 m²
BVI67507
€638,297
Puycelsi, Tarn
5
4
325 m²
224,950 m²
BVI69920
€689,000
La Roque-Gageac, Dordogne
4
3
160 m²
1,977 m²
BVI73814
€644,000
Cordes-sur-Ciel, Tarn
4
3
301 m²
62,697 m²
BVI74572
€850,000
Excideuil, Dordogne
12
12
756 m²
611,369 m²
BVI72809
€1,300,000
Frausseilles, Tarn
7
4
318 m²
42,239 m²
BVI75422
