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 481 - 500 of 4559 €415,000
TSEA5139883
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 103 Lot Size: 18 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Lot Size: 18 Area: Marbella East Region: Andalucía
Beautiful 3 bedrooms and 2 bedroom groundfloor apartment in the hills above Elviria, La Mairena!
This sunny sea view garden apartment located in the east of Marbella, offers a great south
west (...)
€277,000
TSEA5139847
- El Ejido, Costa Del Sol
Beds: 3 Baths: 1 M2: 83 Region: Andalucía
Beds: 3 Baths: 1 M2: 83 Region: Andalucía
Imagine waking up every morning with soft sunlight streaming through your windows. You draw back the curtains, and there it is: your private terrace, your calm little corner in the heart of Málaga. (...)
€600,000
TSEA5139826
- Carvajal, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 110 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Mijas and Mijas Costa Region: Andalucía
Wonderful first line beach apartment with panoramic sea views.
This elegant 3-bedroom, 2-bathroom frontline beach apartment has beautiful panoramic views of the Mediterranean, perfectly located on (...)
€328,900
TSEA5139784
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 56 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 56 Area: Fuengirola Region: Andalucía
New Development: Prices from 328,900 € to 403,900 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 56.00 m2 - 63.00 m2]
Discover our two- and three-bedroom apartments and penthouses, each designed (...)
€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 (...)
€555,000
TSEA5139736
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 162 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 162 Area: Estepona Region: Andalucía
This charming three-storey semi-detached villa combines comfort, spaciousness and a functional layout, ideal for enjoying with the family.
On the main floor, upon entering the house, we find a (...)
€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 (...)
€549,000
TSEA5139616
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 107 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 107 Area: Fuengirola Region: Andalucía
*Unique Opportunity in Torreblanca, Fuengirola – Your Dream Home Awaits!*
Discover this charming terraced house in the heart of Torreblanca, Fuengirola. With a generous 107 m² constructed area (...)
€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 (...)
€390,000
TSEA5139130
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 127 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Casares Region: Andalucía
Step into your new coastal retreat! This beautifully maintained property offers 3 spacious bedrooms, 2 bathrooms, plus a convenient guest toilet.
Enjoy outdoor living with a private newly tiled (...)
€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 (...)
€444,755
TSEA5139070
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 170 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 170 Area: Mijas and Mijas Costa Region: Andalucía
Property with potential value, Benalmádena.
This semi-detached house is the strategic investment you are looking for. Its unbeatable location opposite the Torrequebrada International School, (...)
Current Featured Properties
€1,241,100
TSEA4964773
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 174 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 174 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
€585,000
TSEA4819738
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 2 M2: 103 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: Benahavis Region: Andalucía
The new residential is part of the renowned private urbanization "La Hacienda del Señorío de Cifuentes" with which they will share the enjoyment of its current four swimming pools with (...)
€490,000
TSEA5058604
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
This new development in the Estepona Centre comprising 43 one, two and three bedroom apartments and penthouses, terraces and magnificent communal areas. It boasts excellent finishes, a prime location (...)
