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 05:22:31') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:22:31') 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:22:31') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:22:31') 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 05:22:31') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:22:31') 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:22:31') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:22:31') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 173 - 211 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 05:22:31') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:22:31') 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:22:31') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:22:31') 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 05:22:31') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 05:22:31') 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:22:31') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 05:22:31') 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.
Brigueil-le-Chantre, Vienne
3
1
112 m²
7,862 m²
BVI65331
€172,800
Charroux, Vienne
10
6
233 m²
3,138 m²
BVI69100
€392,200
Savigné, Vienne
4
2
229 m²
662 m²
BVI67357
€187,500
Montmorillon, Vienne
6
5
326 m²
421 m²
BVI68398
€382,000
Charroux, Vienne
9
9
540 m²
148,265 m²
BVI68781
€650,000
La Trimouille, Vienne
6
4
313 m²
1,140,313 m²
BVI65115
€1,579,000
Moulismes, Vienne
7
7
250 m²
262 m²
BVI68610
€71,500
Haims, Vienne
1
1
60 m²
1,217 m²
BVI68293
€34,000
Charroux, Vienne
3
2
107 m²
2,708 m²
BVI67967
€130,800
Charroux, Vienne
4
2
110 m²
168 m²
BVI68260
€119,900
L’Isle-Jourdain, Vienne
4
1
146 m²
45,154 m²
BVI66444
€250,000
Antigny, Vienne
4
1
157 m²
1,282 m²
BVI67413
€142,790
Lizant, Vienne
3
1
146 m²
2,525 m²
BVI65856
€214,000
Couhé, Vienne
5
2
248 m²
297 m²
BVI67750
€306,020
Civray, Vienne
3
1
90 m²
62 m²
BVI67271
€77,000
Montmorillon, Vienne
3
2
125 m²
111 m²
BVI67816
€77,000
Charroux, Vienne
3
1
86 m²
306 m²
BVI67537
€79,992
Montmorillon, Vienne
2
1
72 m²
355 m²
BVI67142
€129,710
Civray, Vienne
9
8
850 m²
2,130 m²
BVI65942
€787,500
Charroux, Vienne
165 m²
360 m²
BVI65791
€56,000
Brigueil-le-Chantre, Vienne
1
1
89 m²
680 m²
BVI65971
€55,000
Lizant, Vienne
3
2
131 m²
4,751 m²
BVI65828
€371,000
Surin, Vienne
3
90 m²
1,756 m²
BVI65730
€99,000
Persac, Vienne
5
3
227 m²
13,788 m²
BVI65589
€249,995
Montmorillon, Vienne
2150 m²
BVI65090
€46,000
Charroux, Vienne
2
1
53 m²
205 m²
BVI64564
€56,000
Lizant, Vienne
2
1
80 m²
198 m²
BVI61563
€88,000
Pressac, Vienne
6
2
290 m²
1,308 m²
BVI63573
€306,020
Thollet, Vienne
4
1
113 m²
2,023 m²
BVI64289
€66,666
Saint-Martin-l’Ars, Vienne
4
3
207 m²
3,210 m²
BVI64383
€265,000
La Trimouille, Vienne
2
2
86 m²
1,265 m²
BVI62391
€66,700
Bourg-Archambault, Vienne
2
1
105 m²
417 m²
BVI60658
€36,000
L’Isle-Jourdain, Vienne
3
1
844 m²
BVI61587
€69,300
Pressac, Vienne
5
3
243 m²
19,398 m²
BVI59986
€240,750
Chatain, Vienne
1
30 m²
633 m²
BVI58110
€23,000
Luchapt, Vienne
3
2
136 m²
1,955 m²
BVI58017
€142,857
Civray, Vienne
3
3
54 m²
4,863 m²
BVI29306
€478,750
Châtellerault, Vienne
7
1
610 m²
42,825 m²
BVI23745
€695,000
Voulême, Vienne
5
4
244 m²
772 m²
BVI65768
