Array
(
[keyword] =>
[province_combi] =>
[county_combi] =>
[country] =>
[locstate] =>
[province] => Vienne
[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 ('vienne') 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:58:01') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:58:01') 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:58:01') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:58:01') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => Vienne [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 ('vienne') 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:58:01') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:58:01') 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:58:01') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:58:01') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 87 - 129 of 211
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 ('vienne') 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:58:01') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:58:01') 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:58:01') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:58:01') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => Vienne [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 ('vienne') 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:58:01') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:58:01') 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:58:01') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:58:01') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Property for sale in the Vienne
One of the four departments that make up the Poitou Charentes region of France, the Vienne was once home to Eleanor of Aquitaine (wife of Henry II) and was a key site during the 100 Years War.
Buy a property in this pretty farming area and discover a more leisurely and peaceful way of life amidst fields of corn and sunflowers. The Vienne river meanders through and there are many attractions that make this a great area whether you are looking for a holiday home or permanent residence.
The Vallée des Singes (a monkey park), Futuroscope (a science theme park), golf courses, boating, fishing and numerous pretty towns and villages to visit will guarantee something for everyone and every interest.
Be sure to try the local wines and the AOC goat cheese!
Looking to buy a property in the Vienne? 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.
Montmorillon, Vienne
5
2
152 m²
700 m²
BVI74838
€205,440
Charroux, Vienne
4
3
258 m²
9,719 m²
BVI71008
€318,000
Charroux, Vienne
7
5
390 m²
5,578 m²
BVI74531
€477,000
Saint-Léomer, Vienne
1
1
38 m²
212 m²
BVI74904
€35,000
Civray, Vienne
4
2
315 m²
1,619 m²
BVI74658
€319,150
Thollet, Vienne
2
1
63 m²
9,669 m²
BVI73560
€99,000
Saint-Savin, Vienne
2
93 m²
67 m²
BVI74443
€36,000
Montmorillon, Vienne
3
1
110 m²
2,122 m²
BVI74423
€82,500
La Chapelle-Bâton, Vienne
5
2
233 m²
12,065 m²
BVI74148
€272,850
Mauprévoir, Vienne
3
2
124 m²
1,789 m²
BVI64565
€121,000
Lizant, Vienne
4
3
366 m²
5,438 m²
BVI70273
€446,250
Civray, Vienne
3
2
388 m²
518 m²
BVI70776
€246,100
Brigueil-le-Chantre, Vienne
3
2
173 m²
2,055 m²
BVI73401
€196,560
Liglet, Vienne
3
2
135 m²
6,567 m²
BVI74128
€175,000
Brux, Vienne
1
1
75 m²
2,027 m²
BVI74117
€82,500
Savigné, Vienne
44 m²
1,267 m²
BVI65271
€41,000
Coulonges, Vienne
3
1
145 m²
809 m²
BVI74002
€98,000
Lathus St Remy, Vienne
3
1
98 m²
503 m²
BVI19103
€119,900
Saint-Léomer, Vienne
3
2
98 m²
1,223 m²
BVI66294
€51,000
Montmorillon, Vienne
3
3
232 m²
12,607 m²
BVI73693
€172,800
Coulonges, Vienne
3
2
96 m²
4,279 m²
BVI73506
€155,000
Liglet, Vienne
3
2
100 m²
113 m²
BVI73571
€66,000
Montmorillon, Vienne
1
1
47 m²
36 m²
BVI72321
€27,000
Haims, Vienne
5
2
165 m²
28,430 m²
BVI73382
€215,000
Saint-Romain, Vienne
3
1
125 m²
451 m²
BVI73146
€48,600
Lathus St Remy, Vienne
2
2
187 m²
680 m²
BVI72975
€61,000
Chaunay, Vienne
3
1
160 m²
1,499 m²
BVI73265
€185,760
Saint-Savin, Vienne
6
4
391 m²
4,615 m²
BVI72827
€519,400
Charroux, Vienne
4
2
183 m²
1,338 m²
BVI73080
€185,000
Thollet, Vienne
4
1
80 m²
699 m²
BVI72280
€109,000
Montmorillon, Vienne
1
1
47 m²
181 m²
BVI72998
€61,000
L’Isle-Jourdain, Vienne
8
8
549 m²
399,641 m²
BVI73111
€2,205,000
Voulême, Vienne
4
2
212 m²
1,360 m²
BVI72960
€194,400
Chatain, Vienne
2
3
95 m²
1,020 m²
BVI72175
€149,500
La Trimouille, Vienne
3
2
88 m²
329 m²
BVI72822
€66,000
Coulonges, Vienne
3
1
90 m²
312 m²
BVI71676
€112,350
Chauvigny, Vienne
3
2
125 m²
2,072 m²
BVI72786
€205,200
Nérignac, Vienne
3
1
75 m²
5,361 m²
BVI64449
€93,500
Lussac-les-Châteaux, Vienne
1
1
56 m²
1,497 m²
BVI70038
€26,000
Coulonges, Vienne
5
3
223 m²
223 m²
BVI72769
€55,000
Montmorillon, Vienne
3
141 m²
892 m²
BVI72785
€36,000
Civray, Vienne
3
2
101 m²
188 m²
BVI72685
€92,000
Vicq-sur-Gartempe, Vienne
3
2
122 m²
1,309 m²
BVI72519
