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 (51,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 (51,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 (51,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 2681 - 2700 of 3915 €910,000
TSEA4964749
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 94 Lot Size: 23 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Lot Size: 23 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 (...)
€415,000
TSEA4964677
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 67 Area: Mijas and Mijas Costa Region: Andalucía
This fantastic top-floor duplex penthouse is located in the heart of Calahonda, within walking distance to the beach, shops, restaurants, gym, padel courts, and all essential amenities.
The (...)
€3,850,000
TSEA4964386
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 136 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 136 Area: Marbella East Region: Andalucía
Situated in the well-known Puente Romano Resort, this apartment offers a comfortable and stylish living space in one of Marbella's most desirable locations. Designed with an open-plan layout, it (...)
€1,150,000
TSEA4964227
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 90 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 90 Area: Marbella Region: Andalucía
Exclusive Luxury Penthouse Duplex in the Heart of Marbella
Discover this architectural gem in a prime location, just 100 metres from the beach and next to Marbella's charming Old Town. This (...)
€1,195,000
TSEA4964221
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 145 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 145 Area: Marbella Region: Andalucía
LARGE PROPERTY 200 METERS FROM THE BEACH IN THE CENTER OF MARBELLA
Fantastic large property, with a privileged location in the center of Marbella, 200 meters from the promenade and the beach, (...)
€1,190,000
TSEA4964188
- Los Flamingos, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 156 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 156 Area: Estepona Region: Andalucía
Luxurious Penthouse with Amazing Panoramic Views in Royal Flamingos, Benahavis!
Located within the prestigious Royal Flamingos community in Benahavis, this exquisite penthouse offers an unparalleled (...)
€410,000
TSEA4964167
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 135 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 135 Area: Estepona Region: Andalucía
Located in the exclusive, privileged area of Costalita on the New Golden Mile, Estepona. Just a few minutes walk to the beautiful, sandy beaches and within easy reach of many local amenities (...)
€299,000
TSEA4964038
- Miraflores, 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
Bright 2-Bed Corner Apartment in Miraflores
A bright and spacious 2-bedroom, 2-bathroom corner apartment in the sought-after Albamar complex in Miraflores, Mijas Costa. Offering a prime west-facing (...)
€480,000
TSEA4964029
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Estepona Region: Andalucía
We are delighted to present this exceptional brand new two-bedroom apartment on the first floor of the brand-new One80 Suites development.
Boasting a spectacular orientation and breathtaking sea (...)
€1,490,000
TSEA4963921
- Sotogrande, Costa Del Sol, Sotogrande
Beds: 3 Baths: 4 M2: 288 Area: Sotogrande Region: Andalucía
Beds: 3 Baths: 4 M2: 288 Area: Sotogrande Region: Andalucía
Village Verde is an exclusive community of luxury apartments in La Reserva in the heart of Sotogrande. This exceptional property boasts the most advantageous location with the development, enjoying (...)
€410,000
TSEA4165081
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 135 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 135 Area: Malaga Region: Andalucía
New Development: Prices from 410,000 € to 410,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 135.00 m2 - 135.00 m2]
The project is designed by the HCP Architecture Studio, distributed in a (...)
€1,179,000
TSEA4961605
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 208 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 208 Area: Marbella West Region: Andalucía
Fantastic fully refurbished penthouse in the well known private urbanization Jardines del Puerto, second line of Puerto Banus so is walking distance to the beach, ammenities and the Port. Tis (...)
€490,000
TSEA4961512
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 133 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Estepona Region: Andalucía
GREAT PROPERTY NEXT TO GOLF COURSES
Fantastic renovated property with large dimensions, located in the exclusive area of Atalaya, next to the Atalaya and El Paraiso golf courses, just a few minutes (...)
€480,000
TSEA4961470
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Area: Benahavis Region: Andalucía
A practical hassle-free investment.
This Duplex Penthouse offers the perfect blend of resort hotel services and amenities with the independence of an apartment. Enjoy access to multiple swimming (...)
€749,000
TSEA4958965
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 102 Lot Size: 108 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Lot Size: 108 Area: Estepona Region: Andalucía
This modern 7th floor penthouse apartment is located overlooking Estepona marina and offers two double bedrooms and two bathrooms (one ensuite) plus a large private roof terrace. The apartment has (...)
€2,600,000
TSEA4958815
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 156 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 156 Area: Marbella West Region: Andalucía
Frontline beach 3 bedroom apartment for sale in Granados Banus near Marbella, Spain.
Rare opportunity! Stunning apartment located in one of the most sought after luxury community in Puerto Banus, (...)
€299,000
TSEA4958782
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 1 Baths: 1 M2: 59 Area: Marbella West Region: Andalucía
Beds: 1 Baths: 1 M2: 59 Area: Marbella West Region: Andalucía
Prime Coastal Apartment – Stunning Views & Ideal Location
Located near the beach, just 450 meters from the sea, this beautifully newly refurbished apartment offers breath-taking views of both (...)
€476,000
TSEA4958722
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 170 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 170 Area: Torremolinos Region: Andalucía
Ground floor apartment in Torremolinos with stunning sea views from almost every room. This spacious property features a shared pool and is situated in a prime location close to supermarkets, (...)
€125,000
TSEA4958695
- Jimena de la Frontera, Costa de la Luz
Beds: 3 Baths: 2 M2: 100 Region: Andalucía
Beds: 3 Baths: 2 M2: 100 Region: Andalucía
Ground Floor Apartment, Jimena de la Frontera, Costa de la Luz.
3 Bedrooms, 2 Bathrooms, Built 100 m², Terrace 20 m².
Setting : Town, Commercial Area, Village, Mountain Pueblo, Close To Shops, (...)
€170,000
TSEA4958632
- Coín, Costa Del Sol, Coin
Beds: 2 Baths: 1 M2: 73 Area: Coin Region: Andalucía
Beds: 2 Baths: 1 M2: 73 Area: Coin Region: Andalucía
Penthouse with large terrace, garage and south facing! Penthouse for sale in a building with only 3 floors, with a communal area ideal for the family. Bright and well-distributed home, perfect for (...)
Current Featured Properties
€867,000
TSEA4555660
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 125 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 125 Area: Estepona Region: Andalucía
SPACIOUS PROPERTIES WITH SPECTACULAR VIEWS!!
An exclusive community comprising 84 luxury properties with generous indoor spaces, roomy terraces, spectacular views, community areas, swimming pool and (...)
€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 (...)
€375,000
TSEA4175446
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 89 Area: Estepona Region: Andalucía
IF YOU LOVE GOLF YOU WILL LOVE THIS DEVELOPMENT!!
This is the new residential development in Estepona Golf, at the heart of the Costa del Sol, a privileged location close to wonderful beaches such as (...)
