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 - (3910), Middle Floor - (3910), Penthouse - (3910), Top Floor Apartment - (3910), Penthouse Duplex - (3910)Properties
Results 2061 - 2080 of 5896 €6,450,000
TSEA5062792
- La Quinta, Costa Del Sol, Benahavis
Beds: 6 Baths: 8 M2: 867 Lot Size: 1,932 Area: Benahavis Region: Andalucía
Beds: 6 Baths: 8 M2: 867 Lot Size: 1,932 Area: Benahavis Region: Andalucía
Experience the pinnacle of modern Mediterranean architecture with this brand-new designer villa nestled in the prestigious La Quinta residential enclave of Benahavís. Offering breathtaking panoramic (...)
€659,000
TSEA5062765
- Alhaurín el Grande, Costa Del Sol, Alhaurin el Grande
Beds: 6 Baths: 4 M2: 296 Lot Size: 1,400 Area: Alhaurin el Grande Region: Andalucía
Beds: 6 Baths: 4 M2: 296 Lot Size: 1,400 Area: Alhaurin el Grande Region: Andalucía
Your Private Rural Retreat: Finca with Pool, Two Guest Homes & Panoramic Views
Set in a privileged location between the picturesque villages of Alhaurín el Grande and Coín, this stunning (...)
€2,850,000
TSEA5062681
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 4 M2: 632 Lot Size: 1,374 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 4 M2: 632 Lot Size: 1,374 Area: Marbella West Region: Andalucía
EXCLUSIVE PROPERTY
This sumptuous Provençal Mediterranean-style villa embodies refinement and authenticity in a verdant setting overlooking one of Marbella's most exclusive golf courses: Las Brisas (...)
€595,000
TSEA5062648
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 86 Area: Estepona Region: Andalucía
Middle Floor Apartment, Estepona, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 86 m², Terrace 5 m².
Setting : Beachfront, Town, Commercial Area, Beachside, Village, Close To Port, Close To Shops, (...)
€270,000
TSEA5062645
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 93 Lot Size: 15 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Lot Size: 15 Area: Mijas and Mijas Costa Region: Andalucía
Discover this superb 2-bedroom apartment in Riviera del Sol, Mijas, offering a tranquil and quiet setting with lovely garden views. Location is key, and this property delivers: you're just a 5-minute (...)
€390,000
TSEA5062618
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 116 Area: Estepona Region: Andalucía
Welcome to this stunning 2-bedroom, 2-bathroom apartment, perfectly situated in a gated community that offers both comfort and convenience. As you step inside, a small hallway leads you to a spacious (...)
€1,436,000
TSEA5062576
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 250 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 250 Area: Mijas and Mijas Costa Region: Andalucía
Spacious duplex penthouse located within walking distance of the golf course, just a 5-minute drive to shops and the beach, and a 20-minute walk to the nearest bus stop.
The first floor features a (...)
€450,000
TSEA5062564
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 78 Area: Marbella Region: Andalucía
Brand-New Apartment in the Heart of Marbella!
We present this magnificent opportunity to acquire a fully renovated, brand-new home in the iconic Edificio Berrocal, located right in the center of (...)
€275,000
TSEA5062540
- 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
We offers MAGNIFICENT APARTMENT LOCATED ON THE OUTSIDE OF ESTEPONA.
Ideal for habitual residence as well as for holiday or long term rental.
Characteristics of the property:
-Surface area: 89 m² (...)
€190,000
TSEA5062462
- Villanueva del Rosario, Costa Del Sol, Antequera
Beds: 1 Baths: 1 M2: 104 Lot Size: 4,227 Area: Antequera Region: Andalucía
Beds: 1 Baths: 1 M2: 104 Lot Size: 4,227 Area: Antequera Region: Andalucía
RUSTIC. Dry and undivided olive grove plot located in the Cortijo Alto neighborhood, in the municipality of Villanueva del Rosario, with an area of 4,228 m². It comprises: a separate residential (...)
€829,000
TSEA5062309
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 2 M2: 132 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 2 M2: 132 Area: La Duquesa Region: Andalucía
This stunning 3 bedroom frontline beach apartment is located in La Duquesa, with panoramic sea views and just a few steps away from the beautiful beach.
Located within one of the most prestige (...)
€485,000
TSEA5062288
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 65 m².
Setting : Beachfront, Town, Commercial Area, Beachside, Port, Close To Shops, Close To Sea, Close To Schools, (...)
€450,000
TSEA5062255
- 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
Penthouse frontline golf
Penthouse located in Estepona Golf within the newly built Sunny Golf complex. The community features a swimming pool and outdoor parking, with one parking space included. It (...)
€2,200,000
TSEA5062237
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 4 Baths: 4 M2: 178 Area: Marbella East Region: Andalucía
Beds: 4 Baths: 4 M2: 178 Area: Marbella East Region: Andalucía
This spacious apartment is located within an exclusive development in Las Lomas del Marbella Club, on Marbella's prestigious Golden Mile — just 2 minutes from Puente Romano and the beach.
The gated (...)
€599,000
TSEA5062213
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 110 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Casares Region: Andalucía
Magnificent PENTHOUSE with LARGE TERRACE and SOLARIUM. Facing southeast, this stunning property enjoys WONDERFUL SEA and GOLF VIEWS. Located in a well-maintained urbanization, it sits in one of the (...)
€490,000
TSEA5062174
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 73 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 73 Area: Estepona Region: Andalucía
Absolutely first line of the beach. There are no better views and location. You can see the sunrise and sunset, Gibraltar and Africa."
Middle Floor Apartment, Estepona, Costa del Sol.
1 Bedroom, (...)
€4,950,000
TSEA5061943
- La Quinta, Costa Del Sol, Benahavis
Beds: 5 Baths: 6 M2: 642 Lot Size: 1,720 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 6 M2: 642 Lot Size: 1,720 Area: Benahavis Region: Andalucía
Exquisite Contemporary Five-Bedroom Villa with Panoramic Platform Setting in the heart of La Quinta, Benahavís. Surrounded by top-tier golf courses and just minutes from Puerto Banús, Marbella, and (...)
€2,950,000
TSEA5061886
- El Paraiso, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 591 Lot Size: 822 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 591 Lot Size: 822 Area: Estepona Region: Andalucía
This exquisitely crafted contemporary villa situated within a gated community presents breathtaking sea views and an open-concept living space filled with natural light. The floor-to-ceiling glass (...)
€449,000
TSEA5061880
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 79 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 79 Area: Fuengirola Region: Andalucía
Brand New Apartment with Panoramic Sea Views in Higuerón
Step into refined coastal living with this brand-new, unfurnished first-floor apartment in the prestigious Higuerón community. Perfectly (...)
€449,000
TSEA5061871
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 76 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 76 Area: Fuengirola Region: Andalucía
Brand New Apartment with great Sea Views in the Higuerón.
Step into refined coastal living with this brand-new, unfurnished first-floor apartment in the prestigious Higuerón community. Perfectly (...)
Current Featured Properties
€530,000
TSEA4761718
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 4 Baths: 2 M2: 120 Area: Algeciras Region: Andalucía
Beds: 4 Baths: 2 M2: 120 Area: Algeciras Region: Andalucía
We´re happy to present a new flagship project in La Alcaidesa, San Roque, just 10 minutes from Sotogrande, with spectacular views of the Mediterranean Sea, the golf course and Gibraltar.
Superb (...)
€406,900
TSEA4307794
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
SURROUNDED BY BEAUTIFUL BEACHES!!!
This is an exceptional development of 80 properties in a complex of almost 10,000m². The development has 2 and 3 bedroom flats all with large terraces and a (...)
€585,000
TSEA4164577
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 130 Lot Size: 210 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 130 Lot Size: 210 Area: Marbella East Region: Andalucía
BEACHFRONT HOME FOR SALE - LIVE THE BEACH LIFE YOU'VE ALWAYS WANTED!!
This middle floor apartment located in Elviria, Marbella East is a great investment opportunity for those who love the beachfront (...)
