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 1961 - 1980 of 5896 €2,860,000
TSEA5067145
- Guadalmina Alta, Costa Del Sol, San Pedro
Beds: 4 Baths: 4 M2: 721 Lot Size: 2,500 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 4 M2: 721 Lot Size: 2,500 Area: San Pedro Region: Andalucía
We offers EXCLUSIVE LUXURY VILLA IN GUADALMINA ALTA, MARBELLA.
If you are looking to live in one of the most exclusive and peaceful areas of Marbella, this property - located on a 2,500 m² plot - (...)
€359,000
TSEA5067139
- La Mairena, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 93 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 93 Area: Marbella East Region: Andalucía
Charming apartment with Sea Views – Rented Until June 2026
This superb apartment, currently rented to a very reliable tenant until June 2026, represents an excellent investment opportunity in (...)
€372,000
TSEA5067124
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 1 M2: 85 Area: Estepona Region: Andalucía
Beds: 2 Baths: 1 M2: 85 Area: Estepona Region: Andalucía
Middle Floor Apartment, Estepona, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 85 m², Terrace 8 m².
Setting : Beachfront, Town, Commercial Area, Beachside, Village, Close To Port, Close To Sea, (...)
€1,250,000
TSEA5067121
- Guadalmar, Costa Del Sol, Malaga
Beds: 7 Baths: 3 M2: 351 Area: Malaga Region: Andalucía
Beds: 7 Baths: 3 M2: 351 Area: Malaga Region: Andalucía
Do you dream of living in a modern villa, surrounded by nature, with access to all amenities and just steps from the sea? We present this stunning 350m² villa located in one of the most sought-after (...)
€499,950
TSEA5067115
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 57 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 57 Area: Fuengirola Region: Andalucía
Due to it's many rental dates, viewings may not be always possible but can be arranged according to change over dates. Please contact us for more details.
This beautifully furnished beach front (...)
€339,000
TSEA5067106
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 1 M2: 100 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 1 M2: 100 Area: Fuengirola Region: Andalucía
SPACIOUS CENTRAL APARTMENT
Impeccably maintained three-bedroom apartment in a prime location in the heart of Fuengirola. Ideal for those seeking quality, comfort, and generous living space. (...)
€228,000
TSEA5067094
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 1 M2: 76 Area: Estepona Region: Andalucía
Beds: 3 Baths: 1 M2: 76 Area: Estepona Region: Andalucía
In the heart of Estepona, surrounded by all kinds of services, bars, restaurants, children's play areas, the town hall's public parking, and other services, is this apartment on the third floor, with (...)
€435,000
TSEA5067085
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 112 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 112 Area: Marbella West Region: Andalucía
DON'T MISS OUT ON THIS GREAT OPPORTUNITY
Spacious 2-Bedroom Apartment with Large Terrace and Dual En-Suite Bedrooms in La Maestranza, Nueva Andalucía
Located in the highly sought-after gated (...)
€246,000
TSEA5067070
- Riviera del Sol, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Cozy 2-Bedroom Corner Apartment with Spacious Terrace, pleasant garden-room & Brand New Kitchen in Riviera del Sol,Mirafloris
This charming 2-bedroom corner apartment in a gated community on (...)
€220,000
TSEA5067043
- Torrox Costa, Costa Del Sol East
Beds: 1 Baths: 1 M2: 50 Region: Andalucía
Beds: 1 Baths: 1 M2: 50 Region: Andalucía
Welcome to this bright and inviting apartment with stunning views of both the sea and the mountains, located in the popular Edificio Valencia – right by the beachfront promenade in Torrox (...)
€559,000
TSEA5066989
- Aloha, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 139 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 139 Area: Marbella West Region: Andalucía
REDUCED TO SELL MOTIVATED SELLERS !!
JUST ON THE MARKET. 3 BED 2 BATH LARGE MIDDLE FLOOR CORNER APARTMENT ALOHA. €559.000
ENTER THE PROPERTY, TO THE RIGHT IS A GOOD SIZED GUEST BEDROOM. tHROUGH THE (...)
€1,100,000
TSEA5066974
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 84 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 84 Area: Fuengirola Region: Andalucía
BRAND NEW- READY NOW- UNIT IN CARAT HIGUERON- EXCEPTIONAL SEA VIEWS- LARGE EAST FACING TERRACE- CONCIERGE SERVICE- CHRISTIAN DIOR GYMNASIUM INDOOR HEATED SWIMMING POOL- WALK TO THE BEACH AND ENJOY (...)
€537,000
TSEA5066971
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 3 Baths: 2 M2: 96 Lot Size: 33 Area: Algeciras Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Lot Size: 33 Area: Algeciras Region: Andalucía
The project is located in La Alcaidesa.
La Alcaidesa, located between La Línea de la Concepción and San Roque, in the province of Cádiz, close to Sotogrande and the Rock of Gibraltar. It is an (...)
€890,000
TSEA5066959
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 3 M2: 135 Lot Size: 227 Area: Estepona Region: Andalucía
Beds: 4 Baths: 3 M2: 135 Lot Size: 227 Area: Estepona Region: Andalucía
Elegant and modern elevated ground-floor apartment with a large private terrace of 90 m² and partial sea views. Located in the sought-after area of Las Mesas, just a 10-minute walk from Estepona (...)
€384,000
TSEA5066911
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 117 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 117 Area: Fuengirola Region: Andalucía
Middle Floor Apartment, Fuengirola, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 117 m².
Setting : Town, Commercial Area, Port, Village, Close To Port, Close To Shops, Close To Sea, Close To (...)
€482,000
TSEA5066908
- La Alcaidesa, Costa Del Sol, Algeciras
Beds: 2 Baths: 2 M2: 78 Lot Size: 34 Area: Algeciras Region: Andalucía
Beds: 2 Baths: 2 M2: 78 Lot Size: 34 Area: Algeciras Region: Andalucía
The project is located in La Alcaidesa.
La Alcaidesa, located between La Línea de la Concepción and San Roque, in the province of Cádiz, close to Sotogrande and the Rock of Gibraltar. It is an (...)
€202,400
TSEA5066878
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 2 Baths: 2 M2: 81 Area: La Duquesa Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: La Duquesa Region: Andalucía
RENTED PROPERTY. OPPORTUNITY FOR INVESTORS.
What does a profitable property mean? Having a profitable property means that the owner is earning financial returns from their property through its (...)
€2,890,000
TSEA5066872
- Bel Air, Costa Del Sol, Estepona
Beds: 5 Baths: 6 M2: 581 Lot Size: 985 Area: Estepona Region: Andalucía
Beds: 5 Baths: 6 M2: 581 Lot Size: 985 Area: Estepona Region: Andalucía
New Development: Prices from 2,890,000 € to 3,290,000 €. [Beds: 5 - 5] [Baths: 6 - 6] [Built size: 581.00 m2 - 590.00 m2]
Welcome to a private enclave of 15 exclusive villas, located in the (...)
€1,995,000
TSEA5066854
- Santa Clara, Costa Del Sol, Marbella East
Beds: 5 Baths: 5 M2: 340 Area: Marbella East Region: Andalucía
Beds: 5 Baths: 5 M2: 340 Area: Marbella East Region: Andalucía
LUXURY CONTEMPORARY STYLE VILLA FOR SALE IN SANTA CLARA – LOS MONTEROS, EAST MARBELLA: ELEGANCE & COMFORT ON THE COSTA DEL SOL
Welcome to this luxury villa located in Santa Clara, the (...)
€360,027
TSEA5066836
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 124 Area: Fuengirola Region: Andalucía
Brand-New Apartment in Fuengirola – 3 Bedrooms, 2 Bathrooms
Spacious 109 m² usable area, featuring a 22 m² rear patio, a 5 m² cover terrace, and a total built area of 139 m².
Discover this (...)
Current Featured Properties
€1,250,000
TSEA4926496
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 117 Lot Size: 16 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 117 Lot Size: 16 Area: Marbella Region: Andalucía
The development epitomizes the zenith of contemporary life in Marbella, renowned for its serene ambiance and breathtaking panoramic vistas that stretch from the lush pine canopies to the shimmering (...)
€699,000
TSEA5144080
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 159 Lot Size: 21 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 159 Lot Size: 21 Area: Estepona Region: Andalucía
Welcome to your sun-kissed paradise on the sought-after New Golden Mile of Estepona, renowned for its sunny skies, golden sands and crystal-clear waters.
With just 25 stunning apartments, you'll get (...)
€1,685,000
TSEA4647067
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 110 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 110 Area: Fuengirola Region: Andalucía
This new development is an ambitious project consisting of 164 homes surrounded by the natural landscape of El Higueron. The properties are made up of 70 deluxe apartments, 49 garden villas, 25 sky (...)
