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 (42,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 (42,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 (42,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 341 - 360 of 5891
€550,000
TSEA5146912
- Ronda, Costa Del Sol, Ronda
Beds: 3 Baths: 2 M2: 229 Area: Ronda Region: Andalucía
Beds: 3 Baths: 2 M2: 229 Area: Ronda Region: Andalucía
✨ Charming country house with private pool and tourist license 10 minutes from Ronda ✨
We present a unique country house that combines nature, comfort, and versatility in a privileged setting. (...)
€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 (...)
€770,000
TSEA5146741
- Pizarra, Costa Del Sol, Cartama
Beds: 11 Baths: 6 M2: 515 Area: Cartama Region: Andalucía
Beds: 11 Baths: 6 M2: 515 Area: Cartama Region: Andalucía
Exclusive estate with 5 independent homes in Pizarra – Property with valid AFO
Are you looking for a large family estate or a unique investment opportunity in the heart of the Guadalhorce (...)
€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 (...)
€1,695,000
TSEA5146693
- Elviria, Costa Del Sol, Marbella East
Beds: 5 Baths: 4 M2: 259 Lot Size: 1,003 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 4 M2: 259 Lot Size: 1,003 Area: Marbella East Region: Andalucía
Charming villa with a rustic touch, reformed (2002) with very good construction quality. Located in a residential area of Elviria. Beautiful views, sea, golf and mountain. Air aconditioning (...)
€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 (...)
€2,550,000
TSEA5146249
- El Chaparral, Costa Del Sol, Mijas and Mijas Costa
Beds: 5 Baths: 4 M2: 534 Lot Size: 1,700 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 5 Baths: 4 M2: 534 Lot Size: 1,700 Area: Mijas and Mijas Costa Region: Andalucía
Spectacular south facing five bedroom villa in El Chaparral, Mijas Costa. Set within an extensive private plot that offers total tranquillity and magnificent panoramic views of the coast and the (...)
€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 (...)
€1,750,000
TSEA5146186
- Setenil de las Bodegas, Costa de la Luz
Beds: 6 Baths: 6 M2: 616 Lot Size: 5,101 Region: Andalucía
Beds: 6 Baths: 6 M2: 616 Lot Size: 5,101 Region: Andalucía
A Rare Blend of Heritage & Modern Innovation Experience a truly extraordinary property, a beautifully converted historic watermill set against the dramatic backdrop of rural Andalusia. Just 24 km (...)
€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 (...)
€825,000
TSEA5145994
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 2 M2: 137 Lot Size: 563 Area: Estepona Region: Andalucía
Beds: 4 Baths: 2 M2: 137 Lot Size: 563 Area: Estepona Region: Andalucía
Detached Villa in Atalaya Baja, Estepona – Spacious, Bright & Full of Potential
Located in the exclusive Atalaya Baja urbanization, this charming detached villa sits on a generous 563 m² (...)
€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 (...)
€268,000
TSEA5145979
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 1 M2: 62 Area: Marbella Region: Andalucía
Beds: 3 Baths: 1 M2: 62 Area: Marbella Region: Andalucía
Discover your new home in the heart of Marbella! ✨
This charming apartment of 71 m² is located on the fourth floor of a building with an elevator, offering both comfort and accessibility. In (...)
€180,000
TSEA5145976
- Guaro, Costa Del Sol, Guaro
Beds: 2 Baths: 2 M2: 77 Area: Guaro Region: Andalucía
Beds: 2 Baths: 2 M2: 77 Area: Guaro Region: Andalucía
Middle Floor Apartment, Guaro, Inland Malaga
2 Bedrooms, 2 Bathrooms, Built 77 m².
Magnificent two-bedroom, two-bathroom apartment for sale, one en suite.
Like new. Fully furnished. Built-in (...)
€1,484,700
TSEA5145973
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 3 M2: 303 Lot Size: 1,149 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 3 M2: 303 Lot Size: 1,149 Area: Benalmadena Region: Andalucía
SPECTACULAR AND MODERN VILLA WITH SEA VIEWS
We are delighted to present this very special villa with its unique, modernist-inspired design, located in one of the most privileged and growing areas of (...)
Current Featured Properties
€735,000
TSEA4677262
- Atalaya, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 96 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 96 Area: Estepona Region: Andalucía
redefining contemporary living in the Golden Triangle. A sublimely stylish development, discretely blending with its surrounding environment, the 88 units of Naya Residences offer the discerning (...)
€630,000
TSEA4245991
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 70 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 70 Area: Benalmadena Region: Andalucía
BREATHTAKING VIEWS OF THE SEA!!!
This is an exclusive, private development situated in a privileged location in Benalmádena. Thanks to its elevated position, all homes boast panoramic views of the (...)
€6,895,000
World class design-led villas with spectacular views
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 482 Lot Size: 2,406 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 482 Lot Size: 2,406 Area: Benahavis Region: Andalucía
400,000€ discount if you purchase before completion! This is a sustainable luxury development of 18 individually designed villas situated in the 200-hectare country club estate of Real de La (...)
