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 (44,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 (44,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 (44,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (3910), Middle Floor - (3910), Penthouse - (3910), Top Floor Apartment - (3910), Penthouse Duplex - (3910)Properties
Results 241 - 260 of 3924
€725,000
TSEA5147932
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 138 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 138 Area: Marbella Region: Andalucía
FIRST LINE BEACH APARTMENT!
Magnificent duplex penthouse for sale in one of the best areas of San Pedro de Alcantara (Marbella). Nueva Alcantara, on the beachfront and of course with wonderful sea (...)
€550,000
TSEA5147926
- Costalita, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: Estepona Region: Andalucía
3-Bedroom Penthouse in Prime Beachside Location
This spacious three-bedroom penthouse is located in Costalita in Estepona East. Upon entering, you are welcomed by a modern kitchen that flows into (...)
€495,000
TSEA5147920
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 127 Area: Mijas and Mijas Costa Region: Andalucía
Live the Mediterranean Dream: Your Beachside Oasis in Calahonda Awaits
Discover the pinnacle of coastal living in this impeccable, ground-floor two-bedroom apartment, situated in a secure beachfront (...)
€540,000
TSEA5147887
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 130 Lot Size: 50 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Lot Size: 50 Area: Marbella West Region: Andalucía
Ground Floor Apartment, Nueva Andalucía, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 130 m², Terrace 26 m², Garden/Plot 50 m².
Setting : Close To Schools, Urbanisation.
Orientation : East, (...)
€425,000
TSEA5147836
- Hacienda del Sol, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: Estepona Region: Andalucía
A beautifully located first-floor apartment in the highly sought-after Hacienda del Sol development. The apartment features a spacious master bedroom with an en-suite bathroom, a second bedroom, and (...)
€649,000
TSEA5147812
- 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
** Experience one of Marbella's most breathtaking panoramic Sea Views from this fully renovated apartment **
This spacious 103m² apartment has been completely renovated with high-quality finishes. (...)
€630,000
TSEA5147809
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 93 Lot Size: 139 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 93 Lot Size: 139 Area: Fuengirola Region: Andalucía
Experience Contemporary Luxury in El Higuerón, Fuengirola
Discover this exclusive ground-floor apartment with a spacious private garden, designed in a modern and minimalist style in one of the most (...)
€415,000
TSEA5147797
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Fantastic 85m2 apartment with terrace. Spacious and bright, fully furnished and equipped with 2 bedrooms, 2 bathrooms, one en suite, on the beachfront in one of the most sought-after areas of the (...)
€199,000
TSEA5147791
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 1 Baths: 1 M2: 26 Area: Benalmadena Region: Andalucía
Beds: 1 Baths: 1 M2: 26 Area: Benalmadena Region: Andalucía
Renovated Studio with Sea Views on the Top Floor – Puerto Marina, Benalmádena
Located on the seventh and top floor of a well-maintained building, this bright, renovated studio offers stunning (...)
€480,000
TSEA5147764
- Los Flamingos, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Estepona Region: Andalucía
Imagine living in a spectacular penthouse in a very private and quiet complex, just at the entrance of Los Flamingos! This wonderful penthouse features 2 bedrooms and 2 bathrooms, a fully equipped (...)
€495,000
TSEA5147761
- Los Flamingos, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 110 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 110 Area: Estepona Region: Andalucía
Stunning Penthouse in an Exclusive and Peaceful Complex at the Entrance of Los Flamingos
This fantastic 3-bedroom, 3-bathroom penthouse offers the perfect blend of privacy, space, and breathtaking (...)
€585,000
TSEA5147521
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 110 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Marbella East Region: Andalucía
Spacious and bright ground floor apartment situated in a beachfront complex in Elviria.
The complex has a direct access to the beach, 2 open swimming pools (one is heated), beautiful well maintained (...)
€489,000
TSEA5147506
- 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
Exclusive Apartment with Panoramic Views in Villa Padierna
Discover a rare opportunity to own a stunning apartment in the prestigious Villa Padierna community, Benahavís. With sweeping views over (...)
€495,000
TSEA5147467
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 81 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 81 Area: Fuengirola Region: Andalucía
???? Apartment for Sale – Paseo Marítimo, Fuengirola
Stunning fourth-floor apartment located on the beachfront, facing south with direct sea views.
The property features 2 bedrooms with built-in (...)
€5,390,000
TSEA5147437
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 588 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 588 Area: Marbella East Region: Andalucía
This exceptional duplex penthouse is located within Epic Marbella on the Golden Mile, one of the most prestigious addresses in Marbella. Designed to impress, the property spans 586 m², including 351 (...)
€345,000
TSEA5147416
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Estepona Region: Andalucía
Charming two bedroom, two bathroom first floor apartment in quiet residential area close to golf, restaurants, shops and schools.
This south facing apartment is in fantastic condition and has (...)
€345,000
TSEA5147392
- Selwo, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: Estepona Region: Andalucía
Middle Floor Apartment, Selwo, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 132 m², Terrace 20 m².
Setting : Urbanisation.
Orientation : South West.
Condition : Excellent.
Pool : (...)
€775,000
TSEA5147380
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 127 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 127 Area: San Pedro Region: Andalucía
Brand-new apartment in MARE Urbanización, San Pedro Alcántara
Discover this modern 3-bedroom, 2-bathroom apartment with 103 m² of interior space and a 30 m² sunny terrace, perfect for enjoying (...)
€660,000
TSEA5147296
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 75 Area: Mijas and Mijas Costa Region: Andalucía
In the prestigious Phase I of the Residential Complex "Ipanema, by Kronos Homes", located in the municipality of Mijas, lies this exclusive penthouse, which combines modern design, (...)
€295,000
TSEA5147170
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 77 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: La Duquesa Region: Andalucía
For sale, South East facing middle floor apartment in an established gated community within Los Hidalgos area of La Duquesa, Manilva Costa del Sol, located just 5 minutes from the beach.
This (...)
Current Featured Properties
€995,000
TSEA4413595
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 162 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 162 Area: San Pedro Region: Andalucía
Located at the heart of the most coveted luxury destination in the world, experience the year-round allure of Europe's finest climate, boasting an average temperature of 20°C and over 300 sun-kissed (...)
€395,000
TSEA4184656
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 91 Lot Size: 49 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Lot Size: 49 Area: Mijas and Mijas Costa Region: Andalucía
FRONTLINE GOLF PROPERTY!!!
This new development is located only 5 minutes away from La Cala de Mijas, one of the most popular holiday locations at the moment on the Costa del Sol. La Cala de Mijas (...)
€2,350,000
TSEA5080762
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Area: Estepona Region: Andalucía
Menara Beach is a luxury beachfront community on the New Golden Mile, located between Marbella and Estepona. Designed by Melvin Villaroel, it features tropical gardens, two outdoor pools, a heated (...)
