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 (70,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 (70,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 (70,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 501 - 520 of 4559 €246,000
TSEA5139061
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 66 Lot Size: 15 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 66 Lot Size: 15 Area: Mijas and Mijas Costa Region: Andalucía
Ground Floor Apartment, Riviera del Sol, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 66 m², Terrace 10 m², Garden/Plot 15 m².
Setting : Suburban, Close To Golf, Close To Sea, Close To Town, (...)
€690,000
TSEA5139049
- El Presidente, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 169 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 169 Area: Estepona Region: Andalucía
Spacious apartment in the El Presidente complex, Estepona, next to the beach and close to all amenities. The apartment features an entrance hall, a large living-dining room, a fully equipped kitchen, (...)
€395,000
TSEA5139040
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 1 M2: 100 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 1 M2: 100 Area: Marbella West Region: Andalucía
Beautiful and modern apartment in the heart of Nueva Andalucía. Great location.
The apartment has two bedrooms and one bathroom. 145 m2 with a private terrace.
Fully equipped.
It doesn't have a (...)
€1,680,000
TSEA5139037
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 152 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 152 Area: Marbella Region: Andalucía
If you dream of waking up every morning to breathtaking views of the Mediterranean, this apartment will captivate you from the very first moment. Located in one of Marbella's most privileged areas, (...)
€1,050,000
TSEA5139022
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 3 Baths: 3 M2: 231 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 3 M2: 231 Area: San Pedro Region: Andalucía
Exquisite Renovated 3-Bedroom Apartment in Alhambra del Golf, Guadalmina Baja
Nestled within the prestigious beachside complex of Alhambra del Golf in Guadalmina Baja, this beautifully renovated (...)
€559,000
TSEA5139010
- Costalita, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Renovated Penthouse with Stunning Sea & Mountain Views – Costalita, Estepona
This beautifully renovated penthouse in the prestigious Costalita development offers a perfect blend of elegance, (...)
€330,000
TSEA5138956
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 146 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 146 Area: La Duquesa Region: Andalucía
If you are looking for a home that includes all brand new furniture, this is the home for you.
The house is completely exterior.
It has 146 square meters, and consists of:
- Living room, designed to (...)
€260,000
TSEA5138944
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 94 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Benahavis Region: Andalucía
Charming Apartment with Mountain Views in Benahavís
This inviting apartment in Benahavís offers the perfect combination of tranquility, comfort, and nature. Located in a well-maintained and (...)
€611,000
TSEA5138941
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
This is not simply a place to live. It's a lifestyle ecosystem. From sunrise swims in your private pool to sunset walks along the coastal path, this is more than just a home — it's a (...)
€1,099,000
TSEA5138932
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 133 Lot Size: 110 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 133 Lot Size: 110 Area: San Pedro Region: Andalucía
New apartment for sale in a newly built building.
Fantastic ground floor apartment with private garden.
A resale of the new apartment. Take advantage of the opportunity!
It is a new residential (...)
€494,000
TSEA5138920
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 86 Area: Estepona Region: Andalucía
This is not simply a place to live. It's a lifestyle ecosystem. From sunrise swims in your private pool to sunset walks along the coastal path, this is more than just a home — it's a (...)
€395,000
TSEA5138917
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Charming 2-Bedroom Apartment – 5 Minutes from the Beach
Enjoy relaxed coastal living in this beautifully renovated 2-bedroom, 2-bathroom apartment in the heart of Riviera del Sol. Bright and (...)
€610,000
TSEA5138908
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 108 Area: Mijas and Mijas Costa Region: Andalucía
NEW ON THE MARKET! Fantastic apartment that combines a modern and elegant style to create the perfect space for your future home.
The property welcomes you at the entrance with a bright, modern (...)
€379,000
TSEA5138899
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 51 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Estepona Region: Andalucía
This is not simply a place to live. It's a lifestyle ecosystem. From sunrise swims in your private pool to sunset walks along the coastal path, this is more than just a home — it's a (...)
€298,000
TSEA5138887
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 2 Baths: 1 M2: 82 Area: Sotogrande Region: Andalucía
Beds: 2 Baths: 1 M2: 82 Area: Sotogrande Region: Andalucía
Modern 2-bedroom apartment just a 1-minute walk to restaurants, bars, shops, and a supermarket. The bus station is only meters away, and Sotogrande Port is within walking distance. Includes a fully (...)
€565,000
TSEA5138848
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 67 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 67 Area: Estepona Region: Andalucía
Your Dream Beachfront Home in Estepona
Imagine waking up every day with the sound of the waves just steps away. This beautifully renovated 2-bedroom, 2-bathroom apartment is set within one of (...)
€226,000
TSEA5138821
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 68 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 68 Area: Estepona Region: Andalucía
We are pleased to present this charming two-bedroom, one-bathroom apartment located in the sought-after area of Estepona Golf. An ideal opportunity, whether as a holiday home, permanent residence, or (...)
€500,000
TSEA5138818
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Spacious and Bright Apartment in the Heart of Marbella, Just Steps from the Beach
For sale: a magnificent 2-bedroom, 1-bathroom apartment located in the very center of Marbella, just a few meters (...)
€294,455
TSEA5138815
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 93 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Fuengirola Region: Andalucía
Brand-New Apartment in Fuengirola – 2 Bedrooms, 2 Bathrooms
Located on the second floor, this apartment features approximately 70 m² of usable space and 93 m² of built area. It includes a (...)
€845,000
TSEA5138809
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 174 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 174 Area: Benahavis Region: Andalucía
Penthouse Los Balcones de la Quinta – Benahavís
3 Bedrooms | 2 Bathrooms | 174 m² Interior | 150 m² Rooftop Terrace | Frontline Golf
A Penthouse for True Bon Vivants
This spectacular (...)
Current Featured Properties
€590,000
TSEA4777498
- Istán, Costa Del Sol, Istan
Beds: 3 Baths: 2 M2: 108 Area: Istan Region: Andalucía
Beds: 3 Baths: 2 M2: 108 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 (...)
€489,950
TSEA4450030
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Area: Fuengirola Region: Andalucía
This new development is located in the north of Fuengirola, in the Los Pacos neighborhood: a residential, multicultural and multilingual area with a cosmopolitan atmosphere, close to the beach and (...)
€420,000
TSEA5034892
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Benalmadena Region: Andalucía
The exclusive residential complex invites you to a modern lifestyle infused with traditional Andalusian charm, all within a community designed for those who appreciate quality and natural beauty. At (...)
