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 (48,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 (48,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 (48,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (2652), Middle Floor - (2652), Penthouse - (2652), Top Floor Apartment - (2652), Penthouse Duplex - (2652)Properties
Results 301 - 320 of 3916
€547,500
TSEA5144950
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 173 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 173 Area: Estepona Region: Andalucía
Exclusive Frontline Beach Apartment in Marina Bay, Estepona
Situated in the sought-after Marina Bay urbanisation, perfectly positioned between the Port of Estepona and the popular Playa del Cristo, (...)
€385,000
TSEA5144932
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Estepona Region: Andalucía
Do you want a pool, walking distance to the old town and the beach? Then this home is the perfect choice for you.
This bright and well-maintained apartment, completed in 2021 and never rented out, (...)
€569,000
TSEA5144884
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 116 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Marbella East Region: Andalucía
Discover Your Dream Coastal Retreat: Southwest-Facing Apartment in Jardines de Don Carlos, Marbella
This standout residence offers an unbeatable fusion of prime positioning, impeccable (...)
€485,000
TSEA5144869
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 63 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 63 Area: Marbella Region: Andalucía
Middle Floor Apartment, Marbella, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 63 m², Terrace 5 m².
Setting : Town, Commercial Area, Beachside, Close To Sea.
Orientation : South West.
Condition : (...)
€345,000
TSEA5144836
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 124 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Casares Region: Andalucía
Stunning 3-Bedroom Penthouse in Casares Costa
This spacious and beautifully presented penthouse is ideally located in Casares Costa, just a short drive from the beach and all local amenities. (...)
€249,950
TSEA5144770
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
This urbanization is very desirable. The views are incredible. And it is very quiet. It is located in Calahonda with restaurants and shops not far away, two minutes by car. The beach and connections (...)
€620,000
TSEA5144746
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 200 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Area: Marbella Region: Andalucía
a highly sought-after area where no more construction is allowed: exceptional apartment with 3 spacious bedrooms, with east-west orientation and panoramic views of the sea and the hills of Mijas (...)
€245,000
TSEA5144743
- Recinto Ferial, Costa Del Sol
Beds: 3 Baths: 2 M2: 97 Region: Andalucía
Beds: 3 Baths: 2 M2: 97 Region: Andalucía
Exclusively available, this spacious and bright apartment features three bedrooms and two full bathrooms (one of them en suite). It is located in the Recinto Ferial area of Fuengirola, just a short (...)
€780,000
TSEA5144722
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 142 Lot Size: 146 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 142 Lot Size: 146 Area: Marbella Region: Andalucía
Welcome to your dream getaway on the Costa del Sol — a bright and spacious apartment designed for effortless beachside living, just a 12-minute walk from the world-famous Puerto Banús.
Located (...)
€727,500
TSEA5144161
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 99 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 99 Area: Torremolinos Region: Andalucía
Middle Floor Apartment, Torremolinos las torres de playamar, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 99 m².
with turistic licence
Community fee all included
Setting : Beachfront, Town, Close (...)
€359,000
TSEA5144158
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Discover your oasis in lower Riviera del Sol, Mijas Costa!
Charming apartment, which without a doubt, is located in the best complex of Riviera del Sol. It is a rare pearl and situated in the lower (...)
€699,000
TSEA5144080
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 159 Lot Size: 21 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 159 Lot Size: 21 Area: Estepona Region: Andalucía
Welcome to your sun-kissed paradise on the sought-after New Golden Mile of Estepona, renowned for its sunny skies, golden sands and crystal-clear waters.
With just 25 stunning apartments, you'll get (...)
€569,000
TSEA5144038
- New Golden Mile, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 87 Area: Estepona Region: Andalucía
Welcome to your sun-kissed paradise on the sought-after New Golden Mile of Estepona, renowned for its sunny skies, golden sands and crystal-clear waters.
With just 25 stunning apartments, you'll get (...)
€535,000
TSEA5144026
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Mijas and Mijas Costa Region: Andalucía
Magnificent apartment with large terrace and sea views!!!!, Close to everything!!!, In the heart of the most wanted LA CALA de Mijas!!!
With a large terrace and sea views to enjoy year-round, (...)
€680,000
TSEA5143975
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Marbella West Region: Andalucía
Exclusivity, Design & Location: Your New Home on the Costa del Sol
Introducing a unique residence, fully renovated to perfection, set in one of the most sought-after areas of the Costa del Sol. (...)
€1,595,000
TSEA5143915
- Sierra Blanca, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 388 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 388 Area: Marbella Region: Andalucía
*Luxurious 3-Bedroom Duplex Penthouse in Prestigious Sierra Blanca*
Discover this expansive 3-bedroom duplex penthouse located in the highly sought-after area of Sierra Blanca. This exquisite (...)
€1,100,000
TSEA5143897
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 121 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 121 Area: Benahavis Region: Andalucía
This stunning top floor apartment., set within the prestigious La Quinta Golf resort, offers an elegant & sophisticated interior with breathtaking panoramic views.
Having been renovated recently (...)
€495,000
TSEA5143876
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Discover this stunning, fully furnished apartment in the heart of Estepona, offering modern luxury and comfort. Recently renovated with top-quality materials, it features a spacious three-bedroom (...)
€360,000
TSEA5143873
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Mijas and Mijas Costa Region: Andalucía
Your Oasis in La Cala de Mijas Awaits You!
Urbanización Ángel de Miraflores – Ground Floor with Private Garden and Communal Pool
We present to you this charming ground-floor apartment located in (...)
€545,000
TSEA5143834
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 3 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Torremolinos Region: Andalucía
This beautifully renovated 3-bedroom, 2-bathroom apartment is ideally situated just 150 meters from La Carihuela beach.
Designed with a smart layout and contemporary finishes, the interiors are both (...)
Current Featured Properties
€1,241,100
TSEA4964773
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 174 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 174 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
€485,850
TSEA4581442
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 112 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: San Pedro Region: Andalucía
The development in San Pedro de Alcantara is made up of 35 homes with 2 and 3 bedrooms, with duplexes with terraces-solariums. Garages in the basement and commercial premises on the ground floor, in (...)
€670,000
TSEA4686511
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 119 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 119 Area: Casares Region: Andalucía
Located in the area of Doña Julia Golf, this new development emerges as an oasis of elegance and tranquility on the Costa del Sol, much more than a simple residential area. A refuge for lovers (...)
