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 (31,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 (31,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 (31,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 221 - 240 of 3992
€425,000
TSEA5148742
- Elviria, Costa Del Sol, Marbella East
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
Beds: 3 Baths: 2 M2: 74 Area: Marbella East Region: Andalucía
ELVIRIA. LOVELY APARTMENT WITH GREAT POTENTIAL SITUATED ON THE TOP FLOOR IN THE CENTRAL URBANIZATION OF PARQUE ELVIRIA. THE APARTMENT IS 105 m2 INCLUDING TERRACES. THE APARTMENT HAS 3 BEDROOMS AND 2 (...)
€400,000
TSEA5148733
- The Golden Mile, Costa Del Sol, Marbella East
Beds: 1 Baths: 1 M2: 71 Area: Marbella East Region: Andalucía
Beds: 1 Baths: 1 M2: 71 Area: Marbella East Region: Andalucía
Beautiful one bedroom apartment with spacious lounge dining room, fitted kitchen and terrace. Property has air conditioning, marble floors, 1 storage room and a parking space in the underground (...)
€185,000
TSEA5148727
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 65 Area: Fuengirola Region: Andalucía
Discover the charm of this beautiful and spacious studio, which was originally a cozy one-bedroom apartment. Located in a prime location, you'll enjoy spectacular sea views from the comfort of your (...)
€315,000
TSEA5148703
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 78 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 78 Area: Torremolinos Region: Andalucía
FLAT FOR SALE IN TORREMOLINOS
Beautiful, sunny flat for sale, built in 2007 with high-quality finishes, located on the second floor of a building with a lift and only seven neighbours, completely (...)
€315,000
TSEA5148673
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 128 Area: Mijas and Mijas Costa Region: Andalucía
spacious 3 bed 2 bath apartment centrally located
large communal pool
in need of some updating
located close to shops and restaurants
Middle Floor Apartment, Las Lagunas, Costa del Sol.
3 (...)
€285,000
TSEA5148664
- Las Lagunas, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 1 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 1 M2: 126 Area: Mijas and Mijas Costa Region: Andalucía
Fantastic apartment located in Las Lagunas.
Discover this fantastic 126 m2 apartment located in the coveted area of Las Lagunas.
The property features three bedrooms, all equipped with (...)
€595,000
TSEA5148604
- Miraflores, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 3 M2: 152 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 3 M2: 152 Area: Mijas and Mijas Costa Region: Andalucía
Bright and Spacious 3 Bed Corner Apartment with Stunning Views, Private Terrace and Premium Facilities
Welcome to this inviting 3-bedroom apartment in the sought-after Las Olas complex in (...)
€535,000
TSEA5148583
- Marbella, Costa Del Sol, Marbella
Beds: 4 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
Beds: 4 Baths: 2 M2: 98 Area: Marbella Region: Andalucía
This four-bedroom flat, situated in the heart of Marbella, Malaga, presents an exceptional opportunity for those seeking a well-located property with substantial potential. Set within a gated (...)
€174,500
TSEA5148568
- San Luis de Sabinillas, Costa Del Sol, Manilva
Beds: 1 Baths: 1 M2: 60 Area: Manilva Region: Andalucía
Beds: 1 Baths: 1 M2: 60 Area: Manilva Region: Andalucía
*** Walk Everywhere Apartment - No Car Necessary! ***
Charming apartment ideally located in the centre of San Luis de Sabinillas.
**** NOTE: This is a 1 bedroom and 1 bath apartment, however, it (...)
€590,000
TSEA5148544
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 2 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
Beds: 2 Baths: 2 M2: 104 Area: San Pedro Region: Andalucía
For sale: an exclusive apartment located in one of the most sought-after residential areas of Nueva Alcántara, San Pedro de Alcántara. This property stands out for its spacious layout, prime (...)
€459,000
TSEA5148505
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 114 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 114 Area: Fuengirola Region: Andalucía
Fantastic Apartment with Sea Views on the Second Line of the Beach
In the Torreblanca area.
Spacious and bright apartment in a high-quality building of approximately 130 m2, just steps from the (...)
€238,000
TSEA5148484
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 1 M2: 60 Area: Ojen Region: Andalucía
Beds: 2 Baths: 1 M2: 60 Area: Ojen Region: Andalucía
Middle Floor Apartment, Ojén, Costa del Sol.
2 Bedrooms, 1 Bathroom, Built 60 m².
Setting : Town, Close To Schools.
Orientation : South West.
Condition : Good.
Climate Control : Air Conditioning, (...)
€743,000
TSEA5148427
- Los Alamos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 102 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 102 Area: Torremolinos Region: Andalucía
Looking to live by the sea in a prime location?
Close proximity to parks, schools, supermarkets, restaurants, and bars.
Easy access to the highway, with quick connections along the coast.
Just a (...)
€344,900
TSEA5148319
- Torre del Mar, Costa Del Sol East
Beds: 3 Baths: 2 M2: 96 Lot Size: 96 Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Lot Size: 96 Region: Andalucía
This modern apartment in the center of Torre del Mar combines comfort, brightness, and an unbeatable location. The property offers 3 bedrooms, one of them currently used as a laundry room, adding (...)
€995,000
TSEA5148298
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 4 Baths: 3 M2: 323 Area: San Pedro Region: Andalucía
Beds: 4 Baths: 3 M2: 323 Area: San Pedro Region: Andalucía
Located in a recently built development, in a prime position just steps from the center of San Pedro de Alcántara, this elegant penthouse combines modern design, comfort, and an unbeatable location, (...)
€389,000
TSEA5148280
- Casares, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 99 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 99 Area: Casares Region: Andalucía
This fantastic ground floor apartment is set in the sought-after gated community of Casares Green, offering the perfect balance between modern living and the beauty of the Andalusian (...)
€779,900
TSEA5148277
- Guadalmina Baja, Costa Del Sol, San Pedro
Beds: 5 Baths: 4 M2: 143 Lot Size: 55 Area: San Pedro Region: Andalucía
Beds: 5 Baths: 4 M2: 143 Lot Size: 55 Area: San Pedro Region: Andalucía
Luxury Beachside Golf Retreat in Guadalmina Baja
Just 5 minutes from Puerto Banús, discover the epitome of Mediterranean elegance in this spacious 5-bedroom, 4-bathroom retreat, perfectly (...)
€249,000
TSEA5148268
- Casares Playa, Costa Del Sol, Casares
Beds: 2 Baths: 2 M2: 90 Area: Casares Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Casares Region: Andalucía
Breathtaking 2-Bedroom Apartment in Casares del Sol – 800m from the Beach
Experience the ultimate Costa del Sol lifestyle in this stunning apartment, perfectly situated in the exclusive gated (...)
€495,000
TSEA5148265
- Estepona, Costa Del Sol, Estepona
Beds: 3 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Beds: 3 Baths: 2 M2: 98 Area: Estepona Region: Andalucía
Elegant 3-Bedroom Apartment in Sunny Golf, Estepona
Welcome to this stylish middle-floor apartment in Sunny Golf, Estepona. Delivered in 2024 and upgraded with care, it offers a modern living (...)
€298,000
TSEA5148250
- Ojén, Costa Del Sol, Ojen
Beds: 2 Baths: 1 M2: 124 Area: Ojen Region: Andalucía
Beds: 2 Baths: 1 M2: 124 Area: Ojen Region: Andalucía
Duplex penthouse in the heart of the charming village of Ojen, very close to shops, supermarkets, and the school.
This spacious and bright duplex penthouse features a large living room with a (...)
Current Featured Properties
€689,900
TSEA4624537
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 2 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
Beds: 2 Baths: 2 M2: 105 Area: Fuengirola Region: Andalucía
This brand new development stands out! An exclusive residential complex with spacious layouts and top-tier construction. The residences have been built with the highest-quality materials and feature (...)
€980,000
TSEA4788301
- New Golden Mile, Costa Del Sol, Estepona
Beds: 3 Baths: 3 M2: 140 Area: Estepona Region: Andalucía
Beds: 3 Baths: 3 M2: 140 Area: Estepona Region: Andalucía
brand new Development on the The New Golden Mile! The mission of the new apartment complex is to provide residents with a unique lifestyle filled with comfort and sophistication. There's soemthing (...)
€424,000
TSEA4752082
- Selwo, 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
IDEALLY SITUATED BETWEEN ESTEPONA AND PUERTO BANUS!!!
Your new home is more than just rooms and features, it must fit in with your lifestyle. We have created a floor-plan that is spacious designed to (...)
