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] => 1
[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`.`featured` 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:39:36') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:39:36') 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:39:36') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:39:36') 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] => 1 [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`.`featured` 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:39:36') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:39:36') 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:39:36') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:39:36') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 44 à 86 sur 148
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`.`featured` 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:39:36') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:39:36') 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:39:36') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:39:36') 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] => 1 [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`.`featured` 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:39:36') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:39:36') 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:39:36') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:39:36') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Notre sélection de biens préférés
Chaque bien sélectionné a un petit je ne sais quoi.
Il peut s'agir de l'emplacement, de la qualité de la rénovation, du prix, ou simplement de ce sentiment particulier que notre conseiller a ressenti en franchissant la porte !
Lizant, Vienne
4
3
366 m²
5,438 m²
BVI70273
€446,250
Réalmont, Tarn
3
2
435 m²
235 m²
BVI61771
€245,000
Sénaillac-Lauzès, Lot
4
1
120 m²
270 m²
BVI74039
€77,800
Clussais-la-Pommeraie, Deux-Sèvres
3
2
204 m²
1,420 m²
BVI65762
€270,300
Padirac, Lot
9
6
370 m²
5,396 m²
BVI73615
€665,000
Clussais-la-Pommeraie, Deux-Sèvres
3
1
153 m²
1,914 m²
BVI73945
€194,500
Moissac, Tarn-et-Garonne
7
7
458 m²
690 m²
BVI72608
€689,000
Beaulieu-sur-Dordogne, Corrèze
7
5
280 m²
9,025 m²
BVI59800
€559,000
Montlieu-la-Garde, Charente-Maritime
6
4
300 m²
1,553 m²
BVI73471
€455,800
Douzens, Aude
14
9
530 m²
21,429 m²
BVI72091
€1,175,000
Cabrerets, Lot
3
1
110 m²
9,368 m²
BVI70710
€259,000
Verteillac, Dordogne
6
4
470 m²
9,895 m²
BVI59335
€750,000
Jonzac, Charente-Maritime
6
2
375 m²
4,674 m²
BVI68968
€540,750
Hanc, Deux-Sèvres
3
4
324 m²
3,077 m²
BVI72918
€246,100
Lisle-sur-Tarn, Tarn
5
5
350 m²
9,254 m²
BVI69293
€575,000
Saint-Savin, Vienne
6
4
391 m²
4,615 m²
BVI72827
€519,400
Monségur, Gironde
3
1
141 m²
2,480 m²
BVI71942
€198,000
Verteillac, Dordogne
3
3
148 m²
2,407 m²
BVI72853
€210,000
Hautefort, Dordogne
9
5
905 m²
17,855 m²
BVI72335
€1,500,000
Leyme, Lot
4
3
181 m²
3,893 m²
BVI72532
€299,000
Champniers-et-Reilhac, Dordogne
4
3
180 m²
19,880 m²
BVI68916
€392,200
Labastide Murat, Lot
9
8
320 m²
830 m²
BVI72631
€695,000
Varen, Tarn-et-Garonne
6
2
295 m²
7,790 m²
BVI69814
€265,000
Rouffilhac, Lot
5
4
210 m²
5,800 m²
BVI71005
€632,000
Chaillac, Indre
3
2
153 m²
1,810 m²
BVI72585
€137,900
Cordes-sur-Ciel, Tarn
5636 m²
BVI71980
€89,000
Aix-en-Provence, Bouches-du-Rhône
6
2
333 m²
5,000 m²
BVI70258
€2,190,000
Limalonges, Deux-Sèvres
3
2
175 m²
3,516 m²
BVI72465
€152,600
Lalbenque, Lot
7
5
270 m²
3,079 m²
BVI70473
€799,000
Rieux-Volvestre, Haute-Garonne
7
5
444 m²
269,542 m²
BVI72027
€750,000
Cognac, Charente
4
3
291 m²
1,390 m²
BVI72239
€425,500
Cellefrouin, Charente
1
1
78 m²
484 m²
BVI72132
€65,850
Lalandusse, Lot-et-Garonne
4
2
134 m²
1,758 m²
BVI70829
€256,800
Limoux, Aude
4
1
125 m²
4,933 m²
BVI72129
€268,000
Saint-Benoît-du-Sault, Indre
8
2
250 m²
850 m²
BVI71545
€299,600
Bernay-Saint-Martin, Charente-Maritime
6
4
346 m²
10,033 m²
BVI71712
€798,000
Verteillac, Dordogne
3
2
168 m²
1,551 m²
BVI67192
€219,350
Eymet, Dordogne
5
3
199 m²
7,305 m²
BVI71690
€514,100
Rieupeyroux, Aveyron
5
3
365 m²
12,129 m²
BVI71879
€636,000
Saint-Sulpice-de-Cognac, Charente
4
2
175 m²
2,474 m²
BVI64557
€275,000
Laroque-Timbaut, Lot-et-Garonne
8
4
400 m²
3,873 m²
BVI69981
€572,000
Le Dorat, Haute-Vienne
3
3
95 m²
483 m²
BVI71809
€162,000
Sauveterre-de-Guyenne, Gironde
4
2
357 m²
8,825 m²
BVI68718
