Array
(
[keyword] =>
[province_combi] =>
[county_combi] =>
[country] =>
[locstate] =>
[province] => Charente-Maritime
[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] =>
[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-maritime') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 08:02:55') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:02: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 08:02:55') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:02: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-Maritime [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] => [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-maritime') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 08:02:55') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:02: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 08:02:55') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:02:55') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 1 - 43 of 105
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-maritime') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 08:02:55') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:02: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 08:02:55') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:02: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-Maritime [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] => [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-maritime') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 08:02:55') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:02: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 08:02:55') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:02:55') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Property for sale in Charente-Maritime
The only part of the Poitou Charente region to enjoy a coastline, the Charente Martime benefits from the resulting mild winters. This micro-climate (officially sub-mediterranean!) means that olives, mimosa, palms and oleander flourish, and those buying a property here will appreciate the effect, too!
The coastal landscape varies widely, from open grassy plains where the local cattle graze to wild salt marshes and tall limestone cliffs.
This is where the mighty Gironde river makes its way into the Atlantic and the mouth of the river is dotted with charming little ports and harbours which retain a truly French feel. This is a popular place with the french looking to buy a second home.
Local produce including the aperitif Pineau (a blend of cognac and grape juice) is a must-try along with the locally produced caviar. Worth a look are Mortagne-sur-Gironde, Saintes for its Roman architecture and Royan - a lovely, busy harbour town with a great zoo neaby at La Palmyre.
Looking to buy a property in the Charente-Maritime? 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.
.
Saint-Sauvant, Charente-Maritime
2
1
122 m²
250 m²
BVI77219
€235,000
Montguyon, Charente-Maritime
4
3
162 m²
972 m²
BVI69052
€325,000
Loulay, Charente-Maritime
2
2
51 m²
100 m²
BVI74419
€77,800
Jonzac, Charente-Maritime
243 m²
210 m²
BVI76958
€197,950
Messac, Charente-Maritime
3
1
183 m²
11,850 m²
BVI76907
€318,000
Tonnay-Boutonne, Charente-Maritime
6
4
227 m²
1,735 m²
BVI76811
€400,000
Léoville, Charente-Maritime
5
3
206 m²
1,434 m²
BVI77357
€299,250
Montguyon, Charente-Maritime
4
2
132 m²
2,711 m²
BVI75985
€274,000
Saint-Jean-d’Angély, Charente-Maritime
4
2
158 m²
778 m²
BVI73336
€205,200
Dœuil-sur-le-Mignon, Charente-Maritime
480 m²
BVI76917
€27,000
Rioux, Charente-Maritime
7
3
310 m²
1,335 m²
BVI71291
€318,000
Paillé, Charente-Maritime
5
2
304 m²
2,314 m²
BVI76933
€230,000
Saint-Bonnet-sur-Gironde, Charente-Maritime
5
2
264 m²
911 m²
BVI76166
€285,000
Saint-Jean-d’Angély, Charente-Maritime
3
2
139 m²
340 m²
BVI76921
€182,000
Saint-Thomas-de-Conac, Charente-Maritime
6
3
318 m²
9,835 m²
BVI76704
€795,000
Jonzac, Charente-Maritime
3
1
106 m²
858 m²
BVI76727
€165,000
Jonzac, Charente-Maritime
5
2
148 m²
661 m²
BVI65804
€225,000
Néré, Charente-Maritime
3
1
148 m²
1,322 m²
BVI60713
€150,420
Saint-Genis-de-Saintonge, Charente-Maritime
3
1
113 m²
173 m²
BVI76331
€137,500
Aumagne, Charente-Maritime
3
4
248 m²
1,105 m²
BVI76380
€379,480
Mirambeau, Charente-Maritime
3
1
124 m²
363 m²
BVI60242
€95,000
Sainte-Lheurine, Charente-Maritime
7
1
177 m²
7,798 m²
BVI74852
€172,800
Brizambourg, Charente-Maritime
3
2
170 m²
1,298 m²
BVI76117
€299,600
Montendre, Charente-Maritime
5
4
126 m²
65,722 m²
BVI75844
€472,500
Jonzac, Charente-Maritime
5
2
279 m²
220 m²
BVI69961
€350,000
Bresdon, Charente-Maritime
4
4
219 m²
891 m²
BVI75001
€345,000
Cressé, Charente-Maritime
5
2
195 m²
2,462 m²
BVI75538
€295,000
Pons, Charente-Maritime
5
1
214 m²
1,770 m²
BVI75387
€198,000
Brie-sous-Matha, Charente-Maritime
3
3
212 m²
2,046 m²
BVI71456
€299,000
Macqueville, Charente-Maritime
4
2
180 m²
4,357 m²
BVI75135
€383,000
Jonzac, Charente-Maritime
3
2
228 m²
9,877 m²
BVI69452
€434,600
Jonzac, Charente-Maritime
5
3
216 m²
1,755 m²
BVI75320
€381,600
Pons, Charente-Maritime
6
4
227 m²
17,616 m²
BVI75032
€498,200
Jonzac, Charente-Maritime
2
1
89 m²
1,080 m²
BVI74402
€167,400
Vervant, Charente-Maritime
4
1
148 m²
866 m²
BVI75332
€286,760
Chamouillac, Charente-Maritime
3
1
89 m²
3,004 m²
BVI75305
€199,800
Mirambeau, Charente-Maritime
3
1
111 m²
746 m²
BVI74953
€130,000
Jonzac, Charente-Maritime
3
1
132 m²
2,454 m²
BVI74964
€299,600
Bresdon, Charente-Maritime
4
3
220 m²
955 m²
BVI74735
€299,999
Léoville, Charente-Maritime
3
2
163 m²
2,431 m²
BVI74656
€299,600
Cherbonnières, Charente-Maritime
713 m²
BVI74815
€20,950
Sainte-Colombe, Charente-Maritime
2098 m²
BVI73947
€51,000
Sainte-Colombe, Charente-Maritime
1997 m²
BVI74377
