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 (46,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 (46,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 (46,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 3926
€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 (...)
€470,000
TSEA5147062
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 104 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 104 Area: Marbella Region: Andalucía
Charming penthouse in the heart of Marbella, 400 metres from the city's best beaches, the Paseo Marítimo and a minute's walk from Marbella's Old Town.
This duplex penthouse consists of two very (...)
€5,950,000
TSEA5147056
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 221 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 221 Area: Marbella West Region: Andalucía
In the heart of Puerto Banús, within the prestigious residential complex Los Granados, stands this spectacular duplex penthouse, an exceptional property that redefines seafront luxury.
From its (...)
€110,000
TSEA5147050
- Manilva, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 44 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 44 Area: Manilva Region: Andalucía
Tourist Apartment for Sale in the PierVacanz Complex – Manilva (Málaga)
For Tourist Use Only – Not for Residential Living
Apartment for sale in the prestigious PierVacanz holiday complex, just (...)
€460,000
TSEA5146993
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 71 Area: Marbella Region: Andalucía
Nestled in the heart of Marbella's prestigious Golden Mile, this elegant ground floor apartment offers the perfect combination of modern comfort and Mediterranean charm. Just five minutes from the (...)
€679,000
TSEA5146972
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 2 M2: 141 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 2 M2: 141 Area: Fuengirola Region: Andalucía
Discover a unique opportunity to live in one of Fuengirola's most sought-after residential complexes with this spacious 4-bedroom first-floor apartment, fully furnished and ready to move in. Its (...)
€397,000
TSEA5146948
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 136 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 136 Area: Estepona Region: Andalucía
Wonderful apartment in El Paraíso Barronal
Your new home awaits you in a privileged location, right on the beach, just a three-minute walk from the sea.
The apartment is located in a beautiful (...)
€850,000
TSEA5146921
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 146 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 146 Area: Marbella East Region: Andalucía
This magnificent ground floor apartment is located in the heart of Marbella's famous Golden Mile — one of the most prestigious and sought-after areas on the Costa del Sol. A unique blend of (...)
€315,000
TSEA5146837
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 94 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Area: Fuengirola Region: Andalucía
Charming Renovated Apartment in the Best Area of Torreblanca – Fuengirola
This beautiful apartment, located on the third floor with elevator, has been recently renovated with a romantic and cozy (...)
€649,000
TSEA5146732
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 150 Lot Size: 20 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 150 Lot Size: 20 Area: Casares Region: Andalucía
New apartment with a modern design, premium finishes, and fully furnished, ready to move in. It comes with three parking spaces and the option to acquire an additional one, along with a pre-installed (...)
€333,000
TSEA5146729
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 79 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 79 Area: Estepona Region: Andalucía
Prime Frontline Beach Apartment on Estepona's Serene Playa de Guadalobón
Idyllic Beachfront Location: Positioned directly on Playa de Guadalobón, Estepona's tranquil western beach known for its (...)
€1,950,000
TSEA5146711
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 115 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 115 Area: Marbella Region: Andalucía
Beautiful apartment in a gated community Playa Esmeralda, located on beachfront, in Golden Mile, Marbella. The apartment has 2 bedrooms, 2 bathrooms (one in-suite), living room with access to the (...)
€623,000
TSEA5146630
- La Mairena, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 166 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 166 Area: Marbella East Region: Andalucía
Spectacular corner apartment a highly sought-after area of La Mairena, 3 spacious bedrooms, with east-west orientation and panoramic views of the sea and Mountains. photovoltaic energy. Gated (...)
€497,000
TSEA5146264
- Rincón de la Victoria, Costa Del Sol East
Beds: 2 Baths: 2 M2: 107 Region: Andalucía
Beds: 2 Baths: 2 M2: 107 Region: Andalucía
New Development: Prices from 497,000 € to 658,000 €. [Beds: 2 - 4] [Baths: 2 - 2] [Built size: 107.00 m2 - 164.00 m2]
Luxury modern-style development comprising 41 homes of the highest (...)
€750,000
TSEA5146240
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 187 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 187 Area: Estepona Region: Andalucía
Located in the very centre of Estepona, this modern duplex penthouse offers the perfect combination of urban convenience and Mediterranean charm. Its privileged setting places you within walking (...)
€765,000
TSEA5146108
- Málaga Centro, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 137 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 137 Area: Malaga Region: Andalucía
Middle Floor Apartment, Málaga Historic Centre Soho, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 137 m².
Setting : Town, Close To Port, Close To Sea.
Condition : Excellent, Recently (...)
€435,000
TSEA5146048
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 101 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 101 Area: Casares Region: Andalucía
Stunning Sea View Penthouse – Just 300m from the Beach
Discover this exceptional 3-bedroom, 2-bathroom penthouse located only a short 5-minute walk (300m) from the golden sandy beaches of (...)
€330,000
TSEA5146021
- Mijas Golf, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 4 M2: 142 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 4 M2: 142 Area: Mijas and Mijas Costa Region: Andalucía
Discover this spectacular apartment located in the idyllic destination of Mijas Golf, famous for its stunning views and high-quality golf courses.
The property features three spacious bedrooms (...)
€350,000
TSEA5145991
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 92 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Estepona Region: Andalucía
GREAT OPPORTUNITY IN ESTEPONA – BEL-AIR AREA
Spacious 2-bedroom apartment with large terraces in a gated community with pool, surrounded by all amenities and just minutes from the beach.
Looking (...)
Current Featured Properties
€349,950
TSEA4335331
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 86 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Fuengirola Region: Andalucía
This new development is located in the north of Fuengirola, in the Los Pacos neighborhood: a residential, multicultural and multilingual area with a cosmopolitan atmosphere, close to the beach and (...)
€368,400
TSEA5063941
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 58 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 58 Area: Mijas and Mijas Costa Region: Andalucía
A modern apartment complex is an innovative development of 116 one-bedroom loft-style apartments, designed for those seeking style, functionality, and excellent value for money. At this residential (...)
€1,150,000
TSEA4742692
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 153 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 153 Area: Estepona Region: Andalucía
Located on the Costa del Sol, this boutique complex of 24 homes overlooks the Mediterranean and offers a wonderful spectacle of light and tranquility. Live the lifestyle you deserve in this dreamlike (...)
