Array
(
[keyword] =>
[province_combi] =>
[county_combi] =>
[country] =>
[locstate] =>
[province] => Charente
[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`.`province` IN ('charente') 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 05:17:55') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:17:55') 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:17:55') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:17:55') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => Charente [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`.`province` IN ('charente') 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 05:17:55') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:17:55') 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:17:55') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:17:55') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 259 - 301 of 363
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`.`province` IN ('charente') 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 05:17:55') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:17:55') 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:17:55') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:17:55') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => Charente [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`.`province` IN ('charente') 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 05:17:55') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:17:55') 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:17:55') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:17:55') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Property for sale in the Charente
Famed worldwide for its Cognac production, the Charente is second only to Provence for the number of sunshine hours per year. The vines flourish under these conditions and stretch for miles in orderly ranks giving a distinctive look to much of the countryside.
The Charente river flows through the department and the city of Angoulème , which hosts an amazing weekend of classic car racing around the old city ramparts each September, where Bugattis battle it out with Rileys and MGs.
The Vienne river also winds through the Charente department and, along with the many lakes, this makes it an ideal place for anyone who enjoys a leisurely boat ride or any number of water sports.
Other must-see towns include Aubeterre (one of the listed 152 most beautiful villages in France), Cognac itself and La Rochefoucauld with its magnificent chateau.
Looking to buy a property in the Charente? We have houses for sale throughout the department. Click on a property below for more details or to arrange a viewing. You can also meet us at one of our estate agencies in the Charente.
.
Chasseneuil-sur-Bonnieure, Charente
9
3
247 m²
7,262 m²
BVI69059
€299,600
Montmoreau, Charente
11
8
566 m²
6,995 m²
BVI68266
€545,000
Ruffec, Charente
1
161 m²
200 m²
BVI64599
€46,000
Courcôme, Charente
6
3
203 m²
1,210 m²
BVI71429
€256,800
Barbezieux-Saint-Hilaire, Charente
6
3
120 m²
11,608 m²
BVI71092
€371,000
Aubeterre-sur-Dronne, Charente
3
1
133 m²
1,493 m²
BVI71425
€129,000
Aubeterre-sur-Dronne, Charente
3
1
150 m²
238 m²
BVI71252
€249,952
Massignac, Charente
5
6
200 m²
5,615 m²
BVI65499
€449,950
Lignières-Sonneville, Charente
2
1
94 m²
5,061 m²
BVI71320
€190,460
La Faye, Charente
3
1
136 m²
590 m²
BVI69817
€147,150
Angoulême, Charente
6
6
420 m²
5,678 m²
BVI65888
€699,600
Villefagnan, Charente
3
2
136 m²
1,160 m²
BVI71284
€152,600
Blanzac Porcheresse, Charente
2
1
82 m²
7,172 m²
BVI71116
€199,800
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
Verteuil-sur-Charente, Charente
3
1
209 m²
253 m²
BVI71268
€109,000
Barbezieux-Saint-Hilaire, Charente
3
1
107 m²
1,648 m²
BVI71151
€286,200
Nanteuil-en-Vallée, Charente
3
2
119 m²
4,963 m²
BVI71258
€251,450
Villefagnan, Charente
8
3
265 m²
1,753 m²
BVI70807
€152,600
Champagne-Mouton, Charente
5
2
166 m²
4,820 m²
BVI67947
€149,995
Rouillac, Charente
4
3
160 m²
800 m²
BVI70771
€318,000
Ruffec, Charente
2
1
132 m²
2,114 m²
BVI71030
€210,600
Verteuil-sur-Charente, Charente
4
2
152 m²
1,535 m²
BVI70827
€158,050
Mansle-les-fontaines, Charente
5
2
160 m²
1,892 m²
BVI58667
€129,500
Challignac, Charente
3
2
184 m²
3,935 m²
BVI70890
€328,650
Confolens, Charente
4
2
154 m²
1,610 m²
BVI61187
€219,000
Aigre, Charente
7
2
191 m²
2,256 m²
BVI70556
€256,800
Villefagnan, Charente
7
4
482 m²
73,138 m²
BVI69922
€636,000
Saint-Laurent-de-Céris, Charente
4
2
136 m²
2,107 m²
BVI65263
€72,500
Bourg-Charente, Charente
5
1
280 m²
6,192 m²
BVI67712
€304,950
Ruffec, Charente
4
2
154 m²
530 m²
BVI70586
€213,840
Roussines, Charente
3
1
95 m²
459 m²
BVI69949
€59,000
Pillac, Charente
3
1
105 m²
2,478 m²
BVI68982
€213,465
Rouillac, Charente
5
4
341 m²
2,020 m²
BVI65041
€599,000
Ruffec, Charente
2
1
87 m²
87 m²
BVI70205
€77,000
Verdille, Charente
3
2
220 m²
6,943 m²
BVI68761
€256,800
Jarnac, Charente
3
2
177 m²
2,036 m²
BVI69552
€280,900
Villiers-le-Roux, Charente
3
2
151 m²
3,901 m²
BVI69763
€141,700
Villefagnan, Charente
5
2
234 m²
1,792 m²
BVI69406
€355,100
Villebois-Lavalette, Charente
3
1
97 m²
840 m²
BVI69026
€99,000
Montjean, Charente
3
4
202 m²
1,464 m²
BVI69695
€256,800
Chalais, Charente
3
1
170 m²
1,392 m²
BVI69480
€199,800
Alloue, Charente
8
8
405 m²
8,132 m²
BVI68984
