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.approved = 1 AND pm.cat_id IN (43,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
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`.`featured` IN ('1') AND p.approved = 1 AND pm.cat_id IN (43,39,40,41,162,163)
GROUP BY p.id
ORDER BY RAND()
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.approved = 1 AND pm.cat_id IN (43,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 981 - 1000 of 4189
€595,000
TSEA5117206
- Nagüeles, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 127 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 127 Area: Marbella Region: Andalucía
This spacious and light-filled duplex penthouse is located in the well-established residential community of Altavista, Nagüeles – one of Marbella's most desirable and quiet neighbourhoods, ideally (...)
€995,000
TSEA5117146
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 166 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 166 Area: San Pedro Region: Andalucía
Discover a rare opportunity to own an exceptionally spacious apartment on the 4th floor of a sought-after complex in Guadalmina Alta. Perfectly positioned in one of the area's most desirable (...)
€650,000
TSEA5117035
- Nagüeles, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 137 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 137 Area: Marbella Region: Andalucía
NEW PRICE..MOTIVATED VENDOR. Super opportunity to obtain a spacious apartment in the Golden Mile, within the sought-after area of Nagūeles.
Gated community with concierge.
The community within which (...)
€400,000
TSEA5117008
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 151 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 151 Area: Marbella West Region: Andalucía
This elegant apartment in residential complex, located in Nueva Andalucía, Marbella, has been fully renovated, offering a modern and sophisticated living space. With 150 m² of built area, the (...)
€395,000
TSEA5116978
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
Charming 2‑Bedroom, 2‑Bathroom Apartment with Sea & Mountain Views – Just West of Estepona
This light-filled first-floor apartment sits within a contemporary, five-year-old development (...)
€320,000
TSEA5116954
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 1 Baths: 1 M2: 83 Area: San Pedro Region: Andalucía
Beds: 1 Baths: 1 M2: 83 Area: San Pedro Region: Andalucía
The origin of a new way of living in Marbella
The first residential project in a new district set to transform the lifestyle in Marbella.
More than just a new development, this development is the (...)
€729,000
TSEA5116945
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 2 M2: 186 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 2 M2: 186 Area: San Pedro Region: Andalucía
The origin of a new way of living in Marbella
The first residential project in a new district set to transform the lifestyle in Marbella.
More than just a new development, this development is the (...)
€565,000
TSEA5116939
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 130 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: San Pedro Region: Andalucía
The origin of a new way of living in Marbella
The first residential project in a new district set to transform the lifestyle in Marbella.
More than just a new development, this development is the (...)
€485,000
TSEA5116936
- Los Almendros, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 96 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 96 Area: Marbella West Region: Andalucía
Apartments likes this don't come on to the market very often!
Situated in a true boutique development of just 12 apartments with communal garden and pool, this first floor unit offers unparalleled (...)
€395,000
TSEA5116924
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 108 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: San Pedro Region: Andalucía
The origin of a new way of living in Marbella
The first residential project in a new district set to transform the lifestyle in Marbella.
More than just a new development, this development is the (...)
€495,000
TSEA5116888
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Elegant Duplex Penthouse with 2 Private Garage Spaces + Storage Room
This beautifully maintained duplex penthouse is move-in ready — perfect as a holiday retreat, year-round residence, or (...)
€335,000
TSEA5116693
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic apartment with sea views located in El Faro.
It features two double bedrooms with built-in wardrobes and two full bathrooms.
This sunny apartment faces south and offers beautiful sea views. (...)
€360,000
TSEA5116687
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 136 Area: Mijas and Mijas Costa Region: Andalucía
STUNNING ULTRA LUXURY/MODERN APARTMENT in front line Mijas Golf location. Refurbished to the very highest of standards. The property consists of a spacious lounge/dining room, modern fully fitted (...)
€895,000
TSEA5116642
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 168 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 168 Area: San Pedro Region: Andalucía
3 bed duplex penthouse in La Gavia, San Pedro, Marbella
THE PROPERTY:
Beautiful beachside west facing 3 bedroom duplex penthouse apartment walking distance to the San Pedro village and just 200 (...)
€380,000
TSEA5116609
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 76 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 76 Area: Marbella Region: Andalucía
Newly renovated apartment with aprox 5 min walk to the beach. It is a farmacy in the building. Parking is outside.
There is parking space in the basement that you can purchase upon (...)
€235,000
TSEA5116597
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 1 M2: 103 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 1 M2: 103 Area: Fuengirola Region: Andalucía
Discover this delightful 3-bedroom apartment in the heart of Andalucía, Málaga, priced at €235,000. Spanning 103m², this residence boasts high ceilings and abundant natural light, creating a (...)
€257,000
TSEA5116588
- Cerros del Aguila, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Charming apartment located in Cerros de Águila in a quiet complex offering the perfect combination of comfort and convenience.
All exterior, with a 23 m2 living-dining room, terrace, and separate, (...)
€320,000
TSEA5116579
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 106 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Area: Casares Region: Andalucía
Spectacular Home in Casares Costa
We are delighted to present this magnificent property located in one of the most sought-after areas of the Costa del Sol, just 10 minutes from the beach and (...)
€375,000
TSEA5116570
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 152 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 152 Area: Estepona Region: Andalucía
Elegant Ground-Floor Apartment with Private Terrace, Two En-Suite Bedrooms, and Direct Garden Access – Perfect for Living or Investment
Located in the exclusive residential complex La Cartuja del (...)
€995,000
TSEA5116504
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 148 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 148 Area: Fuengirola Region: Andalucía
Unique property with AMAZING SEA VIEWS located in the lower area of El Higuerón (Fuengirola). PRIME LOCATION at only 400 mts from the beach and 250 mts from Carvajal train station.
Modern CORNER (...)
Current Featured Properties
€368,400
TSEA5063941
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 58 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 58 Area: Mijas and Mijas Costa Region: Andalucía
A modern apartment complex is an innovative development of 116 one-bedroom loft-style apartments, designed for those seeking style, functionality, and excellent value for money. At this residential (...)
€4,300,000
EMPTY
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 7 Baths: 5 M2: 330 Area: Marbella West Region: Andalucía
Beds: 7 Baths: 5 M2: 330 Area: Marbella West Region: Andalucía
URB. NINE LIONS, NUEVA ANDALUCIA, MARBELLA
A truly unique and stunning fully private 7-bed apartment located in urb. Nine Lions, Nueva Andalucia, a sought after and well secured urbanisation with 53 (...)
€1,350,000
TSEA4752841
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 119 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 119 Area: Estepona Region: Andalucía
redefining contemporary living in the Golden Triangle. A sublimely stylish development, discretely blending with its surrounding environment, the 88 units of Naya Residences offer the discerning (...)
