Array
(
[id] => 304276
)
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 ('304276') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:58:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:58:52') 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 10:58:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:58:52') 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
Find out more or book a viewing Print Manage my favourites Back Discuss an offer
Provence-Alpes-Côte d'Azur
Alpes-Maritimes
Auron
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 ('304276') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:58:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:58:52') 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 10:58:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:58:52') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASC
An exceptional selection of double triplex apartments
€2,602,505 AZANIC230008
Bedrooms
5
Habitable space
173 m2
Area
Auron
Department
Alpes-Maritimes
Find out more or book a viewing Save to my favourites
An exceptional selection of double triplex apartments
Information on any natural risk, such as flooding, can be obtained via this government website
Mandate type: Delegated Mandate
€2,602,505
£ 2,232,195
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
AZANIC230008
Property type
House , Triplex
Bedrooms
5
Habitable space
173 m2
Area
Auron
Department
Alpes-Maritimes
Find out more or book a viewing Print Manage my favourites Back Discuss an offer
1 Living/dining/kitchen area
5 Bedroom(s)
Details
Bedrooms
5
Bathrooms
0
N° rooms
6
Habitable space
173 m2
Plot size
m2
Pool
No
Condition
New
Neighbours
Drainage
Unknown
Heating
unknown
Income potential
Unknown
Tax fonciere
Energy performance certificate
Energy performance
A
B
C
D
E
F
G
DPE Non Applicable
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] => 304276
)
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 ('304276') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:58:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:58:52') 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 10:58:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:58:52') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASCArray ( [province] => Alpes-Maritimes )
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 2342254 AND 2862755) AND `p`.`province` IN ('alpes-maritimes') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:58:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:58:52') 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,82) 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 10:58:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:58:52') 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 ('304276') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:58:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:58:52') 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 10:58:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:58:52') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY p.street ASCArray ( [province] => Alpes-Maritimes )
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 2342254 AND 2862755) AND `p`.`province` IN ('alpes-maritimes') AND p.access IN (1,1,5) AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2025-01-18 10:58:52') AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2025-01-18 10:58:52') 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,82) 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 10:58:52') AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-01-18 10:58:52') AND c.access IN (1,1,5))) GROUP BY p.id ORDER BY RAND()
€2,750,000
€2,700,000
€2,480,000
