SELECT p.*, p.id AS id, p.title AS title, p.street_num, p.street, p.surface_area_terrace, p.street2, p.description as description, p.created as created, p.sea_view, p.golf_close, p.beds, p.province, p.alias as alias, p.listing_info, pm.cat_id FROM psi48_iproperty AS p LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND `p`.`id` IN ('318842') AND p.approved = 1 GROUP BY p.id ORDER BY p.street ASC
More photos

5 bedroom property near Aloha

Price: €2,995,000 | TSEA4348249

Spectacular villa located on the front line of one of the most famous golf courses, Aloha Golf. This villa offers panoramic views of the golf course and the mountains. It has five bedrooms and four bathrooms and all offer beautiful views. There is also a large living room with fireplace and fully renovated kitchen. The villa also has several terraces where you can enjoy the fantastic views and of the golfcourse.

Setting

Close To Golf
Close To Sea
Frontline Golf

Pool

Private

Climate Control

Fireplace

Views

Golf
Mountain
Panoramic
Pool

Condition

Excellent

Category

Golf

Garden

Private
Back More Info Contact us
Beds : 5
Baths : 4
Habitable Size : 400 m2
Land Size : 1,200 m2
Terrace Space : 500 m2
Pool : Yes

Location


Andalucía
Marbella West
Aloha

Find out more or book a viewing


Want to book a viewing? Need more information? We’re here to help. Use this form, call us or send an email and we’ll get right back to you.

If you have dates for a trip to the area, let us know - we’d be glad to meet you

office

 Avenida España 250
Estepona
29680

 +34 951 516 905

 Email office

Invalid Input

Invalid Input

Invalid Input

Invalid Input

Invalid Input

You might also like ...


SELECT p.*, p.id AS id, p.title AS title, p.street_num, p.street, p.surface_area_terrace, p.street2, p.description as description, p.created as created, p.sea_view, p.golf_close, p.beds, p.province, p.alias as alias, p.listing_info, pm.cat_id FROM psi48_iproperty AS p LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND `p`.`id` IN ('323066') AND p.approved = 1 GROUP BY p.id ORDER BY p.street ASC SELECT p.id AS id, p.mls_id, p.pool, p.price, p.call_for_price, p.show_map, p.hide_address, p.price2, p.surface_area_terrace, p.stype_freq, p.title AS title, p.beds, p.baths, p.sqft, p.lot_acres, p.lotsize, p.street_num, p.street, p.street2, p.province, p.apt, p.golf_close, p.sea_view, 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 psi48_iproperty AS p LEFT JOIN psi48_iproperty_propmid as pm ON pm.prop_id = p.id WHERE pm.cat_id != 0 AND `p`.`city` IN ('sedella') AND `p`.`locstate` IN ('5') AND `p`.`region` IN ('andalucía') AND p.approved = 1 GROUP BY p.id ORDER BY price ASC
| €90,000
| €223,000
| €298,000
| €320,000
| €365,000
| €425,000