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 04:56:36') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:56:36') 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 04:56:36') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:56:36') 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 04:56:36') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:56:36') 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 04:56:36') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:56:36') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 44 - 86 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 04:56:36') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:56:36') 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 04:56:36') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:56:36') 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 04:56:36') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 04:56:36') 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 04:56:36') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 04:56:36') 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.
Monbahus, Lot-et-Garonne
4
1
110 m²
23,917 m²
BVI76951
€172,800
Fongrave, Lot-et-Garonne
4
1
155 m²
2,000 m²
BVI76848
€288,900
Villeneuve-sur-Lot, Lot-et-Garonne
4
1
110 m²
663 m²
BVI72522
€225,900
Tournon-d’Agenais, Lot-et-Garonne
3
3
145 m²
2,715 m²
BVI76368
€372,500
Villeréal, Lot-et-Garonne
3
1
93 m²
6,292 m²
BVI76835
€240,750
Pujols, Lot-et-Garonne
3
1
102 m²
3,117 m²
BVI76860
€194,400
Villeréal, Lot-et-Garonne
2
1
72 m²
44,541 m²
BVI76209
€262,200
Monflanquin, Lot-et-Garonne
2
2
100 m²
10,117 m²
BVI75964
€168,480
Paulhiac, Lot-et-Garonne
4
2
152 m²
20,652 m²
BVI76193
€424,000
Monflanquin, Lot-et-Garonne
3
3
225 m²
60,000 m²
BVI76426
€565,000
Douzains, Lot-et-Garonne
5
2
149 m²
2,126 m²
BVI76161
€292,700
Beaugas, Lot-et-Garonne
4
4
308 m²
34,773 m²
BVI67094
€524,000
Villeréal, Lot-et-Garonne
4
1
143 m²
7,030 m²
BVI70221
€278,200
Duras, Lot-et-Garonne
4
2
250 m²
5,000 m²
BVI57969
€452,150
Castelmoron-sur-Lot, Lot-et-Garonne
5
4
280 m²
490 m²
BVI74943
€450,000
Villeréal, Lot-et-Garonne
6
5
290 m²
5,257 m²
BVI76199
€402,800
Cuzorn, Lot-et-Garonne
3
3
170 m²
5,258 m²
BVI75929
€499,950
Cuzorn, Lot-et-Garonne
4
1
140 m²
2,882 m²
BVI71964
€235,400
Monbahus, Lot-et-Garonne
4
3
160 m²
18,318 m²
BVI70262
€381,600
Marmande, Lot-et-Garonne
5
2
272 m²
612 m²
BVI76332
€422,000
Nérac, Lot-et-Garonne
2
1
100 m²
585 m²
BVI73447
€178,200
Lauzun, Lot-et-Garonne
6
5
273 m²
22,489 m²
BVI75416
€638,300
Monbahus, Lot-et-Garonne
3
2
332 m²
5,768 m²
BVI71767
€333,900
Beauville, Lot-et-Garonne
3
1
123 m²
14,527 m²
BVI75440
€249,000
Le Temple-sur-Lot, Lot-et-Garonne
3
1
145 m²
2,005 m²
BVI76292
€318,000
La Sauvetat-du-Dropt, Lot-et-Garonne
3
2
167 m²
122 m²
BVI76118
€235,400
Villeréal, Lot-et-Garonne
4
2
220 m²
439 m²
BVI75248
€267,500
Puymirol, Lot-et-Garonne
8
5
342 m²
29,138 m²
BVI75523
€797,900
Monflanquin, Lot-et-Garonne
4
3
165 m²
6,670 m²
BVI74708
€532,000
Penne-d’Agenais, Lot-et-Garonne
5
2
245 m²
1,255 m²
BVI75046
€360,000
Laroque-Timbaut, Lot-et-Garonne
5
2
400 m²
52,197 m²
BVI75171
€950,000
Castillonnès, Lot-et-Garonne
3
2
120 m²
7,000 m²
BVI70256
€251,450
Allemans-du-Dropt, Lot-et-Garonne
2
2
105 m²
711 m²
BVI73123
€230,050
Monflanquin, Lot-et-Garonne
4
1
118 m²
127,404 m²
BVI61360
€315,000
Monflanquin, Lot-et-Garonne
7
4
295 m²
20,118 m²
BVI75992
€638,500
Duras, Lot-et-Garonne
5
3
209 m²
8,720 m²
BVI75351
€224,700
Villeneuve-sur-Lot, Lot-et-Garonne
4
2
220 m²
5,722 m²
BVI75819
€199,000
Beauville, Lot-et-Garonne
6
5
300 m²
7,762 m²
BVI75905
€649,000
Lacapelle-Biron, Lot-et-Garonne
4
2
167 m²
503 m²
BVI75022
€194,400
Lauzun, Lot-et-Garonne
4
3
186 m²
3,656 m²
BVI75760
€390,000
Lauzun, Lot-et-Garonne
4
3
150 m²
24,135 m²
BVI75554
€450,000
Tombebœuf, Lot-et-Garonne
14
6
450 m²
12,000 m²
BVI75491
€742,000
Tombebœuf, Lot-et-Garonne
2
2
300 m²
2,500 m²
BVI75493
