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 401 - 420 of 5891
€695,000
TSEA5144791
- Alhaurín de la Torre, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 3 M2: 230 Lot Size: 1,382 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 3 M2: 230 Lot Size: 1,382 Area: Mijas and Mijas Costa Region: Andalucía
With incredible views down the valley to the coast of Málaga and the sea, this impressive, detached villa can be used as either a spacious family home or has the possibility of being a high-end (...)
€249,950
TSEA5144770
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
This urbanization is very desirable. The views are incredible. And it is very quiet. It is located in Calahonda with restaurants and shops not far away, two minutes by car. The beach and connections (...)
€620,000
TSEA5144746
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 200 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Area: Marbella Region: Andalucía
a highly sought-after area where no more construction is allowed: exceptional apartment with 3 spacious bedrooms, with east-west orientation and panoramic views of the sea and the hills of Mijas (...)
€245,000
TSEA5144743
- Recinto Ferial, Costa Del Sol
Beds: 3 Baths: 2 M2: 97 Region: Andalucía
Beds: 3 Baths: 2 M2: 97 Region: Andalucía
Exclusively available, this spacious and bright apartment features three bedrooms and two full bathrooms (one of them en suite). It is located in the Recinto Ferial area of Fuengirola, just a short (...)
€780,000
TSEA5144722
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 142 Lot Size: 146 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 142 Lot Size: 146 Area: Marbella Region: Andalucía
Welcome to your dream getaway on the Costa del Sol — a bright and spacious apartment designed for effortless beachside living, just a 12-minute walk from the world-famous Puerto Banús.
Located (...)
€727,500
TSEA5144161
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 99 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 99 Area: Torremolinos Region: Andalucía
Middle Floor Apartment, Torremolinos las torres de playamar, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 99 m².
with turistic licence
Community fee all included
Setting : Beachfront, Town, Close (...)
€359,000
TSEA5144158
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Discover your oasis in lower Riviera del Sol, Mijas Costa!
Charming apartment, which without a doubt, is located in the best complex of Riviera del Sol. It is a rare pearl and situated in the lower (...)
€2,390,000
TSEA5144125
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 4 M2: 296 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 4 M2: 296 Lot Size: 800 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular villa that perfectly blends Mediterranean style with contemporary design, combining traditional charm with modern comfort and top-quality finishes. Located in the prestigious Buena Vista (...)
€699,000
TSEA5144080
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 159 Lot Size: 21 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 159 Lot Size: 21 Area: Estepona Region: Andalucía
Welcome to your sun-kissed paradise on the sought-after New Golden Mile of Estepona, renowned for its sunny skies, golden sands and crystal-clear waters.
With just 25 stunning apartments, you'll get (...)
€985,000
TSEA5144044
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 6 Baths: 4 M2: 218 Area: Fuengirola Region: Andalucía
Beds: 6 Baths: 4 M2: 218 Area: Fuengirola Region: Andalucía
Corner villa in Puebla Lucía, the most exclusive residential area in Fuengirola
In the heart of Fuengirola, within the prestigious and gated community of Puebla Lucía, lies this bright (...)
€569,000
TSEA5144038
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Welcome to your sun-kissed paradise on the sought-after New Golden Mile of Estepona, renowned for its sunny skies, golden sands and crystal-clear waters.
With just 25 stunning apartments, you'll get (...)
€535,000
TSEA5144026
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Magnificent apartment with large terrace and sea views!!!!, Close to everything!!!, In the heart of the most wanted LA CALA de Mijas!!!
With a large terrace and sea views to enjoy year-round, (...)
€680,000
TSEA5143975
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
Exclusivity, Design & Location: Your New Home on the Costa del Sol
Introducing a unique residence, fully renovated to perfection, set in one of the most sought-after areas of the Costa del Sol. (...)
€850,000
TSEA5143966
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 4 Baths: 3 M2: 132 Area: Nerja and Malaga East Region: Andalucía
Beds: 4 Baths: 3 M2: 132 Area: Nerja and Malaga East Region: Andalucía
Cartujano Villas – Luxury and Privacy Just Steps from Burriana Beach
Discover Cartujano Villas, an exclusive collection of only four detached villas in the heart of Nerja, just a short walk from (...)
€995,000
TSEA5143927
- Nerja, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 3 M2: 580 Lot Size: 701 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 3 M2: 580 Lot Size: 701 Area: Nerja and Malaga East Region: Andalucía
This historic property is a large renovated old Mill, previously a working flour mill for the Larios family until approximately 60 years ago named Molino San Jose. The villa has three bedrooms, three (...)
€1,595,000
TSEA5143915
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 388 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 388 Area: Marbella Region: Andalucía
*Luxurious 3-Bedroom Duplex Penthouse in Prestigious Sierra Blanca*
Discover this expansive 3-bedroom duplex penthouse located in the highly sought-after area of Sierra Blanca. This exquisite (...)
€1,695,000
TSEA5143909
- La Mairena, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 254 Lot Size: 2,750 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 254 Lot Size: 2,750 Area: Marbella East Region: Andalucía
Spacious Family Villa with Panoramic Views in La Mairena
This beautifully presented villa in La Mairena was originally built in 2009 and tastefully renovated in 2021, bringing it up to modern (...)
€1,100,000
TSEA5143897
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 121 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 121 Area: Benahavis Region: Andalucía
This stunning top floor apartment., set within the prestigious La Quinta Golf resort, offers an elegant & sophisticated interior with breathtaking panoramic views.
Having been renovated recently (...)
€1,869,000
TSEA5143879
- Casares, Costa Del Sol, Casares
Beds: 4 Baths: 4 M2: 210 Area: Casares Region: Andalucía
Beds: 4 Baths: 4 M2: 210 Area: Casares Region: Andalucía
Luxury villa with unrivalled Mediterranean views – Camarate del Golf, Casares Costa
In the privileged setting of Camarate del Golf, one of the most exclusive residential areas of Casares Costa, (...)
€495,000
TSEA5143876
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Discover this stunning, fully furnished apartment in the heart of Estepona, offering modern luxury and comfort. Recently renovated with top-quality materials, it features a spacious three-bedroom (...)
Current Featured Properties
€2,310,000
Beach-Side Luxury Apartments with Panoramic Views, Estepona
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 114 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 114 Area: Estepona Region: Andalucía
UNIQUE BOUTIQUE DEVELOPMENT BEACHSIDE ESTEPONA!!!!!
A special opportunity to own one of 9 apartments in a new beachside development close to the marina of Estepona. This PREMIUM LUXURY apartment (...)
€1,130,000
TSEA4340668
- Las Chapas, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 175 Lot Size: 162 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 175 Lot Size: 162 Area: Marbella East Region: Andalucía
YOUR DREAM COME TRUE!!!
Located in one of the most exclusive areas of Marbella, a city that stands out for its beauty, elegance and VIP facilities. Stores of the most premium brands and (...)
€530,000
TSEA4761718
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 4 Baths: 2 M2: 120 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 2 M2: 120 Area: Algeciras Region: Andalucía
We´re happy to present a new flagship project in La Alcaidesa, San Roque, just 10 minutes from Sotogrande, with spectacular views of the Mediterranean Sea, the golf course and Gibraltar.
Superb (...)
