Array
(
[keyword] =>
[province_combi] =>
[county_combi] =>
[country] =>
[locstate] =>
[province] =>
[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] => 5
)
[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`.`stype` IN ('5') 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:09:25') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:09:25') 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:09:25') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:09:25') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => [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] => 5 ) [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`.`stype` IN ('5') 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:09:25') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:09:25') 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:09:25') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:09:25') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 130 à 172 sur 257
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`.`stype` IN ('5') 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:09:25') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:09:25') 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:09:25') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:09:25') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => [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] => 5 ) [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`.`stype` IN ('5') 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:09:25') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 08:09:25') 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:09:25') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 08:09:25') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Biens que nous avons vendus
Au cours d'une année, nous vendons une grande variété de biens, des maisons individuelles aux complexes de gîtes et aux châteaux. Chacune d'entre elles bénéficie d'un marketing de qualité sur notre propre site web primé et sur les portails immobiliers.
Vous souhaitez vendre votre bien ? Voyez ce que l’on peut faire pour vous.
Vendre mon bien
Nanteuil-en-Vallée, Charente
1
1
85 m²
454 m²
BVI63342
€77,000
Sainte-Foy-la-Grande, Gironde
5
3
220 m²
11,314 m²
BVI65362
€575,000
Daglan, Dordogne
4
1
120 m²
7,117 m²
BVI72726
€340,425
Civray, Vienne
3
2
101 m²
188 m²
BVI72685
€92,000
Tocane-Saint-Apre, Dordogne
2
2
71 m²
1,818 m²
BVI71615
€61,000
Alloue, Charente
6
2
284 m²
3,359 m²
BVI64429
€535,000
Monflanquin, Lot-et-Garonne
2
2
95 m²
95 m²
BVI72420
€184,900
Lussac-les-Églises, Haute-Vienne
1
1
68 m²
10,077 m²
BVI72612
€54,000
Villefagnan, Charente
2
2
104 m²
1,450 m²
BVI72223
€167,400
Massignac, Charente
3
3
196 m²
3,243 m²
BVI72611
€328,600
Villebois-Lavalette, Charente
5
2
260 m²
3,206 m²
BVI72475
€397,500
Mézières-sur-Issoire, Haute-Vienne
2
1
69 m²
65 m²
BVI66993
€58,000
Saint-Estèphe, Dordogne
2
2
101 m²
11,267 m²
BVI72241
€178,200
Rancon, Haute-Vienne
3
1
119 m²
1,083 m²
BVI72372
€159,000
Montbron, Charente
2
2
108 m²
108 m²
BVI72329
€136,250
Quillan, Aude
4
2
153 m²
8,839 m²
BVI64519
€275,000
Rouffiac, Charente-Maritime
5
2
207 m²
2,452 m²
BVI72049
€299,000
Limoux, Aude
4
3
155 m²
114 m²
BVI72155
€165,000
Chabanais, Charente
2
1
95 m²
75 m²
BVI72123
€50,000
Saint-Front-la-Rivière, Dordogne
6
5
182 m²
3,841 m²
BVI70760
€280,000
Nalliers, Vienne
3
2
105 m²
505 m²
BVI72079
€77,000
Saint-Quantin-de-Rancanne, Charente-Maritime
3
1
93 m²
740 m²
BVI72193
€175,000
Bouteilles St Sebastien, Dordogne
3
3
137 m²
5,483 m²
BVI72086
€236,500
Barbezieux-Saint-Hilaire, Charente
4
1
88 m²
837 m²
BVI65424
€159,840
Ribérac, Dordogne
5
6
271 m²
292 m²
BVI72130
€375,000
Saint-Bonnet-sur-Gironde, Charente-Maritime
4
3
162 m²
9,125 m²
BVI71401
€256,800
Montmoreau, Charente
4
2
339 m²
1,930 m²
BVI71951
€345,000
Champniers, Vienne
3
2
105 m²
589 m²
BVI72168
€95,000
Macqueville, Charente-Maritime
3
1
163 m²
792 m²
BVI70993
€295,000
Sainte-Cécile-du-Cayrou, Tarn
3
4
220 m²
3,973 m²
BVI68442
€475,000
Barbezieux-Saint-Hilaire, Charente
3
1
130 m²
102 m²
BVI70104
€71,500
Aubeterre-sur-Dronne, Charente
6
2
238 m²
19,822 m²
BVI71911
€256,800
Mialet, Dordogne
2
2
78 m²
8,818 m²
BVI70468
€124,500
Les Essards, Charente
4
2
130 m²
5,092 m²
BVI71574
€160,000
Montmorillon, Vienne
4
1
117 m²
1,520 m²
BVI71821
€99,000
Monségur, Gironde
4
3
286 m²
3,800 m²
BVI69296
€646,227
Lagarde-Hachan, Gers
4
3
205 m²
27,807 m²
BVI71528
€350,000
Mansle-les-fontaines, Charente
2
2
107 m²
2,892 m²
BVI69996
€179,820
Oradour-Saint-Genest, Haute-Vienne
2
1
80 m²
1,104 m²
BVI68979
€65,000
Bergerac, Dordogne
4
1
327 m²
4,306 m²
BVI66859
€424,000
Lezay, Deux-Sèvres
3
2
130 m²
1,009 m²
BVI68925
€130,000
Puivert, Aude
3
2
117 m²
433 m²
BVI71420
€160,000
Genouillé, Vienne
4
2
149 m²
1,601 m²
BVI71423
