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 161 - 180 of 1780
€650,000
TSEA5145820
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Modern duplex apartment in Puerto Banús with stunning sea views, just steps from the beach, restaurants, luxury boutiques, and all amenities. Featuring two bedrooms (one en-suite), two (...)
€231,000
TSEA5145313
- Torremolinos Centro, Costa Del Sol, Torremolinos
Beds: 1 Baths: 1 M2: 62 Area: Torremolinos Region: Andalucía
Beds: 1 Baths: 1 M2: 62 Area: Torremolinos Region: Andalucía
Beautiful property for sale in the charming "Pueblo Blanco" of Torremolinos.
One of the best areas of the town, very attractive both for those who want to live in the centre and surrounded (...)
€1,195,000
TSEA5145271
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 145 Area: Marbella West Region: Andalucía
Apartment Jasmine is a beautifully renovated three-bedroom apartment for sale in the exclusive Palacetes Los Belvederes, an established residential community in Nueva Andalucía. Originally built in (...)
€369,000
TSEA5145232
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Apartment in Cerros del Águila with terrace, views and excellent qualities
Located in the quiet urbanization Cerros del Águila, this apartment offers a well-maintained environment with community (...)
€725,000
TSEA5145166
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 175 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 175 Area: Marbella Region: Andalucía
Spacious 3 Bedroom Apartment in the Heart of Marbella.
Just Steps from the Beach
New to the market, this very spacious three-bedroom, two-bathroom apartment is ideally located just one street back (...)
€510,000
TSEA5145076
- Sotogrande Costa, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 149 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 149 Area: Sotogrande Region: Andalucía
Exclusive Apartment with Terrace and Views of Sotogrande Marina
Located in the Ribera de Sotogrande, this apartment is just 300 meters from the beach, allowing you to enjoy a coastal lifestyle (...)
€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 : (...)
€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 (...)
€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 (...)
€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. (...)
€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 (...)
€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 (...)
€359,000
TSEA5143450
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
This well-priced apartment in a popular complex offers a great opportunity to own a home on the Costa del Sol.
The property includes 2 bedrooms and 2 bathrooms, one of them en-suite, a fitted (...)
Current Featured Properties
€530,000
TSEA5151739
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 88 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 88 Area: Fuengirola Region: Andalucía
Breathe and enjoy life at your own rhythm. This brand new apartment development offers the space to be yourself, to focus on what matters, and to reconnect with a lifestyle that feels effort-less. (...)
€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 (...)
€2,950,000
TSEA4216429
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 121 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 121 Area: Marbella West Region: Andalucía
TWO MINUTES AND YOU ARE IN THE CENTRE OF THE FAMOUS BANUS!!!
A sleek contemporary apartment located within the the famous Puerto Banus Marina, showcasing jetliner panoramic views to the Mediterranean (...)
