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,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 (163,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 (163,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 141 - 160 of 296 €375,000
TSEA5040961
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Fuengirola Region: Andalucía
Lovely penthouse with solarium for sale walking distance to the beach. This property offers 2 bedrooms and 2 bathrooms, fully quipped kitchen and lounge dining with a terrace of 18m2 with afternoon (...)
€539,000
TSEA5039416
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 3 M2: 234 Area: Casares Region: Andalucía
Beds: 3 Baths: 3 M2: 234 Area: Casares Region: Andalucía
Exclusive opportunity in Terrazas de Bahía: Spacious 3-bedroom apartment with sea view!
Do you dream of a luxurious life on the sun-kissed Costa del Sol? This impressive 4-bedroom, 3-bathroom (...)
€2,295,000
TSEA5039125
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 363 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 363 Area: Marbella West Region: Andalucía
This expansive duplex penthouse is located within the prestigious Los Arrayanes residential complex, in the peaceful and elevated Supermanzana JKL area of Nueva Andalucía. Spread across two (...)
€459,900
TSEA5039068
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 149 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 149 Area: Estepona Region: Andalucía
Penthouse Duplex, Estepona, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 149 m², Terrace 80 m².
2 minutes to the beach! Centre of Estepona, old town and port
Includes underground garage space and (...)
€349,950
TSEA4907410
- Vélez-Málaga, Costa Del Sol East, Nerja and Malaga East
Beds: 3 Baths: 2 M2: 182 Area: Nerja and Malaga East Region: Andalucía
Beds: 3 Baths: 2 M2: 182 Area: Nerja and Malaga East Region: Andalucía
New Development: Prices from 349,950 € to 349,950 €. [Beds: 3 - 3] [Baths: 2 - 2] [Built size: 182.00 m2 - 182.00 m2]
PHASE 1 IN DELIVERY!
PHASE 2 UNDER CONSTRUCTION.
92 homes with top quality (...)
€1,150,000
TSEA5035138
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 200 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 200 Area: Benahavis Region: Andalucía
This beautifully designed duplex apartment is situated in one of Benahavís' most sought-after residential communities, offering stunning panoramic views of the Mediterranean Sea and surrounding (...)
€1,395,000
TSEA5034265
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 190 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 190 Area: Estepona Region: Andalucía
Incredible 4 Bedroom 3.5 Bath Duplex Penthouse in the sought after development of Mirador de Estepona Hills.
Mirador de Estepona Hills is an exclusive residential development situated in Estepona, (...)
€175,000
TSEA5034157
- Olletas, Costa Del Sol
Beds: 1 Baths: 1 M2: 36 Region: Andalucía
Beds: 1 Baths: 1 M2: 36 Region: Andalucía
Charming Fully Furnished Studio Apartment in Olletas, Málaga — Ready to Move In or Rent Out
This fully furnished and equipped studio is ideal as a primary residence or as a rental unit for (...)
€460,000
TSEA5032792
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Mijas and Mijas Costa Region: Andalucía
Duplex penthouse for sale in Nueva Torrequebrada, Benalmadena Costa.
Duplex penthouse for sale in Nueva Torrequebrada, Benalmadena Costa.
For sale duplex penthouse with spectacular views in Nueva (...)
€699,000
TSEA5032465
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 282 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 282 Area: Marbella Region: Andalucía
This luxurious duplex penthouse is located within a prestigious golf residential complex in Marbella and boasts breathtaking panoramic views. Elegantly furnished and fully equipped with high-end (...)
€695,000
TSEA5032273
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 90 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 90 Area: Estepona Region: Andalucía
Modern Scandinavian-Style Penthouse with Spacious Terrace in Cancelada
This newly built penthouse blends Scandinavian elegance with modern comfort in an unbeatable location.
Featuring 3 bedrooms, (...)
€619,000
TSEA5025922
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 192 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 192 Area: Estepona Region: Andalucía
Exquisite duplex penthouse with panoramic mountain and country views in Lunymar Golf, New Golden Mile, Estepona
Nestled in the highly sought-after New Golden Mile of Estepona, this spectacular (...)
€299,000
TSEA5024455
- Valle Romano, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Estepona Region: Andalucía
Penthouse Duplex, Valle Romano, Costa del Sol.
2 Bedrooms, 2 Bathrooms, Built 100 m², Terrace 100 m².
Setting : Close To Golf, Urbanisation.
Orientation : South.
Condition : Excellent.
Pool : (...)
€895,000
TSEA5024350
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 247 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 247 Area: Marbella Region: Andalucía
Discover your dream home with this stunning townhouse in the prestigious Pueblo Los Monteros Urb. located in Altos de Los Monteros, Marbella.
Meticulously maintained and ready for you to move in! (...)
€815,000
TSEA5022124
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 146 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 146 Area: Estepona Region: Andalucía
Welcome to your future home in Estepona, a place where comfort, design, and spectacular views come together.
This stunning duplex penthouse, with 244 m² of built area including terraces (146 m² of (...)
€1,300,000
TSEA5021158
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 395 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 395 Area: Marbella Region: Andalucía
Nestled in the charming Andalusian-style urbanization of Pueblo Los Monteros in Altos de Marbella, this extraordinary apartment blends traditional elegance with modern sophistication. Originally two (...)
€425,000
TSEA5020513
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Marbella East Region: Andalucía
Ideally located duplex penthouse situated within walking distance to the beaches of Elviria.
This 2 bedroom 2 bathroom duplex penthouse apartment is located on one of the most sought after (...)
€399,000
TSEA5020444
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 118 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 118 Area: Fuengirola Region: Andalucía
Duplex Penthouse with Open Views in Lomas de Torreblanca
Discover this fantastic duplex penthouse, ideal as a family home, located in the sought-after community of Lomas de Torreblanca. The property (...)
€935,000
TSEA5019157
- Artola, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 136 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 136 Area: Marbella East Region: Andalucía
Discover the charm of this luxurious two-bedroom penthouse with a stunning rooftop terrace, located in the sought-after enclave of Artola, just a 20-minute walk from the beach.
Layout:
Upon entering (...)
€298,000
TSEA5018965
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 2 M2: 176 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 2 M2: 176 Area: Mijas and Mijas Costa Region: Andalucía
Comfortable living. Smart investing. One-of-a-kind opportunity.
What if I told you there's a place where peace of mind, profitability, and quality of life come together?
That place exists. It's (...)
Current Featured Properties
€1,100,000
TSEA4433068
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M2: 188 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 4 M2: 188 Area: San Pedro Region: Andalucía
Impressive Duplex Penthouse in Nueva Alcantara only 100 meters from the beach of San Pedro
Spacious duplex penthouse in the urbanization of La Gavia in Nueva Alcántara very close to all kinds of (...)
€2,295,000
EMPTY
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 148 Area: Malaga Region: Andalucía
The development is located in a prime enclave, surrounded by parks and landscaped areas, close to a wide variety of sports, healthcare, commercial spaces, and universities. Just 10 minutes from the (...)
€1,007,050
TSEA5042083
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 97 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 97 Area: San Pedro Region: Andalucía
In an exceptional location in San Pedro Alcántara, just a short walk from the beach and with views of the sea and the impressive La Concha peak. Discover a new way of living in San Pedro Alcántara (...)
