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 05:01:14') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:01: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 05:01:14') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:01: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] => 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 05:01:14') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:01: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 05:01:14') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:01:14') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 87 - 129 of 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 05:01:14') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:01: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 05:01:14') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:01: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] => 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 05:01:14') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:01: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 05:01:14') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:01:14') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Our featured French properties
Each Featured property has a little je ne sais quoi about it.
It might be the location, the quality of the renovation, the price, or it might just be that special feeling that our property consultant got as they walked through the door!
Cajarc, Lot
8
9
560 m²
12,755 m²
BVI58778
€1,266,000
Néré, Charente-Maritime
4
2
326 m²
11,427 m²
BVI71187
€349,500
Bergerac, Dordogne
7
4
438 m²
13,290 m²
BVI71463
€960,000
Courcôme, Charente
6
3
203 m²
1,210 m²
BVI71429
€256,800
Massignac, Charente
5
6
200 m²
5,615 m²
BVI65499
€449,950
Frespech, Lot-et-Garonne
3
3
215 m²
1,300 m²
BVI65495
€318,000
Chasseneuil-sur-Bonnieure, Charente
9
557 m²
7,563 m²
BVI70759
€669,995
La Péruse, Charente
3
2
137 m²
1,036 m²
BVI68848
€150,420
Bergerac, Dordogne
5
3
340 m²
41,615 m²
BVI71060
€950,000
Laparade, Lot-et-Garonne
4
1
82 m²
4,007 m²
BVI70945
€315,000
Marmande, Lot-et-Garonne
6
2
248 m²
18,000 m²
BVI71004
€508,800
La Roque-Gageac, Dordogne
4
4
115 m²
552 m²
BVI70345
€449,000
Nontron, Dordogne
5
3
328 m²
4,468 m²
BVI71127
€599,000
Lizant, Vienne
4
2
320 m²
1,841 m²
BVI70994
€413,400
Mansle-les-fontaines, Charente
5
2
160 m²
1,892 m²
BVI58667
€129,500
Laroque-Timbaut, Lot-et-Garonne
5
3
260 m²
28,360 m²
BVI66957
€619,995
Beaumontois en Périgord, Dordogne
7
4
469 m²
9,127 m²
BVI68198
€752,600
Confolens, Charente
4
2
154 m²
1,610 m²
BVI61187
€219,000
Monestiés, Tarn
4
2
161 m²
4,865 m²
BVI70730
€300,000
Monflanquin, Lot-et-Garonne
7
3
270 m²
4,232 m²
BVI57986
€382,978
Miradoux, Gers
5
4
450 m²
16,467 m²
BVI65794
€1,000,000
Brux, Vienne
2
2
142 m²
3,038 m²
BVI70443
€214,000
Airvault, Deux-Sèvres
9
8
442 m²
4,694 m²
BVI67332
€820,000
Monbazillac, Dordogne
3
2
129 m²
1,358 m²
BVI70476
€583,000
Beauville, Lot-et-Garonne
4
2
224 m²
2,028 m²
BVI70193
€426,400
Beaulieu-sur-Dordogne, Corrèze
2
2
126 m²
4,545 m²
BVI68955
€268,800
Issigeac, Dordogne
3
1
170 m²
333 m²
BVI64908
€199,999
Villefagnan, Charente
5
2
234 m²
1,792 m²
BVI69406
€355,100
Valdelaume, Deux-Sèvres
3
1
159 m²
2,563 m²
BVI69643
€178,200
Castelnau-de-Montmiral, Tarn
7
3
530 m²
69,710 m²
BVI61766
€895,000
Alloue, Charente
8
8
405 m²
8,132 m²
BVI68984
€498,750
Montcuq, Lot
4
2
204 m²
8,430 m²
BVI68795
€695,000
Ginouillac, Lot
2
1
94 m²
18,526 m²
BVI69169
€248,000
Ladignac-le-Long, Haute-Vienne
7
5
312 m²
60,188 m²
BVI68804
€689,000
Minerve, Hérault
3
4
234 m²
34,200 m²
BVI66153
€1,100,000
Chillac, Charente
5
4
310 m²
113,151 m²
BVI61920
€392,200
Beauville, Lot-et-Garonne
120 m²
120 m²
BVI65672
€61,000
Saint-Léger-Magnazeix, Haute-Vienne
5
3
229 m²
18,811 m²
BVI61000
€318,000
Montpon-Ménestérol, Dordogne
9
5
430 m²
10,000 m²
BVI65202
€774,819
Brie-sous-Matha, Charente-Maritime
4
2
140 m²
9,590 m²
BVI66186
€299,600
St Aulaye, Dordogne
5
4
194 m²
2,574 m²
BVI66813
€230,000
Issigeac, Dordogne
12
11
640 m²
88,000 m²
BVI66722
€1,800,000
Bellac, Haute-Vienne
4
180 m²
673 m²
BVI65508
