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 (41,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 (41,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 (41,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 81 - 100 of 792 €495,000
TSEA5138662
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 69 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 69 Area: Mijas and Mijas Costa Region: Andalucía
Welcome to this beautifully refurbished penthouse in the sought-after Los Prados del Golf complex, located in the charming town of La Cala de Mijas. Meticulously modernized to an exceptional standard (...)
€325,000
TSEA5137933
- Alhaurin Golf, Costa Del Sol, Alhaurin el Grande
Beds: 2 Baths: 2 M2: 100 Area: Alhaurin el Grande Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Alhaurin el Grande Region: Andalucía
Beautifully presented penthouse apartment on Alhaurin Golf
The apartment has been tastefully renovated with a new kitchen,
kitchen with all new appliances and leads out onto the private terrace (...)
€615,000
TSEA5137879
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 150 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Area: Benahavis Region: Andalucía
Fantastic property located in one of the most prestigious and sought-after areas of the Costa del Sol — the "Golden Triangle" of Benahavís, next to Guadalmina. The area is surrounded by (...)
€445,000
TSEA5137609
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 51 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 51 Area: Marbella Region: Andalucía
A unique and unrepeatable property, a beautiful one-bedroom penthouse apartment with a large, private, sunny terrace and beautiful unobstructed views over the Old Town.
Located on a quiet pedestrian (...)
€795,000
TSEA5137558
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 87 Area: Mijas and Mijas Costa Region: Andalucía
Penthouse Elegance – La Cala de Mijas
Welcome to a residence where modern architecture, Mediterranean light, and timeless elegance come together in perfect harmony.
Perched above the green (...)
€236,500
TSEA5136706
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 76 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 76 Area: Estepona Region: Andalucía
Central apartment in Estepona
The apartment has three bedrooms, one bathroom, and a terrace. The appliances are new: refrigerator, washing machine, ceramic hob, and electric water heater.
There is a (...)
€429,000
TSEA5136586
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 104 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Marbella East Region: Andalucía
Few places in East Marbella boast such spectacular gardens, large communal pools, and extensive amenities like this resort-style development. Amid the buildings, planters, and walkways, you'll find (...)
€365,000
TSEA5136559
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
A charming apartment for sale in a gated community, just a five-minute walk from the beach and seafront promenade, right in the heart of lower Riviera. The area offers shops, restaurants, the (...)
€298,000
TSEA5136499
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 100 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Manilva Region: Andalucía
Penthouse with Panoramic Sea Views!
Between Sea and Mountains
Nestled in a quiet valley in Manilva, this penthouse offers breathtaking views of the Mediterranean, Gibraltar, and the Moroccan (...)
€240,000
TSEA5136157
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 76 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 76 Area: Estepona Region: Andalucía
Amazing opportunity to live in the very heart of Estepona overlooking the Chess square.
The apartment is incredibly lit being the top 8th floor.
Great views, proximity to all possible services, (...)
€795,000
TSEA5135935
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 121 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 121 Area: Marbella West Region: Andalucía
Nestled within a tranquil gated community in Nueva Andalucía's prestigious Golf Valley, this exceptional, penthouse combines sleek Scandinavian design with unrivaled privacy and stunning golf course (...)
€1,199,000
TSEA5135581
- Montemar, Costa Del Sol, Torremolinos
Beds: 4 Baths: 2 M2: 414 Area: Torremolinos Region: Andalucía
Beds: 4 Baths: 2 M2: 414 Area: Torremolinos Region: Andalucía
Located in one of the best urbanizations of Torremolinos
This stunning penthouse is built on one floor with a large surface very difficult to find in other buildings, enjoys 414 m2 with 4 bedrooms, (...)
€1,495,000
TSEA5135473
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 120 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 120 Area: Fuengirola Region: Andalucía
Experience the pinnacle of coastal living in this exceptional 3-bedroom, 2.5-bathroom penthouse, perfectly positioned in the exclusive El Higuerón community. Designed for those who demand the very (...)
€1,250,000
TSEA5135230
- Higueron, Costa Del Sol
Beds: 3 Baths: 3 M2: 130 Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Region: Andalucía
Exclusive newly built penthouse with 3 bedrooms and 3 bathrooms located in a modern two-storey building with an impressive 16-metre-long façade. The property has a bright living-dining room with a (...)
€620,000
TSEA5135143
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 98 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 98 Area: Marbella Region: Andalucía
Impeccable top floor apartment in the heart of Marbella, just a 5-minute walk from the beach and the promenade, and next to supermarkets and shops. The property was renovated very recently, and (...)
€420,000
TSEA5134771
- Benalmadena Pueblo, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 112 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: Benalmadena Region: Andalucía
Penthouse for Sale in Benalmádena Pueblo – Historic Centre with Terrace and Large Solarium
Discover this exclusive penthouse for sale in Benalmádena Pueblo, located right in the Historic Centre, (...)
€499,000
TSEA5134372
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 3 M2: 170 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 3 M2: 170 Area: La Duquesa Region: Andalucía
PENTHOUSE WITH SPECTACULAR PANORAMIC SEA VIEWS IN A PRIVATE GATED COMMUNITY BETWEEN SOTOGRANDE AND PUERTO DE LA DUQUESA.Privileged location in a beautiful private urbanization with 24-hour security, (...)
€880,000
TSEA5134267
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 306 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 306 Area: San Pedro Region: Andalucía
We invite you to explore this remarkable 4 bedroom penthouse that offers spectacular 180º sea views and epitomizes the perfect blend of location, space, and functionality. Nestled in one of the most (...)
€560,000
TSEA5134201
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
This centrally located apartment is a perfect combination for those who want a modern accommodation but at the same time close to the old town. You'll walk down to the old town in a few minutes where (...)
€335,000
TSEA5133625
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 148 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 148 Area: Mijas and Mijas Costa Region: Andalucía
Opportunity, new on the market!!
Beautiful penthouse with a large sunny terrace with panoramic views, 100% privacy and tranquility, located in the heart of Las Lagunas de Mijas.
The property is (...)
Current Featured Properties
€2,995,000
TSEA5143633
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 154 Area: Estepona Region: Andalucía
Bahía del Velerín is a luxurious community between Marbella and Estepona. It has a fantastic pool area with a snack bar, tropical gardens and 24/7 security. The community is located at one of the (...)
€1,190,000
TSEA5002087
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 130 Area: Mijas and Mijas Costa Region: Andalucía
Discover the beauty of the natural surroundings of your community. Enjoy the serenity of a home committed to nature, which cares for the environment and is committed to replanting native vegetation (...)
€1,050,000
TSEA4581964
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 125 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Marbella Region: Andalucía
New development. Two- and three-bedrooms apartments with all kinds of leisure services that will change your life.
Modern units with large spaces, big windows, and wide terraces. Southwest (...)
