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 (162,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 (162,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 (162,39,40,41,162,163)
GROUP BY p.id
ORDER BY p.created DESC
Subcategories
Ground Floor - (11), Middle Floor - (11), Penthouse - (11), Top Floor Apartment - (11), Penthouse Duplex - (11)Properties
Results 2621 - 2640 of 3894 €1,180,000
TSEA4970107
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 123 Area: Estepona Region: Andalucía
Introducing this stunning duplex penthouse in the sought-after area of El Paraíso, featuring an unbeatable rooftop terrace and a private heated pool - a truly exceptional property. This is a rare (...)
€1,195,000
TSEA4970104
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 3 M2: 195 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 3 M2: 195 Area: Marbella West Region: Andalucía
We are thrilled to present this exceptional ground floor apartment for sale in the prestigious Las Alamandas development, located in the highly desirable area of Nueva Andalucía. This popular (...)
€560,000
TSEA4970038
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 99 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: Marbella West Region: Andalucía
Apartment for sale in , Marbella with 2 bedrooms, 2 bathrooms, 1 on suite bathroom and with orientation south/west, with communal swimming pool, private garage and communal garden. Regarding property (...)
€350,000
TSEA4970008
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 3 Baths: 2 M2: 111 Area: Manilva Region: Andalucía
Beds: 3 Baths: 2 M2: 111 Area: Manilva Region: Andalucía
This spacious ground-floor apartment offers the perfect blend of comfort, convenience, and indoor-outdoor living. Just 5 minutes by car or a 7-minute cycle to the vibrant beachfront town of (...)
€595,000
TSEA4969870
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 1 M2: 102 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 1 M2: 102 Area: Marbella West Region: Andalucía
Welcome to this exceptional corner penthouse located in the heart of the sought-after Los Naranjos de Marbella (Nueva Andalucía). This exclusive residence offers two spacious terraces, perfectly (...)
€251,000
TSEA4969831
- Cancelada, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: Estepona Region: Andalucía
SQUATTED PROPERTY. OPPORTUNITY FOR INVESTORS.
The price of the property has been set considering that the property is being acquired by the buyer as occupied. Therefore, this price would not apply if (...)
€682,500
TSEA4969795
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 121 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 121 Area: San Pedro Region: Andalucía
Middle Floor Apartment, San Pedro de Alcántara, Costa del Sol.
3 Bedrooms, 2 Bathrooms, Built 121 m², Terrace 10 m².
Setting : Town, Commercial Area, Close To Shops, Close To Sea, Close To (...)
€128,847
TSEA4969771
- Manilva, Costa Del Sol, Manilva
Beds: 3 Baths: 1 M2: 91 Area: Manilva Region: Andalucía
Beds: 3 Baths: 1 M2: 91 Area: Manilva Region: Andalucía
RENTED PROPERTY. OPPORTUNITY FOR INVESTORS.
What does a profitable property mean? Having a profitable property means that the owner is obtaining economic benefits from their property through its (...)
€595,000
TSEA4969768
- El Paraiso, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Estepona Region: Andalucía
Price Reduction. From €630,000 to €595,000. This exceptional apartment, built in 2020, offers a perfect fusion of comfort and contemporary style. The home features two bedrooms and two bathrooms (...)
€1,300,000
TSEA4969468
- La Cala, Costa Del Sol, Mijas and Mijas Costa
Beds: 4 Baths: 3 M2: 232 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 4 Baths: 3 M2: 232 Area: Mijas and Mijas Costa Region: Andalucía
We present an extraordinary investment opportunity in the heart of the Costa del Sol - a luxury penthouse with proven success in vacation rentals.
This magnificent property combines premium (...)
€650,000
TSEA4969432
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 103 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 103 Area: San Pedro Region: Andalucía
LUXURIOUS 2,3 & 4 BEDROOM APARTMENTS IN GUADALMINA ALTA! Development of 34 amazing apartments and penthouses in a perfect location, for you to enjoy the Mediterranean lifestyle The living room is (...)
€499,000
TSEA4969108
- Cabopino, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 122 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 122 Area: Marbella East Region: Andalucía
JUST REDUCED from 549.000€ to 499.000€
Beautiful refurbished 3 bedroom apartment with walking distance to the beautiful port and beaches of Cabopino.
If you're looking for a residential or (...)
€329,500
TSEA4742488
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 95 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 95 Area: Manilva Region: Andalucía
New Development: Prices from 329,500 € to 503,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 95.00 m2 - 136.00 m2]
2 bedroom homes next to the sea in Manilva
When you decide to take a few (...)
€480,000
TSEA4907815
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 91 Area: Estepona Region: Andalucía
New Development: Prices from 480,000 € to 542,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 91.00 m2 - 109.00 m2]
This is a development of 51 homes with terrace of 2, 3 and 4 bedrooms (...)
€549,000
TSEA4969039
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 123 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 123 Area: Marbella East Region: Andalucía
SHORT TERM RENTAL AVAILABLE IN THE COMPLEX!!
Spacious Apartment in a Quiet Community with Tropical Gardens – Las Lomas del Marbella Club on The Golden Mile.
Located in an exclusive low-density (...)
€120,000
TSEA4968961
- Manilva, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 69 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 69 Area: Manilva Region: Andalucía
GREAT INVESTMENT OPPORTUNITY
Nice and cosy apartment for sale in Manilva. The apartment has one bedroom, one bathroom, equipped kitchen and living room. It is situated in an authentic Andalusian (...)
€206,000
TSEA4968868
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 55 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 55 Area: Fuengirola Region: Andalucía
Ground Floor Apartment, Fuengirola, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 55 m², Terrace 6 m².
Setting : Town, Beachside, Village, Close To Port, Close To Shops, Close To Sea, Close To (...)
€465,000
TSEA4968784
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 108 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 108 Area: Benalmadena Region: Andalucía
Spectacular flat of recent construction in an exclusive urbanization of Benalmadena!
It stands out for its contemporary design, high quality finishes and a distribution designed for maximum (...)
€769,000
TSEA4968763
- Higueron, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 131 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 131 Area: Fuengirola Region: Andalucía
Best pool area and desirable sea views highlight this modern apartment in Higuerón West.
This particular apartment enjoys what many consider the best pool area in all of Higueron West. Beyond the (...)
€590,000
TSEA4968712
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 81 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Marbella West Region: Andalucía
Discover the perfect blend of luxury and convenience with this spectacular 2-bedroom, 2-bathroom penthouse in the prestigious La Dama de Noche Urbanization. Enjoy breathtaking mountain views and (...)
Current Featured Properties
€910,000
TSEA4964749
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 94 Lot Size: 23 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 94 Lot Size: 23 Area: Marbella Region: Andalucía
This is an exclusive residential complex comprising 113 homes, designed with a unique architecture that reinterprets the traditional concept of the Andalusian courtyard. This approach allows natural (...)
€5,145,000
TSEA4980910
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 4 M2: 300 Lot Size: 334 Area: Marbella Region: Andalucía
Beds: 4 Baths: 4 M2: 300 Lot Size: 334 Area: Marbella Region: Andalucía
ONLY MINUTES AWAY FROM BEAUTIFUL MARBELLA!!!
Situated in the best location in Marbella, the Golden Mile, minutes away from the legendary Marbella Club Hotel, the Puente Romano Resort and the beach. A (...)
€599,000
TSEA4742524
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 113 Lot Size: 48 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 113 Lot Size: 48 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 (...)
