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 (43,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 (43,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 (43,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 261 - 280 of 4194
€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 (...)
€650,000
TSEA5147359
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 134 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 134 Area: Mijas and Mijas Costa Region: Andalucía
This stunning, newly completed modern contemporary 3 bedroom semi-detached villa in urbanisation Alya offers stylish contemporary living in a sought-after residential area. Built to the highest (...)
€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 (...)
€480,000
TSEA5147146
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 102 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 102 Area: Marbella East Region: Andalucía
Master en-suite with full bathroom, dressing room, and direct access to the terrace through double-glazed sliding doors.
Second double bedroom with built-in wardrobe, access to the terrace, and (...)
€375,000
TSEA5147125
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 66 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 66 Area: Marbella Region: Andalucía
BEACHSIDE GROUND FLOOR APARTMENT – REFORM OPPORTUNITY IN MARBELLA DEL MAR
Fantastic opportunity in the sought-after Marbella del Mar complex, set directly on the beachfront and only 10 minutes' (...)
€649,000
TSEA5147071
- El Paraiso, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 103 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 103 Area: Estepona Region: Andalucía
Located in the prestigious Hacienda Señorio de Cifuentes, this stunning apartment offers the perfect balance between luxury, comfort, and nature. Surrounded by renowned golf courses and boasting (...)
€180,000
TSEA5147068
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 50 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 50 Area: Mijas and Mijas Costa Region: Andalucía
Investment Opportunity Just 200 Meters from the Beach!
Beautiful renovated apartment for sale, ideal as a vacation rental or second home. Located in a quiet area with stunning sea views, this bright (...)
Current Featured Properties
€795,000
TSEA4358863
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 101 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Fuengirola Region: Andalucía
ACT NOW, THESE WILL GO FAST!!!
Spectacular new development of 60 luxury apartments in the most sought-after area of El Higuerón, in a gated exclusive community with gym, heated pool, jacuzzis and (...)
€465,500
TSEA4986637
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 84 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 84 Area: Mijas and Mijas Costa Region: Andalucía
An exclusive residential complex that redefines the concept of home, providing its residents with an experience comparable to that of a five-star hotel. Designed for maximum comfort, it integrates (...)
€907,852
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA.
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 124 Lot Size: 15 Area: Estepona Region: Andalucía
LUXURY LEISURE RESORT APARTMENT IN ESTEPONA.
A luxury resort style apartment complex with the best in leisure facilities. This new development has been landscaped to create TOP QUALITY with (...)
