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 08:06:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:06:52') 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:06:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:06:52') 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 08:06:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:06:52') 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:06:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:06:52') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 130 à 172 sur 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 08:06:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:06:52') 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:06:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:06:52') 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 08:06:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:06:52') 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:06:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:06:52') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Maisons à vendre en Charente (16)
Vous cherchez à acheter une maison en Charente ? Que vous souhaitiez acheter une maison de village, ou une maison de campagne, nos agents immobiliers sont prêts à vous accompagner dans vos projets immobiliers. Nous avons des maisons à vendre dans tout le département de la Charente.
Cliquez sur une propriété ci-dessous pour plus de détails ou pour organiser une visite. Vous pouvez également prendre rendez-vous dans nos agences immobilières.
Verneuil, Charente
4
2
144 m²
19,934 m²
BVI75642
€339,200
Villefagnan, Charente
3
2
185 m²
5,339 m²
BVI75851
€256,800
Brie-sous-Barbezieux, Charente
2
1
126 m²
4,296 m²
BVI75014
€194,400
Saint-Angeau, Charente
7
3
398 m²
5,989 m²
BVI75696
€617,100
Saint-Romain, Charente
3
1
92 m²
1,296 m²
BVI75334
€162,000
Chalais, Charente
3
2
189 m²
585 m²
BVI74668
€175,000
Fontenille, Charente
4
2
132 m²
2,355 m²
BVI75808
€256,800
Rouillac, Charente
2
1
75 m²
119 m²
BVI75611
€108,900
Barbezieux-Saint-Hilaire, Charente
3
2
190 m²
3,336 m²
BVI75408
€318,000
Villefagnan, Charente
8
6
453 m²
17,272 m²
BVI72714
€742,000
Chalais, Charente
3
2
181 m²
6,098 m²
BVI75690
€238,000
Villefagnan, Charente
8
2
370 m²
7,330 m²
BVI75432
€499,795
Nanteuil-en-Vallée, Charente
2
2
118 m²
1,100 m²
BVI71914
€135,000
Charmé, Charente
5
2
176 m²
610 m²
BVI74129
€152,820
Abzac, Charente
5
2
170 m²
5,014 m²
BVI75138
€98,450
Confolens, Charente
6
2
178 m²
8,337 m²
BVI72782
€141,700
La Magdeleine, Charente
5
3
216 m²
5,998 m²
BVI75386
€210,600
Paizay-Naudouin-Embourie, Charente
87 m²
318 m²
BVI75412
€75,000
Aubeterre-sur-Dronne, Charente
3
2
150 m²
9,853 m²
BVI73586
€392,200
Mansle-les-fontaines, Charente
4
2
154 m²
8,403 m²
BVI75384
€183,600
Theil-Rabier, Charente
2
1
121 m²
742 m²
BVI75539
€189,000
Chabanais, Charente
3
3
195 m²
6,039 m²
BVI75265
€246,100
Brossac, Charente
3
1
68 m²
767 m²
BVI74029
€88,000
Brossac, Charente
9
4
285 m²
1,365 m²
BVI75445
€395,000
Nanteuil-en-Vallée, Charente
4
2
165 m²
1,303 m²
BVI75269
€319,149
Nanteuil-en-Vallée, Charente
5
4
275 m²
858 m²
BVI75288
€440,000
Aunac, Charente
4
2
229 m²
3,797 m²
BVI73922
€384,780
Val-de-Bonnieure, Charente
3
2
167 m²
472 m²
BVI75358
€206,895
Montmoreau, Charente
3
2
191 m²
4,134 m²
BVI74460
€450,500
Saint-Aulais-la-Chapelle, Charente
2
2
108 m²
6,811 m²
BVI75268
€149,800
Aigre, Charente
3
2
83 m²
40 m²
BVI75330
€132,980
Fleurac, Charente
4
3
210 m²
493 m²
BVI68308
€339,000
Saint-Gourson, Charente
4
2
174 m²
27,213 m²
BVI70370
€174,950
Brossac, Charente
10
5
282 m²
8,116 m²
BVI72238
€449,440
Condac, Charente
3
2
153 m²
1,654 m²
BVI74906
€316,500
Aunac, Charente
3
2
145 m²
1,239 m²
BVI75080
€183,600
Montmoreau, Charente
90 m²
2,500 m²
BVI74959
€77,000
Jarnac, Charente
2
1
326 m²
421 m²
BVI68660
€109,000
Aubeterre-sur-Dronne, Charente
3
2
110 m²
102 m²
BVI73753
€182,500
Barbezieux-Saint-Hilaire, Charente
2
1
130 m²
90 m²
BVI75069
€147,150
Verteuil-sur-Charente, Charente
11
9
399 m²
4,700 m²
BVI70012
€477,000
St Sulpice, Charente
3
121 m²
18,549 m²
BVI74793
€252,300
Chasseneuil-sur-Bonnieure, Charente
6
5
410 m²
4,880 m²
BVI74000
