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 - (3905), Middle Floor - (3905), Penthouse - (3905), Top Floor Apartment - (3905), Penthouse Duplex - (3905)Properties
Results 2681 - 2700 of 5891
€4,850,000
TSEA4795540
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 5 M2: 618 Lot Size: 1,100 Area: Marbella Region: Andalucía
Beds: 4 Baths: 5 M2: 618 Lot Size: 1,100 Area: Marbella Region: Andalucía
New Development: Prices from 4,850,000 € to 5,400,000 €. [Beds: 4 - 4] [Baths: 5 - 5] [Built size: 618.00 m2 - 618.00 m2]
Welcome to the residencial complex of four exceptional single-family (...)
€335,000
TSEA5032750
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 1 Baths: 2 M2: 55 Area: Torremolinos Region: Andalucía
Beds: 1 Baths: 2 M2: 55 Area: Torremolinos Region: Andalucía
New Development: Prices from 335,000 € to 790,000 €. [Beds: 1 - 3] [Baths: 2 - 2] [Built size: 55.00 m2 - 87.00 m2]
This project is located in one of the most sought-after areas of the city — (...)
€850,000
TSEA3467524
- San Roque, Costa Del Sol, San Roque
Beds: 1 Baths: 1 M2: 133 Area: San Roque Region: Andalucía
Beds: 1 Baths: 1 M2: 133 Area: San Roque Region: Andalucía
New Development: Prices from 850,000 € to 1,400,000 €. [Beds: 1 - 3] [Baths: 1 - 3] [Built size: 133.00 m2 - 224.00 m2]
This development is reimagining the traditional concept of a village and (...)
€295,000
TSEA5018287
- Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 295,000 € to 460,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 74.00 m2 - 106.00 m2]
Your ideal home on the Costa del Sol
We are pleased to exclusively present (...)
€490,000
TSEA4953886
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 97 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 97 Area: Fuengirola Region: Andalucía
New Development: Prices from 490,000 € to 1,990,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 97.00 m2 - 187.00 m2]
Exclusivity at Its Finest
Let yourself be captivated by this development, (...)
€393,000
TSEA4100068
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 81 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Malaga Region: Andalucía
New Development: Prices from 393,000 € to 2,000,000 €. [Beds: 2 - 4] [Baths: 2 - 2] [Built size: 81.00 m2 - 160.00 m2]
Located on the edge of the Guadalmina river in the center of the vibrant (...)
€340,000
TSEA4652383
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Mijas and Mijas Costa Region: Andalucía
New Development: Prices from 340,000 € to 470,000 €. [Beds: 2 - 2] [Baths: 2 - 2] [Built size: 80.00 m2 - 98.00 m2]
The innovative and sustainable collection of homes in Las Lagunas de Mijas. (...)
€499,000
TSEA5032726
- Calahonda, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 114 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Mijas and Mijas Costa Region: Andalucía
Enjoy panoramic views of the sea from this spacious top-floor apartment, ideally situated to take in the lively maritime scene.
Features of the Apartment:
- Three double bedrooms with twin beds (...)
€279,000
TSEA5032681
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 54 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 54 Area: Fuengirola Region: Andalucía
Just a step away from the sea in Fuengirola! If you're looking for the perfect place to live or invest, this apartment is ideal for you. With an enviable location in Sohail, one of the most (...)
€775,000
TSEA5032678
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 3 M2: 203 Lot Size: 192 Area: Marbella Region: Andalucía
Beds: 4 Baths: 3 M2: 203 Lot Size: 192 Area: Marbella Region: Andalucía
This bright and spacious ground-floor apartment offers the perfect mix of comfort, outdoor living, and convenience. The modern, renovated kitchen opens directly onto a private garden of 192 m2. An (...)
€580,000
TSEA5032651
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 2 M2: 105 Area: Malaga Region: Andalucía
Beds: 3 Baths: 2 M2: 105 Area: Malaga Region: Andalucía
Open the door to a freshly renovated apartment with a bright, open-plan layout. The property offers 105 m² of well-used space, full of light and modern comfort.
Designed throughout in a clean, (...)
€443,000
TSEA5032642
- Benalmadena Costa, Costa Del Sol, Benalmadena
Beds: 2 Baths: 1 M2: 79 Lot Size: 79 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 1 M2: 79 Lot Size: 79 Area: Benalmadena Region: Andalucía
Rare Opportunity – A Unique Home in a Legendary Community at a Prime Location!
This stunning, fully renovated two-bedroom corner apartment offers the perfect combination of top location, (...)
€410,000
TSEA4362811
- Rincón de la Victoria, Costa Del Sol East
Beds: 2 Baths: 2 M2: 85 Lot Size: 21 Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Lot Size: 21 Region: Andalucía
New Development: Prices from 410,000 € to 477,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 85.00 m2 - 94.00 m2]
Nature and architecture blend together in this development, a project inspired (...)
€350,000
TSEA3461473
- 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
New Development: Prices from 350,000 € to 430,500 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 86.00 m2 - 100.00 m2]
This development stands in the Malagueño municipality of Estepona and in the (...)
€399,000
TSEA4148251
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 2 M2: 85 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 2 M2: 85 Area: Torremolinos Region: Andalucía
New Development: Prices from 399,000 € to 862,000 €. [Beds: 2 - 4] [Baths: 2 - 2] [Built size: 85.00 m2 - 281.00 m2]
This development is located in one of the best areas of Torremolinos, in a (...)
€467,000
TSEA4268065
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 74 Area: Estepona Region: Andalucía
New Development: Prices from 467,000 € to 632,000 €. [Beds: 2 - 3] [Baths: 2 - 2] [Built size: 74.00 m2 - 100.00 m2]
Located on the in the center of the vibrant city of Estepona, on the Costa (...)
€12,000,000
TSEA4848274
- San Roque, Costa Del Sol, San Roque
Beds: 9 Baths: 9 M2: 1,810 Lot Size: 4,506 Area: San Roque Region: Andalucía
Beds: 9 Baths: 9 M2: 1,810 Lot Size: 4,506 Area: San Roque Region: Andalucía
New Development: Prices from 12,000,000 € to 12,000,000 €. [Beds: 9 - 9] [Baths: 9 - 9] [Built size: 1,810.00 m2 - 1,810.00 m2]
The Villa: The First Zero Consumption Villa
This villa is a (...)
€2,495,000
TSEA5032501
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 5 Baths: 6 M2: 304 Lot Size: 1,043 Area: Marbella West Region: Andalucía
Beds: 5 Baths: 6 M2: 304 Lot Size: 1,043 Area: Marbella West Region: Andalucía
Welcome to a contemporary masterpiece located in the picturesque grounds of Los Naranjos Hill Club in La Cerquilla, Nueva Andalucía. This newly developed Andalusian-style villa offers privacy and (...)
€595,000
TSEA5032477
- Benahavís, Costa Del Sol, Benahavis
Beds: 2 Baths: 3 M2: 110 Area: Benahavis Region: Andalucía
Beds: 2 Baths: 3 M2: 110 Area: Benahavis Region: Andalucía
Presenting a truly magnificent top-floor apartment that has been the subject of an extensive and thoughtful transformation, resulting in a living space that artfully balances modern design with (...)
€699,000
TSEA5032465
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 282 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 282 Area: Marbella Region: Andalucía
This luxurious duplex penthouse is located within a prestigious golf residential complex in Marbella and boasts breathtaking panoramic views. Elegantly furnished and fully equipped with high-end (...)
Current Featured Properties
€2,400,000
TSEA3878038
- Benahavís, Costa Del Sol, Benahavis
Beds: 4 Baths: 4 M2: 337 Lot Size: 70 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 4 M2: 337 Lot Size: 70 Area: Benahavis Region: Andalucía
MODULAR VILLAS IN AN UPSCALE COUNTRY CLUB RESORT!!!
A gated and secure community of villas with club house, spa and gym with verdant Mediterranean gardens and amazing panoramic sea views. located in (...)
€415,000
TSEA4148092
- San Roque, Costa Del Sol, San Roque
Beds: 2 Baths: 2 M2: 98 Area: San Roque Region: Andalucía
Beds: 2 Baths: 2 M2: 98 Area: San Roque Region: Andalucía
OASIS OF TRANQUILITY CLOSE TO BEACHES.
New release! A great opportunity to buy an off plan apartment at an UNBEATABLE PRICE. The apartment style is light and bright with large open plan living (...)
€480,000
TSEA4791484
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 128 Area: Estepona Region: Andalucía
We are delighted to introduce this fabulous new development in in the beautiful area of Arroyo Enmedio in Estepona – an exclusive new development featuring 48 two and 3-bedroom apartments and (...)
