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 (39,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 (39,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 (39,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3910), Middle Floor - (3910), Penthouse - (3910), Top Floor Apartment - (3910), Penthouse Duplex - (3910)Properties
Results 1021 - 1040 of 3899 €466,620
TSEA5110804
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 88 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 88 Area: Marbella Region: Andalucía
We offers UNIQUE OPPORTUNITY IN THE HEART OF MARBELLA!
HIGHLIGHTS:
� Located in the very center of Marbella, just 200 meters from the beach.
* It has garage and terrace of 30 meters.
Discover (...)
€750,000
TSEA5110795
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 152 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 152 Area: Marbella Region: Andalucía
Located in the heart of Nueva Andalucía, just minutes from Puerto Banús, this property in Jardines de Andalucía truly has it all: prime location, generous space, and distinctive character. (...)
€1,395,000
TSEA5110753
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 307 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 307 Area: Marbella East Region: Andalucía
**Exclusive Duplex Penthouse Just 500 Meters from the Beach, in Marbella's Golden Mile**
Located in the sought-after area of Nagüeles, in the iconic Golden Mile of Marbella, this stunning 307 m² (...)
€3,200,000
TSEA5110738
- Bahía de Marbella, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 205 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 205 Area: Marbella East Region: Andalucía
Luxury Duplex Penthouse for Sale in Bahia de Marbella – Exceptional Space, Luxury Fittings, and Unbeatable Location.
Walking distance to the beach 500 m.
Idealf or residential living or as well for (...)
€1,195,000
TSEA5110723
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 123 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Marbella West Region: Andalucía
Modern Duplex Penthouse with Sea Views near Puerto Banús
A light-filled, Scandinavian-style 3-bedroom duplex penthouse located in a new development, just a short walk from the lively harbour of (...)
€399,000
TSEA5110687
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 90 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 90 Area: Estepona Region: Andalucía
Unique Opportunity on a Main Street in the Center of Estepona – Just Steps from the Sea.
Discover this charming apartment located on Estepona's iconic central street, in the heart of the town and (...)
€285,000
TSEA5110684
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
PENTHOUSE WITH SEA VIEWS NEXT TO THE BEACH
Fantastic penthouse located in the Torrequbrada area (Benalmadena costa) just a few minutes walk from the beach close to all kinds of services.
Apartment (...)
€425,000
TSEA5110681
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 92 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 92 Area: Fuengirola Region: Andalucía
This brand-new, fully refurbished residence is finished to the highest standards and ideally located less than 100 meters from the beach in Los Boliches, and within easy reach of Fuengirola town (...)
€228,000
TSEA5110648
- Algeciras, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 100 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Algeciras Region: Andalucía
Ground Floor Apartment with Private Patio in Algeciras, Cádiz
This cozy three-bedroom ground-floor apartment offers a prime location near the center of Algeciras, in a quiet, well-connected private (...)
€279,000
TSEA5110606
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 90 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 90 Area: Estepona Region: Andalucía
FOR SALE: Bright 3-Bedroom Apartment in Estepona – 10 Minutes Walk to the Beach!
Discover this charming and fully renovated 3-bedroom apartment, located just a 10-minute walk from the beautiful (...)
€825,000
TSEA5110600
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 102 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Estepona Region: Andalucía
Modern Living on the New Golden Mile – 2-Bedroom Apartment with Large Private Terrace
This stylish, ground-floor apartment is part of a cutting-edge residential complex in one of Estepona's most (...)
€379,500
TSEA5110576
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 61 Lot Size: 78 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 61 Lot Size: 78 Area: Nerja and Malaga East Region: Andalucía
Apartment with Terrace and Partial Sea Views – Costa Blanca
Modern 2-bedroom, 2-bathroom apartment located in a quiet residential area, just minutes from the sea and with excellent access to (...)
€417,450
TSEA5110552
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 1 M2: 57 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 1 M2: 57 Area: Nerja and Malaga East Region: Andalucía
First-Floor Apartment with Terrace and Sea Views
Modern 2-bedroom, 2-bathroom apartment located in a quiet residential area, just minutes from the sea and with excellent access to local amenities (...)
€429,550
TSEA5110519
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 55 Lot Size: 57 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 55 Lot Size: 57 Area: Nerja and Malaga East Region: Andalucía
Modern Apartment with Terrace and Partial Sea Views – Costa Blanca
This charming first-floor apartment offers a comfortable Mediterranean lifestyle in one of the most sought-after areas of the (...)
€429,550
TSEA5110432
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 2 Baths: 2 M2: 53 Lot Size: 56 Area: Nerja and Malaga East Region: Andalucía
Beds: 2 Baths: 2 M2: 53 Lot Size: 56 Area: Nerja and Malaga East Region: Andalucía
Modern Apartment with Terrace and Partial Sea Views – Costa Blanca
This charming first-floor apartment offers a comfortable Mediterranean lifestyle in one of the most sought-after areas of the (...)
€660,000
TSEA5110402
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 120 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Benahavis Region: Andalucía
Discover this sophisticated 3-bedroom, 2-bathroom apartment, located in an exclusive development with 24-hour security. The property has been carefully refurbished, highlighting a contemporary design (...)
€330,000
TSEA5110336
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 59 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 59 Area: Benahavis Region: Andalucía
New Development: Prices from 330,000 € to 890,000 €. [Beds: 1 - 3] [Baths: 1 - 2] [Built size: 59.00 m2 - 128.00 m2]
Located in the heart of Benahavís, a new residential development is being (...)
€239,000
TSEA5110246
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 90 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: La Duquesa Region: Andalucía
Stunning Apartment for Sale – La Colina, Princesa Kristina, Manilva!
Dreaming of owning a Costa del Sol property?
This 2-bedroom, 2-bathroom apartment in the exclusive La Colina, Princesa Kristina (...)
€227,000
TSEA5110240
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 2 M2: 84 Area: Ojen Region: Andalucía
Beds: 2 Baths: 2 M2: 84 Area: Ojen Region: Andalucía
Middle Floor Apartment, Ojén, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 84 m².
Setting : Town, Village, Mountain Pueblo, Close To Shops, Close To Schools.
Orientation : South.
Condition : (...)
€1,380,000
TSEA5110237
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 220 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 220 Area: Marbella West Region: Andalucía
this is an exceptional property for those who wish to enjoy a stay in a privileged location in the center of Puerto Banús, a step away from the Marina, exclusive shops and the best restaurants.
The (...)
Current Featured Properties
€995,000
TSEA4413595
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 162 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 162 Area: San Pedro Region: Andalucía
Located at the heart of the most coveted luxury destination in the world, experience the year-round allure of Europe's finest climate, boasting an average temperature of 20°C and over 300 sun-kissed (...)
€665,000
TSEA4358878
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 112 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Fuengirola Region: Andalucía
A DEVELOPMENT THAT YOU WILL WANT TO VIEW!!!
Spectacular new development of 60 luxury apartments in the most sought-after area of El Higuerón, in a gated exclusive community with gym, heated pool, (...)
€525,000
TSEA5075317
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 4 M2: 102 Area: Casares Region: Andalucía
Beds: 3 Baths: 4 M2: 102 Area: Casares Region: Andalucía
An exclusive residential development in the prime location of Doña Julia Golf, in Casares, Málaga. Designed to offer a unique lifestyle, it combines comfort, nature and luxury in an unbeatable (...)
