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)
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)
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)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 1581 - 1600 of 1769 €595,000
TSEA4747765
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 140 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Area: Marbella West Region: Andalucía
Welcome to this delightful 3-bedroom apartment nestled within one of the most coveted urbanizations in Nueva Andalucia. Renovated to perfection and adorned in elegant Scandinavian style, this (...)
€219,000
TSEA4746646
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 57 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 57 Area: Fuengirola Region: Andalucía
Cozy Apartment Just 100m from the Beach – Fuengirola
Opportunity to purchase a charming apartment only third line from the beach, just 100 metres from the promenade and the sea. Ideally located (...)
€265,000
TSEA4744957
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 79 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 79 Area: Marbella West Region: Andalucía
Apartment in Marbella, Nueva Andalucia centre area, Puerto Banus and beach 5 min by car. It has 1 bedroom, living room with American kitchen, bathroom, glazed terrace. It is recently renovated of (...)
€750,000
TSEA4744438
- 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
Discover this magnificent apartment located in the prestigious urbanization of Campanario Hills, Estepona. Nestled within a gated community, this residence offers luxury and exclusivity with only 29 (...)
€349,000
TSEA4739554
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 49 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 49 Area: Fuengirola Region: Andalucía
This charming apartment, located on the beachfront, offers an unparalleled coastal living experience with breathtaking views of the sea and coastline. West-facing, it allows you to enjoy beautiful (...)
€782,407
TSEA4733509
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA!
A luxury resort style apartment complex with the best in leisure facilities. This new development has been landscaped to create TOP QUALITY with (...)
€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. (...)
€621,000
TSEA4732852
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 118 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 118 Area: Casares Region: Andalucía
Located within the Casares Costa Golf course it has only 74 Apartments and 17 penthouses, with 2 and 3 bedrooms, which is a low construction density oasis of serenity thanks to its. Spacious and (...)
€420,000
TSEA4732825
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 90 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Casares Region: Andalucía
Located within the Casares Costa Golf course it has only 74 Apartments and 17 penthouses, with 2 and 3 bedrooms, which is a low construction density oasis of serenity thanks to its. Spacious and (...)
€3,499,500
TSEA4732402
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 663 Lot Size: 192 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 663 Lot Size: 192 Area: Benahavis Region: Andalucía
Discover this modern 3-bedroom ground floor apartment in a new eco-friendly development in Benahavís, offering panoramic sea views. Situated within a gated resort-style community surrounded by lush (...)
€305,000
TSEA4732072
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Miraflores Golf gardens
The apartment has two bedrooms, a master bedroom with an ensuite bathroom and a twin room with a separate bathroom. The lounge area offers comfortable seating and dinning (...)
€550,000
TSEA4732060
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 86 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Area: Fuengirola Region: Andalucía
Opportunity, brand new renovated!! top floor facing the sea. stunning beach views. 15m2 L-shaped terrace, two-bedroom house with built-in wardrobes and two bathrooms, one of them en suite. Community (...)
€750,000
TSEA4729738
- Málaga Centro, Costa Del Sol, Malaga
Beds: 4 Baths: 2 M2: 170 Area: Malaga Region: Andalucía
Beds: 4 Baths: 2 M2: 170 Area: Malaga Region: Andalucía
We are happy to present this gem in the heart of Malaga in front of the Cervantes theater. Emblematic building, built in 1900
Unbeatable location, located in the most exclusive area, close to all the (...)
€400,000
TSEA4728739
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 69 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 69 Area: Fuengirola Region: Andalucía
Spectacular apartment on the beachfront, in the Carvajal area in Fuengirola. With stunning sea views, newly renovated! A few steps from shops, beach bars, Carvajal train station. Ready to enter!
It (...)
€399,999
TSEA4728670
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 72 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 72 Area: Mijas and Mijas Costa Region: Andalucía
NEWLY RENOVATED BEACHSIDE APARTMENT CALAHONDA
Welcome to this newly renovated beachside apartment in the picturesque Calahonda Beach, just steps away from the beach.
This stunning property has (...)
€505,000
TSEA4726054
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 116 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Casares Region: Andalucía
LAST CHANCE TO BUY! SEA VIEWS THAT YOU DREAM ABOUT!!!
Last 2 beds starting from 360,495€ and one last 3 bed at 558,000€!
Designed in a contemporary style, the apartments and penthouses have been (...)
€265,000
TSEA4723990
- Doña Julia, Costa Del Sol, Casares
Beds: 1 Baths: 2 M2: 90 Area: Casares Region: Andalucía
Beds: 1 Baths: 2 M2: 90 Area: Casares Region: Andalucía
This perfect holiday investment rental property is a 1 bedroom to make 2 doble bedrooms out of it, sleep 6 people or 7!
The huge terrace is 2 separate areas and can made the second bedroom very (...)
€205,000
TSEA4722799
- Calypso, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 63 Area: Mijas and Mijas Costa Region: Andalucía
Renovated 1 bed apartment which the current owners have created a second bedroom from part of the terrace, but with some imagination it could easily be made into a proper 2 bed,
new kitchen
good (...)
€640,000
TSEA4722259
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 168 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 168 Area: San Pedro Region: Andalucía
Middle Floor Apartment, Guadalmina Alta, Costa del Sol.
3 Bedrooms, 3 Bathrooms, Built 168 m², Terrace 25 m².
Setting : Frontline Golf, Close To Golf, Close To Shops, Close To Town, Close To (...)
€490,000
TSEA4721146
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 76 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 76 Area: Estepona Region: Andalucía
A BRAND NEW BOUTIQUE COMPLEX OF ONLY 15 PROPERTIES! Our architects have carefully designed this project, sparing no details. You won't find small windows here, only large glass panels that flood the (...)
Current Featured Properties
€250,000
TSEA4973002
- Estepona, 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 3-BEDROOM APARTMENT WITH SEA VIEWS IN FOREST HILLS – GREAT VALUE & INVESTMENT POTENTIAL
This bright and generously sized 3-bedroom apartment in the popular Forest Hills area offers (...)
€568,700
TSEA4856224
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
A STUNNING GATED DEVELOPMENT!!!
It is a modern project of 50 homes of 2 and 3 bedrooms, each with its own parking space and storage room. The construction will always respect our commitment to the (...)
€525,000
TSEA5128906
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 107 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 107 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 (...)
