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 (53,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 (53,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 (53,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 741 - 760 of 3900 €295,000
TSEA5126407
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 99 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: La Duquesa Region: Andalucía
Princesa Kristina area - South facing elevated spacious apartment with amazing sea views. Spacious, apartments with private terraces, fully equipped kitchens, and access to a communal outdoor (...)
€495,000
TSEA5126401
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 52 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: Marbella Region: Andalucía
Penthouse with 80 m² Terrace to Renovate – Great Potential in the Heart of Marbella Center
Located on the 7th floor of a well-known building on Ricardo Soriano, Marbella's main avenue, this (...)
€279,000
TSEA5126332
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 194 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 194 Area: Casares Region: Andalucía
Located in the peaceful and sought-after urbanization of Hacienda Casares, near the prestigious Doña Julia golf course, this 3-bedroom, 2-bathroom apartment stands out for its excellent condition (...)
€1,590,000
TSEA5126305
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 160 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 160 Area: Marbella East Region: Andalucía
Welcome to Balcon de Puente Romano – a gated community on Marbella's prestigious Golden Mile.
This 3-bedroom ground-floor property offers a sophisticated single-level living, complemented by a (...)
€790,000
TSEA5126278
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 129 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 129 Area: Marbella East Region: Andalucía
Beautiful south-facing apartment with magnificent sea views, located in the sought-after community of Pinos de Nagüeles, in Marbella's prestigious Golden Mile. Within walking distance to the beach, (...)
€785,000
TSEA5126197
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 3 M2: 110 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 3 M2: 110 Area: Fuengirola Region: Andalucía
Luxurious 3-Bedroom Apartment with Tourist License in the Heart of El Higuerón
Welcome to this stunning 3-bedroom, 3-bathroom fully furnished apartment, perfectly positioned in the very heart of (...)
€320,000
TSEA5126191
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 126 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 126 Area: Manilva Region: Andalucía
The house is completely exterior.
It has 146 square meters, and consists of:
- Living room, designed to have 2 environments, with XXL sofa to enjoy the 65 inch LG QNED TV.
- Kitchen and laundry room (...)
€299,900
TSEA5126188
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Penthouse 2-Bedroom Apartment with Mountain Views – Fuengirola
We are delighted to present this bright and beautifully renovated 2-bedroom, 1-bathroom top-floor apartment, ideally located in the (...)
€990,000
TSEA5126179
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 4 M2: 220 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 4 M2: 220 Area: Fuengirola Region: Andalucía
Exclusive Property in a Luxury Complex in Lower Torreblanca
We are delighted to present this magnificent residence located in one of the most luxurious and prestigious residential complexes in the (...)
€439,000
TSEA5126161
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 57 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 57 Area: Mijas and Mijas Costa Region: Andalucía
Elegant Penthouse with Sea Views. Fully Renovated and Surrounded by Tranquility by the Beach
Welcome to a truly exceptional penthouse where style, comfort, and nature come together in perfect (...)
€1,100,000
TSEA5126155
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 183 Region: Andalucía
Beds: 2 Baths: 2 M2: 183 Region: Andalucía
This spectacular brand new penthouse, located in one of the best areas of the exclusive El Higuerón.
The property is part of an exclusive residential complex of only 36 homes, with the maximum (...)
€1,100,000
TSEA5126092
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 91 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Marbella West Region: Andalucía
INVESTOR ALERT – Prime Marina Apartment in Puerto Banús with Panoramic Sea Views
Welcome to the best-located apartment in the heart of Marina Puerto Banús, spacious, bright and on the first line (...)
€1,050,000
TSEA5126071
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 204 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 204 Area: Fuengirola Region: Andalucía
Luxury Penthouse with Private Rooftop Pool
Welcome to one of the most exclusive penthouses on the Costa del Sol — newly renovated, privately elevated above the Fuengirola promenade, and complete (...)
€315,000
TSEA5126065
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 83 Area: Fuengirola Region: Andalucía
Apartment for Sale with Sea Views in Fuengirola – Comfort, Natural Light, and Prime Location
Beautiful ground-floor apartment with a private entrance directly from the street, located in a quiet (...)
€295,000
TSEA5126005
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 94 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Mijas and Mijas Costa Region: Andalucía
Comfortable and very well-maintained apartment located on the 3rd floor of a building with an elevator, in a quiet and peaceful area.
The property consists of two spacious bedrooms and two bathrooms (...)
€529,995
TSEA5125981
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 130 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Marbella East Region: Andalucía
Ample 3 bedroom corner apartment in the sought after Los Jardines in Santa Maria Golf. Situated on the first floor offering a total floor space of 130 square meters plus terrace. The community is (...)
€449,000
TSEA5125966
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 154 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 154 Area: Estepona Region: Andalucía
Stunning Elevated Ground Floor Apartment in Las Olas – Fully Furnished & Key Ready
This beautifully appointed 2-bedroom, 2-bathroom apartment is located in the highly sought-after boutique (...)
€195,000
TSEA5125924
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 1 Baths: 1 M2: 55 Area: La Duquesa Region: Andalucía
Beds: 1 Baths: 1 M2: 55 Area: La Duquesa Region: Andalucía
This charming raised ground floor one bedroom, one bathroom apartment, is situated in a sought-after gated community in the area of Duquesa. The property is in excellent condition and offers a (...)
€649,000
TSEA5125918
- Artola, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 138 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 138 Area: Marbella East Region: Andalucía
Super bright penthouse with 2 large terraces for sale in Artola Alta, East Marbella
Beautiful penthouse, perfectly positioned in the exclusive Ocean Pino Golf complex is now up for sale. Boasting (...)
€475,000
TSEA5125885
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 112 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Estepona Region: Andalucía
Contemporary 3-Bedroom Apartment in the Heart of Estepona
This fully reformed 3-bedroom, 2-bathroom apartment offers modern coastal living just 250 metres from the beach and promenade in Estepona. (...)
Current Featured Properties
€400,000
TSEA4805725
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 56 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 56 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 (...)
€370,000
TSEA5149801
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 46 Area: Estepona Region: Andalucía
This new development rises with an enveloping architectural design, where flowing curves open towards the sea and mountains, seamlessly extending the natural landscape. Its design flows with elegance (...)
€418,500
TSEA4355662
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 90 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Lot Size: 50 Area: Mijas and Mijas Costa Region: Andalucía
A NEW DEVELOPMENT WHERE YOU WILL WANT TO LIVE!!!
This new development is a modern and functional gated residential complex, and an ideal place to live. The development consists of 46, two and three (...)
