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] => 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`.`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 07:42:15') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:42:15') 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:42:15') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:42:15') 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] => 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`.`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 07:42:15') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:42:15') 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:42:15') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:42:15') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Résultats 173 à 215 sur 3165
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 ('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 07:42:15') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:42:15') 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:42:15') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:42:15') 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] => 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`.`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 07:42:15') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:42:15') 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:42:15') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:42:15') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Nos dernières annonces immobilières
Accédez directement aux dernières annonces immobilières ! Visitez notre page régulièrement ou inscrivez-vous pour recevoir les biens correspondant à vos critères directement dans votre boîte email.
Détendez-vous en sachant que vous ne manquerez jamais “VOTRE MAISON” !
Les dernières propriétés dans votre boîte email. Ne manquez pas celle-ci.
S'inscrire
Salles-Lavalette, Charente
5
2
170 m²
1,520 m²
BVI76902
€267,500
Alloinay, Deux-Sèvres
3
2
171 m²
1,762 m²
BVI77174
€199,950
Crespinet, Tarn
11
8
385 m²
793 m²
BVI77116
€402,800
Tonnay-Boutonne, Charente-Maritime
6
4
227 m²
1,735 m²
BVI76811
€400,000
La Mothe-Saint-Héray, Deux-Sèvres
3
3
143 m²
215 m²
BVI75630
€79,750
Sauveterre-de-Guyenne, Gironde
1
60 m²
276 m²
BVI77416
€60,000
Léoville, Charente-Maritime
5
3
206 m²
1,434 m²
BVI77357
€299,250
Saint-Romain, Vienne
2
1
68 m²
6,711 m²
BVI77210
€45,000
Eymet, Dordogne
8
8
347 m²
7,041 m²
BVI77184
€799,000
Guîtres, Gironde
3
3
312 m²
2,844 m²
BVI77136
€466,400
Saint-Sylvestre-sur-Lot, Lot-et-Garonne
8
6
420 m²
34,626 m²
BVI76421
€852,000
Riocaud, Gironde
4
2
228 m²
7,289 m²
BVI76697
€424,000
Manot, Charente
4
2
112 m²
135 m²
BVI74429
€85,000
Rieupeyroux, Aveyron
13
11
528 m²
12,113 m²
BVI75865
€649,950
Aubeterre-sur-Dronne, Charente
2
1
114 m²
2,767 m²
BVI76564
€99,000
Bonneuil, Indre
1
1
50 m²
1,050 m²
BVI77138
€36,000
Ruffec, Charente
1
1
64 m²
100 m²
BVI73455
€43,200
Mézières-sur-Issoire, Haute-Vienne
4
2
190 m²
1,699 m²
BVI71507
€258,064
Salles-Lavalette, Charente
3
2
200 m²
322 m²
BVI76850
€119,900
Saint-Bonnet-de-Bellac, Haute-Vienne
3
1
103 m²
2,369 m²
BVI75521
€194,400
Vélines, Dordogne
3
1
180 m²
1,874 m²
BVI76427
€290,000
Marciac, Gers
6
5
400 m²
34,650 m²
BVI76508
€749,000
Bourg-Archambault, Vienne
2
2
122 m²
998 m²
BVI77236
€125,000
Angles-sur-l’Anglin, Vienne
3
2
71 m²
741 m²
BVI72167
€263,500
Vabre, Tarn
5
2
200 m²
273 m²
BVI76989
€178,200
Journet, Vienne
2
1
66 m²
1,969 m²
BVI75394
€105,000
Saint-Sornin-la-Marche, Haute-Vienne
120 m²
580 m²
BVI76237
€56,000
Sainte-Foy-la-Grande, Gironde
11
8
452 m²
3,636 m²
BVI77143
€660,000
Limoux, Aude
2
2
102 m²
815 m²
BVI62285
€80,000
Simeyrols, Dordogne
4
2
180 m²
1,885 m²
BVI75169
€399,000
La Fouillade, Aveyron
4
3
163 m²
8,783 m²
BVI76301
€440,000
Ventabren, Bouches-du-Rhône
6
6
400 m²
2,400 m²
BVI76497
€2,090,000
Montpon-Ménestérol, Dordogne
8
8
590 m²
8,056 m²
BVI75938
€1,292,000
Brigueil-le-Chantre, Vienne
3
1
76 m²
3,649 m²
BVI77166
€88,000
Cordes-sur-Ciel, Tarn
3
2
819 m²
6,002 m²
BVI74211
€690,000
Cordes-sur-Ciel, Tarn
10
10
819 m²
13,834 m²
BVI71697
€1,950,000
Nanteuil-Auriac-de-Bourzac, Dordogne
8
6
293 m²
19,490 m²
BVI75324
€659,574
Chauvigny, Vienne
3
3
208 m²
10,880 m²
BVI76957
€452,000
Saint-Matré, Lot
4
2
163 m²
33,031 m²
BVI77081
€173,950
Tombebœuf, Lot-et-Garonne
4
3
173 m²
1,400 m²
BVI77238
€359,000
Saint-Benoît-du-Sault, Indre
2
1
54 m²
656 m²
BVI76046
€79,000
Saint-Séverin, Charente
3
1
90 m²
5,520 m²
BVI77122
€246,100
Ranville-Breuillaud, Charente
5
1
170 m²
1,198 m²
BVI75446
