Array
(
[keyword] =>
[province_combi] =>
[county_combi] =>
[country] =>
[locstate] =>
[province] => Lot-et-Garonne
[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] =>
[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 ('lot-et-garonne') 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:35:49') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:35:49') 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:35:49') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:35:49') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => Lot-et-Garonne [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] => [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 ('lot-et-garonne') 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:35:49') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:35:49') 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:35:49') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:35:49') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 1 - 43 of 278
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 ('lot-et-garonne') 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:35:49') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:35:49') 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:35:49') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:35:49') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => Lot-et-Garonne [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] => [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 ('lot-et-garonne') 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:35:49') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 07:35:49') 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:35:49') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 07:35:49') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Property for sale in the Lot-et-Garonne
Occupying a prime spot centred between Bergerac, Toulouse and Bordeaux, and underpinned economically by fruit production and tourism, the Lot et Garonne offers an enviable rural lifestyle whilst never being far from the madding crowds.
Sometimes known as the Tuscany of France, the landscape is populated with sunflowers, vines, cypress trees and red tiled roofs.
The north of the Lot et Garonne includes limestone hills and some pine forest where it joins the Landes. Thereafter it becomes rolling valleys set around the important rivers that give it its name.
Visitor towns include Duras, Nerac, and Monflanquin, with larger towns at Marmande, Villeneuve sur Lot and Agen. The list of pretty hilltop bastides is quite impressive, too.
Looking to buy a property in the Lot-et-Garonne? We have houses for sale throughout the department. Click on a property below for more details or to arrange a viewing. You can also meet us at one of our estate agencies in the Lot-et-Garonne.
Monflanquin, Lot-et-Garonne
4
4
247 m²
235 m²
BVI65486
€399,000
Tournon-d’Agenais, Lot-et-Garonne
2
2
195 m²
375 m²
BVI77521
€360,000
Cancon, Lot-et-Garonne
5
3
193 m²
6,285 m²
BVI77570
€344,500
Nérac, Lot-et-Garonne
2
2
175 m²
1,927 m²
BVI75835
€249,000
Soumensac, Lot-et-Garonne
3
2
138 m²
325 m²
BVI77271
€142,300
Cancon, Lot-et-Garonne
6
3
307 m²
6,056 m²
BVI77549
€499,500
Villeréal, Lot-et-Garonne
6
3
194 m²
7,680 m²
BVI77598
€424,000
Marmande, Lot-et-Garonne
2
1
108 m²
3,002 m²
BVI76287
€119,900
Soumensac, Lot-et-Garonne
3
2
248 m²
3,684 m²
BVI73646
€455,800
Beaugas, Lot-et-Garonne
5
2
195 m²
10,654 m²
BVI75441
€399,000
Penne-d’Agenais, Lot-et-Garonne
4
1
127 m²
31,140 m²
BVI75708
€345,000
Nérac, Lot-et-Garonne
7
2
340 m²
389 m²
BVI77493
€360,400
Castillonnès, Lot-et-Garonne
3
1
220 m²
3,412 m²
BVI74591
€424,000
Duras, Lot-et-Garonne
4
3
208 m²
18,874 m²
BVI77420
€600,000
Allemans-du-Dropt, Lot-et-Garonne
5
5
292 m²
2,265 m²
BVI72066
€434,600
Le Temple-sur-Lot, Lot-et-Garonne
2
1
108 m²
27,009 m²
BVI77424
€212,000
Monflanquin, Lot-et-Garonne
950 m²
BVI67977
€26,000
Tournon-d’Agenais, Lot-et-Garonne
6
3
190 m²
10,638 m²
BVI76189
€558,000
Port-Sainte-Marie, Lot-et-Garonne
3
2
114 m²
11,493 m²
BVI77225
€235,400
Allemans-du-Dropt, Lot-et-Garonne
3
2
115 m²
127 m²
BVI77261
€189,000
Nérac, Lot-et-Garonne
4
1
131 m²
2,881 m²
BVI73604
€225,000
Duras, Lot-et-Garonne
4
2
127 m²
5,869 m²
BVI77316
€275,000
Buzet-sur-Baïse, Lot-et-Garonne
3
1
168 m²
168 m²
BVI77181
€59,999
Nérac, Lot-et-Garonne
4
2
140 m²
2,400 m²
BVI68530
€370,000
Saint-Sylvestre-sur-Lot, Lot-et-Garonne
8
6
420 m²
34,626 m²
BVI76421
€852,000
Tombebœuf, Lot-et-Garonne
4
3
173 m²
1,400 m²
BVI77238
€359,000
Trentels, Lot-et-Garonne
3
2
134 m²
195 m²
BVI77090
€300,000
Paulhiac, Lot-et-Garonne
4
2
153 m²
205,823 m²
BVI76192
€477,000
Casteljaloux, Lot-et-Garonne
9
6
368 m²
18,530 m²
BVI77005
€450,000
Villeréal, Lot-et-Garonne
3
2
133 m²
81 m²
BVI77168
€189,925
Castelnaud-de-Gratecambe, Lot-et-Garonne
1
1
35 m²
35 m²
BVI76631
€71,000
Saint-Eutrope-de-Born, Lot-et-Garonne
11
4
441 m²
8,830 m²
BVI74727
€655,000
Tournon-d’Agenais, Lot-et-Garonne
8
8
372 m²
4,710 m²
BVI67315
€1,250,000
Tombebœuf, Lot-et-Garonne
5
2
347 m²
9,453 m²
BVI76751
€550,000
Monflanquin, Lot-et-Garonne
4
2
155 m²
26,973 m²
BVI76999
€393,500
Castelnaud-de-Gratecambe, Lot-et-Garonne
1
1
35 m²
39 m²
BVI76563
€66,000
Fumel, Lot-et-Garonne
5
3
170 m²
363 m²
BVI76533
€142,900
Monflanquin, Lot-et-Garonne
5
3
231 m²
4,999 m²
BVI76967
€498,000
Duras, Lot-et-Garonne
7
6
350 m²
6,383 m²
BVI77115
€477,000
Villeneuve-de-Duras, Lot-et-Garonne
4
2
190 m²
772 m²
BVI77029
€250,000
Loubès-Bernac, Lot-et-Garonne
3
1
165 m²
9,638 m²
BVI76754
€424,000
Castillonnès, Lot-et-Garonne
3
3
168 m²
195 m²
BVI76158
€275,000
Saint-Pastour, Lot-et-Garonne
8
6
520 m²
21,618 m²
BVI71367
