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 (42,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 (42,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 (42,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 501 - 520 of 5891 €479,000
TSEA5141638
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 146 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 146 Area: Mijas and Mijas Costa Region: Andalucía
Triplex apartment in Torrequebrada Golf, Benalmádena.
This elegant 3-bedroom, 3-bathroom duplex apartment has three terrace areas, communal pool, TWO parking spaces, a storage room and three (...)
€245,000
TSEA5141551
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 75 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 75 Area: Marbella Region: Andalucía
Stunning high-floor Apartment for Sale in Marbella
Tourist license for 3 rooms (up to 6 people)
Impressive sea views
Secure building with two new elevators
Prime Location:
Steps away from (...)
€315,000
TSEA5141524
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Mijas and Mijas Costa Region: Andalucía
This stunning and impeccably maintained apartment is perched in the upper part of Calahonda and boasts the most spectacular panoramic sea views in the entire development. It features two spacious (...)
€287,000
TSEA5141515
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 89 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Manilva Region: Andalucía
Renovated Apartment with Terrace and Private Garden – Manilva, Costa del Sol
This elegant 2-bedroom, 2-bathroom apartment, with approximately 89 m² built area and 80 m² usable area, plus a (...)
€570,000
TSEA5141206
- Valle de Abdalajis, Costa Del Sol, Älora
Beds: 4 Baths: 2 M2: 155 Lot Size: 9,573 Area: Älora Region: Andalucía
Beds: 4 Baths: 2 M2: 155 Lot Size: 9,573 Area: Älora Region: Andalucía
CCharming single-story chalet in Valle de Abdalajís, Málaga, offering 155 m² of living space on a 9,573 m² plot. The 288 m² property features a 39 m² porch, 4 spacious bedrooms with fitted (...)
€900,000
TSEA5141179
- La Quinta, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 112 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Area: Benahavis Region: Andalucía
This beautifully designed two-bedroom, two-bathroom apartment offers a harmonious blend of comfort and sophistication in one of the most sought-after areas of the Golf Valley. With 112 m² of (...)
€375,000
TSEA5141125
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 156 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 156 Area: Estepona Region: Andalucía
This beautifully presented west-facing penthouse is modern, stylish, and ready to move into, located within the secure gated community of Bel Air Gardens in Estepona. Enjoying a prime position just (...)
€335,000
TSEA5141053
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
This charming 2-bedroom, 1-bathroom property in Mijas Golf offers comfortable living in a peaceful and well-appointed community. The home features a bright and airy layout with a spacious living area (...)
€5,799,000
TSEA5141032
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 522 Lot Size: 1,545 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 522 Lot Size: 1,545 Area: Benahavis Region: Andalucía
SNEAK PEEK AT CASA ARTOLA: A statement of lifestyle and exclusivity in the hills of Benahavís.
Set on a generous 1,550 m² south-facing plot, CASA ARTOLA captures the essence of refined
Andalusian (...)
€160,000
TSEA5141029
- Casares Pueblo, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 80 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Casares Region: Andalucía
This beautiful house is located in the picturesque village of Casares, in one of its best areas, just 25 meters from a spacious public parking area — a rare convenience in the historic center. (...)
€645,000
TSEA5141023
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 166 Lot Size: 1,150 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 166 Lot Size: 1,150 Area: Marbella Region: Andalucía
Magnificent opportunity! GUADALMINA ALTA. -
Villa to be renovated with a large plot and many opportunities, located in Guadalmina Alta, one of the most sought-after areas of Marbella. Next to the (...)
€595,000
TSEA5141020
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 64 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 64 Area: Marbella West Region: Andalucía
This apartment is the perfect combination of luxury, design and technology in one of Marbella's most sought-after locations. As soon as you walk in, natural light floods every corner and the direct (...)
€1,250,000
TSEA5141002
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 241 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 241 Area: Marbella West Region: Andalucía
This is a refined duplex penthouse set within the gated community of Aloha Gardens in Nueva Andalucía. This property presents a well-balanced combination of modern design and a prime location in one (...)
€749,995
TSEA5140993
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 281 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 281 Area: Fuengirola Region: Andalucía
Another amazing property in Higueron, with a strong rental history making it an attractive investment!
This unique corner apartment is located in one of the most sought-after areas on Costa del Sol. (...)
€7,500,000
TSEA5140987
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 17 Baths: 11 M2: 1,727 Lot Size: 3,400 Area: Marbella West Region: Andalucía
Beds: 17 Baths: 11 M2: 1,727 Lot Size: 3,400 Area: Marbella West Region: Andalucía
An exceptionally prestigious and exclusive luxury residence with 17 rooms and 11 bathrooms – far beyond the ordinary!
Outstanding social areas designed for recreation, entertaining, and gatherings. (...)
€1,595,000
TSEA5140984
- Elviria, Costa Del Sol, Marbella East
Beds: 5 Baths: 3 M2: 251 Lot Size: 1,755 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 3 M2: 251 Lot Size: 1,755 Area: Marbella East Region: Andalucía
Discover your dream home in this beautifully designed one-level residence, bathed in natural light and featuring direct access to a stunning pool. With five spacious bedrooms and three modern (...)
€2,000,000
TSEA5140972
- Tarifa, Costa de la Luz
Beds: 6 Baths: 6 M2: 750 Lot Size: 3,200 Region: Andalucía
Beds: 6 Baths: 6 M2: 750 Lot Size: 3,200 Region: Andalucía
Located in one of the most sought-after areas of Tarifa, this stunning recently renovated villa offers a unique experience of luxury, comfort, and privacy. Surrounded by a peaceful and natural (...)
€355,000
TSEA5140963
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 82 Area: Marbella Region: Andalucía
✨ Living next to the Artola dunes and the best beach in Marbella ✨
Located in Artola Baja (Cabopino), just 200 meters from the protected natural area of the Artola Dunes and 450 meters (...)
€3,985,000
TSEA5140945
- El Madroñal, Costa Del Sol, San Pedro
Beds: 5 Baths: 5 M2: 380 Lot Size: 1,161 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 5 M2: 380 Lot Size: 1,161 Area: San Pedro Region: Andalucía
This elegantly renovated luxury villa offers a refined lifestyle within an exclusive, secure gated complex. Enjoying a desirable south to south- east orientation, the property boasts breathtaking sea (...)
€1,100,000
TSEA5140939
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 112 Lot Size: 68 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Lot Size: 68 Area: Benahavis Region: Andalucía
The luxurious 3-bedroom ground floor apartment is located in Aqualina residences with a south-facing orientation and views of the swimming pool and the sea and offers the latest technology and (...)
Current Featured Properties
€587,000
Middle Floor Apartment in Los Monteros
- Los Monteros, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Marbella East Region: Andalucía
LUXURY TO ITS HIGHEST STANDARD!!!
A development of 39 luxury apartments. Located in the upper part of Los Monteros, this contemporary design development distributed over 5 floors plus an attic, has (...)
€850,000
TSEA4446319
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 2 Baths: 2 M2: 133 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Sotogrande Region: Andalucía
STUNNING NEW HOMES IN VILLAGE COMMUNITY SETTING!!!!
Exclusive Village Community in prestigious Sotogrande area. SPACIOUS AND CONTEMPORARY apartments have been created around an exclusive Village (...)
€476,700
TSEA4289707
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 118 Lot Size: 20 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Lot Size: 20 Area: Benahavis Region: Andalucía
A HOME YOU WILL NEVER WANT TO LEAVE!!!
The homes in this development are designed to offer you everything you need. On the ground floor you will have a garden and wine cellar, and on the top floor (...)
