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 (48,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 (48,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 (48,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 2641 - 2660 of 3916 €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 (...)
€430,000
TSEA4968664
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 1 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 1 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Exceptional apartment on the beachfront with spectacular sea views.
With its south orientation we will enjoy many hours of sunshine while admiring the blue of the Mediterranean.
Great opportunity for (...)
€575,000
TSEA4968553
- Higueron, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 92 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 92 Area: Fuengirola Region: Andalucía
This beautiful 2 bedroom and 2 bathroom apartment is located in the highly sought-after Higueron West, on the border of Fuengirola and Benalmadena. The bright and airy home boasts stunning views of (...)
€499,000
TSEA4968496
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 82 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 82 Area: Marbella West Region: Andalucía
For Sale: Fully Renovated 3-Bedroom Apartment in Aloha Royal, Nueva Andalucía, Marbella – €499,000
A rare opportunity to own a fully renovated, modern 3-bedroom, 2-bathroom apartment in the (...)
€585,000
TSEA4968484
- Centro Histórico, Costa Del Sol
Beds: 2 Baths: 2 M2: 125 Region: Andalucía
Beds: 2 Baths: 2 M2: 125 Region: Andalucía
Welcome to a new luxury building located in the heart of Malaga's Centro Histórico.
This totlay renovated floor apartment is a true gem. This luxurious residence offers a perfect blend of (...)
€225,000
TSEA4968064
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 1 M2: 61 Area: Fuengirola Region: Andalucía
Excellent apartment with 2 bedrooms and 1 bathroom, living room and kitchen. It has 61 m2 built and the building is from 2006. Elevator. Located next to the main square of Los Pacos with all services (...)
€499,000
TSEA4967974
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 133 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 133 Area: Estepona Region: Andalucía
Brand new apartment for sale. Consists of 3 bedrooms, 2 bathrooms, living room with open plan kitchen and terrace with sea views. The orientation is south and the apartment is very bright. The (...)
€295,000
TSEA4967902
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 57 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 57 Area: Estepona Region: Andalucía
Charming partly renovated apartment in Estepona's old town.
Tucked away on a peaceful street, yet just a three-minute walk from the bustling main street with its lively shops, bars, and restaurants. (...)
€495,000
TSEA4967893
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 110 Area: Estepona Region: Andalucía
LUXURIOUS DUPLEX PENTHOUSE WITH PANORAMIC SEA & MOUNTAINS VIEWS IN SELWO, ESTEPONA
2 parking spaces + 1 storage room included!
Welcome to this stunning duplex penthouse nestled in the tranquil (...)
€650,000
TSEA4967812
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 133 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 133 Area: Marbella Region: Andalucía
Two-Bedroom Apartment in Los Altos de Marbella
Nestled in the exclusive gated community of Los Monteros Hill Club, this elegant two-bedroom apartment offers breathtaking panoramic views over the (...)
Current Featured Properties
€280,000
TSEA4944307
- Estepona, Costa Del Sol, Estepona
Beds: 1 Baths: 1 M2: 81 Lot Size: 34 Area: Estepona Region: Andalucía
Beds: 1 Baths: 1 M2: 81 Lot Size: 34 Area: Estepona Region: Andalucía
BRAND NEW DEVELOPMENT IN ESTEPONA.
Don't miss out on an opportunity to buy in this development of 90 dwellings of 1, 2 and 3 bedrooms, all of them with garage space and storage room. It is an (...)
€485,850
TSEA4581442
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 112 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 112 Area: San Pedro Region: Andalucía
The development in San Pedro de Alcantara is made up of 35 homes with 2 and 3 bedrooms, with duplexes with terraces-solariums. Garages in the basement and commercial premises on the ground floor, in (...)
€928,800
TSEA4964758
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 118 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 118 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 (...)
