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 (40,36,37,38)
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 (40,36,37,38)
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 (40,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 41 - 60 of 1780
€380,000
TSEA5155972
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 85 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 85 Area: Torremolinos Region: Andalucía
Introducing this stunning fully renovated home, just 25 meters from the beach, located in one of the most exclusive areas of the Costa del Sol. Ideal for seaside living or as a high-return tourist (...)
€725,000
TSEA5155720
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 145 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 145 Area: Benahavis Region: Andalucía
Experience Scandinavian elegance with panoramic views of the Mediterranean
This 144 sqm residence has been exquisitely renovated with an emphasis on clean lines, refined design, and top-tier (...)
€492,000
TSEA5155384
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 88 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Estepona Region: Andalucía
This first-floor apartment, located in the exclusive Paseo Maritimo area in the center of Estepona, stands out for its side sea views and direct access to the promenade. Fully renovated and ready to (...)
€445,000
TSEA5155378
- 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
Situated in the very centre of Marbella, just a few steps from the beach, this beautifully refurbished apartment offers the rare combination of luxury, comfort, and unbeatable location. Perfect as a (...)
€360,000
TSEA5155372
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 72 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 72 Area: Estepona Region: Andalucía
This beautiful, newly built (2023) apartment is stylishly furnished and ideally located at the edge of Estepona's historic old town. Offering 2 spacious bedrooms and 2 contemporary bathrooms, the (...)
€499,000
TSEA5155288
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Luxury 2 bed, 2 bath apartment, a short flat walk to La Cala town & beach and many other local amenities. La Cala is booming and this stylish apartment is a great opportunity.
In a small, (...)
€850,000
TSEA5155237
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Stunning 2-Bedroom Apartment with Sea Views in Estepona.
This exquisite 2-bedroom, 2-bathroom property perfectly blends elegance, comfort, and location. With a bright, open-plan living and dining (...)
€284,500
TSEA5155150
- Málaga Este, Costa Del Sol, Nerja and Malaga East
Beds: 3 Baths: 1 M2: 73 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 1 M2: 73 Area: Nerja and Malaga East Region: Andalucía
8th Floor Apartment, Málaga East el Palo, Costa del Sol.
2.5 Bedrooms, 1 Bathroom, Built 73 m².
With turistic licence
Setting : Town, Close To Sea.
Condition : Excellent, Recently (...)
€546,500
TSEA5155111
- Málaga Centro, Costa Del Sol, Malaga
Beds: 2 Baths: 1 M2: 74 Area: Malaga Region: Andalucía
Beds: 2 Baths: 1 M2: 74 Area: Malaga Region: Andalucía
Middle Floor Apartment, Málaga Historic Centre Uncibay area, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 74 m².
Video
Setting : Town.
Condition : Excellent, Recently Renovated.
Features : Lift, (...)
€276,000
TSEA5155093
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 75 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 75 Area: Fuengirola Region: Andalucía
Modern Fully Renovated Apartment with Parking – Fuengirola
This stylish apartment, recently reformed to a high standard, is perfectly located in Fuengirola with excellent transport connections and (...)
€249,900
TSEA5155027
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 55 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: Manilva Region: Andalucía
Lovely beachfront 1-bedroom apartment with sea views in La Noria, in Sabinillas.
We are welcomed by the large and bright living room that leads to a private covered terrace with beautiful sea and (...)
€295,000
TSEA5154874
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Fuengirola Region: Andalucía
Modern flat for sale in the centre of Fuengirola, just 150 metres from the beach and surrounded by all services, shops and transport links. Located in a contemporary building built in 2023, this (...)
€385,000
TSEA5154760
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Apartment in the centre of Marbella, on the second line of the beach. Privileged location, just a few metres from the Marina and the Real Club Marítimo de Marbella.
Ideal option for investors, with (...)
€1,360,000
TSEA5154649
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 159 Area: Estepona Region: Andalucía
Beachfront apartment in a modern luxury residential complex in Estepona. Located 5 minutes drive from Estepona city center.
Avant-garde design complex of almost 10,000 m2, with large garden areas, 2 (...)
€315,000
TSEA5153794
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 132 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 132 Area: Mijas and Mijas Costa Region: Andalucía
Spacious Fully Renovated 3-Bedroom Apartment – Mijas Costa / Fuengirola Border
This bright apartment has been fully reformed and offers generous living space in a convenient location just 100 (...)
€349,000
TSEA5153662
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 1 M2: 94 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 1 M2: 94 Area: Fuengirola Region: Andalucía
Unique Opportunity in the Heart of Fuengirola!
Welcome to this bright and spacious apartment with an unbeatable location in the very center of Fuengirola – right next to the bus station yet (...)
€439,000
TSEA5153653
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 96 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Area: Fuengirola Region: Andalucía
✨ Ideal Apartment for Sale in Fuengirola – Close to the Beach and Train Station!
Discover this bright and spacious 3-bedroom apartment located in one of the most convenient and well-connected (...)
€275,000
TSEA5153434
- Arroyo de la Miel, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 88 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 88 Area: Benalmadena Region: Andalucía
Discover the comfort and charm of living in the center of Arroyo de la Miel with this completely renovated apartment. Located on the second floor of a building with no elevator, this home offers the (...)
€975,000
TSEA5153245
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Welcome to this brand-new, never-lived-in apartment in Mirador de Estepona Hills, one of the most prestigious residential communities in the area of Estepona. Thoughtfully designed for comfort and (...)
€2,985,000
TSEA5153197
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: Marbella East Region: Andalucía
This exceptional apartment is located within the world-renowned Puente Romano Resort, right in the heart of Marbella's Golden Mile – one of the most exclusive addresses in Europe. Designed for (...)
Current Featured Properties
€427,400
TSEA3053554
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 131 Lot Size: 100 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Lot Size: 100 Area: Fuengirola Region: Andalucía
EASY LIVING NEAR THE BEACHES, SHOPS AND RESTAURANTS.
This new development is an innovative and elegant promotion of APARTMENTS and penthouses with swimming pool, private parking and located in a (...)
€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 (...)
€570,000
TSEA3922510
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Estepona Region: Andalucía
LAST OPPORUNITY TO ACQUIRE!!!!
One of the last opportunities to acquire a newly built property in the centre of Estepona, seaside and just 1 minute from the beach. A dream lifestyle which can be (...)
