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 (42,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 (42,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 (42,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 1901 - 1920 of 5896
€725,000
TSEA5070904
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 115 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 115 Area: Marbella West Region: Andalucía
Exclusive Newly Renovated Apartment in Nueva Andalucía, Maenstranza - Perfect Apartment within Walking Distance to Centro Plaza
Discover this stunning newly renovated apartment in the sought-after (...)
€350,000
TSEA5070880
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 1 Baths: 1 M2: 55 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: Marbella East Region: Andalucía
Fantastic Modern apartment with Frontal Views of the Sea and the Marina
Prime location on the seafront in the Port of Cabopino, Marbella.
Completely renovated studio on two levels, distributed as (...)
€1,250,000
TSEA5070868
- Elviria, Costa Del Sol, Marbella East
Beds: 4 Baths: 3 M2: 250 Lot Size: 829 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 3 M2: 250 Lot Size: 829 Area: Marbella East Region: Andalucía
VILLA FOR SALE IN ELVIRIA JUST 10 MINUTES WALK FROM THE BEACH – A UNIQUE OPPORTUNITY TO INVEST IN EAST MARBELLA
LIVE OR INVEST IN THE HEART OF ELVIRIA
If you're looking for a detached villa with (...)
€392,500
TSEA5070859
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 97 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Marbella East Region: Andalucía
Middle Floor Apartment, Elviria Santa Maria golf, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 97 m².
With turistic licence
Setting : Frontline Golf, Close To Golf, Urbanisation.
Condition : (...)
€285,000
TSEA5070847
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
A beautiful apartment for those who want to live close to both golf and the center of La Cala de Mijas.
Because all this is just a few minutes' drive away.
The complex is fully gated and has a (...)
€650,000
TSEA5070841
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 55 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 55 Area: Estepona Region: Andalucía
LOCATION - LOCATION - LOCATION
In the best located building in Estepona, right by the sea and at the beginning of the promenade lies apartment building Jacaranda. There is now a unique opportunity (...)
€334,000
TSEA5070799
- Bajondillo, Costa Del Sol, Torremolinos
Beds: 1 Baths: 1 M2: 43 Area: Torremolinos Region: Andalucía
Beds: 1 Baths: 1 M2: 43 Area: Torremolinos Region: Andalucía
Welcome to your dream coastal retreat in the heart of Torremolinos!
This beautifully designed one-bedroom apartment, built in 2018, perfectly combines modern living with unparalleled convenience. (...)
€1,349,000
TSEA5070757
- Monte Halcones, Costa Del Sol, Benahavis
Beds: 4 Baths: 5 M2: 180 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 5 M2: 180 Area: Benahavis Region: Andalucía
This beautifully renovated 4-bedroom, 3-bathroom duplex is the perfect blend of Scandinavian design and Mediterranean living.
It's bright, spacious, and thoughtfully designed, offers a warm and (...)
€1,195,000
TSEA5070745
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 99 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: San Pedro Region: Andalucía
This luxurious 2 bedroom 2 bathroom apartment located in the prestigious beachfront urbanization in San Pedro has been completely transformed with top-quality renovations, offering a modern and (...)
€444,900
TSEA5070742
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 115 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 115 Area: Estepona Region: Andalucía
Live the Luxury Beachfront Life on the New Golden Mile
Imagine waking up every morning to the sound of the waves and the Mediterranean Sea at your feet. This isn't just a fantasy; it can be your (...)
€1,795,000
TSEA5070685
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 265 Lot Size: 1,450 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 265 Lot Size: 1,450 Area: Estepona Region: Andalucía
Situated in a prime location in El Paraíso, Estepona, this south-facing villa offers great renovation potential just a 10-minute walk from the beach and close to shops, restaurants, schools, and (...)
€690,000
TSEA5070676
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 122 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Marbella Region: Andalucía
This magnificent ground floor apartment is located in Vivero de Marbella, a quiet, low-rise residential complex in the prestigious Sierra Blanca area on Marbella's Golden Mile, between Imara and Le (...)
€334,000
TSEA5070583
- Alcaucín, Costa Del Sol East
Beds: 4 Baths: 2 M2: 284 Lot Size: 1,125 Region: Andalucía
Beds: 4 Baths: 2 M2: 284 Lot Size: 1,125 Region: Andalucía
This charming chalet near Alcaucín offers the perfect blend of Mediterranean lifestyle, comfort, and a close-to-nature location. Surrounded by greenery and offering wonderful views of the (...)
€420,000
TSEA5070574
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 107 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Area: Benahavis Region: Andalucía
Located in the exclusive, gated community of La Quinta near Marbella, this 2-bedroom, 2-bathroom apartment offers a peaceful retreat with captivating views of the La Quinta Golf Course. Set in a (...)
€2,580,000
TSEA5070559
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 3 M2: 372 Lot Size: 1,335 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 3 M2: 372 Lot Size: 1,335 Area: Sotogrande Region: Andalucía
This Magnificent Home in Sotogrande
This stunning home in Sotogrande has been completely renovated with modern architectural and design trends in mind. Spacious and filled with natural light, it (...)
€395,000
TSEA5070469
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 65 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Mijas and Mijas Costa Region: Andalucía
Beautiful 52 m² Beachfront Apartment in La Cala de Mijas – Lubina del Sol
This charming one-bedroom, one-bathroom apartment is located in the sought-after Lubina del Sol development, right on the (...)
€1,450,000
TSEA5070412
- Valle Romano, Costa Del Sol, Estepona
Beds: 3 Baths: 4 M2: 166 Lot Size: 532 Area: Estepona Region: Andalucía
Beds: 3 Baths: 4 M2: 166 Lot Size: 532 Area: Estepona Region: Andalucía
New Development: Prices from 1,450,000 € to 1,990,000 €. [Beds: 3 - 3] [Baths: 4 - 4] [Built size: 166.00 m2 - 263.00 m2]
A unique collection of contemporary villas set in the privileged natural (...)
€475,000
TSEA5070376
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Stylish 2-Bedroom Apartment with Sea Views in Sunset Golf, Selwo, Estepona
Welcome to this elegant and well-maintained apartment located in the prestigious Sunset Golf urbanization, nestled in the (...)
€4,750,000
TSEA5070361
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 5 M2: 1,030 Lot Size: 6,950 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 5 M2: 1,030 Lot Size: 6,950 Area: Benahavis Region: Andalucía
Perched on a rare flat double plot spanning 6.950m2 within the exclusive and secure enclave of Monte Mayor, this cortijo, style villa is a true andalucian sanctuary. Accessed via a 150meter private (...)
€1,199,000
TSEA5070340
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 87 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Marbella Region: Andalucía
Exclusive flat in the emblematic Gran Marbella building, right in the heart of the city and on the beachfront. A unique opportunity to live just 10 metres from the Paseo Marítimo and the Fontanilla (...)
Current Featured Properties
€580,000
TSEA4458493
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 111 Area: Estepona Region: Andalucía
ESCAPE TO PARADISE - PHASE 4! 2 bed apartments from 255,000€. there are also 3 beds at 389,000€. Your opportunity to own a 2 bed, 2 bath apartment in one of the most EXCITING tourist projects (...)
€416,000
TSEA4804681
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Area: Estepona Region: Andalucía
BRAND NEW DEVELOPMENT - GOLFERS PARADISE!!!
Located in one of the best areas of the Costa del Sol. This magnificent residential complex is located in one of the growing areas of Estepona, just 300 (...)
€4,950,000
TSEA4790245
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 5 M2: 488 Lot Size: 970 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 5 M2: 488 Lot Size: 970 Area: Marbella West Region: Andalucía
Nestled within the illustrious enclave of Nueva Andalucia, This new development provides residents a luxurious escape that embodies the true essence of luxury living. With its privileged location in (...)
