Array
(
[id] => 305915
)
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 ('305915') 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:03:33') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:03:33') 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:03:33') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:03:33') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASC
Find out more or book a viewing Save to my favourites
Upon entering the main house, a hallway leads to the living room on one side and the dining room with a beautiful fireplace and a modern kitchen on the other. All ground floor rooms open onto the spacious travertine terrace, offering scenic views of the countryside and the Pyrenees.
Upstairs, a landing with beautiful parquet flooring gives way to three bedrooms and a bathroom with a sizable walk-in shower.
The guesthouse is designed to accommodate individuals with reduced mobility. It comprises an entrance, a lovely living room opening onto the garden through a wide bay window, a fully equipped kitchen, a spacious bedroom, and a bathroom.
Three splendid lime trees adorn the garden, providing refreshing shade during the summer. A large orchard area features cherry trees, fig trees, apricot trees, and more.
This property offers a harmonious balance of practicality, functionality, and charm. Feel free to contact us to arrange a visit.
Fees to be paid by the seller. Energy class E, Climate class E Estimated average amount of annual energy expenditure for standard use, based on the year's energy prices 2021: between 2250.00 and 3120.00 €. Information on the risks to which this property is exposed is available on the Geohazards website: georisques.gouv.fr.
Find out more or book a viewing Print Manage my favourites Back Discuss an offer
Midi-Pyrénées
Gers
Condom
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 ('305915') 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:03:33') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:03:33') 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:03:33') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:03:33') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASC
Charming Village House with Guest House and Garden
€399,000 AAB2808
Bedrooms
4
Bathrooms
2
Habitable space
221 m2
Plot size
3,300 m2
Area
Condom
Department
Gers
Find out more or book a viewing Save to my favourites
Charming Village House with Guest House and Garden
Upon entering the main house, a hallway leads to the living room on one side and the dining room with a beautiful fireplace and a modern kitchen on the other. All ground floor rooms open onto the spacious travertine terrace, offering scenic views of the countryside and the Pyrenees.
Upstairs, a landing with beautiful parquet flooring gives way to three bedrooms and a bathroom with a sizable walk-in shower.
The guesthouse is designed to accommodate individuals with reduced mobility. It comprises an entrance, a lovely living room opening onto the garden through a wide bay window, a fully equipped kitchen, a spacious bedroom, and a bathroom.
Three splendid lime trees adorn the garden, providing refreshing shade during the summer. A large orchard area features cherry trees, fig trees, apricot trees, and more.
This property offers a harmonious balance of practicality, functionality, and charm. Feel free to contact us to arrange a visit.
Fees to be paid by the seller. Energy class E, Climate class E Estimated average amount of annual energy expenditure for standard use, based on the year's energy prices 2021: between 2250.00 and 3120.00 €. Information on the risks to which this property is exposed is available on the Geohazards website: georisques.gouv.fr.
Information on any natural risk, such as flooding, can be obtained via this government website
Mandate type: Delegated Mandate
€399,000
£ 342,226
Save to my favourites
Exchange rate information
€ 1 = £ 0,85 
Last update: 18-01-2025
Lorem ipsum dolor sit amet, consectetur adipiscing elit.
More info
Reference
AAB2808
Property type
House
Bedrooms
4
Bathrooms
2
Habitable space
221 m2
Plot size
3,300 m2
Area
Condom
Department
Gers
Find out more or book a viewing Print Manage my favourites Back Discuss an offer
Details
Bedrooms
4
Bathrooms
2
N° rooms
Habitable space
221 m2
Plot size
3,300 m2
Pool
No
Condition
Neighbours
Drainage
Unknown
Heating
unknown
Income potential
Unknown
Tax fonciere
Energy performance certificate
Estimated annual energy expenditure for typical use approximately € .
Click here for the full details.
Energy performance
A
B
C
D
E
F
G
Gas emission
A
B
C
D
E
F
G
Location
Find out more or book a viewing
This property is listed by Gaelle Perreaux-Booth from our head office. Any questions? Contact us now and we'll get back to you.
Use the form or contact us by email or telephone.
Gaelle Perreaux-Booth
+33 (0)5 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 ...
Array
(
[id] => 305915
)
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 ('305915') 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:03:33') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:03:33') 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:03:33') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:03:33') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASCArray ( [province] => Gers )
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 359100 AND 438900) AND `p`.`province` IN ('gers') 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:03:33') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:03:33') 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 (102) 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:03:33') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:03:33') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY RAND()
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 ('305915') 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:03:33') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:03:33') 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:03:33') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:03:33') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASCArray ( [province] => Gers )
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 359100 AND 438900) AND `p`.`province` IN ('gers') 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:03:33') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 13:03:33') 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 (102) 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:03:33') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 13:03:33') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY RAND()
€372,500
€371,000
€420,000
