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 - (3910), Middle Floor - (3910), Penthouse - (3910), Top Floor Apartment - (3910), Penthouse Duplex - (3910)Properties
Results 201 - 220 of 3924
€320,000
TSEA5150062
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Located in the heart of Marbella, this cozy 1-bedroom, 1-bathroom apartment is an excellent opportunity for both primary residence and investment. Facing east, it enjoys pleasant natural light and (...)
€230,000
TSEA5150041
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 40 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 40 Area: Mijas and Mijas Costa Region: Andalucía
Your perfect getaway on the Costa del Sol awaits!
We are pleased to present this fantastic brand-new apartment (built in 2023) located in Mijas, right in the heart of the Costa del Sol — one of the (...)
€695,000
TSEA5149942
- San Roque Club, Costa Del Sol
Beds: 3 Baths: 3 M2: 193 Region: Andalucía
Beds: 3 Baths: 3 M2: 193 Region: Andalucía
This elegant penthouse, fully renovated and beautifully decorated in a modern style, offers a unique living space in the exclusive setting of San Roque Club. With stunning sea views and surrounded by (...)
€280,000
TSEA5149936
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 71 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 71 Area: Casares Region: Andalucía
Penthouse with Solarium and Panoramic Sea Views in Casares Playa
This exclusive penthouse with a private solarium in Casares Playa combines space, natural light, and a privileged location on the (...)
€875,000
TSEA5149927
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 147 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 147 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular 3 bedrooms apartment with panoramic views of the sea facing the Calanova Golf Course.
The property is located in the middle of the complex, it enjoys fantastic views and privacy.
It has a (...)
€540,000
TSEA5149918
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 127 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Manilva Region: Andalucía
This stunning apartment is located in Los Granados de Duquesa, Manilva, Málaga, a prime beachfront location. Thoughtfully designed and in excellent condition, this property offers a luxurious and (...)
€359,000
TSEA5149888
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Marbella East Region: Andalucía
This is a very attractive modern apartment located in an elevated spot above the beaches of Elviria and East Marbella. Located in the high end enclave of La Maiirena an area occupied by luxury (...)
€580,000
TSEA5149873
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 84 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 84 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€343,000
TSEA5149855
- Málaga Centro, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 50 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 50 Area: Malaga Region: Andalucía
Tourist-Licensed Apartment in the Heart of Málaga – La Merced Area
Turnkey investment with proven high returns!
Located just a few steps from the iconic Plaza de la Merced, this modern apartment (...)
€370,000
TSEA5149840
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€475,000
TSEA5149831
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Mijas and Mijas Costa Region: Andalucía
The spacious apartment to reform with 2-bedroom, 2-bathroom (one en suite) is located in an exclusive frontline beach complex in Calahonda. Situated on the third floor with lift access, it boasts a (...)
€370,000
TSEA5149801
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€425,000
TSEA5148742
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
ELVIRIA. LOVELY APARTMENT WITH GREAT POTENTIAL SITUATED ON THE TOP FLOOR IN THE CENTRAL URBANIZATION OF PARQUE ELVIRIA. THE APARTMENT IS 105 m2 INCLUDING TERRACES. THE APARTMENT HAS 3 BEDROOMS AND 2 (...)
€400,000
TSEA5148733
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 1 Baths: 1 M2: 71 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 1 M2: 71 Area: Marbella East Region: Andalucía
Beautiful one bedroom apartment with spacious lounge dining room, fitted kitchen and terrace. Property has air conditioning, marble floors, 1 storage room and a parking space in the underground (...)
€185,000
TSEA5148727
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Discover the charm of this beautiful and spacious studio, which was originally a cozy one-bedroom apartment. Located in a prime location, you'll enjoy spectacular sea views from the comfort of your (...)
€315,000
TSEA5148703
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 78 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 78 Area: Torremolinos Region: Andalucía
FLAT FOR SALE IN TORREMOLINOS
Beautiful, sunny flat for sale, built in 2007 with high-quality finishes, located on the second floor of a building with a lift and only seven neighbours, completely (...)
€315,000
TSEA5148673
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
spacious 3 bed 2 bath apartment centrally located
large communal pool
in need of some updating
located close to shops and restaurants
Middle Floor Apartment, Las Lagunas, Costa del Sol.
3 (...)
€285,000
TSEA5148664
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic apartment located in Las Lagunas.
Discover this fantastic 126 m2 apartment located in the coveted area of Las Lagunas.
The property features three bedrooms, all equipped with (...)
€595,000
TSEA5148604
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 152 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 152 Area: Mijas and Mijas Costa Region: Andalucía
Bright and Spacious 3 Bed Corner Apartment with Stunning Views, Private Terrace and Premium Facilities
Welcome to this inviting 3-bedroom apartment in the sought-after Las Olas complex in (...)
€535,000
TSEA5148583
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
This four-bedroom flat, situated in the heart of Marbella, Malaga, presents an exceptional opportunity for those seeking a well-located property with substantial potential. Set within a gated (...)
Current Featured Properties
€732,000
Middle Floor Apartment in Atalaya
- Atalaya, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 121 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 121 Area: Estepona Region: Andalucía
FANTASTIC LOCATION NEAR MARBELLA!!!
A new development of apartments (2 or 3 bedrooms available) in the privileged area of Atalaya. This area is close to all services and surrounded by golf (...)
€850,000
TSEA5020489
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 3 M2: 131 Lot Size: 33 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 3 M2: 131 Lot Size: 33 Area: Marbella East Region: Andalucía
This project is a complex of 21 luxurious residences in Marbella, embracing the natural surroundings and creating an ecosystem of peace and harmony. A boutique development offering the perfect (...)
€435,000
TSEA4676452
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 165 Lot Size: 24 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 165 Lot Size: 24 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 (...)
