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 (51,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 (51,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 (51,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 2701 - 2720 of 3915 €329,000
TSEA4958623
- Los Boliches, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 59 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 59 Area: Fuengirola Region: Andalucía
Imagine a home in the Los Boliches area, located near the train station, providing easy access to public transportation and the convenience of having all kinds of amenities nearby, such as (...)
€450,000
TSEA4958605
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 74 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Fuengirola Region: Andalucía
Stylish Fully Furnished apartment priced to sell and with valid Tourist Licence in place.
Welcome to an exceptional newly complete urbanization featuring 160 modern luxury apartments, located within (...)
€650,000
TSEA4958410
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Are you looking for a property for sale with walking distance to all amenities? Do you want to take a short walk and reach everything you need? The development of Los Naranjos de Marbella is situated (...)
€950,000
TSEA4958086
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 165 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 165 Area: Estepona Region: Andalucía
Spacious apartment on the beachfront and in the centre of Estepona, on the best and most sought-after street in Estepona.
Opportunity for a 161m2 apartment with 3 bedrooms, 2 bathrooms, large (...)
€1,149,000
TSEA4958080
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 111 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 (...)
€395,000
TSEA4958074
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
4 Bedrooms, 2 Bathrooms, Built 105 m².
Setting : Town, Commercial Area, Beachside, Village, Close To Port, Close To Shops, Close To Sea, Close To (...)
€440,000
TSEA4958065
- Rincón de la Victoria, Costa Del Sol East
Beds: 2 Baths: 2 M2: 120 Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Region: Andalucía
Our project offers only 21 two and three bedroom homes available, in an exclusive enclave designed for those clients who value peace, tranquillity and the absence of noise. Conceived to guarantee the (...)
€1,850,000
TSEA4957975
- Sotogrande Marina, Costa Del Sol, Sotogrande
Beds: 4 Baths: 4 M2: 446 Area: Sotogrande Region: Andalucía
Beds: 4 Baths: 4 M2: 446 Area: Sotogrande Region: Andalucía
Luxury Penthouse in a Prime Location – Sotogrande Puerto Discover this exclusive penthouse in Puerto de Sotogrande, offering breathtaking panoramic views of the sea, the Marina, and Gibraltar. (...)
€230,000
TSEA4957924
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 1 Baths: 1 M2: 46 Area: Torremolinos Region: Andalucía
Beds: 1 Baths: 1 M2: 46 Area: Torremolinos Region: Andalucía
Excelent opportunity!
La Carihuela beach, by Aldi supermercado, 1-bedroom apartment for Sale, fully furnished.
Touristic license in place, already with booking for summer.
Finished October (...)
€555,000
TSEA4957705
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 86 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Benahavis Region: Andalucía
Nestled in an idyllic setting, this luxurious 2-bedroom, 2-bathroom apartment is a sanctuary of style and comfort. Recently refurbished to an impeccable standard, this property exudes elegance and (...)
€530,000
TSEA4957516
- Bel Air, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 112 Lot Size: 22 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Lot Size: 22 Area: Estepona Region: Andalucía
Exclusive 3-Bedroom Apartment with Private Garden in Bel Air, Cancelada!
Discover this stunning 3-bedroom, 2-bathroom apartment on the ground floor, offering the perfect blend of comfort and luxury. (...)
€630,000
TSEA4957453
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 132 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 132 Area: Estepona Region: Andalucía
Top floor duplex apartment located in Bel-Air. It has three bedrooms, two bathrooms and a toilet, with two large terraces with good views. Parking space and storage room. Gated complex with swimming (...)
€275,000
TSEA4957447
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 70 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 70 Area: Benahavis Region: Andalucía
A practical hassle-free investment.
This property offers the perfect blend of resort hotel services and amenities with the independence of an apartment. Enjoy access to multiple swimming pools, lush (...)
€350,000
TSEA4374559
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 88 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Casares Region: Andalucía
New Development: Prices from 350,000 € to 350,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 88.00 m2 - 88.00 m2]
This development is a complex of 47 apartments with 1, 2 and 3 bedrooms. Each (...)
€659,500
TSEA4957246
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 72 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Area: Fuengirola Region: Andalucía
Luxury and Exclusivity in the Heart of Fuengirola
Live just 100 meters from the beach. Discover an exclusive residential complex designed to offer maximum comfort, luxury, and modernity on the Costa (...)
€595,000
TSEA4957219
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 91 Lot Size: 236 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 91 Lot Size: 236 Area: Fuengirola Region: Andalucía
Just completed before Christmas, this brand-new corner ground-floor apartment offers a perfect blend of modern comfort and outdoor living in the heart of the Costa del Sol.
Designed to make the most (...)
€297,000
TSEA4957129
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 104 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: La Duquesa Region: Andalucía
This magnificent middle-floor apartment is located in one of the most sought-after areas of the Costa del Sol, right in the heart of Puerto de la Duquesa. It is close to the beach and offers a wide (...)
€435,000
TSEA4957060
- Marbesa, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 110 Lot Size: 40 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Lot Size: 40 Area: Marbella East Region: Andalucía
In the area of Cabopino - Marbesa, this charming property stands out for its elegance, comfort and excellent location, just a 10-minute walk from the spectacular beaches and dunes of Cabopino. With a (...)
€371,100
TSEA4956715
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 1 M2: 70 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 1 M2: 70 Area: Marbella West Region: Andalucía
Discover your new home in the heart of Nueva Andalucía! This magnificent penthouse offers spectacular views of the sea from its large 18 square meter terrace, perfect for enjoying unforgettable (...)
€140,000
TSEA4956556
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 50 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 50 Area: Estepona Region: Andalucía
round Floor Apartment in Estepona, Costa del Sol – Unbeatable Price! ????????
This cozy 1-bedroom, 1-bathroom ground floor apartment offers 50 m² of living space in a prime location, just 50 (...)
Current Featured Properties
€670,000
TSEA4982797
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 127 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 127 Area: Estepona Region: Andalucía
Apartments and penthouse apartments with 2, 3 and 4 bedrooms in Selwo, Estepona this is a place where the sea and nature become one, with stunning Mediterranean sea views.
Located in an exceptional (...)
€398,000
TSEA5118049
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 105 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: Manilva Region: Andalucía
This new development of two and three-bedroom apartments in a magnificent urbanisation in an extraordinary location. The project combines modern design architecture with perfectly studied landscaping (...)
€577,500
TSEA3923743
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
GREAT LOCATION CLOSE TO CHARMING ESTEPONA.
The apartments are specially designed to fully enjoy the charm of the Mediterranean lifestyle. A well thought out floor plan, bathrooms with lovely (...)
