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 (163,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 (163,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 (163,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3910), Middle Floor - (3910), Penthouse - (3910), Top Floor Apartment - (3910), Penthouse Duplex - (3910)Properties
Results 421 - 440 of 3899 €249,000
TSEA5139775
- New Golden Mile, 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
Do you have your very own ideas about your dream home? Then this faboulous property is a perfect opportunity for you!
Only 1000 metres from the beach is this fantastic rough diamond of a holiday (...)
€295,000
TSEA5139766
- Calanova Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 95 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Mijas and Mijas Costa Region: Andalucía
Live the Dream! Your Sun-Drenched Golf & Sea View Paradise Awaits in Calanova Golf!
Imagine waking up to breathtaking panoramic views of the mountains and the glittering Mediterranean Sea all (...)
€199,000
TSEA5139703
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 60 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 60 Area: Casares Region: Andalucía
Apartment with spectacular mountain views in Casares Playa
This charming two-bedroom, two-bathroom apartment combines comfort, style, and an unbeatable location in Casares Playa. From its large 28 (...)
€470,000
TSEA5139685
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 115 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Benahavis Region: Andalucía
This exquisite 2-bedroom, 2-bathroom apartment in Benahavís is a perfect blend of modern elegance and
Mediterranean charm. Boasting a generous interior space of 115 square meters, the apartment (...)
€182,000
TSEA5139640
- Casares Playa, Costa Del Sol, Casares
Beds: 1 Baths: 1 M2: 56 Area: Casares Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Casares Region: Andalucía
Apartment in Marina de Casares with Stunning Frontline Sea Views
Key Features:
Living area: 56 m²
Terrace: 10 m²
Floor: First
Bedrooms: 1
Bathrooms: 1
Kitchen: Open-plan
Views: Frontline (...)
€590,000
TSEA5139637
- Selwo, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 160 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 160 Area: Estepona Region: Andalucía
This spectacular 4-bedroom, 3-bathroom duplex apartment is located in the exclusive Selwo area, offering an ideal space for families or those seeking comfort and spaciousness. The living room is (...)
€239,000
TSEA5139253
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 70 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Estepona Region: Andalucía
Renovated Apartment in the Heart of Estepona
Unique opportunity to own a beautifully renovated apartment in one of the most charming areas of Estepona. Ideally situated on a quiet pedestrian street (...)
€425,000
TSEA5139172
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Located in a gated community with a swimming pool and beautiful landscaped gardens, this spacious duplex penthouse offers the perfect combination of comfort, style and an unbeatable location in the (...)
€450,000
TSEA5139157
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 1 Baths: 1 M2: 81 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 1 M2: 81 Area: Marbella East Region: Andalucía
Position is the key of this East-facing one bedroom two bathroom garden apartment overlooking the gardens and pools of the popular La Carolina Park complex. The extensive communal gardens, two (...)
€439,000
TSEA5139097
- 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
Location, Location, Location!
This stunning 3-bedroom, 2-bathroom apartment is perfectly situated in the heart of Estepona town—just a 10-minute walk to the beautiful beach and charming old town. (...)
€630,000
TSEA5139094
- 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
Fantastic Location in the Heart of Estepona!
Less than a 10-minute stroll to the beautiful beach, seafront promenade, and the charming historical Old Town of Estepona, this spacious duplex penthouse (...)
€305,000
TSEA5139082
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 102 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 102 Area: Estepona Region: Andalucía
Spacious renovated apartment in Selwo – La Resina, featuring 3 bedrooms and 3 bathrooms.
It offers a sunny south-facing terrace with sea views. Located in a quiet community,
it includes communal (...)
€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 (...)
Current Featured Properties
€301,000
TSEA5008435
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 88 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Casares Region: Andalucía
STUNNING VIEWS OF THE MOUNTAINS AND SEA!!!
This brand new development consists of 47 apartments with 2 and 3 bedrooms, distributed in 3 blocks with ground floor and 2 floors. All of them with garage (...)
€907,852
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA.
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 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 (...)
€305,000
TSEA4707214
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 62 Area: Fuengirola Region: Andalucía
New development for sale in the center of Fuengirola just 200 m to the beach, historic center, near the Fuengirola Marina. There are 6 apartments with 2 and 3 bedrooms, with 2 bathrooms, terrace and (...)
