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 04:53:45') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:53:45') 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 04:53:45') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:53:45') 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 04:53:45') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:53:45') 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 04:53:45') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:53:45') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 87 - 129 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 04:53:45') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:53:45') 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 04:53:45') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:53:45') 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 04:53:45') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:53:45') 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 04:53:45') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:53:45') 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.
.
Curac, Charente
2570 m²
BVI76240
€28,000
Beaulieu-sur-Sonnette, Charente
2
1
70 m²
350 m²
BVI76322
€88,000
Val-d’Auge, Charente
5
2,245 m²
BVI76136
€214,000
Pillac, Charente
1
1
71 m²
513 m²
BVI75609
€120,875
Cherves-Châtelars, Charente
3
2
120 m²
5,532 m²
BVI76065
€225,000
Rouillac, Charente
11
9
500 m²
4,245 m²
BVI75626
€975,000
Barbezieux-Saint-Hilaire, Charente
3
1
117 m²
965 m²
BVI76235
€233,200
Chalais, Charente
2
1
200 m²
775 m²
BVI76176
€95,000
Berneuil, Charente
938 m²
BVI76344
€20,000
Berneuil, Charente
872 m²
BVI75847
€20,000
Bioussac, Charente
4
2
202 m²
23,402 m²
BVI76186
€328,600
Taizé-Aizie, Charente
1980 m²
BVI76269
€17,000
Saint-Vallier, Charente
3
1
90 m²
2,137 m²
BVI71107
€141,150
Le Lindois, Charente
5
5
250 m²
942 m²
BVI75295
€178,200
Barbezieux-Saint-Hilaire, Charente
4
1
194 m²
1,445 m²
BVI76245
€212,000
Chalais, Charente
3
1
127 m²
14,588 m²
BVI76241
€267,500
Saint-Romain, Charente
4
2
130 m²
5,160 m²
BVI20607
€225,000
Pressignac, Charente
15
7
636 m²
29,420 m²
BVI75615
€795,000
Champagne-Mouton, Charente
8
4
303 m²
2,670 m²
BVI75887
€318,000
Nanteuil-en-Vallée, Charente
4
2
235 m²
3,321 m²
BVI75745
€162,000
Montbron, Charente
3
2
136 m²
126 m²
BVI76196
€95,000
Mansle-les-fontaines, Charente
4
2
250 m²
1,860 m²
BVI76177
€328,600
Aubeterre-sur-Dronne, Charente
3
3
220 m²
10,541 m²
BVI69714
€449,000
Montjean, Charente
4
2
203 m²
5,723 m²
BVI75414
€278,200
Nanteuil-en-Vallée, Charente
4
3
198 m²
443 m²
BVI75402
€318,000
Brossac, Charente
5
1
192 m²
2,370 m²
BVI76167
€298,530
Verteuil-sur-Charente, Charente
2
1
104 m²
1,168 m²
BVI75960
€183,600
Barbezieux-Saint-Hilaire, Charente
3
1
83 m²
641 m²
BVI76057
€213,000
Poullignac, Charente
3
1
146 m²
2,594 m²
BVI71173
€215,000
Abzac, Charente
3
3
116 m²
168 m²
BVI76181
€91,700
Nanteuil-en-Vallée, Charente
3
2
179 m²
1,380 m²
BVI76150
€219,350
Chalais, Charente
3
2
137 m²
1,377 m²
BVI76076
€219,350
Aubeterre-sur-Dronne, Charente
4
3
164 m²
4,666 m²
BVI75619
€455,800
Rouillac, Charente
3
1
160 m²
8,720 m²
BVI76131
€330,000
Ruffec, Charente
5
2
226 m²
2,581 m²
BVI75811
€318,000
Mansle-les-fontaines, Charente
4
2
207 m²
865 m²
BVI74786
€325,000
Tusson, Charente
3
2
145 m²
2,131 m²
BVI75425
€214,000
Baignes-Sainte-Radegonde, Charente
3
1
93 m²
1,327 m²
BVI71568
€98,100
Saint-Séverin, Charente
7
2
278 m²
3,820 m²
BVI75013
€278,200
Aigre, Charente
4
3
194 m²
873 m²
BVI73032
€215,000
Écuras, Charente
3
3
210 m²
33,159 m²
BVI75729
€265,000
Manot, Charente
5
3
170 m²
19,645 m²
BVI75204
€215,000
Nanteuil-en-Vallée, Charente
3
2
124 m²
1,954 m²
BVI67281
