Array
(
[keyword] =>
[province_combi] =>
[county_combi] =>
[country] =>
[locstate] =>
[province] => Tarn
[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 ('tarn') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 01:50:39') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 01:50:39') 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 01:50:39') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 01:50:39') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => Tarn [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 ('tarn') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 01:50:39') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 01:50:39') 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 01:50:39') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 01:50:39') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Results 1 - 43 of 80
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 ('tarn') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 01:50:39') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 01:50:39') 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 01:50:39') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 01:50:39') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESCArray ( [keyword] => [province_combi] => [county_combi] => [country] => [locstate] => [province] => Tarn [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 ('tarn') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 01:50:39') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 01:50:39') 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 01:50:39') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 01:50:39') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.created DESC
Property for sale in the Tarn
Within the dramatic department of the Tarn and its eponymous river gorges, one feels a sense of the south west meeting south east. Architectural styles meet, and the climate from west to east, and north to south, are often quite different. Roads are often winding and the pace of life is necessarily slower. Limestone and sandstone foothills, with granite peaks; this is serious rugby country: frontier-land. Looking to buy a property with a view? You almost can't fail in the Tarn!
The capital Albi, birthplace and museum to Toulouse Lautrec (he produced 7000 works in a 20 year career, and died aged 36) and boasting a magnificent brick cathedral on the river, as well as modern shopping facilities. Gaillac and Castres are larger towns, Castelnau-Montmiral and Cordes-sur-Ciel absolutely unmissable go-to visits.
Looking to buy a property in the Tarn? 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.
Mirandol-Bourgnounac, Tarn
4
2
155 m²
7,589 m²
BVI73884
€349,000
Castelnau-de-Montmiral, Tarn
3
1
195 m²
26,518 m²
BVI77204
€299,000
Castelnau-de-Montmiral, Tarn
5
5
187 m²
218 m²
BVI73501
€430,000
Crespinet, Tarn
11
8
385 m²
793 m²
BVI77116
€402,800
Vabre, Tarn
5
2
200 m²
273 m²
BVI76989
€178,200
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
Rabastens, Tarn
5
4
540 m²
702 m²
BVI76956
€850,000
Castelnau-de-Montmiral, Tarn
4
3
257 m²
24,256 m²
BVI73153
€545,000
Cordes-sur-Ciel, Tarn
3
3
250 m²
4,253 m²
BVI77235
€499,000
Cahuzac-sur-Vère, Tarn
4
3
207 m²
8,492 m²
BVI76668
€395,000
Salles, Tarn
3
1
69 m²
148 m²
BVI71680
€135,000
Saint-Martin-Laguépie, Tarn
2
1
74 m²
2,478 m²
BVI75888
€220,000
Cordes-sur-Ciel, Tarn
3
2
199 m²
337 m²
BVI76450
€425,000
Peyrole, Tarn
5
2
253 m²
27,460 m²
BVI66561
€450,000
Cordes-sur-Ciel, Tarn
4
115 m²
275,621 m²
BVI75898
€278,200
Montirat, Tarn
3
3
240 m²
59,302 m²
BVI76079
€450,000
Le Masnau-Massuguiès, Tarn
4
3
316 m²
84,677 m²
BVI75639
€715,995
Gaillac, Tarn
4
2
247 m²
5,895 m²
BVI75963
€477,500
Lombers, Tarn
7
4
347 m²
90,815 m²
BVI74764
€766,000
Cestayrols, Tarn
3
3
255 m²
642 m²
BVI72561
€435,000
Le Ségur, Tarn
7
7
580 m²
17,600 m²
BVI72919
€730,000
Cahuzac-sur-Vère, Tarn
10
3
445 m²
69,447 m²
BVI75528
€812,766
Cordes-sur-Ciel, Tarn
1
3
64 m²
79 m²
BVI59051
€150,000
Cordes-sur-Ciel, Tarn
4
2
170 m²
329 m²
BVI75645
€318,000
Montirat, Tarn
6
5
308 m²
5,979 m²
BVI75475
€435,000
Cordes-sur-Ciel, Tarn
9
2
266 m²
531,340 m²
BVI71493
€1,132,000
Lisle-sur-Tarn, Tarn
6
3
300 m²
88,053 m²
BVI75457
€765,960
Pont-de-Larn, Tarn
8
3
320 m²
43,305 m²
BVI67507
€638,297
Puycelsi, Tarn
5
4
325 m²
224,950 m²
BVI69920
€689,000
Cordes-sur-Ciel, Tarn
4
3
301 m²
62,697 m²
BVI74572
€850,000
Frausseilles, Tarn
7
4
318 m²
42,239 m²
BVI75422
€680,000
Cagnac-les-Mines, Tarn
3
2
155 m²
593 m²
BVI73516
€371,000
Rabastens, Tarn
2
130 m²
161 m²
BVI72316
€319,150
Cordes-sur-Ciel, Tarn
8
6
413 m²
4,359 m²
BVI71274
€499,000
Cahuzac-sur-Vère, Tarn
8
6
496 m²
10,271 m²
BVI70679
€875,000
Monestiés, Tarn
3
2
140 m²
34,162 m²
BVI74544
€385,000
Pampelonne, Tarn
4
2
162 m²
3,980 m²
BVI65518
€218,000
Réalmont, Tarn
3
2
435 m²
235 m²
BVI61771
€245,000
Cordes-sur-Ciel, Tarn
5
3
447 m²
282 m²
BVI73577
€395,000
Puycelsi, Tarn
4
1
139 m²
879 m²
BVI73201
€139,000
Tanus, Tarn
5
430 m²
716 m²
BVI73259
€395,000
Cordes-sur-Ciel, Tarn
4
3
322 m²
170,970 m²
BVI71506
