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 01:55:37') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 01:55:37') 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 01:55:37') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 01:55:37') 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 01:55:37') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 01:55:37') 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 01:55:37') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 01:55:37') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 1 - 43 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 01:55:37') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 01:55:37') 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 01:55:37') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 01:55:37') 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 01:55:37') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 01:55:37') 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 01:55:37') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 01:55:37') 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.
.
Confolens, Charente
2
1
85 m²
11,854 m²
BVI76009
€120,880
Aubeterre-sur-Dronne, Charente
5
4
166 m²
2,180 m²
BVI77727
€640,000
Saint-Angeau, Charente
4
2
155 m²
13,676 m²
BVI72758
€299,600
Segonzac, Charente
4
2
224 m²
4,596 m²
BVI71043
€549,000
Jarnac, Charente
3
3
198 m²
1,210 m²
BVI72934
€299,000
Cherves-Richemont, Charente
3
1
130 m²
3,122 m²
BVI71492
€320,000
Condéon, Charente
3
1
100 m²
900 m²
BVI72473
€259,900
Brossac, Charente
3
3
213 m²
8,690 m²
BVI77331
€296,800
Jarnac, Charente
4
2
204 m²
3,369 m²
BVI76692
€575,000
Segonzac, Charente
4
2
240 m²
2,350 m²
BVI77240
€371,000
Barbezieux-Saint-Hilaire, Charente
1
77 m²
236 m²
BVI77140
€113,400
Cognac, Charente
4
1
217 m²
2,468 m²
BVI76654
€292,000
Chalais, Charente
6
2
216 m²
1,979 m²
BVI77439
€330,000
Pleuville, Charente
2
1
126 m²
1,490 m²
BVI69567
€189,999
Chalais, Charente
5
3
262 m²
587 m²
BVI69317
€328,600
Nanteuil-en-Vallée, Charente
3
2
177 m²
6,564 m²
BVI70849
€395,000
Villefagnan, Charente
2
1
135 m²
990 m²
BVI77205
€145,000
Barbezieux-Saint-Hilaire, Charente
5
3
1803 m²
1,854 m²
BVI76930
€525,000
Barbezieux-Saint-Hilaire, Charente
3
1
99 m²
917 m²
BVI77264
€233,200
Brillac, Charente
5
2
300 m²
4,020 m²
BVI75275
€205,000
Ruffec, Charente
4
2
295 m²
802 m²
BVI75166
€352,450
Réparsac, Charente
3
3
196 m²
790 m²
BVI77139
€319,000
Rouillac, Charente
3
2
211 m²
2,442 m²
BVI71521
€349,999
Brie, Charente
4
2
178 m²
1,549 m²
BVI77410
€390,350
Souvigné, Charente
3
1
117 m²
943 m²
BVI73405
€77,000
Salles-Lavalette, Charente
5
2
170 m²
1,520 m²
BVI76902
€267,500
Manot, Charente
4
2
112 m²
135 m²
BVI74429
€85,000
Aubeterre-sur-Dronne, Charente
2
1
114 m²
2,767 m²
BVI76564
€99,000
Ruffec, Charente
1
1
64 m²
100 m²
BVI73455
€43,200
Salles-Lavalette, Charente
3
2
200 m²
322 m²
BVI76850
€119,900
Saint-Séverin, Charente
3
1
90 m²
5,520 m²
BVI77122
€246,100
Ranville-Breuillaud, Charente
5
1
170 m²
1,198 m²
BVI75446
€130,800
Villebois-Lavalette, Charente
6
6
350 m²
7,990 m²
BVI76879
€580,000
Pillac, Charente
3
2
90 m²
1,999 m²
BVI76980
€198,000
Saint-Claud, Charente
4
2
201 m²
2,215 m²
BVI76666
€235,400
Champagne-Mouton, Charente
8
8
446 m²
1,902 m²
BVI77248
€439,900
Brossac, Charente
3
2
69 m²
890 m²
BVI76774
€137,250
Roumazières-Loubert, Charente
3
3
140 m²
115,136 m²
BVI76969
€530,000
Montjean, Charente
3
2
110 m²
773 m²
BVI76729
€149,800
Montmoreau, Charente
3
1
155 m²
4,398 m²
BVI77057
€283,550
Tusson, Charente
1
1
52 m²
95 m²
BVI74479
€66,000
Aubeterre-sur-Dronne, Charente
2
1
51 m²
969 m²
BVI73717
€115,000
Lesterps, Charente
3
2
158 m²
44,748 m²
BVI77009
