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,36,37,38)
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,36,37,38)
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,36,37,38)
GROUP BY p.id
ORDER BY p.created DESC
Properties
Results 81 - 100 of 4003
€2,685,000
TSEA5156050
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 3 Baths: 2 M2: 136 Area: Marbella West Region: Andalucía
Beds: 3 Baths: 2 M2: 136 Area: Marbella West Region: Andalucía
Beautiful apartment in the heart of one of the most famous ports on the Costa del Sol - Puerto Banus, with spacious terraces offering ponoramnic views to the sea, sandy beaches, port, coast of (...)
€560,000
TSEA5156041
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 3 M2: 111 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 3 M2: 111 Area: Benalmadena Region: Andalucía
Apartment with magnificent views of the sea and the communal swimming pool.
The property has 3 bedrooms with fitted wardrobes and 2 full bathrooms, one of which is en suite in the master bedroom, a (...)
€335,000
TSEA5156005
- Fuengirola, Costa Del Sol, Fuengirola
Beds: 1 Baths: 1 M2: 57 Area: Fuengirola Region: Andalucía
Beds: 1 Baths: 1 M2: 57 Area: Fuengirola Region: Andalucía
One-bedroom, one-bathroom apartment on the beachfront, near the boliches area, with sea views from the bedroom and living room. Terrace with sea views, air conditioning in the living room and (...)
€577,972
TSEA5155993
- Marbella, Costa Del Sol, Marbella
Beds: 2 Baths: 2 M2: 96 Area: Marbella Region: Andalucía
Beds: 2 Baths: 2 M2: 96 Area: Marbella Region: Andalucía
Duplex penthouse with panoramic sea views in Marbella
This exclusive penthouse apartment is located in the prestigious area near the Quirón Hospital, just a short walk from the beach. This bright (...)
€225,000
TSEA5155978
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 1 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 1 Baths: 1 M2: 70 Area: Mijas and Mijas Costa Region: Andalucía
Rarely available one bed apartment
Totally reformed and spacious one bedroom apartment in this ever poplar development a very short walk to the village.
200 METRES WALK TO THE BEACH
One full (...)
€380,000
TSEA5155972
- Torremolinos, Costa Del Sol, Torremolinos
Beds: 2 Baths: 1 M2: 85 Area: Torremolinos Region: Andalucía
Beds: 2 Baths: 1 M2: 85 Area: Torremolinos Region: Andalucía
Introducing this stunning fully renovated home, just 25 meters from the beach, located in one of the most exclusive areas of the Costa del Sol. Ideal for seaside living or as a high-return tourist (...)
€350,000
TSEA5155966
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 85 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 85 Area: Casares Region: Andalucía
Great opportunity in Hacienda de Casares! Beautiful penthouse with panoramic sea views!
With all the amenities you need and just 5 minutes from the beach. The home is in a prime location, surrounded (...)
€510,000
TSEA5155954
- Puerto Banús, Costa Del Sol, Marbella West
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 2 M2: 90 Area: Marbella West Region: Andalucía
???? Attention investors
New listing in Puerto Banús, Marbella!
Spacious 114 m² apartment with terrace and private parking space, located in one of the most exclusive and peaceful complexes in the (...)
€255,000
TSEA5155915
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 101 Area: Mijas and Mijas Costa Region: Andalucía
For sale: ground-floor apartment with two terraces, one at the entrance of the home and another at the front, totaling approximately 30 m2.
The apartment has a constructed area of 99 m2, of (...)
€599,000
TSEA5155873
- Mijas Costa, Costa Del Sol, Mijas and Mijas Costa
Beds: 3 Baths: 2 M2: 116 Lot Size: 56 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 3 Baths: 2 M2: 116 Lot Size: 56 Area: Mijas and Mijas Costa Region: Andalucía
New on the market!!
Welcome to your dream getaway!
Located on the ground floor of the prestigious Casa Banderas complex, this modern 3-bedroom, 2-bathroom apartment offers the perfect blend of (...)
€316,000
TSEA5155780
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 114 Area: Estepona Region: Andalucía
Beautiful renovated 114 m2 apartment with 2 bedrooms and 2 bathrooms in a residential area very close to Estepona beach.
The property stands out for its brightness, freshness, and charm, offering a (...)
€725,000
TSEA5155720
- La Quinta, Costa Del Sol, Benahavis
Beds: 3 Baths: 3 M2: 145 Area: Benahavis Region: Andalucía
Beds: 3 Baths: 3 M2: 145 Area: Benahavis Region: Andalucía
Experience Scandinavian elegance with panoramic views of the Mediterranean
This 144 sqm residence has been exquisitely renovated with an emphasis on clean lines, refined design, and top-tier (...)
€560,000
TSEA5155711
- Nueva Andalucía, Costa Del Sol, Marbella West
Beds: 2 Baths: 3 M2: 128 Area: Marbella West Region: Andalucía
Beds: 2 Baths: 3 M2: 128 Area: Marbella West Region: Andalucía
Fantastic Investment Opportunity in Prime Golf Valley Location, Señorio de Aloha.
This 2-bedroom duplex penthouse is ideally situated in the heart of Nueva Andalucía's Golf Valley, just a short (...)
€399,000
TSEA5155435
- Torreblanca, Costa Del Sol, Fuengirola
Beds: 3 Baths: 2 M2: 113 Area: Fuengirola Region: Andalucía
Beds: 3 Baths: 2 M2: 113 Area: Fuengirola Region: Andalucía
HIGHLIGHTS
Pine Hill Residences represents a unique opportunity to enjoy life on the Costa del Sol in a modern and exclusive setting. This development combines a strategic location, just minutes from (...)
€900,000
TSEA5155387
- La Quinta, Costa Del Sol, Benahavis
Beds: 4 Baths: 3 M2: 154 Area: Benahavis Region: Andalucía
Beds: 4 Baths: 3 M2: 154 Area: Benahavis Region: Andalucía
Beautiful large fully renovated penthouse located in a gated complex in La Quinta, close to the famous Westin Hotel. The property comprises of a spacious living area with open plan kitchen, 4 (...)
€492,000
TSEA5155384
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 2 M2: 88 Area: Estepona Region: Andalucía
Beds: 2 Baths: 2 M2: 88 Area: Estepona Region: Andalucía
This first-floor apartment, located in the exclusive Paseo Maritimo area in the center of Estepona, stands out for its side sea views and direct access to the promenade. Fully renovated and ready to (...)
€445,000
TSEA5155378
- Marbella, Costa Del Sol, Marbella
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Beds: 1 Baths: 1 M2: 56 Area: Marbella Region: Andalucía
Situated in the very centre of Marbella, just a few steps from the beach, this beautifully refurbished apartment offers the rare combination of luxury, comfort, and unbeatable location. Perfect as a (...)
€360,000
TSEA5155372
- Estepona, Costa Del Sol, Estepona
Beds: 2 Baths: 3 M2: 72 Area: Estepona Region: Andalucía
Beds: 2 Baths: 3 M2: 72 Area: Estepona Region: Andalucía
This beautiful, newly built (2023) apartment is stylishly furnished and ideally located at the edge of Estepona's historic old town. Offering 2 spacious bedrooms and 2 contemporary bathrooms, the (...)
€895,000
TSEA5155318
- Benalmadena, Costa Del Sol, Benalmadena
Beds: 3 Baths: 2 M2: 238 Area: Benalmadena Region: Andalucía
Beds: 3 Baths: 2 M2: 238 Area: Benalmadena Region: Andalucía
Penthouse for sale in , Benalmadena with 3 bedrooms, 2 bathrooms, 1 on suite bathroom and with orientation south, with communal swimming pool, private garage (1 parking spaces) and communal garden. (...)
€499,000
TSEA5155288
- La Cala de Mijas, Costa Del Sol, Mijas and Mijas Costa
Beds: 2 Baths: 2 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Beds: 2 Baths: 2 M2: 81 Area: Mijas and Mijas Costa Region: Andalucía
Luxury 2 bed, 2 bath apartment, a short flat walk to La Cala town & beach and many other local amenities. La Cala is booming and this stylish apartment is a great opportunity.
In a small, (...)
Current Featured Properties
€893,000
TSEA4887208
- Casares, Costa Del Sol, Casares
Beds: 3 Baths: 2 M2: 175 Area: Casares Region: Andalucía
Beds: 3 Baths: 2 M2: 175 Area: Casares Region: Andalucía
This residential complex of 36 homes with 2 and 3 bedrooms and an exceptional range of services. Each home is carefully designed using soft, organic lines that blend naturally into the surroundings, (...)
€4,995,000
TSEA4445479
- Marbella, Costa Del Sol, Marbella
Beds: 3 Baths: 3 M2: 138 Area: Marbella Region: Andalucía
Beds: 3 Baths: 3 M2: 138 Area: Marbella Region: Andalucía
This is a stunning modern apartment sporting sea views within the exclusive enclave of the Puente Romano Resort on the Marbella Golden Mile. The apartment exudes seaside sophistication, embracing its (...)
€550,000
TSEA5042059
- San Pedro de Alcántara, Costa Del Sol, San Pedro
Beds: 3 Baths: 2 M2: 96 Area: San Pedro Region: Andalucía
Beds: 3 Baths: 2 M2: 96 Area: San Pedro Region: Andalucía
In an exceptional location in San Pedro Alcántara, just a short walk from the beach and with views of the sea and the impressive La Concha peak. Discover a new way of living in San Pedro Alcántara (...)
