SELECT p.province_combi,p.county_combi,p.*, p.id AS id, p.province_num, p.title AS title, p.exc, p.office, p.liv, p.vtour, p.video, p.street_num, p.street_dir, p.street, p.street2, p.garage_type, p.heating_device, p.drainage, p.garage_size, p.description as description, p.created as created, p.alias as alias, p.heating_access, 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`.`id` IN ('315806') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 13:22:32') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:22:32') 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 (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 13:22:32') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:22:32') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASC
Exceptional property with swimming pool and amazing views
Find out more or book a viewing Save to my favourites
Exceptional property with swimming pool and amazing views
- 19th century chateau
- Magnificently situated overlooking the river Lot
- Beautifully renovated interiors
- Charming garden
Whether you are looking for a stunning family home or a bed and breakfast project, this property is sure to seduce you.
Information on any natural risk, such as flooding, can be obtained via this government website
Mandate type: Direct - Fees to be paid by the vendor
Exchange rate information
€ 1 = £ 0,85 
Last update: 18-01-2025
Lorem ipsum dolor sit amet, consectetur adipiscing elit.
More info
Find out more or book a viewing Print Manage my favourites Back Discuss an offer
Rooms and Areas
1 Terrace - (90 M2)
1 Pool house
1 Parking
1 Land - (3816 M2)
1 Entrance - (16 M2)
1 Kitchen - (12 M2)
1 Living-room - (16 M2)
1 Bedroom(s) - (18 M2)
1 Bathroom / Lavatory - (16 M2)
1 Studio - (13 M2)
1 Kitchen - (50 M2)
1 Cellar
1 Laundry room - (25 M2)
1 Lavatory
1 Bedroom(s) - (16 M2)
1 Master bedroom - (18 M2)
1 Bathroom - (16 M2)
1 Bedroom(s) - (13 M2)
1 Lavatory
1 Attic - (100 M2)
2 Bedroom(s) - (8 M2)
Details
Energy performance certificate
Realised: 27 April 2021
Estimated annual energy expenditure for typical use approximately € 2418.
Click here for the full details.
Energy performance
Gas emission
Virtual tour
Video
Location
Find out more or book a viewing
Monflanquin
This property is listed by Eric Garnier from our office in Monflanquin. Any questions? Contact us now and we'll get back to you.
Use the form or contact us by email or telephone.
49 Place des Arcades
47150 Monflanquin
Lot-et-Garonne
05 56 71 36 59
info@beauxvillages.com
Discuss an Offer
If this or other properties are of potential serious interest, you may wish to speak in confidence and without obligation or commitment with a sympathetic senior negotiator to discuss what flexibility there may be in the price.
Getting the right deal can be a question of good timing and we have that information.
Whatever you read in the press, it is simply not true that one can apply a percentage discount to the price of any property we like the look of. And it is a real shame to fall in love with a property that is beyond what you wish to spend or can afford.
To arrange a callback, please email in-confidence@beauxvillages.comFinance and Currencies
Currencies
For a live no-obligation quote, please click to contact Smart Currency Exchange
Mortgages
Talk to a French bank, in English (or in French!), for a quick in-principle guide to your suitability for a loan. Or to an international broker - in one of several languages. We are happy to advise which is the most sensible route to pursue in any given circumstance.
Please email our Head of Finance: deborah.lewis@beauxvillages.com
You might also like ...
SELECT p.province_combi,p.county_combi,p.*, p.id AS id, p.province_num, p.title AS title, p.exc, p.office, p.liv, p.vtour, p.video, p.street_num, p.street_dir, p.street, p.street2, p.garage_type, p.heating_device, p.drainage, p.garage_size, p.description as description, p.created as created, p.alias as alias, p.heating_access, 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`.`id` IN ('315806') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 13:22:32') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:22:32') 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 (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 13:22:32') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:22:32') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASCArray ( [province] => Lot )
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.price BETWEEN 1080000 AND 1320000) AND `p`.`province` IN ('lot') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 13:22:32') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:22:32') 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 (94,86) 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 13:22:32') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:22:32') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY RAND()
