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 1921 - 1940 of 5896 €880,000
TSEA5070319
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 2 Baths: 2 M2: 120 Lot Size: 701 Area: Benalmadena Region: Andalucía
Beds: 2 Baths: 2 M2: 120 Lot Size: 701 Area: Benalmadena Region: Andalucía
Discover your new home in Torremuelle, Benalmádena! This charming detached villa offers a built area of 120sqm on a 701sqm plot, where tranquility and sea views combine to create an idyllic (...)
€589,000
TSEA5070274
- Málaga Centro, Costa Del Sol, Malaga
Beds: 5 Baths: 2 M2: 187 Area: Malaga Region: Andalucía
Beds: 5 Baths: 2 M2: 187 Area: Malaga Region: Andalucía
Located in one of the most iconic areas of Málaga, this spacious and bright home offers the perfect balance between comfort and functionality.
Upon entering, you are welcomed by a large (...)
€735,000
TSEA5070265
- Estacion de Cartama, Costa Del Sol, Cartama
Beds: 6 Baths: 5 M2: 400 Lot Size: 900 Area: Cartama Region: Andalucía
Beds: 6 Baths: 5 M2: 400 Lot Size: 900 Area: Cartama Region: Andalucía
Detached Villa, Estacion de Cartama, Costa del Sol.
6 Bedrooms, 5 Bathrooms, Built 400 m², Garden/Plot 900 m².
Great Villa in a quiet location in the popular town of Estacion de Cartama.
Excellent (...)
€379,000
TSEA5070235
- Málaga Centro, Costa Del Sol, Malaga
Beds: 1 Baths: 2 M2: 58 Area: Malaga Region: Andalucía
Beds: 1 Baths: 2 M2: 58 Area: Malaga Region: Andalucía
New Development: Prices from 379,000 € to 809,000 €. [Beds: 1 - 2] [Baths: 2 - 2] [Built size: 58.00 m2 - 92.00 m2]
In the heart of the historical center in a very unique historical building (...)
€1,856,000
TSEA5070232
- Estepona, Costa Del Sol, Estepona
Beds: 4 Baths: 4 M2: 273 Lot Size: 948 Area: Estepona Region: Andalucía
Beds: 4 Baths: 4 M2: 273 Lot Size: 948 Area: Estepona Region: Andalucía
Independent Villa in Estepona – 984 m² Plot and 273 m² Built
Main Features:
Generous 984 m² plot with 273 m² built
4 spacious and bright bedrooms
4 full bathrooms, one adapted for people (...)
€599,000
TSEA5070217
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 4 Baths: 3 M2: 203 Area: Fuengirola Region: Andalucía
Beds: 4 Baths: 3 M2: 203 Area: Fuengirola Region: Andalucía
SPACIOUS & EXCLUSIVE APARTMENT IN PUEBLO LÓPEZ!
Imagine living in a home where two apartments have been seamlessly merged into one elegant, functional space. This real-estate gem offers (...)
€1,890,000
TSEA5070202
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 2 M2: 150 Lot Size: 50 Area: Marbella Region: Andalucía
Beds: 3 Baths: 2 M2: 150 Lot Size: 50 Area: Marbella Region: Andalucía
3-bedroom beachfront apartment – Palm Beach, Marbella
3 bedrooms, 2 bathrooms and guest toilet
Stylish apartment, located on the ground floor with a private garden, situated in one of the most (...)
€295,000
TSEA5070199
- La Duquesa, Costa Del Sol, La Duquesa
Beds: 3 Baths: 3 M2: 111 Area: La Duquesa Region: Andalucía
Beds: 3 Baths: 3 M2: 111 Area: La Duquesa Region: Andalucía
***Immaculate 3-Bedroom Duplex Penthouse with Stunning Coastal Views*** Located within the sought-after elevated urbanisation of Vistalmar Norte in the Hacienda Guadalupe area of Duquesa, this (...)
€1,800,000
TSEA5070157
- Cerrado de Calderón, Costa Del Sol
Beds: 6 Baths: 3 M2: 375 Region: Andalucía
Beds: 6 Baths: 3 M2: 375 Region: Andalucía
Located in one of the most prestigious residential areas of Malaga, this impressive villa stands in the Cerrado de Calderon urbanization, offering an environment of tranquillity and (...)
€473,000
TSEA5070073
- Torrequebrada, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 187 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 187 Area: Mijas and Mijas Costa Region: Andalucía
Eng.: Discover this fantastic apartment located in the prestigious Golf Resort Torrequebrada development, a prime area of Benalmádena, just 1 km from the beach and Arroyo de la Miel, and very close (...)
€2,000,000
TSEA5069965
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 145 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 145 Area: Estepona Region: Andalucía
This fontal sea view penthouse is situated in the sought-after Dominion Beach area, located in Estepona East, Malaga. Offering a blend of comfort and sophistication, the property boasts a generous (...)
€3,995,000
TSEA5069938
- Benahavís, Costa Del Sol, Benahavis
Beds: 5 Baths: 7 M2: 700 Lot Size: 3,240 Area: Benahavis Region: Andalucía
Beds: 5 Baths: 7 M2: 700 Lot Size: 3,240 Area: Benahavis Region: Andalucía
This stunning villa offers fantastic panoramic views over the Costa del Sol. Situated close to the Marbella golf club resort, within a gated community and offering 24-hour security this villa is (...)
€795,000
TSEA5069848
- Puerto de Cabopino, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 160 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 160 Area: Marbella East Region: Andalucía
Discover this beautifully renovated 2-bedroom, 2.5-bathroom apartment located in the highly sought-after Puerto de Cabopino. Finished to an exceptional standard and furnished with top-of-the-line (...)
€695,000
TSEA5069830
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 106 Lot Size: 590 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 106 Lot Size: 590 Area: Mijas and Mijas Costa Region: Andalucía
A villa with great renovation potential in a great area Miraflores, close to the beach and the owner is OPEN TO OFFERS. Make an Offer!
Located in the exclusive area of Miraflores, this property is (...)
€355,000
TSEA5069815
- Elviria, Costa Del Sol, Marbella East
Beds: 2 Baths: 2 M2: 80 Area: Marbella East Region: Andalucía
Beds: 2 Baths: 2 M2: 80 Area: Marbella East Region: Andalucía
Beautiful 2-bedroom, 2-bathroom beachside apartment, near Don Carlos and Nikki Beach.
Sold with an underground parking space.
Communal pool and garden. West facing.
Gated community with (...)
€270,000
TSEA5069812
- Manilva, Costa Del Sol, Manilva
Beds: 2 Baths: 2 M2: 125 Area: Manilva Region: Andalucía
Beds: 2 Baths: 2 M2: 125 Area: Manilva Region: Andalucía
This beautiful two bedroom and two bathroom apartment is located in the much sought after area of Manilva Playa, within just a short walk to the beautiful beaches. South facing apartment which boasts (...)
€350,000
TSEA5069761
- Frigiliana, Costa Del Sol East
Beds: 2 Baths: 1 M2: 90 Lot Size: 5,034 Region: Andalucía
Beds: 2 Baths: 1 M2: 90 Lot Size: 5,034 Region: Andalucía
Rustic Charm and Incredible Views: Villa with Pool in the Countryside of Frigiliana
Located in a privileged natural setting north of Frigiliana, this cozy villa offers a perfect escape from the (...)
€1,299,000
TSEA5069755
- Benahavís, Costa Del Sol, Benahavis
Beds: 3 Baths: 2 M2: 238 Lot Size: 132 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 2 M2: 238 Lot Size: 132 Area: Benahavis Region: Andalucía
Wonderful 3 Bedroom Ground floor Corner Apartment with Spectacular Mediterranean Views in Real de La Quinta
A Haven of Luxury and Tranquility, nestled in Real de La Quinta Residential Country Club (...)
€989,000
TSEA5069731
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 4 Baths: 4 M2: 256 Area: Benalmadena Region: Andalucía
Beds: 4 Baths: 4 M2: 256 Area: Benalmadena Region: Andalucía
Modern property with sea views from all the three floors of the house.
Main description of the house :
The property features 4 spacious bedrooms, 4 stylish bathrooms, and a practical guest (...)
€425,000
TSEA5069719
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic 3 bedroom 2 bathroom penthouse only 11 minutes walk to La Cala beach. Located in the sought after Angel de Miraflores urbanization, this lovely penthouse also has a 70m2 solarium with (...)
Current Featured Properties
€2,250,000
TSEA4943188
- Málaga, Costa Del Sol, Malaga
Beds: 3 Baths: 3 M2: 142 Lot Size: 186 Area: Malaga Region: Andalucía
Beds: 3 Baths: 3 M2: 142 Lot Size: 186 Area: Malaga Region: Andalucía
This residential complex is where the contemporary and the traditional come together. For this reason, we will find renovated buildings, alongside newly built buildings or buildings protected as (...)
€570,000
TSEA4581883
- Altos de los Monteros, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 82 Area: Marbella Region: Andalucía
New development. Two- and three-bedrooms apartments with all kinds of leisure services that will change your life.
Modern units with large spaces, big windows, and wide terraces. Southwest (...)
€905,000
EMPTY
- Málaga, Costa Del Sol, Malaga
Beds: 2 Baths: 2 M2: 100 Area: Malaga Region: Andalucía
Beds: 2 Baths: 2 M2: 100 Area: Malaga Region: Andalucía
The development is located in a prime enclave, surrounded by parks and landscaped areas, close to a wide variety of sports, healthcare, commercial spaces, and universities. Just 10 minutes from the (...)
