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-04-24 10:51:17') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-04-24 10:51:17') 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-04-24 10:51:17') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-24 10:51:17') 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-04-24 10:51:17') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-04-24 10:51:17') 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-04-24 10:51:17') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-24 10:51:17') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 44 à 86 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-04-24 10:51:17') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-04-24 10:51:17') 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-04-24 10:51:17') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-24 10:51:17') 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-04-24 10:51:17') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-04-24 10:51:17') 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-04-24 10:51:17') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-24 10:51:17') 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
Eymet, Dordogne
5
4
204 m²
3,157 m²
BVI73772
€487,600
Longré, Charente
858 m²
BVI74361
€21,000
Ribérac, Dordogne
3
2
177 m²
2,612 m²
BVI73410
€349,800
Vanzay, Deux-Sèvres
3
2
189 m²
1,563 m²
BVI72289
€239,784
Villebois-Lavalette, Charente
8
4
177 m²
1,908 m²
BVI71754
€235,000
Mézin, Lot-et-Garonne
3
1
120 m²
141,012 m²
BVI69162
€214,000
Saint-Jean-de-Côle, Dordogne
3
1
150 m²
23,471 m²
BVI74218
€318,000
Piégut-Pluviers, Dordogne
3
2
136 m²
1,061 m²
BVI72665
€219,950
Sauzé-Vaussais, Deux-Sèvres
2
1
70 m²
4,040 m²
BVI74447
€147,150
Aizecq, Charente
77 m²
663 m²
BVI68313
€30,000
Lauzun, Lot-et-Garonne
5
2
220 m²
12,296 m²
BVI73592
€560,000
Les Métairies, Charente
3
2
122 m²
1,790 m²
BVI74275
€256,800
Baignes-Sainte-Radegonde, Charente
3
1
191 m²
1,420 m²
BVI72942
€258,000
Mauprévoir, Vienne
3
2
124 m²
1,789 m²
BVI64565
€121,000
Arques, Aude
64 m²
22,010 m²
BVI73497
€80,000
Rouillac, Charente
4
3
180 m²
860 m²
BVI72888
€249,999
Theil-Rabier, Charente
1
1
109 m²
1,437 m²
BVI74099
€71,500
La Coquille, Dordogne
4
3
127 m²
6,840 m²
BVI74166
€267,000
Villeneuve, Aveyron
3
2
139 m²
7,086 m²
BVI72003
€299,000
Montbron, Charente
2
100 m²
11,245 m²
BVI72476
€77,000
Limoux, Aude
3
1
164 m²
2,480 m²
BVI73998
€360,000
Ambernac, Charente
6
2
170 m²
14,900 m²
BVI72405
€246,100
Brigueil-le-Chantre, Vienne
3
2
173 m²
2,055 m²
BVI73401
€196,560
Chabanais, Charente
4
2
124 m²
865 m²
BVI73705
€135,000
Brux, Vienne
1
1
75 m²
2,027 m²
BVI74117
€82,500
Chef-Boutonne, Deux-Sèvres
6
6
360 m²
1,405 m²
BVI69827
€371,000
Aubeterre-sur-Dronne, Charente
4
2
150 m²
865 m²
BVI72979
€165,000
Saint-Martin-de-Ribérac, Dordogne
4
3
345 m²
5,065 m²
BVI70688
€540,600
Villeneuve-sur-Lot, Lot-et-Garonne
1
223 m²
9,367 m²
BVI72362
€473,290
Jonzac, Charente-Maritime
2
1
84 m²
2,367 m²
BVI71868
€162,000
Saint-Saud-Lacoussière, Dordogne
3
2
142 m²
10,511 m²
BVI73334
€215,000
Nanteuil-en-Vallée, Charente
3
3
228 m²
5,886 m²
BVI73671
€429,000
La Roche-Chalais, Dordogne
2098 m²
BVI73892
€17,000
Jonzac, Charente-Maritime
1
1
92 m²
4,581 m²
BVI70751
€170,640
Val-d’Oire-et-Gartempe, Haute-Vienne
3
2
123 m²
1,286 m²
BVI64306
€79,000
Monségur, Gironde
4
1
112 m²
4,638 m²
BVI73286
€267,500
Hanc, Deux-Sèvres
2
2
110 m²
1,000 m²
BVI73917
€194,400
Gignac, Lot
4
1
210 m²
795 m²
BVI73628
€305,000
Eymet, Dordogne
8
4
370 m²
490 m²
BVI72987
€450,000
Matha, Charente-Maritime
4
3
213 m²
3,643 m²
BVI73759
€399,959
Barbaste, Lot-et-Garonne
6
2
400 m²
117,875 m²
BVI73672
€595,000
Saint-Léger-Magnazeix, Haute-Vienne
4
2
71 m²
185 m²
BVI73652
€31,000
Val-d’Oire-et-Gartempe, Haute-Vienne
3
2
98 m²
1,499 m²
BVI73640
