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 (41,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 (41,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 (41,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 541 - 560 of 3894
€1,200,000
TSEA5134417
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 144 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 144 Area: Fuengirola Region: Andalucía
NEW ON THE MARKET: Newly completed luxury residence in Reserva del Higuerón – €1,200,000 – ready for immediate viewing!
This stunning resale unit has just been completed and is move-in ready. (...)
€200,000
TSEA5134408
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 1 M2: 45 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 1 M2: 45 Area: La Duquesa Region: Andalucía
This is a fabulous first floor apartment located in Hacienda Guadalupe near to the popular marina of La Duquesa, with a fabulous selection of restaurants, bars and shops. This property is in (...)
€450,000
TSEA5134405
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 3 M2: 162 Area: Manilva Region: Andalucía
Beds: 3 Baths: 3 M2: 162 Area: Manilva Region: Andalucía
This 3-bedroom, 3-bathroom apartment boasts a stunning 30m² terrace with panoramic sea views. The apartment is very well-maintained, fully furnished, and features underfloor heating, which is very (...)
€499,000
TSEA5134372
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 3 M2: 170 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 3 M2: 170 Area: La Duquesa Region: Andalucía
PENTHOUSE WITH SPECTACULAR PANORAMIC SEA VIEWS IN A PRIVATE GATED COMMUNITY BETWEEN SOTOGRANDE AND PUERTO DE LA DUQUESA.Privileged location in a beautiful private urbanization with 24-hour security, (...)
€268,000
TSEA5134366
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 104 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 104 Area: Mijas and Mijas Costa Region: Andalucía
SPACIOUS 3-BEDROOM APARTMENT WITH GARAGE IN LAS LAGUNAS – LOS RÍOS AREA, MIJAS
We present this spacious apartment in one of the most practical and established areas of Las Lagunas de Mijas, (...)
€639,000
TSEA5134273
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 102 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 102 Area: Malaga Region: Andalucía
In the very heart of Málaga's historic centre, on the corner of two charming pedestrian streets, lies one of those treasures that makes the hearts of architecture lovers beat faster. This is not a (...)
€880,000
TSEA5134267
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 306 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 306 Area: San Pedro Region: Andalucía
We invite you to explore this remarkable 4 bedroom penthouse that offers spectacular 180º sea views and epitomizes the perfect blend of location, space, and functionality. Nestled in one of the most (...)
€560,000
TSEA5134201
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
This centrally located apartment is a perfect combination for those who want a modern accommodation but at the same time close to the old town. You'll walk down to the old town in a few minutes where (...)
€375,000
TSEA5133712
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 87 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 87 Area: Marbella Region: Andalucía
Flawless 1-Bedroom Oasis with Ocean Breeze & City Access
1-Bedroom Apartment with Private Terrace – Steps from the Beach This stylish and exceptionally well maintained 1-bedroom apartment (...)
€530,000
TSEA5133631
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 85 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Marbella West Region: Andalucía
Located in one of the newest blocks of the sought-after Los Naranjos de Marbella complex, this beautifully presented ground-floor apartment offers the perfect blend of modern convenience, abundant (...)
€335,000
TSEA5133625
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 148 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 148 Area: Mijas and Mijas Costa Region: Andalucía
Opportunity, new on the market!!
Beautiful penthouse with a large sunny terrace with panoramic views, 100% privacy and tranquility, located in the heart of Las Lagunas de Mijas.
The property is (...)
€740,000
TSEA5133550
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 170 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 170 Area: Marbella West Region: Andalucía
This stunning two-bedroom ground floor apartment, located in one of the most prestigious urbanisations in Puerto Banús with 24-hour security, is a true gem. Recently renovated to the highest (...)
€690,000
TSEA5133538
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
Stunning 2-Bedroom Penthouse in Terrazas de Atalaya, Estepona
Built in 2018, this stylish 2-bedroom, 2-bathroom apartment offers a modern, light-filled living experience. The standout feature is the (...)
€379,000
TSEA5133526
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 125 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Estepona Region: Andalucía
Discover this stunning 3-bedroom, 2-bathroom penthouse duplex located in the sought-after Selwo area of Estepona. Boasting a spacious 30 m² terrace with elegant glass curtains and a 60 m² solarium (...)
€1,995,000
TSEA5133523
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Estepona Region: Andalucía
Stunning, recently renovated, apartment on the beach close to Estepona town!
This fully renovated apartment offers beautiful views of the surrounding landscape and sea. With underfloor heating and a (...)
€1,895,000
TSEA5133517
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 126 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 126 Area: Estepona Region: Andalucía
Beachfront luxury apartment close to Estepona town!
This ground-floor apartment offers the perfect blend of luxury and tranquility. The apartment has direct access to a private terrace and lush (...)
€295,000
TSEA5133478
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 125 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: La Duquesa Region: Andalucía
Middle Floor Apartment, La Duquesa, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 125 m², Terrace 52 m².
Setting : Frontline Golf, Close To Golf, Close To Port, Close To Sea, Close To Town, Close (...)
€270,000
TSEA5133460
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 1 M2: 75 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 1 M2: 75 Area: San Pedro Region: Andalucía
Amazing apartment in the heart of San Pedro with proximity to all the services that provides the town: farmacies, restaurants, supermarkets, schools, sports centres.
Very bright with south (...)
€249,000
TSEA5133445
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 70 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Casares Region: Andalucía
BEAUTIFUL GROUND-FLOOR APARTMENT WITH SPACIOUS TERRACE AND PLEASANT GARDEN VIEWS, CASARES COSTA.
Located in Casares Costa, an up-and-coming area that combines peace, nature, and excellent future (...)
€449,000
TSEA5133442
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 84 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 84 Area: Mijas and Mijas Costa Region: Andalucía
FOR SALE – PENTHOUSE WITH PRIVATE SOLARIUM AND PANORAMIC VIEWS IN UPPER CALAHONDA – MIJAS
Discover this stunning 2-bedroom penthouse, fully renovated and located in a peaceful (...)
Current Featured Properties
€415,000
TSEA4148092
- San Roque, Costa Del Sol, San Roque
Beds: 2 Baths: 2 M2: 98 Area: San Roque Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: San Roque Region: Andalucía
OASIS OF TRANQUILITY CLOSE TO BEACHES.
New release! A great opportunity to buy an off plan apartment at an UNBEATABLE PRICE. The apartment style is light and bright with large open plan living (...)
€375,000
TSEA4428991
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
This is a place to start living, with an excellent location. Mijas has an environment in constant movement, offering a wide variety of services, leisure, health centers, schools or shopping centers. (...)
€965,000
TSEA4955521
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 167 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 167 Area: Casares Region: Andalucía
A private beach right on your doorstep. Turquoise waters in a tropical setting. An exclusive Mediterranean-style residential complex. Homes with large terraces and high-quality finishes. 38 (...)
