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:03:05') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:03:05') 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:03:05') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:03:05') 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:03:05') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:03:05') 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:03:05') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:03:05') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 44 - 86 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:03:05') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:03:05') 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:03:05') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:03:05') 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:03:05') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:03:05') 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:03:05') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:03:05') 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.
.
Barro, Charente
3
1
103 m²
3,202 m²
BVI70721
€162,000
Ventouse, Charente
5
3
279 m²
15,029 m²
BVI76918
€497,200
Villefagnan, Charente
3
1
133 m²
1,080 m²
BVI77078
€165,000
Jarnac, Charente
3
1
80 m²
107 m²
BVI77068
€184,800
Challignac, Charente
7
4
291 m²
6,557 m²
BVI67007
€397,500
Barbezieux-Saint-Hilaire, Charente
3
1
124 m²
366 m²
BVI76385
€243,800
Chalais, Charente
11
12
423 m²
40,242 m²
BVI66164
€899,900
Courbillac, Charente
3
3
167 m²
3,334 m²
BVI75997
€380,000
Saint-Séverin, Charente
4
2
114 m²
307 m²
BVI76142
€130,800
Vieux-Ruffec, Charente
8
3
260 m²
8,728 m²
BVI75396
€638,300
Ruffec, Charente
3
1
133 m²
2,562 m²
BVI75782
€214,000
Chillac, Charente
5
3
169 m²
4,336 m²
BVI76828
€299,600
Blanzac Porcheresse, Charente
5
2
284 m²
24,435 m²
BVI76810
€499,700
Montignac-le-Coq, Charente
3
2
152 m²
5,716 m²
BVI76855
€267,500
Mérignac, Charente
4
2
153 m²
2,953 m²
BVI75991
€350,000
Épenède, Charente
1
1
42 m²
580 m²
BVI76829
€46,000
Montmoreau, Charente
4
2
200 m²
13,055 m²
BVI76529
€310,300
Aigre, Charente
1
2
100 m²
66 m²
BVI71404
€21,000
Verteuil-sur-Charente, Charente
2
1
107 m²
137 m²
BVI76753
€158,050
Cognac, Charente
5
6
358 m²
3,506 m²
BVI76185
€545,000
Beaulieu-sur-Sonnette, Charente
3
2
186 m²
809 m²
BVI76488
€245,000
Palluaud, Charente
4
2
201 m²
15,407 m²
BVI74534
€199,000
Jarnac, Charente
6
2
237 m²
260 m²
BVI76519
€228,975
Bassac, Charente
4
2
150 m²
1,200 m²
BVI76309
€170,400
Chalais, Charente
5
2
169 m²
2,400 m²
BVI75750
€258,100
Saint-Séverin, Charente
4
2
170 m²
2,641 m²
BVI75015
€246,100
Nanteuil-en-Vallée, Charente
4
3
171 m²
2,690 m²
BVI60811
€349,900
Charras, Charente
2
1
68 m²
58,056 m²
BVI74522
€135,000
Chalais, Charente
4
2
179 m²
3,641 m²
BVI76207
€280,000
Bonnes, Charente
5730 m²
BVI76044
€50,000
Brossac, Charente
5
4
329 m²
8,885 m²
BVI73942
€380,000
Sainte-Sévère, Charente
4
2
300 m²
2,494 m²
BVI73726
€397,500
Chabanais, Charente
5
2
340 m²
26,925 m²
BVI76225
€499,900
Marthon, Charente
5
5
381 m²
7,290 m²
BVI74699
€495,000
Montignac-le-Coq, Charente
3
2
99 m²
3,090 m²
BVI75701
€155,000
Barbezieux-Saint-Hilaire, Charente
3
1
168 m²
2,846 m²
BVI76262
€197,950
Chalais, Charente
3
3
193 m²
3,467 m²
BVI75659
€195,700
Jarnac, Charente
5
3
238 m²
849 m²
BVI75716
€585,000
Brie, Charente
3
2
100 m²
1,502 m²
BVI76430
€235,400
Montbron, Charente
2
1
120 m²
1,894 m²
BVI67795
€162,000
Aubeterre-sur-Dronne, Charente
3
2
126 m²
3,900 m²
BVI76476
€214,000
Yviers, Charente
4
2
176 m²
3,700 m²
BVI76434
€250,000
Jarnac, Charente
10
7
798 m²
23,250 m²
BVI70783
