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 (41,36,37,38)
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 (41,36,37,38)
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 (41,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 121 - 140 of 792 €350,000
TSEA5129044
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Mijas and Mijas Costa Region: Andalucía
Stylish South-Facing Penthouse Apartment with Panoramic Sea Views in Upper Calahonda
Recently renovated and well presented, this 2-bedroom, 2-bathroom Penthouse apartment is a true gem in the (...)
€527,000
TSEA5128996
- Casares Playa, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 140 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 140 Area: Casares Region: Andalucía
Beautiful south-facing penthouse with 3 bedrooms and 2 bathrooms, featuring stunning views from multiple terraces. The master bedroom includes an en-suite bathroom, and all bedrooms come with (...)
€890,000
TSEA5128924
- Higueron, Costa Del Sol
Beds: 2 Baths: 2 M2: 95 Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Region: Andalucía
Exclusive 3-bedroom penthouse with a sea-to-sky horizon and southwest orientation that ensures sun, views, and privacy throughout the day.
Located in a leading residential in the Higuerón area, with (...)
€1,220,000
TSEA5128693
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Marbella West Region: Andalucía
Elegant Penthouse in La Alcazaba, Puerto Banús
Enjoy luxury living in this beautiful penthouse with views over the communal garden and pool. The spacious terrace is perfect for relaxing or (...)
€298,000
TSEA5127373
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 141 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 141 Area: San Pedro Region: Andalucía
Apartment in the Center of San Pedro Alcántara – Marbella
Located on the 5th floor, (with lift and parking) this property is a great opportunity for those looking to live or invest in one of the (...)
€890,000
TSEA5127253
- Benahavís, Costa Del Sol, Benahavis
Beds: 1 Baths: 1 M2: 89 Area: Benahavis Region: Andalucía
Beds: 1 Baths: 1 M2: 89 Area: Benahavis Region: Andalucía
Originally a 2-bedroom home, this elegant apartment has been completely refurbished to the highest standards, with a modern and practical layout that makes the most of every space.
The custom-made (...)
€595,000
TSEA5126983
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 149 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 149 Area: Marbella Region: Andalucía
This amazing penthouse is located a top Marbella location in Altos de Marbella, Los Monteros from its elevated position one enjoys amazing views of the mediterranean coastline including Marbella, (...)
€845,000
TSEA5126926
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 189 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 189 Area: Mijas and Mijas Costa Region: Andalucía
The penthouse is on the first floor. It is stylishly furnished and has a large terrace plus a solarium with a private plunge pool where you can relax in the sun. The terrace also has an outdoor (...)
€495,000
TSEA5126401
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 1 M2: 52 Area: Marbella Region: Andalucía
Beds: 2 Baths: 1 M2: 52 Area: Marbella Region: Andalucía
Penthouse with 80 m² Terrace to Renovate – Great Potential in the Heart of Marbella Center
Located on the 7th floor of a well-known building on Ricardo Soriano, Marbella's main avenue, this (...)
€279,000
TSEA5126332
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 194 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 194 Area: Casares Region: Andalucía
Located in the peaceful and sought-after urbanization of Hacienda Casares, near the prestigious Doña Julia golf course, this 3-bedroom, 2-bathroom apartment stands out for its excellent condition (...)
€790,000
TSEA5126278
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 3 Baths: 3 M2: 129 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 3 M2: 129 Area: Marbella East Region: Andalucía
Beautiful south-facing apartment with magnificent sea views, located in the sought-after community of Pinos de Nagüeles, in Marbella's prestigious Golden Mile. Within walking distance to the beach, (...)
€299,900
TSEA5126188
- 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
Penthouse 2-Bedroom Apartment with Mountain Views – Fuengirola
We are delighted to present this bright and beautifully renovated 2-bedroom, 1-bathroom top-floor apartment, ideally located in the (...)
€439,000
TSEA5126161
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 57 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 57 Area: Mijas and Mijas Costa Region: Andalucía
Elegant Penthouse with Sea Views. Fully Renovated and Surrounded by Tranquility by the Beach
Welcome to a truly exceptional penthouse where style, comfort, and nature come together in perfect (...)
€1,100,000
TSEA5126092
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 91 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Marbella West Region: Andalucía
INVESTOR ALERT – Prime Marina Apartment in Puerto Banús with Panoramic Sea Views
Welcome to the best-located apartment in the heart of Marina Puerto Banús, spacious, bright and on the first line (...)
€1,050,000
TSEA5126071
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 204 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 204 Area: Fuengirola Region: Andalucía
Luxury Penthouse with Private Rooftop Pool
Welcome to one of the most exclusive penthouses on the Costa del Sol — newly renovated, privately elevated above the Fuengirola promenade, and complete (...)
€649,000
TSEA5125918
- Artola, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 138 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 138 Area: Marbella East Region: Andalucía
Super bright penthouse with 2 large terraces for sale in Artola Alta, East Marbella
Beautiful penthouse, perfectly positioned in the exclusive Ocean Pino Golf complex is now up for sale. Boasting (...)
€415,000
TSEA5124172
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Area: Mijas and Mijas Costa Region: Andalucía
Elegant Apartment with TOURIST LICENCE, Parking and Storage Room – 2 Bedrooms with Nature Views in Torrequebrada, Benalmádena.
Located in a quiet and secure residential complex, near the beach, (...)
€675,000
TSEA5124094
- Selwo, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 160 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 160 Area: Estepona Region: Andalucía
Stunning 2-Bedroom Penthouse – La Resina Golf, Selwo, Estepona
This beautifully renovated and fully furnished top-floor penthouse is located in the peaceful and up-and-coming Selwo area of (...)
€999,000
TSEA5124016
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 129 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 129 Area: Benahavis Region: Andalucía
Stunning Luxury Penthouse with Breathtaking Sea & Golf Views – Priced to Sell Fast!
For Sale – Don't miss this rare opportunity to own a spectacular 3-bedroom, 2-bathroom penthouse in the (...)
€595,000
TSEA5123860
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 111 Area: Mijas and Mijas Costa Region: Andalucía
A rare opportunity to buy this penthouse apartment, centrally located in the beautiful white village of Mijas Pueblo, with two allocated parking spaces and storeroom.
This stunning penthouse is (...)
Current Featured Properties
€649,000
TSEA3990796
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 91 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Casares Region: Andalucía
LAST CHANCE TO BUY! SEA VIEWS THAT YOU DREAM ABOUT!!!
Last 2 beds starting from 360,495€ and one last 3 bed at 558,000€!
Designed in a contemporary style, the apartments and penthouses have been (...)
€678,000
TSEA4941382
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 187 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 187 Area: Estepona Region: Andalucía
PHASE II OUT NOW! ACT FAST.
An exclusive community comprising 84 luxury properties with generous indoor spaces, roomy terraces, spectacular views, community areas, swimming pool and club zone. A (...)
€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 (...)
