Array
(
[keyword] =>
[province_combi] =>
[county_combi] =>
[country] =>
[locstate] =>
[province] => Deux-Sèvres
[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 ('deux-sèvres') 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:50:33') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:50:33') 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:50:33') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:50:33') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => Deux-Sèvres [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 ('deux-sèvres') 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:50:33') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:50:33') 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:50:33') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:50:33') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 44 - 86 of 106
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 ('deux-sèvres') 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:50:33') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:50:33') 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:50:33') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:50:33') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => Deux-Sèvres [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 ('deux-sèvres') 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:50:33') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:50:33') 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:50:33') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:50:33') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Property for sale in the Deux-Sèvres
One of the four departments that make up the Poitou Charentes region of France, and one of the 87 departments created after the French Revolution, Deux Sévres is slightly more off the beaten track than its neighbours.
In the south west of the Deux Sèvres you find the Marais Poitevin (literally, the Poitou Marsh), an immense network of natural and manmade water channels through a fenland landscape that offers possibilities for walking, boating, fishing or just kicking back and enjoying the green and leafy surroundings. Nature-lovers searching for their dream French property to buy will find their niche here with kingfishers, herons, deer and coypu to be spied. Elsewhere in Deux Sèvres the landscape is mostly agricultural and time turns slowly to the rhythm of the farming year.
Looking to buy a property in the Deux-Sèvres? We have houses for sale throughout the department. Click on a property below for more details or to arrange a viewing.
Saint-Varent, Deux-Sèvres
3
1
79 m²
415 m²
BVI75132
€56,000
Sauzé-Vaussais, Deux-Sèvres
3
181 m²
5,869 m²
BVI74464
€77,000
Sauzé-Vaussais, Deux-Sèvres
3
290 m²
765 m²
BVI74551
€36,000
Saint-Aubin-le-Cloud, Deux-Sèvres
6
5
375 m²
7,388 m²
BVI75073
€484,640
Pers, Deux-Sèvres
8
6
350 m²
4,778 m²
BVI63269
€349,500
Parthenay, Deux-Sèvres
35485 m²
BVI74806
€370,000
Parthenay, Deux-Sèvres
7
7
860 m²
93,500 m²
BVI72820
€1,278,000
Loubillé, Deux-Sèvres
3
2
236 m²
1,041 m²
BVI74014
€149,950
Lezay, Deux-Sèvres
4
3
178 m²
5,184 m²
BVI72339
€235,400
Marnes, Deux-Sèvres
3
2
181 m²
4,081 m²
BVI74489
€177,000
Maisontiers, Deux-Sèvres
1
1
164 m²
945 m²
BVI73573
€210,000
La Mothe-Saint-Héray, Deux-Sèvres
7
6
270 m²
1,340 m²
BVI64078
€249,500
Vanzay, Deux-Sèvres
3
2
189 m²
1,563 m²
BVI72289
€239,784
Sauzé-Vaussais, Deux-Sèvres
2
1
70 m²
4,040 m²
BVI74447
€147,150
Gournay-Loizé, Deux-Sèvres
3
2
135 m²
1,020 m²
BVI72188
€235,400
Chef-Boutonne, Deux-Sèvres
6
6
360 m²
1,405 m²
BVI69827
€371,000
Clussais-la-Pommeraie, Deux-Sèvres
3
2
204 m²
1,420 m²
BVI65762
€270,300
Clussais-la-Pommeraie, Deux-Sèvres
3
1
153 m²
1,914 m²
BVI73945
€194,500
Hanc, Deux-Sèvres
2
2
110 m²
1,000 m²
BVI73917
€194,400
Valdelaume, Deux-Sèvres
2
1
87 m²
375 m²
BVI69530
€61,000
Sauzé-Vaussais, Deux-Sèvres
3
3
132 m²
565 m²
BVI73303
€179,000
Caunay, Deux-Sèvres
4
3
191 m²
1,450 m²
BVI73366
€289,000
Secondigny, Deux-Sèvres
2
1
583 m²
583 m²
BVI73400
€79,750
Hanc, Deux-Sèvres
3
4
324 m²
3,077 m²
BVI72918
€246,100
Secondigny, Deux-Sèvres
3
2
120 m²
21,352 m²
BVI72823
€365,700
Thouars, Deux-Sèvres
1
125 m²
31,707 m²
BVI57873
€1,164,000
Limalonges, Deux-Sèvres
3
2
175 m²
3,516 m²
BVI72465
€152,600
Chef-Boutonne, Deux-Sèvres
3
1
115 m²
3,615 m²
BVI71831
€194,400
Loubillé, Deux-Sèvres
1
1
48 m²
2,090 m²
BVI71848
€35,000
Faye-l’Abbesse, Deux-Sèvres
7
5
211 m²
9,339 m²
BVI68127
€424,000
Lezay, Deux-Sèvres
3
2
130 m²
1,009 m²
BVI68925
€130,000
Niort, Deux-Sèvres
9
7
667 m²
63,227 m²
BVI59919
€1,365,000
Argentonnay, Deux-Sèvres
1
78 m²
1,803 m²
BVI71178
€59,950
Moncoutant, Deux-Sèvres
4
3
197 m²
2,916 m²
BVI71211
€172,800
Paizay-le-Chapt, Deux-Sèvres
4
3
266 m²
791 m²
BVI71033
€349,950
Chef-Boutonne, Deux-Sèvres
3
2
109 m²
110 m²
BVI70947
€93,500
Parthenay, Deux-Sèvres
25
3
1837 m²
199,621 m²
BVI67552
€1,264,000
Sauzé-Vaussais, Deux-Sèvres
6
3
540 m²
4,157 m²
BVI70670
€167,400
Clussais-la-Pommeraie, Deux-Sèvres
2
2
135 m²
2,847 m²
BVI70297
€172,800
Airvault, Deux-Sèvres
9
8
442 m²
4,694 m²
BVI67332
€820,000
Argentonnay, Deux-Sèvres
8
3
315 m²
2,400 m²
BVI67912
€344,500
Valdelaume, Deux-Sèvres
3
1
159 m²
2,563 m²
BVI69643
€178,200
Loubillé, Deux-Sèvres
7
2
272 m²
688 m²
BVI61474
