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,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 (40,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 (40,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 1441 - 1460 of 3894 €590,000
TSEA5072011
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 140 Lot Size: 69 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Lot Size: 69 Area: Casares Region: Andalucía
Discover this exclusive new development consisting of 99 apartments and penthouses, each with 2 or 3 bedrooms, designed to help you find where you truly belong. Situated in the prime location of (...)
€1,190,000
TSEA5071291
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 2 M2: 227 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 2 M2: 227 Area: Mijas and Mijas Costa Region: Andalucía
EXCLUSIVE PENTHOUSE with PRIVATE POOL and SEA VIEWS in Benalmádena Costa
Discover this stunning penthouse in Cortijo de Torrequebrada! A truly unique property that combines luxury, spacious living (...)
€440,000
TSEA5071168
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 110 Lot Size: 34 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Lot Size: 34 Area: Casares Region: Andalucía
Discover this exclusive new development consisting of 99 apartments and penthouses, each with 2 or 3 bedrooms, designed to help you find where you truly belong. Situated in the prime location of (...)
€470,000
TSEA5071156
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 2 Baths: 2 M2: 100 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Sotogrande Region: Andalucía
URGENT SALE
Flat with certified valuation at 500.000€. Price reduction for a quicker sale.
This property located in Ribera del Paraiso offers an unrivalled living experience in the heart of La (...)
€780,000
TSEA5071135
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 2 M2: 175 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 2 M2: 175 Area: Sotogrande Region: Andalucía
URGENT SALE
Flat with certified valuation at €800,000. Price reduction for a quicker sale.
This property located in Ribera del Paraiso offers an unrivalled living experience in the heart of La (...)
€660,000
TSEA5071132
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
2-bedroom apartment in Fuengirola for €660,000
The apartment is located in an innovative and sustainable residential development situated on a green hillside overlooking the Fuengirola coastline, (...)
€345,000
TSEA5071117
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 96 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 96 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 345,000 € to 458,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 96.00 m2 - 120.00 m2]
Our company is a real estate investment and development group with 80 years (...)
€335,000
TSEA5071108
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 132 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 132 Area: Manilva Region: Andalucía
This stunning apartment is located in a peaceful area within a secure gated community that offers 3 large swimming pools for adults, 2 smaller pools for children, and a paddle tennis court. It's just (...)
€380,000
TSEA5071054
- Casares, Costa Del Sol, Casares
Beds: 1 Baths: 1 M2: 69 Lot Size: 45 Area: Casares Region: Andalucía
Beds: 1 Baths: 1 M2: 69 Lot Size: 45 Area: Casares Region: Andalucía
Discover a peaceful coastal retreat in this beautifully designed one-bedroom apartment located in the prestigious Azata del Mar urbanization, Casares. Set in a serene and well-connected area (...)
€265,000
TSEA5070973
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 73 Area: Mijas and Mijas Costa Region: Andalucía
Tranquil Apartment with Panoramic Views in Puebla Tranquila, Mijas
This bright and inviting 73 m² apartment offers 2 well-proportioned bedrooms and 1 bathroom, all thoughtfully laid out to (...)
€575,000
TSEA5070955
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 1 M2: 73 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 1 M2: 73 Area: Marbella East Region: Andalucía
Incredible opportunity in Puerto de Cabopino, Marbella, just 20 minutes from Malaga Airport and 10 minutes from Marbella Center.
Exclusive, fully renovated property located on the seafront, with (...)
€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 (...)
€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 (...)
Current Featured Properties
€530,000
TSEA4761718
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 4 Baths: 2 M2: 120 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 2 M2: 120 Area: Algeciras Region: Andalucía
We´re happy to present a new flagship project in La Alcaidesa, San Roque, just 10 minutes from Sotogrande, with spectacular views of the Mediterranean Sea, the golf course and Gibraltar.
Superb (...)
€515,000
TSEA4814728
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 109 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 109 Area: Istan Region: Andalucía
COUNTRY LIVING ONLY 10 MINS FROM EVERYTHING!
This is the first phase on sale, comprising 32 exclusive apartments with stunning panoramic views, situated in the most elevated part of the Almazara (...)
€650,000
TSEA4969432
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 103 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: San Pedro Region: Andalucía
LUXURIOUS 2,3 & 4 BEDROOM APARTMENTS IN GUADALMINA ALTA! Development of 34 amazing apartments and penthouses in a perfect location, for you to enjoy the Mediterranean lifestyle The living room is (...)
