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 07:57:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:57: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 07:57:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:57: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] => [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 07:57:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:57: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 07:57:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:57:52') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 173 à 215 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 07:57:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:57: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 07:57:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:57: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] => [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 07:57:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:57: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 07:57:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:57:52') 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
Tournon-d’Agenais, Lot-et-Garonne
205 m²
70 m²
BVI71382
€46,000
Bourg-Charente, Charente
3
3
200 m²
5,487 m²
BVI65867
€365,000
Niort, Deux-Sèvres
9
7
667 m²
63,227 m²
BVI59919
€1,365,000
Surin, Vienne
4
4
207 m²
2,780 m²
BVI71316
€339,200
Busserolles, Dordogne
2
1
80 m²
250 m²
BVI66438
€95,000
Eymet, Dordogne
3
2
136 m²
4,801 m²
BVI68327
€344,500
Marcilhac-sur-Célé, Lot
4
3
120 m²
1,839 m²
BVI66338
€385,000
Puivert, Aude
4
2
160 m²
304 m²
BVI71077
€190,000
Limoux, Aude
2
2
98 m²
3,105 m²
BVI68232
€79,002
Couture, Charente
5
3
319 m²
2,100 m²
BVI71202
€278,200
Prignac, Charente-Maritime
2
1
64 m²
90 m²
BVI70974
€65,000
Eymet, Dordogne
3
2
112 m²
3,228 m²
BVI70886
€265,360
Jarnac, Charente
5
2
225 m²
434 m²
BVI71003
€382,978
Bellac, Haute-Vienne
2
1
110 m²
330 m²
BVI66851
€77,000
Eymet, Dordogne
3
1
112 m²
4,790 m²
BVI62481
€162,000
Saint-Simeux, Charente
2
2
142 m²
1,479 m²
BVI70692
€302,810
Parthenay, Deux-Sèvres
25
3
1837 m²
199,621 m²
BVI67552
€1,264,000
Salles-Lavalette, Charente
3
4
155 m²
5,353 m²
BVI64797
€395,000
Étouars, Dordogne
2
1
70 m²
650 m²
BVI65951
€89,980
Limoux, Aude
3
1
127 m²
2,503 m²
BVI70365
€279,600
Laguépie, Tarn-et-Garonne
3
2
198 m²
8,554 m²
BVI70840
€395,000
Monflanquin, Lot-et-Garonne
9
5
565 m²
191,714 m²
BVI70102
€1,890,000
Charroux, Vienne
3
1
136 m²
1,234 m²
BVI61133
€216,140
La Trimouille, Vienne
7
2
150 m²
345 m²
BVI70648
€66,000
Limoux, Aude
4
3
195 m²
1,766 m²
BVI70557
€450,000
Prayssac, Lot
4
4
210 m²
30,782 m²
BVI70768
€395,000
Champs-Romain, Dordogne
4
3
124 m²
3,084 m²
BVI70302
€229,500
Lathus St Remy, Vienne
3
2
89 m²
159 m²
BVI16469
€66,000
Charroux, Vienne
3
3
206 m²
8,902 m²
BVI70543
€309,500
Busserolles, Dordogne
3
160 m²
2,213 m²
BVI68829
€88,000
Monflanquin, Lot-et-Garonne
3
2
164 m²
184 m²
BVI70001
€185,000
Eymet, Dordogne
4
3
203 m²
10,166 m²
BVI70561
€550,000
Saint-Savin, Vienne
9
3
500 m²
1,387 m²
BVI62633
€389,000
Aubeterre-sur-Dronne, Charente
3
2
143 m²
2,796 m²
BVI70042
€330,000
Monflanquin, Lot-et-Garonne
3
2
116 m²
4,997 m²
BVI70017
€395,000
Chalais, Charente
3
2
103 m²
8,823 m²
BVI69558
€136,250
Saint-Privat-des-Prés, Dordogne
4
2
215 m²
5,089 m²
BVI68886
€205,200
Quillan, Aude
4
2
156 m²
2,200 m²
BVI69992
€349,000
Piégut-Pluviers, Dordogne
12
6
450 m²
6,896 m²
BVI69711
€598,900
Lauzun, Lot-et-Garonne
4
3
203 m²
8,007 m²
BVI69488
€466,400
Chasseneuil-sur-Bonnieure, Charente
3
2
109 m²
1,183 m²
BVI69242
€147,150
Tombebœuf, Lot-et-Garonne
7
4
350 m²
44,979 m²
BVI68980
€842,500
Beaulieu-sur-Sonnette, Charente
5
2
250 m²
11,073 m²
BVI63171
