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 (44,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 (44,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 (44,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (2652), Middle Floor - (2652), Penthouse - (2652), Top Floor Apartment - (2652), Penthouse Duplex - (2652)Properties
Results 2621 - 2640 of 3924 €699,000
TSEA4974349
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 2 M2: 158 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 2 M2: 158 Area: Nerja and Malaga East Region: Andalucía
Exclusive penthouse in the heart of Nerja, spectacular sea views with both sunrise and sunset from the terraces.
Large well-planned penthouse with 3 bedrooms and 2 bathrooms, wonderful terraces with (...)
€1,795,000
TSEA4974301
- Ojén, Costa Del Sol, Ojen
Beds: 3 Baths: 3 M2: 193 Area: Ojen Region: Andalucía
Beds: 3 Baths: 3 M2: 193 Area: Ojen Region: Andalucía
Experience unmatched luxury and sophistication in this stunning ground floor apartment situated within the prestigious Los Pinsapos building, nestled in the highly desirable Palo Alto, Ojen area. (...)
€850,000
TSEA4974064
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 100 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Malaga Region: Andalucía
Just a few steps from the historic Atarazanas Market, this duplex penthouse offers a rare mix of character and modern design. The building has been fully renovated, preserving its charm while (...)
€4,850,000
TSEA4973995
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 6 M2: 199 Area: Estepona Region: Andalucía
Beds: 4 Baths: 6 M2: 199 Area: Estepona Region: Andalucía
Exclusive Beachfront Duplex Penthouse in The Sapphire, Estepona
A Rare Opportunity to Own a Piece of Paradise
Welcome to The Sapphire, an ultra-exclusive beachfront development in Estepona, where (...)
€1,420,000
TSEA4973818
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 3 M2: 150 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 3 M2: 150 Area: Marbella West Region: Andalucía
This stunning 2-bedroom, 2-bathroom penthouse is located in the newly built luxury complex, Nine Lions Residences. Set within an exclusive gated community, the apartment offers breathtaking panoramic (...)
€465,000
TSEA4973716
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 139 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Area: Marbella East Region: Andalucía
This is a rare opportunity to purchase an incredible home or luxury vacation apartment in the exclusive La Mairena area.
Outstanding very large corner three bedroom first floor apartment set in sub (...)
€810,000
TSEA4973569
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 135 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: Marbella West Region: Andalucía
Stunning 2-Bedroom Apartment with Panoramic Views in Marbella
Discover this amazing 2-bedroom apartment, perfectly situated on a privileged hillside position, offering the best panoramic views over (...)
€1,150,000
TSEA4973542
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 270 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 270 Area: Estepona Region: Andalucía
Located in the prestigious Dominion Beach area of Estepona East, this luxurious duplex penthouse offers a combination of elegant living and unbeatable convenience. Situated along the renowned New (...)
€1,050,000
TSEA4973533
- Martiricos, Costa Del Sol
Beds: 3 Baths: 2 M2: 143 Region: Andalucía
Beds: 3 Baths: 2 M2: 143 Region: Andalucía
Discover life in the heights in this impressive brand new penthouse, located on the 28th floor of an emblematic 29-story building in the heart of Malaga. This luxurious property offers a unique (...)
€450,000
TSEA4973422
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 95 Lot Size: 55 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 95 Lot Size: 55 Area: Estepona Region: Andalucía
Unique opportunity in the heart of Estepona!
Beautiful duplex penthouse for sale in the exclusive Edificio Los Cármenes, located in the heart of Estepona. This property offers an ideal space to (...)
€439,900
TSEA4973374
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Bright and spacious 3-bedrooms apartment, with natural light streaming through the windows, creating the perfect start to your day. This brand-new, key-ready apartment is not just a place to live – (...)
€549,000
TSEA4973215
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 93 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Area: Fuengirola Region: Andalucía
Brand new apartment with sea view in El Higueron.
This modern first-floor apartment features three bedrooms and two bathrooms.
The open-plan kitchen seamlessly connects to a bright living and (...)
€469,000
TSEA4973131
- Teatinos, Costa Del Sol, Malaga
Beds: 4 Baths: 2 M2: 110 Area: Malaga Region: Andalucía
Beds: 4 Baths: 2 M2: 110 Area: Malaga Region: Andalucía
**Exceptional Opportunity in Teatinos, Málaga: Ideal for Families and a Great Investment**
This 4-bedroom, 2-bathroom property is located in one of the most sought-after areas of Málaga, Teatinos. (...)
€793,000
TSEA4973128
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 210 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 210 Area: Benalmadena Region: Andalucía
Opportunity to live in a very spacious PENTHOUSE with solarium of 77m2 where you can enjoy the sun all day.
Recently finished, ALL NEW.
South-West facing.
Panoramic sea and mountain views.
With 3 (...)
€250,000
TSEA4973002
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
SPACIOUS 3-BEDROOM APARTMENT WITH SEA VIEWS IN FOREST HILLS – GREAT VALUE & INVESTMENT POTENTIAL
This bright and generously sized 3-bedroom apartment in the popular Forest Hills area offers (...)
€459,000
TSEA4972981
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 110 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Mijas and Mijas Costa Region: Andalucía
EXCLUSIVE PENTHOUSE IN FINCA SAN ANTONIO – SPACE, COMFORT, AND STUNNING VIEWS
Discover this impressive penthouse in the prestigious Finca San Antonio, a home that offers spacious living, comfort, (...)
€320,000
TSEA4972939
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
This fantastic home in Mijas is perfect for those seeking comfort and tranquility while staying close to all essential services. It is a recently renovated ground-floor property, ready to move into, (...)
€458,000
TSEA4972624
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 168 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 168 Area: Mijas and Mijas Costa Region: Andalucía
First floor NO lift. Just reduced from 489.000 to 458.000 for a quick sale.
This spectacular, recently renovated duplex penthouse is located in the heart of the city, just a few minutes walk from (...)
€285,000
TSEA4972525
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
NO RENTAL LICENSE RESTRICTIONS - GOOD NUMBERS FOR INVESTMENT
Second Line from the Beach in a World Class Resort!
This recently reformed two bedroom unit is ready to be enjoyed or to be put to (...)
€360,000
TSEA4972408
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 78 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Benalmadena Region: Andalucía
Stylish two-bedroom house with sea views in Carvajal
Welcome to this beautifully renovated and fully furnished two-bedroom apartment in the lower part of Carvajal, just a short walk from the (...)
Current Featured Properties
€850,000
TSEA4792021
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 378 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 378 Area: Estepona Region: Andalucía
We are delighted to introduce this fabulous new development in in the beautiful area of Arroyo Enmedio in Estepona – an exclusive new development featuring 48 two and 3-bedroom apartments and (...)
€995,000
TSEA4777597
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
LIGHT FLOODS INTO THE PROPERTY!!!
We will change weight for square meters, color for avant-garde architectural design, clarity for light and size for the best qualities and certified construction (...)
€480,000
TSEA4646746
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Area: Estepona Region: Andalucía
This is a magnificent development comprising fifty-one 2-, 3- and 4-bedroom homes, which also include penthouses with suntrap terraces and community facilities featuring a kiddies' paddling pool, a (...)
