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 321 - 340 of 3894
€475,000
TSEA5143807
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Mijas and Mijas Costa Region: Andalucía
Top-Floor Living close to the Sea – Penthouse For Sale
Looking for something special? This bright and modern penthouse ticks all the boxes — stunning sea views, a spacious 40 m² terrace, and a (...)
€685,000
TSEA5143777
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 150 Lot Size: 20 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Lot Size: 20 Area: Casares Region: Andalucía
Discover Your Dream Home: Luxurious Brand-New Apartment in Casares Costa
Prime Location with Breathtaking Views: Enjoy stunning sea and mountain vistas from your private terrace in a south-facing (...)
€415,000
TSEA5143774
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 92 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 92 Area: Marbella Region: Andalucía
Stunning & Spacious 2-Bedroom Apartment in the Heart of Marbella
Discover your dream home in this beautiful 85 m² apartment (90 m² built) located in the vibrant Avenida General López (...)
€415,000
TSEA5143771
- 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
Top Floor Apartment, Estepona, Costa del Sol.
3 Bedrooms, 1 Bathroom, Built 90 m², Terrace 15 m².
Setting : Town, Close To Port, Close To Shops, Close To Sea, Close To Town, Close To Schools, (...)
€675,000
TSEA5143657
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
This beautiful 3 bedroom 2 bathroom penthouse nestled in the heart of Nueva Andalucia must be seen. With an expansive terrace and solarium totally nearly 100 sqm means there is a multitude of outdoor (...)
€1,995,000
TSEA5143639
- Estepona, 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
Bahía del Velerín is a prestigious community located between Marbella and Estepona. It boasts a beautiful pool area with a snack bar, lush tropical gardens, and 24/7 security. Set in a prime (...)
€2,995,000
TSEA5143633
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Bahía del Velerín is a luxurious community between Marbella and Estepona. It has a fantastic pool area with a snack bar, tropical gardens and 24/7 security. The community is located at one of the (...)
€439,000
TSEA5143624
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 109 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 109 Area: Mijas and Mijas Costa Region: Andalucía
BACK ON THE MARKET !- Casa Banderas
Nice corner Garden Apartment with open Panoramic view towards Mijas Pueblo
2 Bedrooms/2 bathrooms with open plan kitchen
Very bright and close to all the (...)
€299,000
TSEA5143567
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 75 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 75 Area: Benalmadena Region: Andalucía
Apartment for sale in Benalmádena Costa - Puerto Marina
???? Beautiful apartment for sale in the heart of Benalmádena! Just a 1-minute walk from the famous Puerto Marina, this charming (...)
€359,000
TSEA5143450
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
This well-priced apartment in a popular complex offers a great opportunity to own a home on the Costa del Sol.
The property includes 2 bedrooms and 2 bathrooms, one of them en-suite, a fitted (...)
€630,000
TSEA5143432
- Río Real, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 107 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Area: Marbella East Region: Andalucía
This beautifully renovated two-bedroom apartment is situated in the iconic Torre de Río Real, one of Marbella's most renowned buildings. Located in the exclusive Río Real residential area in (...)
€3,995,000
TSEA5143360
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 186 Area: Estepona Region: Andalucía
Discover a fully renovated, southwest-facing beachfront apartment in the prestigious Los Granados del Mar gated community. Perfectly positioned on the New Golden Mile between Marbella and Estepona, (...)
€295,000
TSEA5143276
- Estepona, 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
Exclusive Apartment with Terrace and Parking in a Luxury Residential Complex – 5 Minutes from the Beach and Town Centre
Located in one of the most exclusive residential areas, this apartment (...)
€410,000
TSEA5143219
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 150 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: Manilva Region: Andalucía
Stunning Seafront Apartment in Sotogrande with Gibraltar Views
Discover this spacious and bright 150 m² apartment in the heart of Sotogrande, offering breathtaking views of the sea and the iconic (...)
€2,695,000
TSEA5143117
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Located between Marbella and Estepona, Bahía del Velerín is a prestigious community with a beautiful pool area, a snack bar, lush tropical gardens, and 24/7 security.
This fully renovated penthouse (...)
€2,395,000
TSEA5143105
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 134 Area: Estepona Region: Andalucía
This southwest-facing, fully renovated 3-bedroom, 2-bathroom apartment offers an exceptional blend of style, comfort, and panoramic views over subtropical gardens and the Mediterranean Sea. The (...)
€220,000
TSEA5143093
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 48 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 48 Area: Mijas and Mijas Costa Region: Andalucía
New to the market!
One bedroom, one bathroom apartment for sale in La Cala De Mijas
A very rare opportunity to purchase a 1 bedroom, 1 bathroom property, on a beautiful urbanisation in La Cala de (...)
€410,000
TSEA5143036
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 111 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: La Duquesa Region: Andalucía
Discover Paradise: Stunning Penthouse with Panoramic Sea Views and Direct Beach Access
Breathtaking Views and Space: Enjoy 180º panoramic sea views from a massive 110 m² terrace, complemented by (...)
€249,500
TSEA5143003
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 49 Area: Benalmadena Region: Andalucía
Middle Floor Apartment, Benalmadena, Costa del Sol.
1 Bedroom, 1 Bathroom, Built 49 m².
Possibility of turistic licence
Setting : Town, Urbanisation.
Condition : Excellent.
Features : Covered (...)
€629,000
TSEA5142994
- Selwo, 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 Ground-Floor Apartment with Private Garden
This bright and spacious ground-floor apartment offers the perfect balance between comfort, style, and outdoor living. With 3 bedrooms and 2 (...)
Current Featured Properties
€1,095,000
TSEA4624024
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
EMBRACE SPANISH LIFE TO THE FULLEST. Beautifully styled contemporary apartments and sky villas, extensive green areas and a PANORAMIC OVERVIEW of the Mediterranean sea is what sets this development (...)
€400,000
TSEA5128918
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 87 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Benahavis Region: Andalucía
Located in the heart of Benahavís, a new residential development is being launched featuring 28 Mediterranean-style apartments with 1, 2, or 3 bedrooms. Each home includes a private underground (...)
€899,000
TSEA4733500
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 126 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 126 Area: Benahavis Region: Andalucía
BREATH TAKING VIEWS FROM THE STUNNING TERRACE!!!
From its elevated position just above Marbella's emblematic Golf Valley, you will enjoy luxurious and contemporary living in an exclusive location. (...)
